Data source: Big Local News · About: Big Local

2,772 rows where grade = "grade_2" and state = "ID" sorted by total_int

View and edit SQL

year

grade

  • grade_2 · 2,672
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 ▼
1279688 ID     school 1602490 351   ONEIDA COUNTY DISTRICT 160249000434 797 STONE ELEMENTARY SCHOOL   Regular School No Elementary PK 3.0 2018   grade_2 3 0 1   0 0     0   0   3 1             *         4 3 0 1   0 0     0   0   3 1                 4
1308735 ID     school 1600090 383   ARBON ELEMENTARY DISTRICT 160009000006 810 ARBON ELEMENTARY SCHOOL   Regular School No Elementary KG 6.0 2019   grade_2 3 0 1   0 0     0   0   3 1             *         4 3 0 1   0 0     0   0   3 1                 4
1683802 ID     school 1602520 171   OROFINO JOINT DISTRICT 160252000436 481 CAVENDISH-TEAKEAN ELEMENTARY SCHOOL   Regular School No 1.0 PK 06 2015   grade_2 4 0 0   0 0     0   0   3 1             *         4 4 0 0   0 0     0   0   3 1                 4
1685098 ID     school 1602490 351   ONEIDA COUNTY DISTRICT 160249000434 797 STONE ELEMENTARY SCHOOL   Regular School No 1.0 PK 03 2015   grade_2 3 0 1   0 0     0   0   1 3             *         4 3 0 1   0 0     0   0   1 3                 4
1729384 ID     school 1602280 392   MULLAN DISTRICT 160228000404 815 JOHN MULLAN ELEMENTARY SCHOOL   Regular School No Elementary PK 6.0 2017   grade_2 4 0 0   0 0     0   0   1 3             *         4 4 0 0   0 0     0   0   1 3                 4
1821816 ID     school 1600001 83   WEST BONNER COUNTY DISTRICT 160000100620 406 PRIEST LAKE ELEMENTARY SCHOOL   Regular School No 1.0 PK 06 2016   grade_2 4 0 0   0 0     0   0   3 1             *         4 4 0 0   0 0     0   0   3 1                 4
1822858 ID     school 1602520 171   OROFINO JOINT DISTRICT 160252000442 482 PECK ELEMENTARY SCHOOL   Regular School No 1.0 PK 06 2016   grade_2 2 0 0   0 1     0   1   3 1             *         4 2 0 0   0 1     0   1   3 1                 4
1823104 ID     school 1601020 221   EMMETT INDEPENDENT DISTRICT 160102000190 710 OLA ELEMENTARY SCHOOL   Regular School No 1.0 PK 06 2016   grade_2 4 0 0   0 0     0   0   3 1             *         4 4 0 0   0 0     0   0   3 1                 4
1823202 ID     school 1600138 243   SALMON RIVER JOINT SCHOOL DISTRICT 160013800959 1280 RIGGINS ELEMENTARY SCHOOL   Regular School No 1.0 PK 05 2016   grade_2 4 0 0   0 0     0   0   3 1             *         4 4 0 0   0 0     0   0   3 1                 4
1823770 ID     school 1603030 292   SOUTH LEMHI DISTRICT 160303000529 765 TENDOY ELEMENTARY SCHOOL   Regular School No 1.0 KG 06 2016   grade_2 3 0 0   0 0     0   1   1 3             *         4 3 0 0   0 0     0   1   1 3                 4
1824111 ID     school 1600870 342   CULDESAC JOINT DISTRICT 160087000164 795 CULDESAC SCHOOL   Regular School No 4.0 PK 12 2016   grade_2 3 0 0   0 1     0   0   1 3             *         4 3 0 0   0 1     0   0   1 3                 4
1824133 ID     school 1602490 351   ONEIDA COUNTY DISTRICT 160249000434 797 STONE ELEMENTARY SCHOOL   Regular School No 1.0 PK 03 2016   grade_2 4 0 0   0 0     0   0   3 1             *         4 4 0 0   0 0     0   0   3 1                 4
1824161 ID     school 1602610 364   PLEASANT VALLEY ELEMENTARY DISTRICT 160261000459 800 PLEASANT VALLEY ELEM/JR HIGH   Regular School No 1.0 PK 08 2016   grade_2 4 0 0   0 0     0   0   3 1             *         4 4 0 0   0 0     0   0   3 1                 4
706138 ID     school 1603030 292   SOUTH LEMHI DISTRICT 160303000528 137 LEADORE SCHOOL   Regular School No Other PK 12 2021   grade_2 4 0 0   0 0     0   1   1 4             *         5 4 0 0   0 0     0   1   1 4                 5
706498 ID     school 1602490 351   ONEIDA COUNTY DISTRICT 160249000434 797 STONE ELEMENTARY SCHOOL   Regular School No Elementary PK 03 2021   grade_2 4 0 1   0 0     0   0   4 1             *         5 4 0 1   0 0     0   0   4 1                 5
706556 ID     school 1600450 365   BRUNEAU-GRAND VIEW JOINT SCHOOL DISTRICT 160045000098 801 BRUNEAU ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2021   grade_2 5 0 0   0 0     0   0   3 2             *         5 5 0 0   0 0     0   0   3 2                 5
850045 ID     school 1603120 92   SWAN VALLEY ELEMENTARY DISTRICT 160312000541 424 SWAN VALLEY ELEMENTARY SCHOOL   Regular School No Elementary PK 08 2020   grade_2 5 0 0   0 0     0   0   3 2             *         5 5 0 0   0 0     0   0   3 2                 5
852165 ID     school 1602490 351   ONEIDA COUNTY DISTRICT 160249000434 797 STONE ELEMENTARY SCHOOL   Regular School No Elementary PK 03 2020   grade_2 5 0 0   0 0     0   0   3 2             *         5 5 0 0   0 0     0   0   3 2                 5
853305 ID     school 1600172 534   GEM PREP: ONLINE LLC 160017200846 1426 GEM PREP: ONLINE SCHOOL   Regular School Yes Other PK 12 2020   grade_2 3 0 0   0 0     0   2   2 3             *         5 3 0 0   0 0     0   2   2 3                 5
1278643 ID     school 1601020 221   EMMETT INDEPENDENT DISTRICT 160102000192 707 SWEET MONTOUR ELEMENTARY SCHOOL   Regular School No Elementary KG 5.0 2018   grade_2 4 0 1   0 0     0   0   2 3             *         5 4 0 1   0 0     0   0   2 3                 5
1280263 ID     school 1602160 433   MIDVALE DISTRICT 160216000857 286 MIDVALE SCHOOL   Regular School No Other PK 12.0 2018   grade_2 5 0 0   0 0     0   0   3 2             *         5 5 0 0   0 0     0   0   3 2                 5
1307246 ID     school 1600750 161   CLARK COUNTY DISTRICT 160075000145 478 LINDY ROSS ELEMENTARY SCHOOL   Regular School No Elementary PK 8.0 2019   grade_2 1 0 4   0 0     0   0   4 1             *         5 1 0 4   0 0     0   0   4 1                 5
1307284 ID     school 1602520 171   OROFINO JOINT DISTRICT 160252000442 482 PECK ELEMENTARY SCHOOL   Regular School No Elementary PK 6.0 2019   grade_2 4 0 1   0 0     0   0   3 2             *         5 4 0 1   0 0     0   0   3 2                 5
1307517 ID     school 1601020 221   EMMETT INDEPENDENT DISTRICT 160102000192 707 SWEET MONTOUR ELEMENTARY SCHOOL   Regular School No Elementary KG 5.0 2019   grade_2 5 0 0   0 0     0   0   3 2             *         5 5 0 0   0 0     0   0   3 2                 5
1308195 ID     school 1603030 292   SOUTH LEMHI DISTRICT 160303000529 765 TENDOY ELEMENTARY SCHOOL   Regular School No Elementary KG 5.0 2019   grade_2 5 0 0   0 0     0   0   3 2             *         5 5 0 0   0 0     0   0   3 2                 5
1308767 ID     school 1602280 392   MULLAN DISTRICT 160228000405 172 MULLAN SCHOOLS   Regular School No Other KG 12.0 2019   grade_2 4 0 0   0 0     0   1   2 3             *         5 4 0 0   0 0     0   1   2 3                 5
1308973 ID     school 1601050 413   FILER DISTRICT 160105000195 832 HOLLISTER ELEMENTARY SCHOOL   Regular School No Elementary PK 5.0 2019   grade_2 1 0 4   0 0     0   0   3 2             *         5 1 0 4   0 0     0   0   3 2                 5
1683223 ID     school 1600490 111   BUTTE COUNTY JOINT DISTRICT 160049000011 438 HOWE ELEMENTARY SCHOOL   Regular School No 1.0 PK 05 2015   grade_2 4 0 1   0 0     0   0   4 1             *         5 4 0 1   0 0     0   0   4 1                 5
1683748 ID     school 1600660 151   CASSIA COUNTY JOINT DISTRICT 160066000122 475 ALBION ELEMENTARY SCHOOL   Regular School No 1.0 PK 05 2015   grade_2 5 0 0   0 0     0   0   2 3             *         5 5 0 0   0 0     0   0   2 3                 5
1684713 ID     school 1603030 292   SOUTH LEMHI DISTRICT 160303000528 137 LEADORE SCHOOL   Regular School No 4.0 PK 12 2015   grade_2 5 0 0   0 0     0   0   3 2             *         5 5 0 0   0 0     0   0   3 2                 5
1728341 ID     school 1603400 253   WEST JEFFERSON DISTRICT 160340000273 729 HAMER ELEMENTARY SCHOOL   Regular School No Elementary KG 4.0 2017   grade_2 4 0 1   0 0     0   0   4 1             *         5 4 0 1   0 0     0   0   4 1                 5
1730228 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_2 3 0 1   1 0     0   0   3 2             *         5 3 0 1   1 0     0   0   3 2                 5
1821330 ID     school 1601950 21   MARSH VALLEY JOINT DISTRICT 160195000346 349 LAVA ELEMENTARY SCHOOL   Regular School No 1.0 PK 06 2016   grade_2 5 0 0   0 0     0   0   3 2             *         5 5 0 0   0 0     0   0   3 2                 5
1823621 ID     school 1601740 274   KOOTENAI DISTRICT 160174000302 751 HARRISON ELEMENTARY SCHOOL   Regular School No 1.0 KG 05 2016   grade_2 5 0 0   0 0     0   0   3 2             *         5 5 0 0   0 0     0   0   3 2                 5
1824315 ID     school 1600090 383   ARBON ELEMENTARY DISTRICT 160009000006 810 ARBON ELEMENTARY SCHOOL   Regular School No 1.0 KG 06 2016   grade_2 4 0 0   1 0     0   0   3 2             *         5 4 0 0   1 0     0   0   3 2                 5
1825164 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_2 3 0 2   0 0     0   0   2 3             *         5 3 0 2   0 0     0   0   2 3                 5
705420 ID     school 1601020 221   EMMETT INDEPENDENT DISTRICT 160102000192 707 SWEET MONTOUR ELEMENTARY SCHOOL   Regular School No Elementary KG 05 2021   grade_2 6 0 0   0 0     0   0   4 2             *         6 6 0 0   0 0     0   0   4 2                 6
849810 ID     school 1600001 83   WEST BONNER COUNTY DISTRICT 160000100620 406 PRIEST LAKE ELEMENTARY SCHOOL   Regular School No Elementary PK 06 2020   grade_2 5 0 1   0 0     0   0   5 1             *         6 5 0 1   0 0     0   0   5 1                 6
850721 ID     school   150   SODA SPRINGS JOINT DISTRICT   1025 BORDER DISTRICT - FREEDOM ELEMENTARY             2020   grade_2 6 0 0   0 0     0   0   1 5             *         6 6 0 0   0 0     0   0   1 5                 6
851194 ID     school 1600330 234   BLISS JOINT DISTRICT 160033000040 714 BLISS SCHOOL   Regular School No Other PK 12 2020   grade_2 4 0 2   0 0     0   0   3 3             *         6 4 0 2   0 0     0   0   3 3                 6
851652 ID     school 1601740 274   KOOTENAI DISTRICT 160174000302 751 HARRISON ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2020   grade_2 4 0 0   0 0     0   2   5 1             *         6 4 0 0   0 0     0   2   5 1                 6
851790 ID     school 1603030 292   SOUTH LEMHI DISTRICT 160303000528 137 LEADORE SCHOOL   Regular School No Other PK 12 2020   grade_2 5 0 0   0 0     0   1   4 2             *         6 5 0 0   0 0     0   1   4 2                 6
852740 ID     school 1602160 433   MIDVALE DISTRICT 160216000857 286 MIDVALE SCHOOL   Regular School No Other PK 12 2020   grade_2 6 0 0   0 0     0   0   5 1             *         6 6 0 0   0 0     0   0   5 1                 6
1276835 ID     school 1602060 11   MEADOWS VALLEY DISTRICT 160206000826 342 MEADOWS VALLEY SCHOOL   Regular School No Other PK 12.0 2018   grade_2 5 0 1   0 0     0   0   1 5             *         6 5 0 1   0 0     0   0   1 5                 6
1278875 ID     school 1603400 253   WEST JEFFERSON DISTRICT 160340000273 729 HAMER ELEMENTARY SCHOOL   Regular School No Elementary KG 4.0 2018   grade_2 4 0 2   0 0     0   0   5 1             *         6 4 0 2   0 0     0   0   5 1                 6
1306217 ID     school 1600001 83   WEST BONNER COUNTY DISTRICT 160000100620 406 PRIEST LAKE ELEMENTARY SCHOOL   Regular School No Elementary PK 6.0 2019   grade_2 6 0 0   0 0     0   0   4 2             *         6 6 0 0   0 0     0   0   4 2                 6
1308235 ID     school 1601440 305   HIGHLAND JOINT DISTRICT 160144000849 285 HIGHLAND SCHOOL   Regular School No Other PK 12.0 2019   grade_2 6 0 0   0 0     0   0   1 5             *         6 6 0 0   0 0     0   0   1 5                 6
1309139 ID     school 1602160 433   MIDVALE DISTRICT 160216000857 286 MIDVALE SCHOOL   Regular School No Other PK 12.0 2019   grade_2 5 0 1   0 0     0   0   3 3             *         6 5 0 1   0 0     0   0   3 3                 6
1684046 ID     school 1601020 221   EMMETT INDEPENDENT DISTRICT 160102000192 707 SWEET MONTOUR ELEMENTARY SCHOOL   Regular School No 1.0 KG 06 2015   grade_2 5 0 1   0 0     0   0   5 1             *         6 5 0 1   0 0     0   0   5 1                 6
1684054 ID     school 1601020 221   EMMETT INDEPENDENT DISTRICT 160102000190 710 OLA ELEMENTARY SCHOOL   Regular School No 1.0 PK 06 2015   grade_2 6 0 0   0 0     0   0   4 2             *         6 6 0 0   0 0     0   0   4 2                 6
1684151 ID     school 1600138 243   SALMON RIVER JOINT SCHOOL DISTRICT 160013800959 1280 RIGGINS ELEMENTARY SCHOOL   Regular School No 1.0 PK 05 2015   grade_2 6 0 0   0 0     0   0   3 3             *         6 6 0 0   0 0     0   0   3 3                 6
1685074 ID     school 1600870 342   CULDESAC JOINT DISTRICT 160087000164 795 CULDESAC SCHOOL   Regular School No 4.0 PK 12 2015   grade_2 5 0 0   1 0     0   0   5 1             *         6 5 0 0   1 0     0   0   5 1                 6
1686120 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_2 5 0 1   0 0     0   0   4 2             *         6 5 0 1   0 0     0   0   4 2                 6
1727061 ID     school 1603120 92   SWAN VALLEY ELEMENTARY DISTRICT 160312000541 424 SWAN VALLEY ELEMENTARY SCHOOL   Regular School No Elementary PK 8.0 2017   grade_2 5 0 1   0 0     0   0   1 5             *         6 5 0 1   0 0     0   0   1 5                 6
1728058 ID     school 1601110 215   FREMONT COUNTY JOINT DISTRICT 160111000204 700 PARKER-EGIN ELEMENTARY SCHOOL   Regular School No Elementary PK 5.0 2017   grade_2 5 0 0   0 0     1   0   5 1             *         6 5 0 0   0 0     1   0   5 1                 6
1728106 ID     school 1601020 221   EMMETT INDEPENDENT DISTRICT 160102000192 707 SWEET MONTOUR ELEMENTARY SCHOOL   Regular School No Elementary KG 6.0 2017   grade_2 4 0 2   0 0     0   0   3 3             *         6 4 0 2   0 0     0   0   3 3                 6
1728774 ID     school 1603030 292   SOUTH LEMHI DISTRICT 160303000528 137 LEADORE SCHOOL   Regular School No Other PK 12.0 2017   grade_2 6 0 0   0 0     0   0   2 4             *         6 6 0 0   0 0     0   0   2 4                 6
1822058 ID     school 1603120 92   SWAN VALLEY ELEMENTARY DISTRICT 160312000541 424 SWAN VALLEY ELEMENTARY SCHOOL   Regular School No 1.0 PK 08 2016   grade_2 6 0 0   0 0     0   0   2 4             *         6 6 0 0   0 0     0   0   2 4                 6
1823096 ID     school 1601020 221   EMMETT INDEPENDENT DISTRICT 160102000192 707 SWEET MONTOUR ELEMENTARY SCHOOL   Regular School No 1.0 KG 06 2016   grade_2 6 0 0   0 0     0   0   5 1             *         6 6 0 0   0 0     0   0   5 1                 6
1824682 ID     school 1602160 433   MIDVALE DISTRICT 160216000857 286 MIDVALE SCHOOL   Regular School No 4.0 PK 12 2016   grade_2 5 0 1   0 0     0   0   3 3             *         6 5 0 1   0 0     0   0   3 3                 6
703559 ID     school 1601950 21   MARSH VALLEY JOINT DISTRICT 160195000344 350 DOWNEY ELEMENTARY SCHOOL   Regular School No Elementary PK 06 2021   grade_2 7 0 0   0 0     0   0   6 1             *         7 7 0 0   0 0     0   0   6 1                 7
704323 ID     school 1603120 92   SWAN VALLEY ELEMENTARY DISTRICT 160312000541 424 SWAN VALLEY ELEMENTARY SCHOOL   Regular School No Elementary PK 08 2021   grade_2 6 0 1   0 0     0   0   4 3             *         7 6 0 1   0 0     0   0   4 3                 7
705689 ID     school 1603400 253   WEST JEFFERSON DISTRICT 160340000273 729 HAMER ELEMENTARY SCHOOL   Regular School No Elementary KG 04 2021   grade_2 6 0 1   0 0     0   0   4 3             *         7 6 0 1   0 0     0   0   4 3                 7
707091 ID     school 1602160 433   MIDVALE DISTRICT 160216000857 286 MIDVALE SCHOOL   Regular School No Other PK 12 2021   grade_2 7 0 0   0 0     0   0   4 3             *         7 7 0 0   0 0     0   0   4 3                 7
852362 ID     school 1601650 391   KELLOGG JOINT DISTRICT 160165000290 812 CANYON ELEMENTARY SCHOOL   Regular School No Elementary KG 05 2020   grade_2 7 0 0   0 0     0   0   3 4             *         7 7 0 0   0 0     0   0   3 4                 7
852372 ID     school 1602280 392   MULLAN DISTRICT 160228000405 172 MULLAN SCHOOLS   Regular School No Other PK 12 2020   grade_2 6 0 0   0 0     0   1   3 4             *         7 6 0 0   0 0     0   1   3 4                 7
1277821 ID     school 1600540 121   CAMAS COUNTY DISTRICT 160054000110 440 CAMAS COUNTY ELEM/JR HIGH SCHOOL   Regular School No Elementary PK 8.0 2018   grade_2 7 0 0   0 0     0   0   2 5             *         7 7 0 0   0 0     0   0   2 5                 7
1279178 ID     school 1601740 274   KOOTENAI DISTRICT 160174000302 751 HARRISON ELEMENTARY SCHOOL   Regular School No Elementary KG 5.0 2018   grade_2 5 0 1   0 1     0   0   3 4             *         7 5 0 1   0 1     0   0   3 4                 7
1279665 ID     school 1600870 342   CULDESAC JOINT DISTRICT 160087000164 795 CULDESAC SCHOOL   Regular School No Other PK 12.0 2018   grade_2 7 0 0   0 0     0   0   6 1             *         7 7 0 0   0 0     0   0   6 1                 7
1279743 ID     school 1600450 365   BRUNEAU-GRAND VIEW JOINT SCHOOL DISTRICT 160045000098 801 BRUNEAU ELEMENTARY SCHOOL   Regular School No Elementary PK 5.0 2018   grade_2 5 0 2   0 0     0   0   4 3             *         7 5 0 2   0 0     0   0   4 3                 7
1305694 ID     school 1602060 11   MEADOWS VALLEY DISTRICT 160206000826 342 MEADOWS VALLEY SCHOOL   Regular School No Other PK 12.0 2019   grade_2 7 0 0   0 0     0   0   5 2             *         7 7 0 0   0 0     0   0   5 2                 7
1305945 ID     school 1603060 41   ST MARIES JOINT DISTRICT 160306000536 374 UPRIVER ELEMENTARY SCHOOL   Regular School No Elementary KG 6.0 2019   grade_2 5 0 0   0 0     0   2   5 2             *         7 5 0 0   0 0     0   2   5 2                 7
1307092 ID     school 1602430 149   NORTH GEM DISTRICT 160243000427 464 NORTH GEM ELEMENTARY   Regular School No Elementary PK 6.0 2019   grade_2 7 0 0   0 0     0   0   4 3             *         7 7 0 0   0 0     0   0   4 3                 7
1308534 ID     school 1600870 342   CULDESAC JOINT DISTRICT 160087000164 795 CULDESAC SCHOOL   Regular School No Other PK 12.0 2019   grade_2 6 0 0   1 0     0   0   2 5             *         7 6 0 0   1 0     0   0   2 5                 7
1309129 ID     school 1600570 432   CAMBRIDGE JOINT DISTRICT 160057000112 841 CAMBRIDGE ELEMENTARY SCHOOL   Regular School No Elementary PK 5.0 2019   grade_2 7 0 0   0 0     0   0   5 2             *         7 7 0 0   0 0     0   0   5 2                 7
1685316 ID     school 1602280 392   MULLAN DISTRICT 160228000404 815 JOHN MULLAN ELEMENTARY SCHOOL   Regular School No 1.0 PK 06 2015   grade_2 6 0 0   0 0     0   1   4 3             *         7 6 0 0   0 0     0   1   4 3                 7
1685654 ID     school 1602160 433   MIDVALE DISTRICT 160216000857 286 MIDVALE SCHOOL   Regular School No 4.0 PK 12 2015   grade_2 7 0 0   0 0     0   0   4 3             *         7 7 0 0   0 0     0   0   4 3                 7
1726818 ID     school 1600001 83   WEST BONNER COUNTY DISTRICT 160000100620 406 PRIEST LAKE ELEMENTARY SCHOOL   Regular School No Elementary PK 6.0 2017   grade_2 7 0 0   0 0     0   0   3 4             *         7 7 0 0   0 0     0   0   3 4                 7
1823759 ID     school 1603030 292   SOUTH LEMHI DISTRICT 160303000528 137 LEADORE SCHOOL   Regular School No 4.0 PK 12 2016   grade_2 6 0 0   1 0     0   0   4 3             *         7 6 0 0   1 0     0   0   4 3                 7
704074 ID     school 1600001 83   WEST BONNER COUNTY DISTRICT 160000100620 406 PRIEST LAKE ELEMENTARY SCHOOL   Regular School No Elementary PK 06 2021   grade_2 7 0 0   1 0     0   0   5 3             *         8 7 0 0   1 0     0   0   5 3                 8
850819 ID     school 1600660 151   CASSIA COUNTY JOINT DISTRICT 160066000122 475 ALBION ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2020   grade_2 8 0 0   0 0     0   0   5 3             *         8 8 0 0   0 0     0   0   5 3                 8
850849 ID     school 1600750 161   CLARK COUNTY DISTRICT 160075000145 478 LINDY ROSS ELEMENTARY SCHOOL   Regular School No Elementary PK 08 2020   grade_2 3 0 5   0 0     0   0   3 5             *         8 3 0 5   0 0     0   0   3 5                 8
1278372 ID     school 1600750 161   CLARK COUNTY DISTRICT 160075000145 478 LINDY ROSS ELEMENTARY SCHOOL   Regular School No Elementary PK 8.0 2018   grade_2 0 0 8   0 0     0   0   4 4             *         8 0 0 8   0 0     0   0   4 4                 8
1279887 ID     school 1601650 391   KELLOGG JOINT DISTRICT 160165000290 812 CANYON ELEMENTARY SCHOOL   Regular School No Elementary KG 5.0 2018   grade_2 8 0 0   0 0     0   0   3 5             *         8 8 0 0   0 0     0   0   3 5                 8
1280787 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_2 6 0 1   0 0     0   1   2 6             *         8 6 0 1   0 0     0   1   2 6                 8
1307216 ID     school 1600660 151   CASSIA COUNTY JOINT DISTRICT 160066000122 475 ALBION ELEMENTARY SCHOOL   Regular School No Elementary PK 5.0 2019   grade_2 8 0 0   0 0     0   0   5 3             *         8 8 0 0   0 0     0   0   5 3                 8
1307592 ID     school 1600330 234   BLISS JOINT DISTRICT 160033000040 714 BLISS SCHOOL   Regular School No Other PK 12.0 2019   grade_2 5 0 3   0 0     0   0   4 4             *         8 5 0 3   0 0     0   0   4 4                 8
1307745 ID     school 1603400 253   WEST JEFFERSON DISTRICT 160340000273 729 HAMER ELEMENTARY SCHOOL   Regular School No Elementary KG 4.0 2019   grade_2 7 0 1   0 0     0   0   1 7             *         8 7 0 1   0 0     0   0   1 7                 8
1309546 ID     school 1600166 488   SYRINGA MOUNTAIN SCHOOL, INC. 160016601066 1367 SYRINGA MOUNTAIN CHARTER SCHOOL   Regular School Yes Elementary KG 7.0 2019   grade_2 7 0 1   0 0     0   0   7 1             *         8 7 0 1   0 0     0   0   7 1                 8
1683772 ID     school 1600750 161   CLARK COUNTY DISTRICT 160075000145 478 LINDY ROSS ELEMENTARY SCHOOL   Regular School No 1.0 PK 08 2015   grade_2 4 0 4   0 0     0   0   2 6             *         8 4 0 4   0 0     0   0   2 6                 8
1684572 ID     school 1601740 274   KOOTENAI DISTRICT 160174000302 751 HARRISON ELEMENTARY SCHOOL   Regular School No 1.0 KG 05 2015   grade_2 7 0 1   0 0     0   0   5 3             *         8 7 0 1   0 0     0   0   5 3                 8
1685643 ID     school 1600570 432   CAMBRIDGE JOINT DISTRICT 160057000112 841 CAMBRIDGE ELEMENTARY SCHOOL   Regular School No 1.0 PK 06 2015   grade_2 8 0 0   0 0     0   0   2 6             *         8 8 0 0   0 0     0   0   2 6                 8
1727695 ID     school 1602430 149   NORTH GEM DISTRICT 160243000427 464 NORTH GEM ELEMENTARY   Regular School No Elementary PK 6.0 2017   grade_2 8 0 0   0 0     0   0   3 5             *         8 8 0 0   0 0     0   0   3 5                 8
1728185 ID     school 1600330 234   BLISS JOINT DISTRICT 160033000040 714 BLISS SCHOOL   Regular School No Other PK 12.0 2017   grade_2 4 0 4   0 0     0   0   4 4             *         8 4 0 4   0 0     0   0   4 4                 8
1728637 ID     school 1601740 274   KOOTENAI DISTRICT 160174000302 751 HARRISON ELEMENTARY SCHOOL   Regular School No Elementary KG 5.0 2017   grade_2 7 0 1   0 0     0   0   2 6             *         8 7 0 1   0 0     0   0   2 6                 8
1729569 ID     school 1601050 413   FILER DISTRICT 160105000195 832 HOLLISTER ELEMENTARY SCHOOL   Regular School No Elementary PK 5.0 2017   grade_2 5 0 3   0 0     0   0   3 5             *         8 5 0 3   0 0     0   0   3 5                 8
1822794 ID     school 1600660 151   CASSIA COUNTY JOINT DISTRICT 160066000122 475 ALBION ELEMENTARY SCHOOL   Regular School No 1.0 PK 05 2016   grade_2 8 0 0   0 0     0   0   4 4             *         8 8 0 0   0 0     0   0   4 4                 8
703779 ID     school 1603060 41   ST MARIES JOINT DISTRICT 160306000536 374 UPRIVER ELEMENTARY SCHOOL   Regular School No Elementary KG 06 2021   grade_2 9 0 0   0 0     0   0   2 7             *         9 9 0 0   0 0     0   0   2 7                 9
705100 ID     school 1600660 151   CASSIA COUNTY JOINT DISTRICT 160066000122 475 ALBION ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2021   grade_2 9 0 0   0 0     0   0   6 3             *         9 9 0 0   0 0     0   0   6 3                 9
706675 ID     school 1602820 382   ROCKLAND DISTRICT 160282000501 169 ROCKLAND PUBLIC SCHOOL   Regular School No Other PK 12 2021   grade_2 9 0 0   0 0     0   0   3 6             *         9 9 0 0   0 0     0   0   3 6                 9

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