Data source: Big Local News · About: Big Local

1,641 rows where grade = "grade_9" and state = "ID" sorted by total_int

View and edit SQL

year

grade

  • grade_9 · 1,581
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 ▼
1821492 ID     school 1602640 25   POCATELLO DISTRICT 160264000186 9034 POCATELLO JUVENILE DETENTION   Alternative Education School No 4.0 01 12 2016   grade_9 0 0 0   1 0     0   0   1 0             *         1 0 0 0   1 0     0   0   1 0                 1
1821527 ID     school 1600240 33   BEAR LAKE COUNTY DISTRICT 160024000827 404 CLOVER CREEK HIGH SCHOOL   Alternative Education School No 3.0 09 12 2016   grade_9 1 0 0   0 0     0   0   1 0             *         1 1 0 0   0 0     0   0   1 0                 1
1821919 ID     school 1600002 84   LAKE PEND OREILLE SCHOOL DISTRICT 160000200604 997 SANDPOINT JUVENILE DETENTION   Alternative Education School No 4.0 05 12 2016   grade_9 1 0 0   0 0     0   0   0 1             *         1 1 0 0   0 0     0   0   0 1                 1
1822666 ID     school 1600600 139   VALLIVUE SCHOOL DISTRICT 160060000914 9017 VALLIVUE ACADEMY   Alternative Education School No 3.0 09 12 2016   grade_9 0 0 1   0 0     0   0   0 1             *         1 0 0 1   0 0     0   0   0 1                 1
1824026 ID     school   340   LEWISTON INDEPENDENT DISTRICT   611 NORTHWEST CHILDRENS HOME             2016   grade_9 0 0 0   1 0     0   0   1 0             *         1 0 0 0   1 0     0   0   1 0                 1
703710 ID     school 1602640 25   POCATELLO DISTRICT 160264000468 1141 NEW HORIZON HIGH SCHOOL   Alternative School No High 09 12 2021   grade_9 1 0 0   0 0     0   1   1 1             *         2 1 0 0   0 0     0   1   1 1                 2
705192 ID     school 1602520 171   OROFINO JOINT DISTRICT 160252001057 1362 IDAHO YOUTH CHALLENGE ACADEMY FALL   Alternative School No High 09 12 2021   grade_9 1 0 0   0 0     0   1   2 0             *         2 1 0 0   0 0     0   1   2 0                 2
705394 ID     school 1601110 215   FREMONT COUNTY JOINT DISTRICT 160111000912 1271 FIVE-COUNTY DETENTION CENTER   Alternative School No High 05 12 2021   grade_9 1 0 0   0 0     0   1   1 1             *         2 1 0 0   0 0     0   1   1 1                 2
705725 ID     school 1601590 261   JEROME JOINT DISTRICT 160159000097 1272 FALLS CITY ACADEMY   Alternative School No High 06 12 2021   grade_9 1 0 1   0 0     0   0   1 1             *         2 1 0 1   0 0     0   0   1 1                 2
706321 ID     school 1603090 322   SUGAR-SALEM JOINT DISTRICT 160309000853 874 VALLEY VIEW ALTERNATIVE HIGH SCHOOL   Alternative School No High 09 12 2021   grade_9 1 0 0   1 0     0   0   1 1             *         2 1 0 0   1 0     0   0   1 1                 2
706399 ID     school   340   LEWISTON INDEPENDENT DISTRICT   611 NORTHWEST CHILDRENS HOME             2021   grade_9 2 0 0   0 0     0   0   2 0             *         2 2 0 0   0 0     0   0   2 0                 2
706604 ID     school 1602580 371   PAYETTE JOINT DISTRICT 160258001153 1400 TREASURE VALLEY TECH (TVT) - IDAHO   Career and Technical School No Not reported M M 2021   grade_9 2 0 0   0 0     0   0   2 0             *         2 2 0 0   0 0     0   0   2 0                 2
848582 ID     school 1600360 1   BOISE INDEPENDENT DISTRICT 160036000045 8 BORAH SENIOR HIGH SCHOOL   Regular School No High 09 12 2020   grade_9 1 0 1   0 0     0   0   1 1             *         2 1 0 1   0 0     0   0   1 1                 2
849182 ID     school 1602100 2   JOINT SCHOOL DISTRICT NO. 2 160210001025 1297 REBOUND SCHOOL OF OPPORTUNITY   Alternative School No High 06 12 2020   grade_9 1 0 1   0 0     0   0   1 1             *         2 1 0 1   0 0     0   0   1 1                 2
850032 ID     school 1601530 91   IDAHO FALLS DISTRICT 160153000697 1048 EMERSON HIGH SCHOOL   Alternative School No High 09 12 2020   grade_9 0 0 2   0 0     0   0   2 0             *         2 0 0 2   0 0     0   0   2 0                 2
851973 ID     school 1603090 322   SUGAR-SALEM JOINT DISTRICT 160309000853 874 VALLEY VIEW ALTERNATIVE HIGH SCHOOL   Alternative School No High 09 12 2020   grade_9 2 0 0   0 0     0   0   1 1             *         2 2 0 0   0 0     0   0   1 1                 2
852559 ID     school 1600480 412   BUHL JOINT DISTRICT 160048001106 1403 WAKAPA ACADEMY   Alternative School No High 09 12 2020   grade_9 1 0 1   0 0     0   0   2 0             *         2 1 0 1   0 0     0   0   2 0                 2
852683 ID     school 1602030 421   MCCALL-DONNELLY JOINT SCHOOL DISTRICT 160203000740 1264 HEARTLAND HIGH SCHOOL   Alternative School No High 09 12 2020   grade_9 1 0 0   0 0     0   1   1 1             *         2 1 0 0   0 0     0   1   1 1                 2
852754 ID     school 1602160 433   MIDVALE DISTRICT 160216000939 1113 MIDVALE ALTERNATIVE SCHOOL   Alternative School No High 07 12 2020   grade_9 1 0 1   0 0     0   0   0 2             *         2 1 0 1   0 0     0   0   0 2                 2
1277066 ID     school 1600240 33   BEAR LAKE COUNTY DISTRICT 160024000827 404 CLOVER CREEK HIGH SCHOOL   Alternative School No High 09 12.0 2018   grade_9 2 0 0   0 0     0   0   2 0             *         2 2 0 0   0 0     0   0   2 0                 2
1277737 ID     school 1600930 93   BONNEVILLE JOINT DISTRICT 160093001063 1357 TECHNICAL CAREERS HIGH SCHOOL   Career and Technical School No High 09 12.0 2018   grade_9 2 0 0   0 0     0   0   1 1             *         2 2 0 0   0 0     0   0   1 1                 2
1278274 ID     school   150   SODA SPRINGS JOINT DISTRICT   1026 BORDER DISTRICT FREEDOM - SECONDARY             2018   grade_9 2 0 0   0 0     0   0   2 0             *         2 2 0 0   0 0     0   0   2 0                 2
1278420 ID     school 1602520 171   OROFINO JOINT DISTRICT 160252001057 1362 IDAHO YOUTH CHALLENGE ACADEMY FALL   Alternative School No High 09 12.0 2018   grade_9 2 0 0   0 0     0   0   2 0             *         2 2 0 0   0 0     0   0   2 0                 2
1279553 ID     school 1602190 331   MINIDOKA COUNTY JOINT DISTRICT 160219000166 1100 MINI-CASSIA JUVENILE DETENTION CENTER   Alternative School No Other 03 12.0 2018   grade_9 2 0 0   0 0     0   0   2 0             *         2 2 0 0   0 0     0   0   2 0                 2
1280041 ID     school 1603240 411   TWIN FALLS DISTRICT 160324000739 1260 SNAKE RIVER JUVENILE DETENTION   Alternative School No Other 01 12.0 2018   grade_9 1 0 1   0 0     0   0   2 0             *         2 1 0 1   0 0     0   0   2 0                 2
1280207 ID     school 1602030 421   MCCALL-DONNELLY JOINT SCHOOL DISTRICT 160203000740 1264 HEARTLAND HIGH SCHOOL   Alternative School No High 09 12.0 2018   grade_9 0 1 1   0 0     0   0   1 1             *         2 0 1 1   0 0     0   0   1 1                 2
1280278 ID     school 1602160 433   MIDVALE DISTRICT 160216000939 1113 MIDVALE ALTERNATIVE SCHOOL   Alternative School No High 07 12.0 2018   grade_9 2 0 0   0 0     0   0   1 1             *         2 2 0 0   0 0     0   0   1 1                 2
1280507 ID     school 1600149 470   THE KOOTENAI BRIDGE ACADEMY, INC. 160014900992 1232 KOOTENAI BRIDGE ACADEMY   Alternative School Yes High 09 12.0 2018   grade_9 2 0 0   0 0     0   0   2 0             *         2 2 0 0   0 0     0   0   2 0                 2
1305892 ID     school 1602640 25   POCATELLO DISTRICT 160264000186 9034 POCATELLO JUVENILE DETENTION   Alternative School No Other 01 12.0 2019   grade_9 2 0 0   0 0     0   0   2 0             *         2 2 0 0   0 0     0   0   2 0                 2
1307130 ID     school   150   SODA SPRINGS JOINT DISTRICT   1026 BORDER DISTRICT FREEDOM - SECONDARY             2019   grade_9 1 0 1   0 0     0   0   2 0             *         2 1 0 1   0 0     0   0   2 0                 2
1307491 ID     school 1601110 215   FREMONT COUNTY JOINT DISTRICT 160111000912 1271 FIVE-COUNTY DETENTION CENTER   Alternative School No High 05 12.0 2019   grade_9 1 0 1   0 0     0   0   0 2             *         2 1 0 1   0 0     0   0   0 2                 2
1308448 ID     school   340   LEWISTON INDEPENDENT DISTRICT   611 NORTHWEST CHILDRENS HOME             2019   grade_9 2 0 0   0 0     0   0   2 0             *         2 2 0 0   0 0     0   0   2 0                 2
1308602 ID     school   364   PLEASANT VALLEY ELEMENTARY DISTRICT   1056 BORDER DISTRICT - JORDAN VALLEY SECONDARY             2019   grade_9 2 0 0   0 0     0   0   0 2             *         2 2 0 0   0 0     0   0   0 2                 2
1308908 ID     school 1603240 411   TWIN FALLS DISTRICT 160324000739 1260 SNAKE RIVER JUVENILE DETENTION   Alternative School No Other 01 12.0 2019   grade_9 2 0 0   0 0     0   0   1 1             *         2 2 0 0   0 0     0   0   1 1                 2
1682806 ID     school 1600001 83   WEST BONNER COUNTY DISTRICT 160000100771 1172 PRIEST RIVER EDUCATIONAL PROGRAM (PREP)   Alternative Education School No 3.0 09 12 2015   grade_9 2 0 0   0 0     0   0   2 0             *         2 2 0 0   0 0     0   0   2 0                 2
1682882 ID     school 1600002 84   LAKE PEND OREILLE SCHOOL DISTRICT 160000200604 997 SANDPOINT JUVENILE DETENTION   Alternative Education School No 4.0 05 12 2015   grade_9 2 0 0   0 0     0   0   2 0             *         2 2 0 0   0 0     0   0   2 0                 2
1683374 ID     school 1602340 131   NAMPA SCHOOL DISTRICT 160234000669 1052 PARKVIEW ALTERNATIVE HIGH SCHOOL   Alternative Education School No 3.0 09 12 2015   grade_9 1 0 1   0 0     0   0   1 1             *         2 1 0 1   0 0     0   0   1 1                 2
1683954 ID     school 1600960 201   PRESTON JOINT DISTRICT 160096000764 8844 FRANKLIN COUNTY HIGH SCHOOL   Alternative Education School No 3.0 09 12 2015   grade_9 2 0 0   0 0     0   0   1 1             *         2 2 0 0   0 0     0   0   1 1                 2
1684020 ID     school 1601110 215   FREMONT COUNTY JOINT DISTRICT 160111000912 1271 FIVE-COUNTY DETENTION CENTER   Alternative Education School No 4.0 05 12 2015   grade_9 1 0 0   0 0     0   1   2 0             *         2 1 0 0   0 0     0   1   2 0                 2
1684707 ID     school 1602850 291   SALMON DISTRICT 160285000700 9014 SALMON ALTERNATIVE HIGH SCHOOL   Alternative Education School No 3.0 08 12 2015   grade_9 2 0 0   0 0     0   0   1 1             *         2 2 0 0   0 0     0   0   1 1                 2
1685194 ID     school 1602580 371   PAYETTE JOINT DISTRICT 160258001051 1318 PAYETTE ALTERNATIVE CENTER   Special Education School No 4.0 PK 12 2015   grade_9 2 0 0   0 0     0   0   2 0             *         2 2 0 0   0 0     0   0   2 0                 2
1685443 ID     school 1603240 411   TWIN FALLS DISTRICT 160324000703 1066 MAGIC VALLEY HIGH SCHOOL   Alternative Education School No 3.0 09 12 2015   grade_9 2 0 0   0 0     0   0   0 2             *         2 2 0 0   0 0     0   0   0 2                 2
1727047 ID     school 1601530 91   IDAHO FALLS DISTRICT 160153000697 1048 EMERSON HIGH SCHOOL   Alternative School No High 07 12.0 2017   grade_9 1 0 1   0 0     0   0   0 2             *         2 1 0 1   0 0     0   0   0 2                 2
1727053 ID     school 1601530 91   IDAHO FALLS DISTRICT 160153000605 1152 3B JUVENILE DETENTION CENTER   Alternative School No Other 04 12.0 2017   grade_9 0 0 0   1 0     0   1   2 0             *         2 0 0 0   1 0     0   1   2 0                 2
1727073 ID     school   92   SWAN VALLEY ELEMENTARY DISTRICT   1015 BORDER DISTRICT - STAR VALLEY JR-SR HIGH SCHOOL             2017   grade_9 2 0 0   0 0     0   0   1 1             *         2 2 0 0   0 0     0   0   1 1                 2
1728153 ID     school 1603360 232   WENDELL DISTRICT 160336000571 104 WENDELL MIDDLE SCHOOL   Regular School No Middle 05 8.0 2017   grade_9 0 0 2   0 0     0   0   1 1             *         2 0 0 2   0 0     0   0   1 1                 2
1728855 ID     school 1602940 312   SHOSHONE JOINT DISTRICT 160294001026 846 HIGH DESERT   Alternative School No High 09 12.0 2017   grade_9 1 0 1   0 0     0   0   2 0             *         2 1 0 1   0 0     0   0   2 0                 2
1728960 ID     school 1603090 322   SUGAR-SALEM JOINT DISTRICT 160309000853 874 VALLEY VIEW ALTERNATIVE HIGH SCHOOL   Alternative School No High 09 12.0 2017   grade_9 1 0 1   0 0     0   0   2 0             *         2 1 0 1   0 0     0   0   2 0                 2
1729673 ID     school 1602030 421   MCCALL-DONNELLY JOINT SCHOOL DISTRICT 160203000740 1264 HEARTLAND HIGH SCHOOL   Alternative School No High 09 12.0 2017   grade_9 1 0 1   0 0     0   0   1 1             *         2 1 0 1   0 0     0   0   1 1                 2
1729961 ID     school 1600149 470   THE KOOTENAI BRIDGE ACADEMY, INC. 160014900992 1232 KOOTENAI BRIDGE ACADEMY   Alternative School Yes High 09 12.0 2017   grade_9 2 0 0   0 0     0   0   0 2             *         2 2 0 0   0 0     0   0   0 2                 2
1821842 ID     school 1600001 83   WEST BONNER COUNTY DISTRICT 160000100771 1172 PRIEST RIVER EDUCATIONAL PROGRAM (PREP)   Alternative Education School No 3.0 09 12 2016   grade_9 1 0 0   0 0     0   1   2 0             *         2 1 0 0   0 0     0   1   2 0                 2
1822043 ID     school 1601530 91   IDAHO FALLS DISTRICT 160153000697 1048 EMERSON HIGH SCHOOL   Alternative Education School No 3.0 07 12 2016   grade_9 1 0 1   0 0     0   0   0 2             *         2 1 0 1   0 0     0   0   0 2                 2
1824170 ID     school   364   PLEASANT VALLEY ELEMENTARY DISTRICT   1056 BORDER DISTRICT - JORDAN VALLEY SECONDARY             2016   grade_9 2 0 0   0 0     0   0   0 2             *         2 2 0 0   0 0     0   0   0 2                 2
1824238 ID     school 1602580 371   PAYETTE JOINT DISTRICT 160258001051 1318 PAYETTE ALTERNATIVE CENTER   Special Education School No 4.0 PK 12 2016   grade_9 1 0 0   0 0     0   1   1 1             *         2 1 0 0   0 0     0   1   1 1                 2
1824275 ID     school 1601140 373   FRUITLAND DISTRICT 160114000988 1332 FRUITLAND PREPARATORY ACADEMY   Alternative Education School No 3.0 07 12 2016   grade_9 2 0 0   0 0     0   0   1 1             *         2 2 0 0   0 0     0   0   1 1                 2
1824696 ID     school 1602160 433   MIDVALE DISTRICT 160216000939 1113 MIDVALE ALTERNATIVE SCHOOL   Alternative Education School No 3.0 07 12 2016   grade_9 2 0 0   0 0     0   0   1 1             *         2 2 0 0   0 0     0   0   1 1                 2
1824909 ID     school 1600149 470   THE KOOTENAI BRIDGE ACADEMY, INC. 160014900992 1232 KOOTENAI BRIDGE ACADEMY   Alternative Education School Yes 3.0 09 12 2016   grade_9 1 0 1   0 0     0   0   0 2             *         2 1 0 1   0 0     0   0   0 2                 2
703095 ID     school 1600360 1   BOISE INDEPENDENT DISTRICT 160036000708 9002 ADA COUNTY JUVENILE CENTER   Alternative School No High 05 12 2021   grade_9 1 1 1   0 0     0   0   2 1             *         3 1 1 1   0 0     0   0   2 1                 3
704776 ID     school 1600510 132   CALDWELL DISTRICT 160051000043 1087 SOUTHWEST IDAHO JUVENILE DETENTION   Alternative School No Other 01 12 2021   grade_9 1 0 2   0 0     0   0   2 1             *         3 1 0 2   0 0     0   0   2 1                 3
704953 ID     school 1600600 139   VALLIVUE SCHOOL DISTRICT 160060000914 9017 VALLIVUE ACADEMY   Alternative School No High 09 12 2021   grade_9 1 0 2   0 0     0   0   2 1             *         3 1 0 2   0 0     0   0   2 1                 3
705019 ID     school   150   SODA SPRINGS JOINT DISTRICT   1026 BORDER DISTRICT FREEDOM - SECONDARY             2021   grade_9 3 0 0   0 0     0   0   2 1             *         3 3 0 0   0 0     0   0   2 1                 3
705633 ID     school 1601570 251   JEFFERSON COUNTY JOINT DISTRICT 160157000626 1143 JEFFERSON HIGH SCHOOL   Alternative School No High 09 12 2021   grade_9 3 0 0   0 0     0   0   2 1             *         3 3 0 0   0 0     0   0   2 1                 3
705848 ID     school 1600780 271   COEUR D'ALENE DISTRICT 160078000704 1038 CDA JUVENILE DETENTION CENTER   Alternative School No Other 04 12 2021   grade_9 2 0 0   1 0     0   0   1 2             *         3 2 0 0   1 0     0   0   1 2                 3
705968 ID     school 1602670 273   POST FALLS DISTRICT 160267000705 1084 NEW VISION HIGH SCHOOL   Alternative School No High 09 12 2021   grade_9 3 0 0   0 0     0   0   1 2             *         3 3 0 0   0 0     0   0   1 2                 3
706216 ID     school 1602940 312   SHOSHONE JOINT DISTRICT 160294001026 846 HIGH DESERT   Alternative School No High 09 12 2021   grade_9 2 0 1   0 0     0   0   2 1             *         3 2 0 1   0 0     0   0   2 1                 3
707348 ID     school 1600149 470   THE KOOTENAI BRIDGE ACADEMY, INC. 160014900992 1232 KOOTENAI BRIDGE ACADEMY   Alternative School Yes High 09 12 2021   grade_9 3 0 0   0 0     0   0   2 1             *         3 3 0 0   0 0     0   0   2 1                 3
850485 ID     school 1600510 132   CALDWELL DISTRICT 160051000043 1087 SOUTHWEST IDAHO JUVENILE DETENTION   Alternative School No Other 01 12 2020   grade_9 1 0 2   0 0     0   0   2 1             *         3 1 0 2   0 0     0   0   2 1                 3
852049 ID     school   340   LEWISTON INDEPENDENT DISTRICT   611 NORTHWEST CHILDRENS HOME             2020   grade_9 2 0 1   0 0     0   0   3 0             *         3 2 0 1   0 0     0   0   3 0                 3
852110 ID     school 1601860 340   LEWISTON INDEPENDENT DISTRICT 160186000711 1034 TAMMANY HIGH SCHOOL   Alternative School No High 09 12 2020   grade_9 2 0 0   1 0     0   0   1 2             *         3 2 0 0   1 0     0   0   1 2                 3
1278209 ID     school 1600600 139   VALLIVUE SCHOOL DISTRICT 160060000914 9017 VALLIVUE ACADEMY   Alternative School No High 09 12.0 2018   grade_9 3 0 0   0 0     0   0   2 1             *         3 3 0 0   0 0     0   0   2 1                 3
1278617 ID     school 1601110 215   FREMONT COUNTY JOINT DISTRICT 160111000912 1271 FIVE-COUNTY DETENTION CENTER   Alternative School No High 05 12.0 2018   grade_9 0 0 1   2 0     0   0   0 3             *         3 0 0 1   2 0     0   0   0 3                 3
1278836 ID     school 1601570 251   JEFFERSON COUNTY JOINT DISTRICT 160157000626 1143 JEFFERSON HIGH SCHOOL   Alternative School No High 09 12.0 2018   grade_9 2 0 1   0 0     0   0   2 1             *         3 2 0 1   0 0     0   0   2 1                 3
1278913 ID     school 1601590 261   JEROME JOINT DISTRICT 160159000097 1272 FALLS CITY ACADEMY   Alternative School No High 06 12.0 2018   grade_9 2 0 1   0 0     0   0   1 2             *         3 2 0 1   0 0     0   0   1 2                 3
1279580 ID     school 1601860 340   LEWISTON INDEPENDENT DISTRICT 160186000929 611 NORTHWEST CHILDRENS HOME   Special Education School No Other PK 12.0 2018   grade_9 3 0 0   0 0     0   0   3 0             *         3 3 0 0   0 0     0   0   3 0                 3
1280027 ID     school 1603240 411   TWIN FALLS DISTRICT 160324000703 1066 MAGIC VALLEY HIGH SCHOOL   Alternative School No High 09 12.0 2018   grade_9 2 0 1   0 0     0   0   2 1             *         3 2 0 1   0 0     0   0   2 1                 3
1306438 ID     school 1601530 91   IDAHO FALLS DISTRICT 160153000605 1152 3B JUVENILE DETENTION CENTER   Alternative School No Other 04 12.0 2019   grade_9 0 0 3   0 0     0   0   3 0             *         3 0 0 3   0 0     0   0   3 0                 3
1307294 ID     school 1602520 171   OROFINO JOINT DISTRICT 160252001057 1362 IDAHO YOUTH CHALLENGE ACADEMY FALL   Alternative School No High 09 12.0 2019   grade_9 1 0 2   0 0     0   0   2 1             *         3 1 0 2   0 0     0   0   2 1                 3
1308024 ID     school 1602670 273   POST FALLS DISTRICT 160267000705 1084 NEW VISION HIGH SCHOOL   Alternative School No High 09 12.0 2019   grade_9 3 0 0   0 0     0   0   1 2             *         3 3 0 0   0 0     0   0   1 2                 3
1308896 ID     school 1603240 411   TWIN FALLS DISTRICT 160324000703 1066 MAGIC VALLEY HIGH SCHOOL   Alternative School No High 09 12.0 2019   grade_9 2 0 1   0 0     0   0   3 0             *         3 2 0 1   0 0     0   0   3 0                 3
1309152 ID     school 1602160 433   MIDVALE DISTRICT 160216000939 1113 MIDVALE ALTERNATIVE SCHOOL   Alternative School No High 07 12.0 2019   grade_9 3 0 0   0 0     0   0   1 2             *         3 3 0 0   0 0     0   0   1 2                 3
1682491 ID     school 1600240 33   BEAR LAKE COUNTY DISTRICT 160024000827 404 CLOVER CREEK HIGH SCHOOL   Alternative Education School No 3.0 09 12 2015   grade_9 2 0 1   0 0     0   0   1 2             *         3 2 0 1   0 0     0   0   1 2                 3
1683011 ID     school 1601530 91   IDAHO FALLS DISTRICT 160153000605 1152 3B JUVENILE DETENTION CENTER   Alternative Education School No 4.0 05 12 2015   grade_9 2 0 1   0 0     0   0   3 0             *         3 2 0 1   0 0     0   0   3 0                 3
1683123 ID     school 1600930 93   BONNEVILLE JOINT DISTRICT 160093000649 1159 TELFORD ACADEMY (ALT)   Alternative Education School No 2.0 07 09 2015   grade_9 3 0 0   0 0     0   0   3 0             *         3 3 0 0   0 0     0   0   3 0                 3
1684794 ID     school 1602940 312   SHOSHONE JOINT DISTRICT 160294001026 846 HIGH DESERT   Alternative Education School No 3.0 09 12 2015   grade_9 2 0 1   0 0     0   0   2 1             *         3 2 0 1   0 0     0   0   2 1                 3
1685045 ID     school 1601860 340   LEWISTON INDEPENDENT DISTRICT 160186000170 1266 REGION 2 JUVENILE DETENTION CENTER   Alternative Education School No 4.0 03 12 2015   grade_9 3 0 0   0 0     0   0   3 0             *         3 3 0 0   0 0     0   0   3 0                 3
1727664 ID     school 1600600 139   VALLIVUE SCHOOL DISTRICT 160060000914 9017 VALLIVUE ACADEMY   Alternative School No High 09 12.0 2017   grade_9 1 0 2   0 0     0   0   2 1             *         3 1 0 2   0 0     0   0   2 1                 3
1728379 ID     school 1601590 261   JEROME JOINT DISTRICT 160159000097 1272 FALLS CITY ACADEMY   Alternative School No Other 06 12.0 2017   grade_9 1 0 2   0 0     0   0   2 1             *         3 1 0 2   0 0     0   0   2 1                 3
1728781 ID     school 1603030 292   SOUTH LEMHI DISTRICT 160303000528 137 LEADORE SCHOOL   Regular School No Other PK 12.0 2017   grade_9 3 0 0   0 0     0   0   2 1             *         3 3 0 0   0 0     0   0   2 1                 3
1729044 ID     school   340   LEWISTON INDEPENDENT DISTRICT   611 NORTHWEST CHILDRENS HOME             2017   grade_9 2 0 0   1 0     0   0   2 1             *         3 2 0 0   1 0     0   0   2 1                 3
1729509 ID     school 1603240 411   TWIN FALLS DISTRICT 160324000703 1066 MAGIC VALLEY HIGH SCHOOL   Alternative School No High 09 12.0 2017   grade_9 0 2 1   0 0     0   0   1 2             *         3 0 2 1   0 0     0   0   1 2                 3
1729744 ID     school 1602160 433   MIDVALE DISTRICT 160216000939 1113 MIDVALE ALTERNATIVE SCHOOL   Alternative School No High 07 12.0 2017   grade_9 3 0 0   0 0     0   0   2 1             *         3 3 0 0   0 0     0   0   2 1                 3
1730235 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_9 3 0 0   0 0     0   0   2 1             *         3 3 0 0   0 0     0   0   2 1                 3
1822050 ID     school 1601530 91   IDAHO FALLS DISTRICT 160153000605 1152 3B JUVENILE DETENTION CENTER   Alternative Education School No 4.0 04 12 2016   grade_9 0 0 1   1 0     0   1   3 0             *         3 0 0 1   1 0     0   1   3 0                 3
1822172 ID     school 1600930 93   BONNEVILLE JOINT DISTRICT 160093000649 1159 TELFORD ACADEMY (ALT)   Alternative Education School No 2.0 07 09 2016   grade_9 2 0 0   0 1     0   0   2 1             *         3 2 0 0   0 1     0   0   2 1                 3
1822868 ID     school 1602520 171   OROFINO JOINT DISTRICT 160252001057 1362 IDAHO YOUTH CHALLENGE ACADEMY FALL   Alternative Education School No 3.0 09 12 2016   grade_9 2 0 0   1 0     0   0   2 1             *         3 2 0 0   1 0     0   0   2 1                 3
1823944 ID     school 1603090 322   SUGAR-SALEM JOINT DISTRICT 160309000853 874 VALLEY VIEW ALTERNATIVE HIGH SCHOOL   Alternative Education School No 3.0 09 12 2016   grade_9 2 0 1   0 0     0   0   2 1             *         3 2 0 1   0 0     0   0   2 1                 3
1824017 ID     school 1601860 340   LEWISTON INDEPENDENT DISTRICT 160186000323 153 LEWISTON HIGH SCHOOL   Regular School No 3.0 09 12 2016   grade_9 3 0 0   0 0     0   0   2 1             *         3 3 0 0   0 0     0   0   2 1                 3
1824475 ID     school 1603240 411   TWIN FALLS DISTRICT 160324000703 1066 MAGIC VALLEY HIGH SCHOOL   Alternative Education School No 3.0 09 12 2016   grade_9 2 0 1   0 0     0   0   2 1             *         3 2 0 1   0 0     0   0   2 1                 3
1825051 ID     school 1600170 486   UPPER CARMEN PUBLIC CHARTER SCHOOL, INC. 160017000847 1366 UPPER CARMEN PUBLIC CHARTER SCHOOL   Regular School Yes 1.0 PK 08 2016   grade_9 3 0 0   0 0     0   0   1 2             *         3 3 0 0   0 0     0   0   1 2                 3
704012 ID     school 1600300 61   BLAINE COUNTY DISTRICT 160030000197 1102 SILVER CREEK HIGH SCHOOL   Alternative School No High 09 12 2021   grade_9 1 0 3   0 0     0   0   2 2             *         4 1 0 3   0 0     0   0   2 2                 4

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