Data source: Big Local News · About: Big Local

5,050 rows where state = "ID" and year = 2021 sorted by total_int

View and edit SQL

grade

year

  • 2021 · 4,968
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 ▼
703031 ID     school 1600360 1   BOISE INDEPENDENT DISTRICT 160036000823 573 TREASURE VALLEY MATH/SCIENCE   Regular School No Other 04 12 2021   grade_5 2 0 0   0 0     0   0   2 0             *         2 2 0 0   0 0     0   0   2 0                 2
703073 ID     school 1600360 1   BOISE INDEPENDENT DISTRICT 160036000984 675 FRANK CHURCH HIGH SCHOOL   Alternative School No High 06 12 2021   grade_8 1 0 1   0 0     0   0   2 0             *         2 1 0 1   0 0     0   0   2 0                 2
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
704028 ID     school 1601170 71   GARDEN VALLEY DISTRICT 160117000216 398 LOWMAN ELEMENTARY SCHOOL   Regular School No Elementary PK 06 2021   grade_1 2 0 0   0 0     0   0   1 1             *         2 2 0 0   0 0     0   0   1 1                 2
704029 ID     school 1601170 71   GARDEN VALLEY DISTRICT 160117000216 398 LOWMAN ELEMENTARY SCHOOL   Regular School No Elementary PK 06 2021   grade_2 2 0 0   0 0     0   0   0 2             *         2 2 0 0   0 0     0   0   0 2                 2
704031 ID     school 1601170 71   GARDEN VALLEY DISTRICT 160117000216 398 LOWMAN ELEMENTARY SCHOOL   Regular School No Elementary PK 06 2021   grade_4 2 0 0   0 0     0   0   1 1             *         2 2 0 0   0 0     0   0   1 1                 2
704032 ID     school 1601170 71   GARDEN VALLEY DISTRICT 160117000216 398 LOWMAN ELEMENTARY SCHOOL   Regular School No Elementary PK 06 2021   grade_5 2 0 0   0 0     0   0   1 1             *         2 2 0 0   0 0     0   0   1 1                 2
704168 ID     school 1600002 84   LAKE PEND OREILLE SCHOOL DISTRICT 160000200604 997 SANDPOINT JUVENILE DETENTION   Alternative School No High 05 12 2021   grade_10 2 0 0   0 0     0   0   1 1             *         2 2 0 0   0 0     0   0   1 1                 2
704176 ID     school 1600002 84   LAKE PEND OREILLE SCHOOL DISTRICT 160000201086 1391 LPOSD HOME SCHOOL ACADEMY   Regular School No Elementary KG 08 2021   k_12_total 1 0 0   1 0     0   0   2 0             *         2 1 0 0   1 0     0   0   2 0                 2
704177 ID     school 1600002 84   LAKE PEND OREILLE SCHOOL DISTRICT 160000201086 1391 LPOSD HOME SCHOOL ACADEMY   Regular School No Elementary KG 08 2021   kindergarten 1 0 0   1 0     0   0   2 0             *         2 1 0 0   1 0     0   0   2 0                 2
704276 ID     school 1601530 91   IDAHO FALLS DISTRICT 160153000784 566 CAREER & TECHNICAL EDUCATION CENTER   Career and Technical School No High 10 12 2021   k_12_total 1 0 1   0 0     0   0   0 2             *         2 1 0 1   0 0     0   0   0 2                 2
704332 ID     school   92   SWAN VALLEY ELEMENTARY DISTRICT   1014 BORDER DISTRICT - STAR VALLEY ELEMENTARY SCHOOL             2021   grade_3 2 0 0   0 0     0   0   0 2             *         2 2 0 0   0 0     0   0   0 2                 2
704428 ID     school 1600930 93   BONNEVILLE JOINT DISTRICT 160093000361 1053 LINCOLN HIGH SCHOOL   Alternative School No High 07 12 2021   grade_8 1 0 1   0 0     0   0   2 0             *         2 1 0 1   0 0     0   0   2 0                 2
705008 ID     school   150   SODA SPRINGS JOINT DISTRICT   1025 BORDER DISTRICT - FREEDOM ELEMENTARY             2021   grade_2 2 0 0   0 0     0   0   1 1             *         2 2 0 0   0 0     0   0   1 1                 2
705016 ID     school   150   SODA SPRINGS JOINT DISTRICT   1026 BORDER DISTRICT FREEDOM - SECONDARY             2021   grade_11 0 0 2   0 0     0   0   2 0             *         2 0 0 2   0 0     0   0   2 0                 2
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
705177 ID     school 1602520 171   OROFINO JOINT DISTRICT 160252000436 481 CAVENDISH-TEAKEAN ELEMENTARY SCHOOL   Regular School No Elementary PK 06 2021   grade_5 2 0 0   0 0     0   0   1 1             *         2 2 0 0   0 0     0   0   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
705216 ID     school 1600720 181   CHALLIS JOINT DISTRICT 160072000143 486 STANLEY ELEM/JR HIGH SCHOOL   Regular School No Elementary KG 08 2021   kindergarten 2 0 0   0 0     0   0   2 0             *         2 2 0 0   0 0     0   0   2 0                 2
705240 ID     school 1602730 191   PRAIRIE ELEMENTARY DISTRICT 160273000496 491 PRAIRIE ELEM/JR HIGH SCHOOL   Regular School No Elementary KG 08 2021   grade_1 2 0 0   0 0     0   0   2 0             *         2 2 0 0   0 0     0   0   2 0                 2
705241 ID     school 1602730 191   PRAIRIE ELEMENTARY DISTRICT 160273000496 491 PRAIRIE ELEM/JR HIGH SCHOOL   Regular School No Elementary KG 08 2021   grade_5 2 0 0   0 0     0   0   0 2             *         2 2 0 0   0 0     0   0   0 2                 2
705242 ID     school 1602730 191   PRAIRIE ELEMENTARY DISTRICT 160273000496 491 PRAIRIE ELEM/JR HIGH SCHOOL   Regular School No Elementary KG 08 2021   grade_7 2 0 0   0 0     0   0   1 1             *         2 2 0 0   0 0     0   0   1 1                 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
705429 ID     school 1601020 221   EMMETT INDEPENDENT DISTRICT 160102000190 710 OLA ELEMENTARY SCHOOL   Regular School No Elementary KG 06 2021   grade_1 2 0 0   0 0     0   0   0 2             *         2 2 0 0   0 0     0   0   0 2                 2
705431 ID     school 1601020 221   EMMETT INDEPENDENT DISTRICT 160102000190 710 OLA ELEMENTARY SCHOOL   Regular School No Elementary KG 06 2021   grade_3 2 0 0   0 0     0   0   0 2             *         2 2 0 0   0 0     0   0   0 2                 2
705434 ID     school 1601020 221   EMMETT INDEPENDENT DISTRICT 160102000190 710 OLA ELEMENTARY SCHOOL   Regular School No Elementary KG 06 2021   grade_6 2 0 0   0 0     0   0   0 2             *         2 2 0 0   0 0     0   0   0 2                 2
705436 ID     school 1601020 221   EMMETT INDEPENDENT DISTRICT 160102000190 710 OLA ELEMENTARY SCHOOL   Regular School No Elementary KG 06 2021   kindergarten 2 0 0   0 0     0   0   0 2             *         2 2 0 0   0 0     0   0   0 2                 2
705587 ID     school 1600139 244   MOUNTAIN VIEW SCHOOL DISTRICT 160013900933 1287 ELK CITY SCHOOL   Regular School No Elementary PK 08 2021   grade_8 2 0 0   0 0     0   0   2 0             *         2 2 0 0   0 0     0   0   2 0                 2
705589 ID     school 1600139 244   MOUNTAIN VIEW SCHOOL DISTRICT 160013900933 1287 ELK CITY SCHOOL   Regular School No Elementary PK 08 2021   kindergarten 2 0 0   0 0     0   0   1 1             *         2 2 0 0   0 0     0   0   1 1                 2
705707 ID     school 1601590 261   JEROME JOINT DISTRICT 160159000289 297 JEROME ACADEMY   Special Education School No Other KG 12 2021   grade_3 1 0 1   0 0     0   0   2 0             *         2 1 0 1   0 0     0   0   2 0                 2
705724 ID     school 1601590 261   JEROME JOINT DISTRICT 160159000097 1272 FALLS CITY ACADEMY   Alternative School No High 06 12 2021   grade_8 1 0 1   0 0     0   0   2 0             *         2 1 0 1   0 0     0   0   2 0                 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
705727 ID     school 1601590 261   JEROME JOINT DISTRICT 160159000972 2516 SUMMIT ELEMENTARY   Regular School No Elementary 02 05 2021   grade_2 1 0 1   0 0     0   0   2 0             *         2 1 0 1   0 0     0   0   2 0                 2
705728 ID     school 1601590 261   JEROME JOINT DISTRICT 160159000972 2516 SUMMIT ELEMENTARY   Regular School No Elementary 02 05 2021   grade_3 0 0 1   1 0     0   0   2 0             *         2 0 0 1   1 0     0   0   2 0                 2
705847 ID     school 1600780 271   COEUR D'ALENE DISTRICT 160078000704 1038 CDA JUVENILE DETENTION CENTER   Alternative School No Other 04 12 2021   grade_8 1 0 0   0 0     0   1   2 0             *         2 1 0 0   0 0     0   1   2 0                 2
706136 ID     school 1603030 292   SOUTH LEMHI DISTRICT 160303000528 137 LEADORE SCHOOL   Regular School No Other PK 12 2021   grade_11 2 0 0   0 0     0   0   1 1             *         2 2 0 0   0 0     0   0   1 1                 2
706319 ID     school 1603090 322   SUGAR-SALEM JOINT DISTRICT 160309000853 874 VALLEY VIEW ALTERNATIVE HIGH SCHOOL   Alternative School No High 09 12 2021   grade_11 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
706373 ID     school 1602190 331   MINIDOKA COUNTY JOINT DISTRICT 160219000166 1100 MINI-CASSIA JUVENILE DETENTION CENTER   Alternative School No Other 03 12 2021   grade_11 0 0 2   0 0     0   0   1 1             *         2 0 0 2   0 0     0   0   1 1                 2
706374 ID     school 1602190 331   MINIDOKA COUNTY JOINT DISTRICT 160219000166 1100 MINI-CASSIA JUVENILE DETENTION CENTER   Alternative School No Other 03 12 2021   grade_12 1 0 1   0 0     0   0   0 2             *         2 1 0 1   0 0     0   0   0 2                 2
706375 ID     school 1602190 331   MINIDOKA COUNTY JOINT DISTRICT 160219000166 1100 MINI-CASSIA JUVENILE DETENTION CENTER   Alternative School No Other 03 12 2021   grade_8 0 0 2   0 0     0   0   2 0             *         2 0 0 2   0 0     0   0   2 0                 2
706396 ID     school   340   LEWISTON INDEPENDENT DISTRICT   611 NORTHWEST CHILDRENS HOME             2021   grade_6 2 0 0   0 0     0   0   2 0             *         2 2 0 0   0 0     0   0   2 0                 2
706397 ID     school   340   LEWISTON INDEPENDENT DISTRICT   611 NORTHWEST CHILDRENS HOME             2021   grade_7 2 0 0   0 0     0   0   2 0             *         2 2 0 0   0 0     0   0   2 0                 2
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
706455 ID     school 1601860 340   LEWISTON INDEPENDENT DISTRICT 160186000170 1266 REGION 2 JUVENILE DETENTION CENTER   Alternative School No Other 03 12 2021   grade_10 1 0 1   0 0     0   0   2 0             *         2 1 0 1   0 0     0   0   2 0                 2
706456 ID     school 1601860 340   LEWISTON INDEPENDENT DISTRICT 160186000170 1266 REGION 2 JUVENILE DETENTION CENTER   Alternative School No Other 03 12 2021   k_12_total 1 0 1   0 0     0   0   2 0             *         2 1 0 1   0 0     0   0   2 0                 2
706501 ID     school 1602490 351   ONEIDA COUNTY DISTRICT 160249000434 797 STONE ELEMENTARY SCHOOL   Regular School No Elementary PK 03 2021   kindergarten 1 0 1   0 0     0   0   1 1             *         2 1 0 1   0 0     0   0   1 1                 2
706537 ID     school 1602610 364   PLEASANT VALLEY ELEMENTARY DISTRICT 160261000459 800 PLEASANT VALLEY ELEM/JR HIGH   Regular School No Elementary PK 08 2021   grade_1 2 0 0   0 0     0   0   1 1             *         2 2 0 0   0 0     0   0   1 1                 2
706543 ID     school 1602610 364   PLEASANT VALLEY ELEMENTARY DISTRICT 160261000459 800 PLEASANT VALLEY ELEM/JR HIGH   Regular School No Elementary PK 08 2021   kindergarten 2 0 0   0 0     0   0   1 1             *         2 2 0 0   0 0     0   0   1 1                 2
706544 ID     school   364   PLEASANT VALLEY ELEMENTARY DISTRICT   1056 BORDER DISTRICT - JORDAN VALLEY SECONDARY             2021   grade_11 2 0 0   0 0     0   0   0 2             *         2 2 0 0   0 0     0   0   0 2                 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
706659 ID     school 1600060 381   AMERICAN FALLS JOINT DISTRICT 160006000768 261 AMERICAN FALLS ACADEMY   Alternative School No High 06 12 2021   grade_6 2 0 0   0 0     0   0   2 0             *         2 2 0 0   0 0     0   0   2 0                 2
706661 ID     school 1600060 381   AMERICAN FALLS JOINT DISTRICT 160006000768 261 AMERICAN FALLS ACADEMY   Alternative School No High 06 12 2021   grade_8 0 0 2   0 0     0   0   1 1             *         2 0 0 2   0 0     0   0   1 1                 2
706688 ID     school 1600090 383   ARBON ELEMENTARY DISTRICT 160009000006 810 ARBON ELEMENTARY SCHOOL   Regular School No Elementary KG 06 2021   grade_6 2 0 0   0 0     0   0   1 1             *         2 2 0 0   0 0     0   0   1 1                 2
706716 ID     school 1602280 392   MULLAN DISTRICT 160228000405 172 MULLAN SCHOOLS   Regular School No Other KG 12 2021   grade_11 2 0 0   0 0     0   0   1 1             *         2 2 0 0   0 0     0   0   1 1                 2
706718 ID     school 1602280 392   MULLAN DISTRICT 160228000405 172 MULLAN SCHOOLS   Regular School No Other KG 12 2021   grade_2 2 0 0   0 0     0   0   1 1             *         2 2 0 0   0 0     0   0   1 1                 2
706745 ID     school 1600150 394   AVERY SCHOOL DISTRICT 160015001010 820 CALDER SCHOOL   Regular School No Elementary KG 08 2021   grade_3 2 0 0   0 0     0   0   1 1             *         2 2 0 0   0 0     0   0   1 1                 2
706746 ID     school 1600150 394   AVERY SCHOOL DISTRICT 160015001010 820 CALDER SCHOOL   Regular School No Elementary KG 08 2021   grade_4 2 0 0   0 0     0   0   1 1             *         2 2 0 0   0 0     0   0   1 1                 2
706859 ID     school 1603240 411   TWIN FALLS DISTRICT 160324000739 1260 SNAKE RIVER JUVENILE DETENTION   Alternative School No Other 01 12 2021   grade_10 2 0 0   0 0     0   0   1 1             *         2 2 0 0   0 0     0   0   1 1                 2
706860 ID     school 1603240 411   TWIN FALLS DISTRICT 160324000739 1260 SNAKE RIVER JUVENILE DETENTION   Alternative School No Other 01 12 2021   grade_11 1 0 1   0 0     0   0   2 0             *         2 1 0 1   0 0     0   0   2 0                 2
706909 ID     school 1600480 412   BUHL JOINT DISTRICT 160048001106 1403 WAKAPA ACADEMY   Alternative School No High 09 12 2021   grade_10 0 0 2   0 0     0   0   2 0             *         2 0 0 2   0 0     0   0   2 0                 2
707069 ID     school 1603330 431   WEISER DISTRICT 160333001049 1067 INDIANHEAD ACADEMY HIGH SCHOOL   Alternative School No High 09 12 2021   grade_11 2 0 0   0 0     0   0   1 1             *         2 2 0 0   0 0     0   0   1 1                 2
707691 ID     school 1600192 540   ISLAND PARK CHARTER SCHOOL, INC. 160019201125 1435 ISLAND PARK CHARTER SCHOOL   Regular School Yes Elementary KG 04 2021   grade_2 2 0 0   0 0     0   0   1 1             *         2 2 0 0   0 0     0   0   1 1                 2
707742 ID     school 1603511 596   IDAHO BUREAU OF EDUCATIONAL SERVICES FOR THE DEAF AND THE BLIND 160351100685 948 IDAHO SCHOOL FOR THE DEAF AND THE BLIND   Special Education School No Other PK 12 2021   grade_3 0 0 1   0 0     0   1   0 2             *         2 0 0 1   0 0     0   1   0 2                 2
703024 ID     school 1600360 1   BOISE INDEPENDENT DISTRICT 160036000817 563 DEHRYL A DENNIS PROF-TECH CENTER   Career and Technical School No High 07 12 2021   grade_10 3 0 0   0 0     0   0   3 0             *         3 3 0 0   0 0     0   0   3 0                 3
703072 ID     school 1600360 1   BOISE INDEPENDENT DISTRICT 160036000984 675 FRANK CHURCH HIGH SCHOOL   Alternative School No High 06 12 2021   grade_7 2 0 1   0 0     0   0   3 0             *         3 2 0 1   0 0     0   0   3 0                 3
703092 ID     school 1600360 1   BOISE INDEPENDENT DISTRICT 160036000708 9002 ADA COUNTY JUVENILE CENTER   Alternative School No High 05 12 2021   grade_10 2 0 1   0 0     0   0   3 0             *         3 2 0 1   0 0     0   0   3 0                 3
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
703787 ID     school 1603060 41   ST MARIES JOINT DISTRICT 160306000491 1138 ST MARIES COMMUNITY EDUCATION ALTERNATIVE   Alternative School No High 09 12 2021   grade_11 3 0 0   0 0     0   0   3 0             *         3 3 0 0   0 0     0   0   3 0                 3
704170 ID     school 1600002 84   LAKE PEND OREILLE SCHOOL DISTRICT 160000200604 997 SANDPOINT JUVENILE DETENTION   Alternative School No High 05 12 2021   k_12_total 3 0 0   0 0     0   0   2 1             *         3 3 0 0   0 0     0   0   2 1                 3
704299 ID     school 1601530 91   IDAHO FALLS DISTRICT 160153000605 1152 3B JUVENILE DETENTION CENTER   Alternative School No Other 04 12 2021   grade_11 1 0 1   0 0     0   1   2 1             *         3 1 0 1   0 0     0   1   2 1                 3
704326 ID     school 1603120 92   SWAN VALLEY ELEMENTARY DISTRICT 160312000541 424 SWAN VALLEY ELEMENTARY SCHOOL   Regular School No Elementary PK 08 2021   grade_5 3 0 0   0 0     0   0   1 2             *         3 3 0 0   0 0     0   0   1 2                 3
704334 ID     school   92   SWAN VALLEY ELEMENTARY DISTRICT   1014 BORDER DISTRICT - STAR VALLEY ELEMENTARY SCHOOL             2021   k_12_total 3 0 0   0 0     0   0   1 2             *         3 3 0 0   0 0     0   0   1 2                 3
704535 ID     school 1600490 111   BUTTE COUNTY JOINT DISTRICT 160049000011 438 HOWE ELEMENTARY SCHOOL   Regular School No Elementary KG 03 2021   k_12_total 2 0 0   1 0     0   0   0 3             *         3 2 0 0   1 0     0   0   0 3                 3
704536 ID     school 1600490 111   BUTTE COUNTY JOINT DISTRICT 160049000011 438 HOWE ELEMENTARY SCHOOL   Regular School No Elementary KG 03 2021   kindergarten 2 0 0   1 0     0   0   0 3             *         3 2 0 0   1 0     0   0   0 3                 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
705173 ID     school 1602520 171   OROFINO JOINT DISTRICT 160252000436 481 CAVENDISH-TEAKEAN ELEMENTARY SCHOOL   Regular School No Elementary PK 06 2021   grade_1 3 0 0   0 0     0   0   3 0             *         3 3 0 0   0 0     0   0   3 0                 3
705174 ID     school 1602520 171   OROFINO JOINT DISTRICT 160252000436 481 CAVENDISH-TEAKEAN ELEMENTARY SCHOOL   Regular School No Elementary PK 06 2021   grade_2 3 0 0   0 0     0   0   1 2             *         3 3 0 0   0 0     0   0   1 2                 3
705181 ID     school 1602520 171   OROFINO JOINT DISTRICT 160252000442 482 PECK ELEMENTARY SCHOOL   Regular School No Elementary PK 06 2021   grade_1 3 0 0   0 0     0   0   1 2             *         3 3 0 0   0 0     0   0   1 2                 3
705182 ID     school 1602520 171   OROFINO JOINT DISTRICT 160252000442 482 PECK ELEMENTARY SCHOOL   Regular School No Elementary PK 06 2021   grade_2 3 0 0   0 0     0   0   0 3             *         3 3 0 0   0 0     0   0   0 3                 3
705185 ID     school 1602520 171   OROFINO JOINT DISTRICT 160252000442 482 PECK ELEMENTARY SCHOOL   Regular School No Elementary PK 06 2021   grade_5 2 0 1   0 0     0   0   0 3             *         3 2 0 1   0 0     0   0   0 3                 3
705209 ID     school 1600720 181   CHALLIS JOINT DISTRICT 160072000143 486 STANLEY ELEM/JR HIGH SCHOOL   Regular School No Elementary KG 08 2021   grade_3 3 0 0   0 0     0   0   2 1             *         3 3 0 0   0 0     0   0   2 1                 3
705210 ID     school 1600720 181   CHALLIS JOINT DISTRICT 160072000143 486 STANLEY ELEM/JR HIGH SCHOOL   Regular School No Elementary KG 08 2021   grade_4 3 0 0   0 0     0   0   1 2             *         3 3 0 0   0 0     0   0   1 2                 3
705390 ID     school 1601110 215   FREMONT COUNTY JOINT DISTRICT 160111000912 1271 FIVE-COUNTY DETENTION CENTER   Alternative School No High 05 12 2021   grade_10 2 0 0   1 0     0   0   1 2             *         3 2 0 0   1 0     0   0   1 2                 3
705430 ID     school 1601020 221   EMMETT INDEPENDENT DISTRICT 160102000190 710 OLA ELEMENTARY SCHOOL   Regular School No Elementary KG 06 2021   grade_2 3 0 0   0 0     0   0   2 1             *         3 3 0 0   0 0     0   0   2 1                 3
705439 ID     school 1601020 221   EMMETT INDEPENDENT DISTRICT 160102000923 1111 THE PATRIOT CENTER   Alternative School No High 06 12 2021   grade_12 2 0 1   0 0     0   0   3 0             *         3 2 0 1   0 0     0   0   3 0                 3
705442 ID     school 1601020 221   EMMETT INDEPENDENT DISTRICT 160102000923 1111 THE PATRIOT CENTER   Alternative School No High 06 12 2021   grade_8 2 0 0   0 0     0   1   3 0             *         3 2 0 0   0 0     0   1   3 0                 3
705583 ID     school 1600139 244   MOUNTAIN VIEW SCHOOL DISTRICT 160013900933 1287 ELK CITY SCHOOL   Regular School No Elementary PK 08 2021   grade_2 3 0 0   0 0     0   0   3 0             *         3 3 0 0   0 0     0   0   3 0                 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
705708 ID     school 1601590 261   JEROME JOINT DISTRICT 160159000289 297 JEROME ACADEMY   Special Education School No Other KG 12 2021   grade_4 3 0 0   0 0     0   0   3 0             *         3 3 0 0   0 0     0   0   3 0                 3
705709 ID     school 1601590 261   JEROME JOINT DISTRICT 160159000289 297 JEROME ACADEMY   Special Education School No Other KG 12 2021   grade_5 3 0 0   0 0     0   0   3 0             *         3 3 0 0   0 0     0   0   3 0                 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
706133 ID     school 1602850 291   SALMON DISTRICT 160285000700 9014 SALMON ALTERNATIVE HIGH SCHOOL   Alternative School No High 09 12 2021   k_12_total 2 1 0   0 0     0   0   1 2             *         3 2 1 0   0 0     0   0   1 2                 3
706149 ID     school 1603030 292   SOUTH LEMHI DISTRICT 160303000529 765 TENDOY ELEMENTARY SCHOOL   Regular School No Elementary KG 05 2021   grade_4 3 0 0   0 0     0   0   2 1             *         3 3 0 0   0 0     0   0   2 1                 3
706152 ID     school 1603030 292   SOUTH LEMHI DISTRICT 160303000529 765 TENDOY ELEMENTARY SCHOOL   Regular School No Elementary KG 05 2021   kindergarten 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
706390 ID     school   340   LEWISTON INDEPENDENT DISTRICT   611 NORTHWEST CHILDRENS HOME             2021   grade_10 2 0 1   0 0     0   0   3 0             *         3 2 0 1   0 0     0   0   3 0                 3

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