Data source: Big Local News · About: Big Local

4,737 rows where state = "ID" and year = 2018 sorted by white_int

View and edit SQL

grade

year

  • 2018 · 4,637
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
1279574 ID     school 1601860 340   LEWISTON INDEPENDENT DISTRICT 160186000929 611 NORTHWEST CHILDRENS HOME   Special Education School No Other PK 12.0 2018   grade_3 1 0 0   1 0     0   0   2 0             *         2 1 0 0   1 0     0   0   2 0                 2
1279575 ID     school 1601860 340   LEWISTON INDEPENDENT DISTRICT 160186000929 611 NORTHWEST CHILDRENS HOME   Special Education School No Other PK 12.0 2018   grade_4 1 0 0   0 0     0   0   1 0             *         1 1 0 0   0 0     0   0   1 0                 1
1279576 ID     school 1601860 340   LEWISTON INDEPENDENT DISTRICT 160186000929 611 NORTHWEST CHILDRENS HOME   Special Education School No Other PK 12.0 2018   grade_5 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
1279645 ID     school 1601860 340   LEWISTON INDEPENDENT DISTRICT 160186000170 1266 REGION 2 JUVENILE DETENTION CENTER   Alternative School No Other 03 12.0 2018   k_12_total 1 0 0   3 0     0   0   4 0             *         4 1 0 0   3 0     0   0   4 0                 4
1279647 ID     school 1601830 341   LAPWAI DISTRICT 160183000854 583 LAPWAI MIDDLE/HIGH SCHOOL   Regular School No High 06 12.0 2018   grade_11 1 0 1   29 0     0   2   15 18             *         33 1 0 1   29 0     0   2   15 18                 33
1279650 ID     school 1601830 341   LAPWAI DISTRICT 160183000854 583 LAPWAI MIDDLE/HIGH SCHOOL   Regular School No High 06 12.0 2018   grade_7 1 0 1   34 0     0   4   23 17             *         40 1 0 1   34 0     0   4   23 17                 40
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
1279656 ID     school 1601830 341   LAPWAI DISTRICT 160183000317 844 LAPWAI ELEMENTARY SCHOOL   Regular School No Elementary PK 5.0 2018   grade_3 1 0 2   30 0     0   2   18 17             *         35 1 0 2   30 0     0   2   18 17                 35
1279680 ID     school 1602490 351   ONEIDA COUNTY DISTRICT 160249000856 580 ONEIDA HIGH SCHOOL   Alternative School No High 09 12.0 2018   grade_10 1 0 0   0 0     0   0   1 0             *         1 1 0 0   0 0     0   0   1 0                 1
1279725 ID     school 1602610 364   PLEASANT VALLEY ELEMENTARY DISTRICT 160261000459 800 PLEASANT VALLEY ELEM/JR HIGH   Regular School No Elementary PK 8.0 2018   grade_1 1 0 0   0 0     0   0   0 1             *         1 1 0 0   0 0     0   0   0 1                 1
1279726 ID     school 1602610 364   PLEASANT VALLEY ELEMENTARY DISTRICT 160261000459 800 PLEASANT VALLEY ELEM/JR HIGH   Regular School No Elementary PK 8.0 2018   grade_2 1 0 0   0 0     0   0   0 1             *         1 1 0 0   0 0     0   0   0 1                 1
1279727 ID     school 1602610 364   PLEASANT VALLEY ELEMENTARY DISTRICT 160261000459 800 PLEASANT VALLEY ELEM/JR HIGH   Regular School No Elementary PK 8.0 2018   grade_3 1 0 0   0 0     0   0   0 1             *         1 1 0 0   0 0     0   0   0 1                 1
1279732 ID     school   364   PLEASANT VALLEY ELEMENTARY DISTRICT   1056 BORDER DISTRICT - JORDAN VALLEY SECONDARY             2018   grade_11 1 0 0   0 0     0   0   0 1             *         1 1 0 0   0 0     0   0   0 1                 1
1279733 ID     school   364   PLEASANT VALLEY ELEMENTARY DISTRICT   1056 BORDER DISTRICT - JORDAN VALLEY SECONDARY             2018   k_12_total 1 0 0   0 0     0   0   0 1             *         1 1 0 0   0 0     0   0   0 1                 1
1279927 ID     school 1600150 394   AVERY SCHOOL DISTRICT 160015001010 820 CALDER SCHOOL   Regular School No Elementary KG 8.0 2018   grade_5 1 0 0   0 0     0   0   1 0             *         1 1 0 0   0 0     0   0   1 0                 1
1279928 ID     school 1600150 394   AVERY SCHOOL DISTRICT 160015001010 820 CALDER SCHOOL   Regular School No Elementary KG 8.0 2018   grade_6 1 0 0   0 0     0   1   2 0             *         2 1 0 0   0 0     0   1   2 0                 2
1279929 ID     school 1600150 394   AVERY SCHOOL DISTRICT 160015001010 820 CALDER SCHOOL   Regular School No Elementary KG 8.0 2018   grade_8 1 0 0   0 0     0   0   0 1             *         1 1 0 0   0 0     0   0   0 1                 1
1279931 ID     school 1600150 394   AVERY SCHOOL DISTRICT 160015001010 820 CALDER SCHOOL   Regular School No Elementary KG 8.0 2018   kindergarten 1 0 0   0 0     0   0   0 1             *         1 1 0 0   0 0     0   0   0 1                 1
1280037 ID     school 1603240 411   TWIN FALLS DISTRICT 160324000739 1260 SNAKE RIVER JUVENILE DETENTION   Alternative School No Other 01 12.0 2018   grade_10 1 0 0   0 0     0   0   1 0             *         1 1 0 0   0 0     0   0   1 0                 1
1280038 ID     school 1603240 411   TWIN FALLS DISTRICT 160324000739 1260 SNAKE RIVER JUVENILE DETENTION   Alternative School No Other 01 12.0 2018   grade_11 1 0 0   0 0     0   0   1 0             *         1 1 0 0   0 0     0   0   1 0                 1
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
1280061 ID     school 1603240 411   TWIN FALLS DISTRICT 160324001105 1402 TWIN FALLS VIRTUAL SCHOOLHOUSE   Regular School No Elementary PK 8.0 2018   grade_1 1 0 1   0 0     0   0   0 2             *         2 1 0 1   0 0     0   0   0 2                 2
1280062 ID     school 1603240 411   TWIN FALLS DISTRICT 160324001105 1402 TWIN FALLS VIRTUAL SCHOOLHOUSE   Regular School No Elementary PK 8.0 2018   grade_2 1 0 0   0 0     0   0   0 1             *         1 1 0 0   0 0     0   0   0 1                 1
1280063 ID     school 1603240 411   TWIN FALLS DISTRICT 160324001105 1402 TWIN FALLS VIRTUAL SCHOOLHOUSE   Regular School No Elementary PK 8.0 2018   grade_3 1 0 0   0 0     0   0   0 1             *         1 1 0 0   0 0     0   0   0 1                 1
1280065 ID     school 1603240 411   TWIN FALLS DISTRICT 160324001105 1402 TWIN FALLS VIRTUAL SCHOOLHOUSE   Regular School No Elementary PK 8.0 2018   grade_5 1 0 1   0 0     0   0   1 1             *         2 1 0 1   0 0     0   0   1 1                 2
1280145 ID     school 1603210 416   THREE CREEK JOINT ELEMENTARY DISTRICT 160321000546 835 THREE CREEK ELEM/JR HIGH SCHOOL   Regular School No Elementary PK 8.0 2018   grade_1 1 0 0   0 0     0   0   0 1             *         1 1 0 0   0 0     0   0   0 1                 1
1280146 ID     school 1603210 416   THREE CREEK JOINT ELEMENTARY DISTRICT 160321000546 835 THREE CREEK ELEM/JR HIGH SCHOOL   Regular School No Elementary PK 8.0 2018   grade_2 1 0 0   0 0     0   0   0 1             *         1 1 0 0   0 0     0   0   0 1                 1
1280147 ID     school 1603210 416   THREE CREEK JOINT ELEMENTARY DISTRICT 160321000546 835 THREE CREEK ELEM/JR HIGH SCHOOL   Regular School No Elementary PK 8.0 2018   grade_3 1 0 0   0 0     0   0   1 0             *         1 1 0 0   0 0     0   0   1 0                 1
1280148 ID     school 1603210 416   THREE CREEK JOINT ELEMENTARY DISTRICT 160321000546 835 THREE CREEK ELEM/JR HIGH SCHOOL   Regular School No Elementary PK 8.0 2018   grade_4 1 0 0   0 0     0   0   0 1             *         1 1 0 0   0 0     0   0   0 1                 1
1280149 ID     school 1603210 416   THREE CREEK JOINT ELEMENTARY DISTRICT 160321000546 835 THREE CREEK ELEM/JR HIGH SCHOOL   Regular School No Elementary PK 8.0 2018   grade_6 1 0 0   0 0     0   0   0 1             *         1 1 0 0   0 0     0   0   0 1                 1
1280150 ID     school 1603210 416   THREE CREEK JOINT ELEMENTARY DISTRICT 160321000546 835 THREE CREEK ELEM/JR HIGH SCHOOL   Regular School No Elementary PK 8.0 2018   grade_7 1 0 0   0 0     0   0   1 0             *         1 1 0 0   0 0     0   0   1 0                 1
1280276 ID     school 1602160 433   MIDVALE DISTRICT 160216000939 1113 MIDVALE ALTERNATIVE SCHOOL   Alternative School No High 07 12.0 2018   grade_7 1 0 0   0 0     0   0   0 1             *         1 1 0 0   0 0     0   0   0 1                 1
1280277 ID     school 1602160 433   MIDVALE DISTRICT 160216000939 1113 MIDVALE ALTERNATIVE SCHOOL   Alternative School No High 07 12.0 2018   grade_8 1 0 0   0 0     0   0   1 0             *         1 1 0 0   0 0     0   0   1 0                 1
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
1280638 ID     school 1600163 483   CHIEF TAHGEE ELEMENTARY ACADEMY, INC. 160016301040 1347 CHIEF TAHGEE ELEMENTARY ACADEMY   Regular School Yes Elementary KG 6.0 2018   grade_4 1 0 3   11 0     0   0   7 8             10         15 1 0 3   11 0     0   0   7 8         10       15
1280641 ID     school 1600163 483   CHIEF TAHGEE ELEMENTARY ACADEMY, INC. 160016301040 1347 CHIEF TAHGEE ELEMENTARY ACADEMY   Regular School Yes Elementary KG 6.0 2018   k_12_total 1 0 8   75 0     1   2   48 39             70         87 1 0 8   75 0     1   2   48 39         70       87
1280765 ID     school 1600152 555   CANYON-OWYHEE SCHOOL SERVICE AGENCY (COSSA) 160015200304 1291 COSSA ACADEMY   Alternative School No High 07 12.0 2018   grade_7 1 0 1   0 0     0   1   3 0             *         3 1 0 1   0 0     0   1   3 0                 3
1280792 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_7 1 0 1   0 1     0   0   1 2             *         3 1 0 1   0 1     0   0   1 2                 3
1280796 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   kindergarten 1 0 1   0 0     0   0   1 1             *         2 1 0 1   0 0     0   0   1 1                 2
1276438 ID     school 1600360 1   BOISE INDEPENDENT DISTRICT 160036000708 9002 ADA COUNTY JUVENILE CENTER   Alternative School No High 05 12.0 2018   grade_11 2 0 0   0 0     0   0   1 1             *         2 2 0 0   0 0     0   0   1 1                 2
1277023 ID     school 1602640 25   POCATELLO DISTRICT 160264000686 1002 KINPORT MIDDLE SCHOOL   Alternative School No Middle 06 8.0 2018   grade_8 2 0 2   0 0     0   0   4 0             *         4 2 0 2   0 0     0   0   4 0                 4
1277063 ID     school 1600240 33   BEAR LAKE COUNTY DISTRICT 160024000827 404 CLOVER CREEK HIGH SCHOOL   Alternative School No High 09 12.0 2018   grade_10 2 0 1   0 0     0   0   2 1             *         3 2 0 1   0 0     0   0   2 1                 3
1277066 ID     school 1600240 33   BEAR LAKE COUNTY DISTRICT 160024000827 404 CLOVER CREEK HIGH SCHOOL   Alternative School No High 09 12.0 2018   grade_9 2 0 0   0 0     0   0   2 0             *         2 2 0 0   0 0     0   0   2 0                 2
1277295 ID     school 1600300 61   BLAINE COUNTY DISTRICT 160030000197 1102 SILVER CREEK HIGH SCHOOL   Alternative School No High 09 12.0 2018   grade_9 2 0 3   0 0     0   1   4 2             *         6 2 0 3   0 0     0   1   4 2                 6
1277315 ID     school 1601170 71   GARDEN VALLEY DISTRICT 160117000216 398 LOWMAN ELEMENTARY SCHOOL   Regular School No Elementary PK 6.0 2018   kindergarten 2 0 0   0 0     0   0   2 0             *         2 2 0 0   0 0     0   0   2 0                 2
1277359 ID     school 1600001 83   WEST BONNER COUNTY DISTRICT 160000100620 406 PRIEST LAKE ELEMENTARY SCHOOL   Regular School No Elementary PK 6.0 2018   grade_6 2 0 0   0 0     0   0   2 0             *         2 2 0 0   0 0     0   0   2 0                 2
1277454 ID     school 1600002 84   LAKE PEND OREILLE SCHOOL DISTRICT 160000200604 997 SANDPOINT JUVENILE DETENTION   Alternative School No High 05 12.0 2018   grade_10 2 0 0   0 0     0   0   0 2             *         2 2 0 0   0 0     0   0   0 2                 2
1277582 ID     school 1601530 91   IDAHO FALLS DISTRICT 160153000605 1152 3B JUVENILE DETENTION CENTER   Alternative School No Other 04 12.0 2018   grade_11 2 0 0   0 0     0   1   3 0             *         3 2 0 0   0 0     0   1   3 0                 3
1277604 ID     school   92   SWAN VALLEY ELEMENTARY DISTRICT   1015 BORDER DISTRICT - STAR VALLEY JR-SR HIGH SCHOOL             2018   grade_10 2 0 0   0 0     0   0   1 1             *         2 2 0 0   0 0     0   0   1 1                 2
1277707 ID     school 1600930 93   BONNEVILLE JOINT DISTRICT 160093000999 1238 BONNEVILLE ONLINE ELEMENTARY   Regular School No Elementary PK 8.0 2018   grade_8 2 0 0   0 0     0   2   4 0             *         4 2 0 0   0 0     0   2   4 0                 4
1277737 ID     school 1600930 93   BONNEVILLE JOINT DISTRICT 160093001063 1357 TECHNICAL CAREERS HIGH SCHOOL   Career and Technical School No High 09 12.0 2018   grade_9 2 0 0   0 0     0   0   1 1             *         2 2 0 0   0 0     0   0   1 1                 2
1278083 ID     school 1602130 134   MIDDLETON DISTRICT 160213000777 1168 MIDDLETON ACADEMY   Alternative School No High 07 12.0 2018   grade_7 2 0 1   0 0     0   0   2 1             *         3 2 0 1   0 0     0   0   2 1                 3
1278267 ID     school   150   SODA SPRINGS JOINT DISTRICT   1025 BORDER DISTRICT - FREEDOM ELEMENTARY             2018   grade_5 2 0 0   0 0     0   0   2 0             *         2 2 0 0   0 0     0   0   2 0                 2
1278274 ID     school   150   SODA SPRINGS JOINT DISTRICT   1026 BORDER DISTRICT FREEDOM - SECONDARY             2018   grade_9 2 0 0   0 0     0   0   2 0             *         2 2 0 0   0 0     0   0   2 0                 2
1278313 ID     school 1600660 151   CASSIA COUNTY JOINT DISTRICT 160066000123 468 ALMO ELEMENTARY SCHOOL   Regular School No Elementary PK 6.0 2018   grade_3 2 0 0   0 0     0   0   1 1             *         2 2 0 0   0 0     0   0   1 1                 2
1278359 ID     school 1600660 151   CASSIA COUNTY JOINT DISTRICT 160066000540 990 CASSIA JR/SR HIGH SCHOOL   Alternative School No High 07 12.0 2018   grade_7 2 0 1   0 0     0   0   1 2             *         3 2 0 1   0 0     0   0   1 2                 3
1278375 ID     school 1600750 161   CLARK COUNTY DISTRICT 160075000145 478 LINDY ROSS ELEMENTARY SCHOOL   Regular School No Elementary PK 8.0 2018   grade_5 2 0 5   0 0     0   0   1 6             *         7 2 0 5   0 0     0   0   1 6                 7
1278401 ID     school 1602520 171   OROFINO JOINT DISTRICT 160252000436 481 CAVENDISH-TEAKEAN ELEMENTARY SCHOOL   Regular School No Elementary PK 6.0 2018   grade_1 2 0 0   0 0     0   1   1 2             *         3 2 0 0   0 0     0   1   1 2                 3
1278409 ID     school 1602520 171   OROFINO JOINT DISTRICT 160252000442 482 PECK ELEMENTARY SCHOOL   Regular School No Elementary PK 6.0 2018   grade_1 2 0 0   0 0     0   0   1 1             *         2 2 0 0   0 0     0   0   1 1                 2
1278410 ID     school 1602520 171   OROFINO JOINT DISTRICT 160252000442 482 PECK ELEMENTARY SCHOOL   Regular School No Elementary PK 6.0 2018   grade_2 2 0 0   0 0     0   0   2 0             *         2 2 0 0   0 0     0   0   2 0                 2
1278411 ID     school 1602520 171   OROFINO JOINT DISTRICT 160252000442 482 PECK ELEMENTARY SCHOOL   Regular School No Elementary PK 6.0 2018   grade_3 2 0 0   0 0     0   0   2 0             *         2 2 0 0   0 0     0   0   2 0                 2
1278413 ID     school 1602520 171   OROFINO JOINT DISTRICT 160252000442 482 PECK ELEMENTARY SCHOOL   Regular School No Elementary PK 6.0 2018   grade_5 2 0 0   0 0     0   0   2 0             *         2 2 0 0   0 0     0   0   2 0                 2
1278416 ID     school 1602520 171   OROFINO JOINT DISTRICT 160252000442 482 PECK ELEMENTARY SCHOOL   Regular School No Elementary PK 6.0 2018   kindergarten 2 0 0   0 0     0   0   1 1             *         2 2 0 0   0 0     0   0   1 1                 2
1278420 ID     school 1602520 171   OROFINO JOINT DISTRICT 160252001057 1362 IDAHO YOUTH CHALLENGE ACADEMY FALL   Alternative School No High 09 12.0 2018   grade_9 2 0 0   0 0     0   0   2 0             *         2 2 0 0   0 0     0   0   2 0                 2
1278437 ID     school 1600720 181   CHALLIS JOINT DISTRICT 160072000143 486 STANLEY ELEM/JR HIGH SCHOOL   Regular School No Elementary KG 8.0 2018   grade_4 2 0 0   0 0     0   0   0 2             *         2 2 0 0   0 0     0   0   0 2                 2
1278441 ID     school 1600720 181   CHALLIS JOINT DISTRICT 160072000143 486 STANLEY ELEM/JR HIGH SCHOOL   Regular School No Elementary KG 8.0 2018   grade_8 2 0 0   0 0     0   0   2 0             *         2 2 0 0   0 0     0   0   2 0                 2
1278468 ID     school 1602730 191   PRAIRIE ELEMENTARY DISTRICT 160273000496 491 PRAIRIE ELEM/JR HIGH SCHOOL   Regular School No Elementary KG 8.0 2018   grade_8 2 0 0   0 0     0   0   1 1             *         2 2 0 0   0 0     0   0   1 1                 2
1278518 ID     school 1602250 193   MOUNTAIN HOME DISTRICT 160225000266 517 PINE ELEM/JR HIGH SCHOOL   Regular School No Elementary PK 8.0 2018   grade_1 2 0 0   0 0     0   0   0 2             *         2 2 0 0   0 0     0   0   0 2                 2
1278614 ID     school 1601110 215   FREMONT COUNTY JOINT DISTRICT 160111000912 1271 FIVE-COUNTY DETENTION CENTER   Alternative School No High 05 12.0 2018   grade_11 2 0 1   1 0     0   0   1 3             *         4 2 0 1   1 0     0   0   1 3                 4
1278651 ID     school 1601020 221   EMMETT INDEPENDENT DISTRICT 160102000190 710 OLA ELEMENTARY SCHOOL   Regular School No Elementary KG 6.0 2018   grade_3 2 0 0   0 0     0   0   0 2             *         2 2 0 0   0 0     0   0   0 2                 2
1278662 ID     school 1601020 221   EMMETT INDEPENDENT DISTRICT 160102000923 1111 THE PATRIOT CENTER   Alternative School No High 06 12.0 2018   grade_8 2 1 0   0 0     0   0   3 0             *         3 2 1 0   0 0     0   0   3 0                 3
1278836 ID     school 1601570 251   JEFFERSON COUNTY JOINT DISTRICT 160157000626 1143 JEFFERSON HIGH SCHOOL   Alternative School No High 09 12.0 2018   grade_9 2 0 1   0 0     0   0   2 1             *         3 2 0 1   0 0     0   0   2 1                 3
1278879 ID     school 1603400 253   WEST JEFFERSON DISTRICT 160340000273 729 HAMER ELEMENTARY SCHOOL   Regular School No Elementary KG 4.0 2018   kindergarten 2 0 0   0 0     0   0   2 0             *         2 2 0 0   0 0     0   0   2 0                 2
1278911 ID     school 1601590 261   JEROME JOINT DISTRICT 160159000097 1272 FALLS CITY ACADEMY   Alternative School No High 06 12.0 2018   grade_7 2 0 1   0 0     0   0   3 0             *         3 2 0 1   0 0     0   0   3 0                 3
1278913 ID     school 1601590 261   JEROME JOINT DISTRICT 160159000097 1272 FALLS CITY ACADEMY   Alternative School No High 06 12.0 2018   grade_9 2 0 1   0 0     0   0   1 2             *         3 2 0 1   0 0     0   0   1 2                 3
1279033 ID     school 1600780 271   COEUR D'ALENE DISTRICT 160078000704 1038 CDA JUVENILE DETENTION CENTER   Alternative School No Other 04 12.0 2018   grade_7 2 0 0   0 0     0   0   2 0             *         2 2 0 0   0 0     0   0   2 0                 2
1279309 ID     school 1602850 291   SALMON DISTRICT 160285000700 9014 SALMON ALTERNATIVE HIGH SCHOOL   Alternative School No High 09 12.0 2018   grade_12 2 0 1   0 0     0   0   3 0             *         3 2 0 1   0 0     0   0   3 0                 3
1279314 ID     school 1603030 292   SOUTH LEMHI DISTRICT 160303000528 137 LEADORE SCHOOL   Regular School No Other PK 12.0 2018   grade_11 2 0 1   0 0     0   0   1 2             *         3 2 0 1   0 0     0   0   1 2                 3
1279330 ID     school 1603030 292   SOUTH LEMHI DISTRICT 160303000529 765 TENDOY ELEMENTARY SCHOOL   Regular School No Elementary KG 5.0 2018   grade_5 2 0 0   0 0     0   0   0 2             *         2 2 0 0   0 0     0   0   0 2                 2
1279393 ID     school 1602940 312   SHOSHONE JOINT DISTRICT 160294001026 846 HIGH DESERT   Alternative School No High 09 12.0 2018   grade_10 2 0 1   0 0     0   0   2 1             *         3 2 0 1   0 0     0   0   2 1                 3
1279546 ID     school 1602190 331   MINIDOKA COUNTY JOINT DISTRICT 160219000158 1046 MT HARRISON JR/SR HIGH   Alternative School No High 06 12.0 2018   grade_8 2 0 5   0 0     0   0   3 4             *         7 2 0 5   0 0     0   0   3 4                 7
1279553 ID     school 1602190 331   MINIDOKA COUNTY JOINT DISTRICT 160219000166 1100 MINI-CASSIA JUVENILE DETENTION CENTER   Alternative School No Other 03 12.0 2018   grade_9 2 0 0   0 0     0   0   2 0             *         2 2 0 0   0 0     0   0   2 0                 2
1279558 ID     school 1602190 331   MINIDOKA COUNTY JOINT DISTRICT 160219001028 1263 DAY TREATMENT ELEMENTARY   Special Education School No Elementary KG 6.0 2018   grade_4 2 0 2   0 0     0   0   4 0             *         4 2 0 2   0 0     0   0   4 0                 4
1279559 ID     school 1602190 331   MINIDOKA COUNTY JOINT DISTRICT 160219001028 1263 DAY TREATMENT ELEMENTARY   Special Education School No Elementary KG 6.0 2018   grade_5 2 0 0   0 0     0   0   2 0             *         2 2 0 0   0 0     0   0   2 0                 2
1279573 ID     school 1601860 340   LEWISTON INDEPENDENT DISTRICT 160186000929 611 NORTHWEST CHILDRENS HOME   Special Education School No Other PK 12.0 2018   grade_12 2 0 0   0 0     0   0   1 1             *         2 2 0 0   0 0     0   0   1 1                 2
1279579 ID     school 1601860 340   LEWISTON INDEPENDENT DISTRICT 160186000929 611 NORTHWEST CHILDRENS HOME   Special Education School No Other PK 12.0 2018   grade_8 2 0 0   0 0     0   0   2 0             *         2 2 0 0   0 0     0   0   2 0                 2
1279648 ID     school 1601830 341   LAPWAI DISTRICT 160183000854 583 LAPWAI MIDDLE/HIGH SCHOOL   Regular School No High 06 12.0 2018   grade_12 2 0 2   18 0     0   2   11 13             *         24 2 0 2   18 0     0   2   11 13                 24
1279689 ID     school 1602490 351   ONEIDA COUNTY DISTRICT 160249000434 797 STONE ELEMENTARY SCHOOL   Regular School No Elementary PK 3.0 2018   grade_3 2 0 0   0 0     0   0   1 1             *         2 2 0 0   0 0     0   0   1 1                 2
1279728 ID     school 1602610 364   PLEASANT VALLEY ELEMENTARY DISTRICT 160261000459 800 PLEASANT VALLEY ELEM/JR HIGH   Regular School No Elementary PK 8.0 2018   grade_4 2 0 0   0 0     0   0   1 1             *         2 2 0 0   0 0     0   0   1 1                 2
1279729 ID     school 1602610 364   PLEASANT VALLEY ELEMENTARY DISTRICT 160261000459 800 PLEASANT VALLEY ELEM/JR HIGH   Regular School No Elementary PK 8.0 2018   grade_6 2 0 0   0 0     0   0   0 2             *         2 2 0 0   0 0     0   0   0 2                 2
1279821 ID     school 1601140 373   FRUITLAND DISTRICT 160114000988 1332 FRUITLAND PREPARATORY ACADEMY   Alternative School No High 06 12.0 2018   grade_10 2 0 1   0 0     0   0   2 1             *         3 2 0 1   0 0     0   0   2 1                 3
1279835 ID     school 1600060 381   AMERICAN FALLS JOINT DISTRICT 160006000768 261 AMERICAN FALLS ACADEMY   Alternative School No High 06 12.0 2018   grade_10 2 0 1   0 0     0   0   2 1             *         3 2 0 1   0 0     0   0   2 1                 3
1279867 ID     school 1600090 383   ARBON ELEMENTARY DISTRICT 160009000006 810 ARBON ELEMENTARY SCHOOL   Regular School No Elementary KG 6.0 2018   grade_6 2 0 0   0 0     0   0   2 0             *         2 2 0 0   0 0     0   0   2 0                 2
1279923 ID     school 1600150 394   AVERY SCHOOL DISTRICT 160015001010 820 CALDER SCHOOL   Regular School No Elementary KG 8.0 2018   grade_1 2 0 0   0 0     0   0   1 1             *         2 2 0 0   0 0     0   0   1 1                 2
1279924 ID     school 1600150 394   AVERY SCHOOL DISTRICT 160015001010 820 CALDER SCHOOL   Regular School No Elementary KG 8.0 2018   grade_2 2 0 0   0 0     0   0   1 1             *         2 2 0 0   0 0     0   0   1 1                 2
1279925 ID     school 1600150 394   AVERY SCHOOL DISTRICT 160015001010 820 CALDER SCHOOL   Regular School No Elementary KG 8.0 2018   grade_3 2 0 0   0 0     0   0   1 1             *         2 2 0 0   0 0     0   0   1 1                 2
1280027 ID     school 1603240 411   TWIN FALLS DISTRICT 160324000703 1066 MAGIC VALLEY HIGH SCHOOL   Alternative School No High 09 12.0 2018   grade_9 2 0 1   0 0     0   0   2 1             *         3 2 0 1   0 0     0   0   2 1                 3
1280040 ID     school 1603240 411   TWIN FALLS DISTRICT 160324000739 1260 SNAKE RIVER JUVENILE DETENTION   Alternative School No Other 01 12.0 2018   grade_8 2 0 0   1 0     0   0   2 1             *         3 2 0 0   1 0     0   0   2 1                 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]);