Data source: Big Local News · About: Big Local

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

View and edit SQL

year

grade

  • grade_9 · 1,641
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
705443 ID     school 1601020 221   EMMETT INDEPENDENT DISTRICT 160102000923 1111 THE PATRIOT CENTER   Alternative School No High 06 12 2021   grade_9 0 0 1   0 0     0   0   1 0             *         1 0 0 1   0 0     0   0   1 0                 1
706849 ID     school 1603240 411   TWIN FALLS DISTRICT 160324000703 1066 MAGIC VALLEY HIGH SCHOOL   Alternative School No High 09 12 2021   grade_9 0 0 1   0 0     0   0   0 1             *         1 0 0 1   0 0     0   0   0 1                 1
706863 ID     school 1603240 411   TWIN FALLS DISTRICT 160324000739 1260 SNAKE RIVER JUVENILE DETENTION   Alternative School No Other 01 12 2021   grade_9 0 0 1   0 0     0   0   1 0             *         1 0 0 1   0 0     0   0   1 0                 1
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
850154 ID     school 1600930 93   BONNEVILLE JOINT DISTRICT 160093000361 1053 LINCOLN HIGH SCHOOL   Alternative School No High 07 12 2020   grade_9 0 0 1   0 0     0   0   1 0             *         1 0 0 1   0 0     0   0   1 0                 1
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
1279824 ID     school 1601140 373   FRUITLAND DISTRICT 160114000988 1332 FRUITLAND PREPARATORY ACADEMY   Alternative School No High 06 12.0 2018   grade_9 0 0 0   0 0     0   1   1 0             *         1 0 0 0   0 0     0   1   1 0                 1
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
1304995 ID     school 1600360 1   BOISE INDEPENDENT DISTRICT 160036000045 8 BORAH SENIOR HIGH SCHOOL   Regular School No High 09 12.0 2019   grade_9 0 7 0   0 0     0   0   4 3             *         7 0 7 0   0 0     0   0   4 3                 7
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
1308178 ID     school 1602850 291   SALMON DISTRICT 160285000700 9014 SALMON ALTERNATIVE HIGH SCHOOL   Alternative School No High 09 12.0 2019   grade_9 0 1 0   0 0     0   0   1 0             *         1 0 1 0   0 0     0   0   1 0                 1
1308424 ID     school 1602190 331   MINIDOKA COUNTY JOINT DISTRICT 160219000166 1100 MINI-CASSIA JUVENILE DETENTION CENTER   Alternative School No Other 03 12.0 2019   grade_9 0 0 1   0 0     0   0   0 1             *         1 0 0 1   0 0     0   0   0 1                 1
1308511 ID     school 1601860 340   LEWISTON INDEPENDENT DISTRICT 160186000170 1266 REGION 2 JUVENILE DETENTION CENTER   Alternative School No Other 03 12.0 2019   grade_9 0 0 0   1 0     0   0   1 0             *         1 0 0 0   1 0     0   0   1 0                 1
1308957 ID     school 1600480 412   BUHL JOINT DISTRICT 160048001106 1403 WAKAPA ACADEMY   Alternative School No High 09 12.0 2019   grade_9 0 0 1   0 0     0   0   0 1             *         1 0 0 1   0 0     0   0   0 1                 1
1683249 ID     school 1600540 121   CAMAS COUNTY DISTRICT 160054000110 440 CAMAS COUNTY ELEM/JR HIGH SCHOOL   Regular School No 1.0 PK 08 2015   grade_9 0 0 1   0 0     0   0   1 0             *         1 0 0 1   0 0     0   0   1 0                 1
1683616 ID     school 1600600 139   VALLIVUE SCHOOL DISTRICT 160060001011 1296 VALLIVUE VIRTUAL ACADEMY   Regular School No 4.0 PK 12 2015   grade_9 0 0 1   0 0     0   0   0 1             *         1 0 0 1   0 0     0   0   0 1                 1
1684952 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_9 0 0 1   0 0     0   0   1 0             *         1 0 0 1   0 0     0   0   1 0                 1
1685231 ID     school 1601140 373   FRUITLAND DISTRICT 160114000988 1332 FRUITLAND PREPARATORY ACADEMY   Alternative Education School No 3.0 07 12 2015   grade_9 0 0 1   0 0     0   0   0 1             *         1 0 0 1   0 0     0   0   0 1                 1
1685880 ID     school 1600149 470   THE KOOTENAI BRIDGE ACADEMY, INC. 160014900992 1232 KOOTENAI BRIDGE ACADEMY   Alternative Education School Yes 3.0 09 12 2015   grade_9 0 0 0   0 0     0   1   0 1             *         1 0 0 0   0 0     0   1   0 1                 1
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
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
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
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
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
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
1824098 ID     school 1601830 341   LAPWAI DISTRICT 160183000854 583 LAPWAI MIDDLE/HIGH SCHOOL   Regular School No 4.0 06 12 2016   grade_9 0 0 2   34 0     0   2   17 21             *         38 0 0 2   34 0     0   2   17 21                 38
1824480 ID     school 1603240 411   TWIN FALLS DISTRICT 160324000755 1147 BRIDGE ACADEMY   Alternative Education School No 3.0 07 12 2016   grade_9 0 4 0   0 0     0   0   4 0             *         4 0 4 0   0 0     0   0   4 0                 4
702790 ID     school 1600360 1   BOISE INDEPENDENT DISTRICT 160036000045 8 BORAH SENIOR HIGH SCHOOL   Regular School No High 09 12 2021   grade_9 1 0 0   0 0     0   0   1 0             *         1 1 0 0   0 0     0   0   1 0                 1
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
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
703715 ID     school 1602640 25   POCATELLO DISTRICT 160264000186 9034 POCATELLO JUVENILE DETENTION   Alternative School No Other 01 12 2021   grade_9 1 0 0   0 0     0   0   1 0             *         1 1 0 0   0 0     0   0   1 0                 1
703750 ID     school 1600240 33   BEAR LAKE COUNTY DISTRICT 160024000827 404 CLOVER CREEK HIGH SCHOOL   Alternative School No High 09 12 2021   grade_9 1 0 0   0 0     0   0   1 0             *         1 1 0 0   0 0     0   0   1 0                 1
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
704429 ID     school 1600930 93   BONNEVILLE JOINT DISTRICT 160093000361 1053 LINCOLN HIGH SCHOOL   Alternative School No High 07 12 2021   grade_9 1 0 0   0 0     0   0   0 1             *         1 1 0 0   0 0     0   0   0 1                 1
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
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
706132 ID     school 1602850 291   SALMON DISTRICT 160285000700 9014 SALMON ALTERNATIVE HIGH SCHOOL   Alternative School No High 09 12 2021   grade_9 1 0 0   0 0     0   0   0 1             *         1 1 0 0   0 0     0   0   0 1                 1
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
706545 ID     school   364   PLEASANT VALLEY ELEMENTARY DISTRICT   1056 BORDER DISTRICT - JORDAN VALLEY SECONDARY             2021   grade_9 1 0 0   0 0     0   0   0 1             *         1 1 0 0   0 0     0   0   0 1                 1
706646 ID     school 1601140 373   FRUITLAND DISTRICT 160114000988 1332 FRUITLAND PREPARATORY ACADEMY   Alternative School No High 06 12 2021   grade_9 1 0 0   0 0     0   0   1 0             *         1 1 0 0   0 0     0   0   1 0                 1
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
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
850665 ID     school 1600600 139   VALLIVUE SCHOOL DISTRICT 160060000914 9017 VALLIVUE ACADEMY   Alternative School No High 09 12 2020   grade_9 1 0 0   0 0     0   0   0 1             *         1 1 0 0   0 0     0   0   0 1                 1
851784 ID     school 1602850 291   SALMON DISTRICT 160285000700 9014 SALMON ALTERNATIVE HIGH SCHOOL   Alternative School No High 09 12 2020   grade_9 1 0 0   0 0     0   0   0 1             *         1 1 0 0   0 0     0   0   0 1                 1
852039 ID     school 1601860 340   LEWISTON INDEPENDENT DISTRICT 160186000323 153 LEWISTON HIGH SCHOOL   Regular School No High 09 12 2020   grade_9 1 0 0   0 0     0   0   1 0             *         1 1 0 0   0 0     0   0   1 0                 1
852116 ID     school 1601860 340   LEWISTON INDEPENDENT DISTRICT 160186000170 1266 REGION 2 JUVENILE DETENTION CENTER   Alternative School No Other 03 12 2020   grade_9 1 0 0   0 0     0   0   1 0             *         1 1 0 0   0 0     0   0   1 0                 1
852124 ID     school 1601830 341   LAPWAI DISTRICT 160183000854 583 LAPWAI MIDDLE/HIGH SCHOOL   Regular School No High 06 12 2020   grade_9 1 0 1   33 0     1   3   21 18             19         39 1 0 1   33 0     1   3   21 18         19       39
852208 ID     school   364   PLEASANT VALLEY ELEMENTARY DISTRICT   1056 BORDER DISTRICT - JORDAN VALLEY SECONDARY             2020   grade_9 1 0 0   0 0     0   0   0 1             *         1 1 0 0   0 0     0   0   0 1                 1
852300 ID     school 1601140 373   FRUITLAND DISTRICT 160114000988 1332 FRUITLAND PREPARATORY ACADEMY   Alternative School No High 06 12 2020   grade_9 1 0 0   0 0     0   0   0 1             *         1 1 0 0   0 0     0   0   0 1                 1
852517 ID     school 1603240 411   TWIN FALLS DISTRICT 160324000739 1260 SNAKE RIVER JUVENILE DETENTION   Alternative School No Other 01 12 2020   grade_9 1 0 0   0 0     0   0   0 1             *         1 1 0 0   0 0     0   0   0 1                 1
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
852865 ID     school 1600011 457   INSPIRE ACADEMICS, INC. 160001101120 1430 EMPOWER CONNECTIONS ACADEMY   Alternative School Yes High 06 12 2020   grade_9 1 0 0   0 0     0   0   1 0             *         1 1 0 0   0 0     0   0   1 0                 1
1276138 ID     school 1600360 1   BOISE INDEPENDENT DISTRICT 160036000045 8 BORAH SENIOR HIGH SCHOOL   Regular School No High 09 13.0 2018   grade_9 1 6 1   0 2     0   0   5 5             *         10 1 6 1   0 2     0   0   5 5                 10
1276143 ID     school 1600360 1   BOISE INDEPENDENT DISTRICT 160036000047 9 CAPITAL SENIOR HIGH SCHOOL   Regular School No High 09 13.0 2018   grade_9 1 0 0   0 0     0   0   1 0             *         1 1 0 0   0 0     0   0   1 0                 1
1277381 ID     school 1600001 83   WEST BONNER COUNTY DISTRICT 160000100771 1172 PRIEST RIVER EDUCATIONAL PROGRAM (PREP)   Alternative School No High 09 12.0 2018   grade_9 1 0 0   0 0     0   0   1 0             *         1 1 0 0   0 0     0   0   1 0                 1
1278192 ID     school 1600600 139   VALLIVUE SCHOOL DISTRICT 160060001011 1296 VALLIVUE VIRTUAL ACADEMY   Regular School No Other PK 12.0 2018   grade_9 1 0 0   0 0     0   0   1 0             *         1 1 0 0   0 0     0   0   1 0                 1
1279310 ID     school 1602850 291   SALMON DISTRICT 160285000700 9014 SALMON ALTERNATIVE HIGH SCHOOL   Alternative School No High 09 12.0 2018   grade_9 1 0 0   0 0     0   0   1 0             *         1 1 0 0   0 0     0   0   1 0                 1
1279641 ID     school 1601860 340   LEWISTON INDEPENDENT DISTRICT 160186000711 1034 TAMMANY HIGH SCHOOL   Alternative School No High 09 12.0 2018   grade_9 1 0 0   0 0     0   0   0 1             *         1 1 0 0   0 0     0   0   0 1                 1
1279644 ID     school 1601860 340   LEWISTON INDEPENDENT DISTRICT 160186000170 1266 REGION 2 JUVENILE DETENTION CENTER   Alternative School No Other 03 12.0 2018   grade_9 1 0 0   0 0     0   0   1 0             *         1 1 0 0   0 0     0   0   1 0                 1
1279652 ID     school 1601830 341   LAPWAI DISTRICT 160183000854 583 LAPWAI MIDDLE/HIGH SCHOOL   Regular School No High 06 12.0 2018   grade_9 1 0 1   26 0     0   1   18 11             *         29 1 0 1   26 0     0   1   18 11                 29
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
1280330 ID     school 1600005 453   IDAHO VIRTUAL HIGH SCHOOL, INC. 160000501108 1399 RICHARD MCKENNA CHARTER SCHOOL - ONSITE   Regular School Yes High 09 12.0 2018   grade_9 1 0 0   0 0     0   0   0 1             *         1 1 0 0   0 0     0   0   0 1                 1
1306459 ID     school   92   SWAN VALLEY ELEMENTARY DISTRICT   1015 BORDER DISTRICT - STAR VALLEY JR-SR HIGH SCHOOL             2019   grade_9 1 0 0   0 0     0   0   0 1             *         1 1 0 0   0 0     0   0   0 1                 1
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
1307227 ID     school 1600660 151   CASSIA COUNTY JOINT DISTRICT 160066000540 990 CASSIA JR/SR HIGH SCHOOL   Alternative School No High 07 12.0 2019   grade_9 1 0 10   0 0     0   0   5 6             *         11 1 0 10   0 0     0   0   5 6                 11
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
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
1307707 ID     school 1601570 251   JEFFERSON COUNTY JOINT DISTRICT 160157000626 1143 JEFFERSON HIGH SCHOOL   Alternative School No High 07 12.0 2019   grade_9 1 0 0   0 0     0   0   1 0             *         1 1 0 0   0 0     0   0   1 0                 1
1308191 ID     school 1603030 292   SOUTH LEMHI DISTRICT 160303000528 137 LEADORE SCHOOL   Regular School No Other PK 12.0 2019   grade_9 1 0 0   0 0     0   0   0 1             *         1 1 0 0   0 0     0   0   0 1                 1
1308264 ID     school 1602940 312   SHOSHONE JOINT DISTRICT 160294001026 846 HIGH DESERT   Alternative School No High 09 12.0 2019   grade_9 1 0 3   0 0     0   0   4 0             *         4 1 0 3   0 0     0   0   4 0                 4
1308437 ID     school 1601860 340   LEWISTON INDEPENDENT DISTRICT 160186000323 153 LEWISTON HIGH SCHOOL   Regular School No High 09 12.0 2019   grade_9 1 0 0   0 0     0   0   0 1             *         1 1 0 0   0 0     0   0   0 1                 1
1308528 ID     school   341   LAPWAI DISTRICT   1050 NORTHWEST CHILDREN'S HOME             2019   grade_9 1 0 0   0 0     0   0   1 0             *         1 1 0 0   0 0     0   0   1 0                 1
1309118 ID     school 1603330 431   WEISER DISTRICT 160333001049 1067 INDIANHEAD ACADEMY HIGH SCHOOL   Alternative School No High 09 12.0 2019   grade_9 1 0 0   0 0     0   0   1 0             *         1 1 0 0   0 0     0   0   1 0                 1
1309126 ID     school 1600570 432   CAMBRIDGE JOINT DISTRICT 160057000113 193 CAMBRIDGE MIDDLE/HIGH SCHOOL   Regular School No High 06 12.0 2019   grade_9 1 0 0   0 0     0   0   0 1             *         1 1 0 0   0 0     0   0   0 1                 1
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
1683383 ID     school 1602340 131   NAMPA SCHOOL DISTRICT 160234000762 1154 UNION HIGH SCHOOL   Alternative Education School No 3.0 09 12 2015   grade_9 1 0 0   0 0     0   0   0 1             *         1 1 0 0   0 0     0   0   0 1                 1
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
1684980 ID     school   340   LEWISTON INDEPENDENT DISTRICT   611 NORTHWEST CHILDRENS HOME             2015   grade_9 1 0 0   0 0     0   0   1 0             *         1 1 0 0   0 0     0   0   1 0                 1
1685116 ID     school 1601980 363   MARSING JOINT DISTRICT 160198000636 530 MARSING MIDDLE SCHOOL   Regular School No 2.0 06 08 2015   grade_9 1 0 0   0 0     0   0   1 0             *         1 1 0 0   0 0     0   0   1 0                 1
1685373 ID     school 1603180 401   TETON COUNTY DISTRICT 160318000884 875 BASIN ALTERNATIVE HIGH SCHOOL   Alternative Education School No 3.0 09 12 2015   grade_9 1 0 0   0 0     0   0   0 1             *         1 1 0 0   0 0     0   0   0 1                 1
1685460 ID     school 1603240 411   TWIN FALLS DISTRICT 160324000739 1260 SNAKE RIVER JUVENILE DETENTION   Alternative Education School No 4.0 01 12 2015   grade_9 1 0 0   0 0     0   0   1 0             *         1 1 0 0   0 0     0   0   1 0                 1
1685593 ID     school 1602030 421   MCCALL-DONNELLY JOINT SCHOOL DISTRICT 160203000713 1070 VALLEY COUNTY JUVENILE DETENTION   Alternative Education School No 4.0 05 12 2015   grade_9 1 0 0   0 0     0   0   0 1             *         1 1 0 0   0 0     0   0   0 1                 1
1686147 ID     school 1602190 790   ADVANCED REGIONAL TECHNICAL EDUCATION, INC. 160219000883 639 ARTEC CHARTER SCHOOL   Vocational Education School Yes 3.0 09 12 2015   grade_9 1 0 0   0 0     0   0   1 0             *         1 1 0 0   0 0     0   0   1 0                 1
1726759 ID     school 1600300 61   BLAINE COUNTY DISTRICT 160030000197 1102 SILVER CREEK HIGH SCHOOL   Alternative School No High 09 12.0 2017   grade_9 1 0 3   0 0     0   0   2 2             *         4 1 0 3   0 0     0   0   2 2                 4
1726844 ID     school 1600001 83   WEST BONNER COUNTY DISTRICT 160000100771 1172 PRIEST RIVER EDUCATIONAL PROGRAM (PREP)   Alternative School No High 09 12.0 2017   grade_9 1 0 0   0 0     0   0   0 1             *         1 1 0 0   0 0     0   0   0 1                 1
1726921 ID     school 1600002 84   LAKE PEND OREILLE SCHOOL DISTRICT 160000200604 997 SANDPOINT JUVENILE DETENTION   Alternative School No Other 05 12.0 2017   grade_9 1 0 0   0 0     0   0   1 0             *         1 1 0 0   0 0     0   0   1 0                 1
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
1727488 ID     school 1600510 132   CALDWELL DISTRICT 160051000043 1087 SOUTHWEST IDAHO JUVENILE DETENTION   Alternative School No Other 01 12.0 2017   grade_9 1 0 6   1 0     0   1   4 5             *         9 1 0 6   1 0     0   1   4 5                 9
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
1727728 ID     school   150   SODA SPRINGS JOINT DISTRICT   1026 BORDER DISTRICT FREEDOM - SECONDARY             2017   grade_9 1 0 0   0 0     0   0   1 0             *         1 1 0 0   0 0     0   0   1 0                 1
1728015 ID     school 1600960 201   PRESTON JOINT DISTRICT 160096000764 8844 FRANKLIN COUNTY HIGH SCHOOL   Alternative School No High 09 12.0 2017   grade_9 1 0 0   0 0     0   0   1 0             *         1 1 0 0   0 0     0   0   1 0                 1
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
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

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