Data source: Big Local News · About: Big Local

4,796 rows where state = "ID" and year = 2019 sorted by total_int

View and edit SQL

grade

year

  • 2019 · 4,696
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 ▼
1307128 ID     school   150   SODA SPRINGS JOINT DISTRICT   1026 BORDER DISTRICT FREEDOM - SECONDARY             2019   grade_7 1 0 1   0 0     0   0   1 1             *         2 1 0 1   0 0     0   0   1 1                 2
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
1307175 ID     school 1600660 151   CASSIA COUNTY JOINT DISTRICT 160066000123 468 ALMO ELEMENTARY SCHOOL   Regular School No Elementary PK 6.0 2019   kindergarten 2 0 0   0 0     0   0   2 0             *         2 2 0 0   0 0     0   0   2 0                 2
1307275 ID     school 1602520 171   OROFINO JOINT DISTRICT 160252000436 481 CAVENDISH-TEAKEAN ELEMENTARY SCHOOL   Regular School No Elementary PK 6.0 2019   grade_1 2 0 0   0 0     0   0   0 2             *         2 2 0 0   0 0     0   0   0 2                 2
1307286 ID     school 1602520 171   OROFINO JOINT DISTRICT 160252000442 482 PECK ELEMENTARY SCHOOL   Regular School No Elementary PK 6.0 2019   grade_4 2 0 0   0 0     0   0   1 1             *         2 2 0 0   0 0     0   0   1 1                 2
1307287 ID     school 1602520 171   OROFINO JOINT DISTRICT 160252000442 482 PECK ELEMENTARY SCHOOL   Regular School No Elementary PK 6.0 2019   grade_5 2 0 0   0 0     0   0   1 1             *         2 2 0 0   0 0     0   0   1 1                 2
1307288 ID     school 1602520 171   OROFINO JOINT DISTRICT 160252000442 482 PECK ELEMENTARY SCHOOL   Regular School No Elementary PK 6.0 2019   grade_6 2 0 0   0 0     0   0   1 1             *         2 2 0 0   0 0     0   0   1 1                 2
1307310 ID     school 1600720 181   CHALLIS JOINT DISTRICT 160072000143 486 STANLEY ELEM/JR HIGH SCHOOL   Regular School No Elementary KG 8.0 2019   grade_1 2 0 0   0 0     0   0   1 1             *         2 2 0 0   0 0     0   0   1 1                 2
1307311 ID     school 1600720 181   CHALLIS JOINT DISTRICT 160072000143 486 STANLEY ELEM/JR HIGH SCHOOL   Regular School No Elementary KG 8.0 2019   grade_2 2 0 0   0 0     0   0   0 2             *         2 2 0 0   0 0     0   0   0 2                 2
1307343 ID     school 1602730 191   PRAIRIE ELEMENTARY DISTRICT 160273000496 491 PRAIRIE ELEM/JR HIGH SCHOOL   Regular School No Elementary KG 8.0 2019   k_12_total 2 0 0   0 0     0   0   1 1             *         2 2 0 0   0 0     0   0   1 1                 2
1307392 ID     school 1602250 193   MOUNTAIN HOME DISTRICT 160225000266 517 PINE ELEM/JR HIGH SCHOOL   Regular School No Elementary PK 8.0 2019   grade_2 2 0 0   0 0     0   0   0 2             *         2 2 0 0   0 0     0   0   0 2                 2
1307487 ID     school 1601110 215   FREMONT COUNTY JOINT DISTRICT 160111000912 1271 FIVE-COUNTY DETENTION CENTER   Alternative School No High 05 12.0 2019   grade_10 0 0 1   1 0     0   0   0 2             *         2 0 0 1   1 0     0   0   0 2                 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
1307523 ID     school 1601020 221   EMMETT INDEPENDENT DISTRICT 160102000190 710 OLA ELEMENTARY SCHOOL   Regular School No Elementary KG 6.0 2019   grade_1 2 0 0   0 0     0   0   1 1             *         2 2 0 0   0 0     0   0   1 1                 2
1307744 ID     school 1603400 253   WEST JEFFERSON DISTRICT 160340000273 729 HAMER ELEMENTARY SCHOOL   Regular School No Elementary KG 4.0 2019   grade_1 2 0 0   0 0     0   0   2 0             *         2 2 0 0   0 0     0   0   2 0                 2
1307762 ID     school 1601590 261   JEROME JOINT DISTRICT 160159000289 297 JEROME ACADEMY   Special Education School No Other KG 12.0 2019   grade_1 1 0 1   0 0     0   0   2 0             *         2 1 0 1   0 0     0   0   2 0                 2
1307780 ID     school 1601590 261   JEROME JOINT DISTRICT 160159000097 1272 FALLS CITY ACADEMY   Alternative School No High 06 12.0 2019   grade_6 1 0 1   0 0     0   0   2 0             *         2 1 0 1   0 0     0   0   2 0                 2
1307902 ID     school 1600780 271   COEUR D'ALENE DISTRICT 160078000704 1038 CDA JUVENILE DETENTION CENTER   Alternative School No Other 04 12.0 2019   grade_7 1 1 0   0 0     0   0   2 0             *         2 1 1 0   0 0     0   0   2 0                 2
1307903 ID     school 1600780 271   COEUR D'ALENE DISTRICT 160078000704 1038 CDA JUVENILE DETENTION CENTER   Alternative School No Other 04 12.0 2019   grade_8 2 0 0   0 0     0   0   1 1             *         2 2 0 0   0 0     0   0   1 1                 2
1308176 ID     school 1602850 291   SALMON DISTRICT 160285000700 9014 SALMON ALTERNATIVE HIGH SCHOOL   Alternative School No High 09 12.0 2019   grade_11 1 0 1   0 0     0   0   1 1             *         2 1 0 1   0 0     0   0   1 1                 2
1308261 ID     school 1602940 312   SHOSHONE JOINT DISTRICT 160294001026 846 HIGH DESERT   Alternative School No High 09 12.0 2019   grade_10 0 0 2   0 0     0   0   2 0             *         2 0 0 2   0 0     0   0   2 0                 2
1308440 ID     school   340   LEWISTON INDEPENDENT DISTRICT   611 NORTHWEST CHILDRENS HOME             2019   grade_10 2 0 0   0 0     0   0   2 0             *         2 2 0 0   0 0     0   0   2 0                 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
1308552 ID     school 1602490 351   ONEIDA COUNTY DISTRICT 160249000856 580 ONEIDA HIGH SCHOOL   Alternative School No High 09 12.0 2019   grade_11 2 0 0   0 0     0   0   1 1             *         2 2 0 0   0 0     0   0   1 1                 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
1308736 ID     school 1600090 383   ARBON ELEMENTARY DISTRICT 160009000006 810 ARBON ELEMENTARY SCHOOL   Regular School No Elementary KG 6.0 2019   grade_4 2 0 0   0 0     0   0   1 1             *         2 2 0 0   0 0     0   0   1 1                 2
1308792 ID     school 1600150 394   AVERY SCHOOL DISTRICT 160015001010 820 CALDER SCHOOL   Regular School No Elementary KG 8.0 2019   grade_1 2 0 0   0 0     0   0   1 1             *         2 2 0 0   0 0     0   0   1 1                 2
1308797 ID     school 1600150 394   AVERY SCHOOL DISTRICT 160015001010 820 CALDER SCHOOL   Regular School No Elementary KG 8.0 2019   grade_6 2 0 0   0 0     0   0   2 0             *         2 2 0 0   0 0     0   0   2 0                 2
1308798 ID     school 1600150 394   AVERY SCHOOL DISTRICT 160015001010 820 CALDER SCHOOL   Regular School No Elementary KG 8.0 2019   grade_7 1 0 0   0 0     0   1   2 0             *         2 1 0 0   0 0     0   1   2 0                 2
1308800 ID     school 1600150 394   AVERY SCHOOL DISTRICT 160015001010 820 CALDER SCHOOL   Regular School No Elementary KG 8.0 2019   kindergarten 2 0 0   0 0     0   0   1 1             *         2 2 0 0   0 0     0   0   1 1                 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
1308954 ID     school 1600480 412   BUHL JOINT DISTRICT 160048001106 1403 WAKAPA ACADEMY   Alternative School No High 09 12.0 2019   grade_10 2 0 0   0 0     0   0   0 2             *         2 2 0 0   0 0     0   0   0 2                 2
1309115 ID     school 1603330 431   WEISER DISTRICT 160333001049 1067 INDIANHEAD ACADEMY HIGH SCHOOL   Alternative School No High 09 12.0 2019   grade_10 1 1 0   0 0     0   0   0 2             *         2 1 1 0   0 0     0   0   0 2                 2
1309149 ID     school 1602160 433   MIDVALE DISTRICT 160216000939 1113 MIDVALE ALTERNATIVE SCHOOL   Alternative School No High 07 12.0 2019   grade_10 2 0 0   0 0     0   0   1 1             *         2 2 0 0   0 0     0   0   1 1                 2
1309151 ID     school 1602160 433   MIDVALE DISTRICT 160216000939 1113 MIDVALE ALTERNATIVE SCHOOL   Alternative School No High 07 12.0 2019   grade_12 2 0 0   0 0     0   0   0 2             *         2 2 0 0   0 0     0   0   0 2                 2
1309677 ID     school 1600152 555   CANYON-OWYHEE SCHOOL SERVICE AGENCY (COSSA) 160015200304 1291 COSSA ACADEMY   Alternative School No High 07 12.0 2019   grade_7 1 0 1   0 0     0   0   2 0             *         2 1 0 1   0 0     0   0   2 0                 2
1306437 ID     school 1601530 91   IDAHO FALLS DISTRICT 160153000605 1152 3B JUVENILE DETENTION CENTER   Alternative School No Other 04 12.0 2019   grade_12 0 0 2   0 0     0   1   1 2             *         3 0 0 2   0 0     0   1   1 2                 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
1306446 ID     school 1603120 92   SWAN VALLEY ELEMENTARY DISTRICT 160312000541 424 SWAN VALLEY ELEMENTARY SCHOOL   Regular School No Elementary PK 8.0 2019   grade_2 3 0 0   0 0     0   0   1 2             *         3 3 0 0   0 0     0   0   1 2                 3
1306456 ID     school   92   SWAN VALLEY ELEMENTARY DISTRICT   1014 BORDER DISTRICT - STAR VALLEY ELEMENTARY SCHOOL             2019   k_12_total 3 0 0   0 0     0   0   1 2             *         3 3 0 0   0 0     0   0   1 2                 3
1306460 ID     school   92   SWAN VALLEY ELEMENTARY DISTRICT   1015 BORDER DISTRICT - STAR VALLEY JR-SR HIGH SCHOOL             2019   k_12_total 3 0 0   0 0     0   0   1 2             *         3 3 0 0   0 0     0   0   1 2                 3
1306660 ID     school 1600490 111   BUTTE COUNTY JOINT DISTRICT 160049000011 438 HOWE ELEMENTARY SCHOOL   Regular School No Elementary PK 5.0 2019   grade_2 3 0 0   0 0     0   0   2 1             *         3 3 0 0   0 0     0   0   2 1                 3
1307118 ID     school   150   SODA SPRINGS JOINT DISTRICT   1025 BORDER DISTRICT - FREEDOM ELEMENTARY             2019   grade_1 3 0 0   0 0     0   0   0 3             *         3 3 0 0   0 0     0   0   0 3                 3
1307120 ID     school   150   SODA SPRINGS JOINT DISTRICT   1025 BORDER DISTRICT - FREEDOM ELEMENTARY             2019   grade_3 3 0 0   0 0     0   0   2 1             *         3 3 0 0   0 0     0   0   2 1                 3
1307129 ID     school   150   SODA SPRINGS JOINT DISTRICT   1026 BORDER DISTRICT FREEDOM - SECONDARY             2019   grade_8 2 0 1   0 0     0   0   2 1             *         3 2 0 1   0 0     0   0   2 1                 3
1307172 ID     school 1600660 151   CASSIA COUNTY JOINT DISTRICT 160066000123 468 ALMO ELEMENTARY SCHOOL   Regular School No Elementary PK 6.0 2019   grade_2 3 0 0   0 0     0   0   3 0             *         3 3 0 0   0 0     0   0   3 0                 3
1307173 ID     school 1600660 151   CASSIA COUNTY JOINT DISTRICT 160066000123 468 ALMO ELEMENTARY SCHOOL   Regular School No Elementary PK 6.0 2019   grade_3 3 0 0   0 0     0   0   0 3             *         3 3 0 0   0 0     0   0   0 3                 3
1307225 ID     school 1600660 151   CASSIA COUNTY JOINT DISTRICT 160066000540 990 CASSIA JR/SR HIGH SCHOOL   Alternative School No High 07 12.0 2019   grade_7 3 0 0   0 0     0   0   0 3             *         3 3 0 0   0 0     0   0   0 3                 3
1307276 ID     school 1602520 171   OROFINO JOINT DISTRICT 160252000436 481 CAVENDISH-TEAKEAN ELEMENTARY SCHOOL   Regular School No Elementary PK 6.0 2019   grade_2 2 0 0   0 0     0   1   1 2             *         3 2 0 0   0 0     0   1   1 2                 3
1307277 ID     school 1602520 171   OROFINO JOINT DISTRICT 160252000436 481 CAVENDISH-TEAKEAN ELEMENTARY SCHOOL   Regular School No Elementary PK 6.0 2019   grade_3 3 0 0   0 0     0   0   2 1             *         3 3 0 0   0 0     0   0   2 1                 3
1307278 ID     school 1602520 171   OROFINO JOINT DISTRICT 160252000436 481 CAVENDISH-TEAKEAN ELEMENTARY SCHOOL   Regular School No Elementary PK 6.0 2019   grade_4 3 0 0   0 0     0   0   0 3             *         3 3 0 0   0 0     0   0   0 3                 3
1307280 ID     school 1602520 171   OROFINO JOINT DISTRICT 160252000436 481 CAVENDISH-TEAKEAN ELEMENTARY SCHOOL   Regular School No Elementary PK 6.0 2019   grade_6 3 0 0   0 0     0   0   3 0             *         3 3 0 0   0 0     0   0   3 0                 3
1307282 ID     school 1602520 171   OROFINO JOINT DISTRICT 160252000436 481 CAVENDISH-TEAKEAN ELEMENTARY SCHOOL   Regular School No Elementary PK 6.0 2019   kindergarten 2 0 0   0 0     0   1   1 2             *         3 2 0 0   0 0     0   1   1 2                 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
1307394 ID     school 1602250 193   MOUNTAIN HOME DISTRICT 160225000266 517 PINE ELEM/JR HIGH SCHOOL   Regular School No Elementary PK 8.0 2019   k_12_total 2 0 0   1 0     0   0   0 3             *         3 2 0 0   1 0     0   0   0 3                 3
1307524 ID     school 1601020 221   EMMETT INDEPENDENT DISTRICT 160102000190 710 OLA ELEMENTARY SCHOOL   Regular School No Elementary KG 6.0 2019   grade_2 1 0 2   0 0     0   0   1 2             *         3 1 0 2   0 0     0   0   1 2                 3
1307533 ID     school 1601020 221   EMMETT INDEPENDENT DISTRICT 160102000923 1111 THE PATRIOT CENTER   Alternative School No High 06 12.0 2019   grade_6 2 0 1   0 0     0   0   3 0             *         3 2 0 1   0 0     0   0   3 0                 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
1308062 ID     school 1602220 281   MOSCOW DISTRICT 160222000154 612 PARADISE CREEK REGIONAL HIGH SCHOOL   Alternative School No High 09 12.0 2019   grade_11 2 0 1   0 0     0   0   0 3             *         3 2 0 1   0 0     0   0   0 3                 3
1308197 ID     school 1603030 292   SOUTH LEMHI DISTRICT 160303000529 765 TENDOY ELEMENTARY SCHOOL   Regular School No Elementary KG 5.0 2019   grade_4 3 0 0   0 0     0   0   3 0             *         3 3 0 0   0 0     0   0   3 0                 3
1308421 ID     school 1602190 331   MINIDOKA COUNTY JOINT DISTRICT 160219000166 1100 MINI-CASSIA JUVENILE DETENTION CENTER   Alternative School No Other 03 12.0 2019   grade_11 1 0 2   0 0     0   0   1 2             *         3 1 0 2   0 0     0   0   1 2                 3
1308442 ID     school   340   LEWISTON INDEPENDENT DISTRICT   611 NORTHWEST CHILDRENS HOME             2019   grade_3 3 0 0   0 0     0   0   2 1             *         3 3 0 0   0 0     0   0   2 1                 3
1308447 ID     school   340   LEWISTON INDEPENDENT DISTRICT   611 NORTHWEST CHILDRENS HOME             2019   grade_8 2 0 1   0 0     0   0   3 0             *         3 2 0 1   0 0     0   0   3 0                 3
1308551 ID     school 1602490 351   ONEIDA COUNTY DISTRICT 160249000856 580 ONEIDA HIGH SCHOOL   Alternative School No High 09 12.0 2019   grade_10 3 0 0   0 0     0   0   1 2             *         3 3 0 0   0 0     0   0   1 2                 3
1308562 ID     school 1602490 351   ONEIDA COUNTY DISTRICT 160249000434 797 STONE ELEMENTARY SCHOOL   Regular School No Elementary PK 3.0 2019   kindergarten 2 0 1   0 0     0   0   2 1             *         3 2 0 1   0 0     0   0   2 1                 3
1308596 ID     school 1602610 364   PLEASANT VALLEY ELEMENTARY DISTRICT 160261000459 800 PLEASANT VALLEY ELEM/JR HIGH   Regular School No Elementary PK 8.0 2019   grade_1 3 0 0   0 0     0   0   3 0             *         3 3 0 0   0 0     0   0   3 0                 3
1308603 ID     school   364   PLEASANT VALLEY ELEMENTARY DISTRICT   1056 BORDER DISTRICT - JORDAN VALLEY SECONDARY             2019   k_12_total 3 0 0   0 0     0   0   0 3             *         3 3 0 0   0 0     0   0   0 3                 3
1308694 ID     school 1601140 373   FRUITLAND DISTRICT 160114000988 1332 FRUITLAND PREPARATORY ACADEMY   Alternative School No High 06 12.0 2019   grade_8 2 0 1   0 0     0   0   2 1             *         3 2 0 1   0 0     0   0   2 1                 3
1308709 ID     school 1600060 381   AMERICAN FALLS JOINT DISTRICT 160006000768 261 AMERICAN FALLS ACADEMY   Alternative School No High 06 12.0 2019   grade_7 0 0 3   0 0     0   0   3 0             *         3 0 0 3   0 0     0   0   3 0                 3
1308769 ID     school 1602280 392   MULLAN DISTRICT 160228000405 172 MULLAN SCHOOLS   Regular School No Other KG 12.0 2019   grade_4 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
1308907 ID     school 1603240 411   TWIN FALLS DISTRICT 160324000739 1260 SNAKE RIVER JUVENILE DETENTION   Alternative School No Other 01 12.0 2019   grade_11 3 0 0   0 0     0   0   3 0             *         3 3 0 0   0 0     0   0   3 0                 3
1309150 ID     school 1602160 433   MIDVALE DISTRICT 160216000939 1113 MIDVALE ALTERNATIVE SCHOOL   Alternative School No High 07 12.0 2019   grade_11 3 0 0   0 0     0   0   2 1             *         3 3 0 0   0 0     0   0   2 1                 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
1309519 ID     school 1600163 483   CHIEF TAHGEE ELEMENTARY ACADEMY, INC. 160016301040 1347 CHIEF TAHGEE ELEMENTARY ACADEMY   Regular School Yes Elementary KG 7.0 2019   grade_7 0 0 0   3 0     0   0   2 1             *         3 0 0 0   3 0     0   0   2 1                 3
1309696 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 2019   grade_10 1 0 1   0 0     1   0   0 3             *         3 1 0 1   0 0     1   0   0 3                 3
1309705 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 2019   grade_8 1 0 1   0 1     0   0   1 2             *         3 1 0 1   0 1     0   0   1 2                 3
1305233 ID     school 1600360 1   BOISE INDEPENDENT DISTRICT 160036000823 573 TREASURE VALLEY MATH/SCIENCE   Regular School No Other 04 12.0 2019   grade_6 0 0 0   0 4     0   0   1 3             *         4 0 0 0   0 4     0   0   1 3                 4
1305295 ID     school 1600360 1   BOISE INDEPENDENT DISTRICT 160036000708 9002 ADA COUNTY JUVENILE CENTER   Alternative School No High 05 12.0 2019   grade_12 3 0 0   1 0     0   0   4 0             *         4 3 0 0   1 0     0   0   4 0                 4
1305893 ID     school 1602640 25   POCATELLO DISTRICT 160264000186 9034 POCATELLO JUVENILE DETENTION   Alternative School No Other 01 12.0 2019   k_12_total 4 0 0   0 0     0   0   3 1             *         4 4 0 0   0 0     0   0   3 1                 4
1306433 ID     school 1601530 91   IDAHO FALLS DISTRICT 160153000697 1048 EMERSON HIGH SCHOOL   Alternative School No High 09 12.0 2019   grade_9 2 0 1   0 0     0   1   2 2             *         4 2 0 1   0 0     0   1   2 2                 4
1306451 ID     school 1603120 92   SWAN VALLEY ELEMENTARY DISTRICT 160312000541 424 SWAN VALLEY ELEMENTARY SCHOOL   Regular School No Elementary PK 8.0 2019   grade_7 4 0 0   0 0     0   0   3 1             *         4 4 0 0   0 0     0   0   3 1                 4
1306561 ID     school 1600930 93   BONNEVILLE JOINT DISTRICT 160093000999 1238 BONNEVILLE ONLINE ELEMENTARY   Regular School No Elementary PK 8.0 2019   grade_8 4 0 0   0 0     0   0   2 2             *         4 4 0 0   0 0     0   0   2 2                 4
1306659 ID     school 1600490 111   BUTTE COUNTY JOINT DISTRICT 160049000011 438 HOWE ELEMENTARY SCHOOL   Regular School No Elementary PK 5.0 2019   grade_1 4 0 0   0 0     0   0   4 0             *         4 4 0 0   0 0     0   0   4 0                 4
1307121 ID     school   150   SODA SPRINGS JOINT DISTRICT   1025 BORDER DISTRICT - FREEDOM ELEMENTARY             2019   grade_5 3 0 1   0 0     0   0   2 2             *         4 3 0 1   0 0     0   0   2 2                 4
1307279 ID     school 1602520 171   OROFINO JOINT DISTRICT 160252000436 481 CAVENDISH-TEAKEAN ELEMENTARY SCHOOL   Regular School No Elementary PK 6.0 2019   grade_5 4 0 0   0 0     0   0   2 2             *         4 4 0 0   0 0     0   0   2 2                 4
1307283 ID     school 1602520 171   OROFINO JOINT DISTRICT 160252000442 482 PECK ELEMENTARY SCHOOL   Regular School No Elementary PK 6.0 2019   grade_1 4 0 0   0 0     0   0   2 2             *         4 4 0 0   0 0     0   0   2 2                 4
1307488 ID     school 1601110 215   FREMONT COUNTY JOINT DISTRICT 160111000912 1271 FIVE-COUNTY DETENTION CENTER   Alternative School No High 05 12.0 2019   grade_11 1 0 0   3 0     0   0   0 4             *         4 1 0 0   3 0     0   0   0 4                 4
1307527 ID     school 1601020 221   EMMETT INDEPENDENT DISTRICT 160102000190 710 OLA ELEMENTARY SCHOOL   Regular School No Elementary KG 6.0 2019   grade_5 4 0 0   0 0     0   0   3 1             *         4 4 0 0   0 0     0   0   3 1                 4
1307535 ID     school 1601020 221   EMMETT INDEPENDENT DISTRICT 160102000923 1111 THE PATRIOT CENTER   Alternative School No High 06 12.0 2019   grade_9 2 0 1   1 0     0   0   4 0             *         4 2 0 1   1 0     0   0   4 0                 4
1307665 ID     school 1600139 244   MOUNTAIN VIEW SCHOOL DISTRICT 160013900933 1287 ELK CITY SCHOOL   Regular School No Elementary PK 8.0 2019   k_12_total 3 0 1   0 0     0   0   2 2             *         4 3 0 1   0 0     0   0   2 2                 4
1307765 ID     school 1601590 261   JEROME JOINT DISTRICT 160159000289 297 JEROME ACADEMY   Special Education School No Other KG 12.0 2019   grade_4 3 0 1   0 0     0   0   4 0             *         4 3 0 1   0 0     0   0   4 0                 4
1308179 ID     school 1602850 291   SALMON DISTRICT 160285000700 9014 SALMON ALTERNATIVE HIGH SCHOOL   Alternative School No High 09 12.0 2019   k_12_total 1 1 2   0 0     0   0   3 1             *         4 1 1 2   0 0     0   0   3 1                 4
1308183 ID     school 1603030 292   SOUTH LEMHI DISTRICT 160303000528 137 LEADORE SCHOOL   Regular School No Other PK 12.0 2019   grade_12 3 0 1   0 0     0   0   1 3             *         4 3 0 1   0 0     0   0   1 3                 4
1308193 ID     school 1603030 292   SOUTH LEMHI DISTRICT 160303000528 137 LEADORE SCHOOL   Regular School No Other PK 12.0 2019   kindergarten 4 0 0   0 0     0   0   1 3             *         4 4 0 0   0 0     0   0   1 3                 4
1308198 ID     school 1603030 292   SOUTH LEMHI DISTRICT 160303000529 765 TENDOY ELEMENTARY SCHOOL   Regular School No Elementary KG 5.0 2019   grade_5 3 0 0   0 0     0   1   1 3             *         4 3 0 0   0 0     0   1   1 3                 4
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
1308369 ID     school 1603090 322   SUGAR-SALEM JOINT DISTRICT 160309000853 874 VALLEY VIEW ALTERNATIVE HIGH SCHOOL   Alternative School No High 09 12.0 2019   grade_12 2 0 2   0 0     0   0   1 3             *         4 2 0 2   0 0     0   0   1 3                 4
1308510 ID     school 1601860 340   LEWISTON INDEPENDENT DISTRICT 160186000170 1266 REGION 2 JUVENILE DETENTION CENTER   Alternative School No Other 03 12.0 2019   grade_11 2 0 0   2 0     0   0   4 0             *         4 2 0 0   2 0     0   0   4 0                 4
1308532 ID     school 1600870 342   CULDESAC JOINT DISTRICT 160087000164 795 CULDESAC SCHOOL   Regular School No Other PK 12.0 2019   grade_11 4 0 0   0 0     0   0   2 2             *         4 4 0 0   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]);