Data source: Big Local News · About: Big Local

2,743 rows where grade = "grade_4" and state = "ID" sorted by white

View and edit SQL

year

grade

  • grade_4 · 2,743
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
703877 ID     school 1600270 55   BLACKFOOT DISTRICT 160027000026 387 FORT HALL ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2021   grade_4 0 0 5   11 0     0   2   11 7             10         18 0 0 5   11 0     0   2   11 7         10       18
707479 ID     school 1600163 483   CHIEF TAHGEE ELEMENTARY ACADEMY, INC. 160016301040 1347 CHIEF TAHGEE ELEMENTARY ACADEMY   Regular School Yes Elementary KG 07 2021   grade_4 0 0 0   9 0     0   0   7 2             *         9 0 0 0   9 0     0   0   7 2                 9
849625 ID     school 1600270 55   BLACKFOOT DISTRICT 160027000026 387 FORT HALL ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2020   grade_4 0 0 4   22 0     0   1   12 15             17         27 0 0 4   22 0     0   1   12 15         17       27
853126 ID     school 1600163 483   CHIEF TAHGEE ELEMENTARY ACADEMY, INC. 160016301040 1347 CHIEF TAHGEE ELEMENTARY ACADEMY   Regular School Yes Elementary KG 07 2020   grade_4 0 0 1   8 0     0   0   8 1             *         9 0 0 1   8 0     0   0   8 1                 9
1277173 ID     school 1600270 55   BLACKFOOT DISTRICT 160027000026 387 FORT HALL ELEMENTARY SCHOOL   Regular School No Elementary PK 5.0 2018   grade_4 0 0 5   18 0     0   2   11 14             *         25 0 0 5   18 0     0   2   11 14                 25
1278519 ID     school 1602250 193   MOUNTAIN HOME DISTRICT 160225000266 517 PINE ELEM/JR HIGH SCHOOL   Regular School No Elementary PK 8.0 2018   grade_4 0 0 0   1 0     0   0   0 1             *         1 0 0 0   1 0     0   0   0 1                 1
1278895 ID     school 1601590 261   JEROME JOINT DISTRICT 160159000289 297 JEROME ACADEMY   Special Education School No Other KG 12.0 2018   grade_4 0 0 1   0 0     0   0   0 1             *         1 0 0 1   0 0     0   0   0 1                 1
1306033 ID     school 1600270 55   BLACKFOOT DISTRICT 160027000026 387 FORT HALL ELEMENTARY SCHOOL   Regular School No Elementary PK 5.0 2019   grade_4 0 0 5   20 0     0   1   11 15             *         26 0 0 5   20 0     0   1   11 15                 26
1308544 ID     school   342   CULDESAC JOINT DISTRICT   1373 NORTHWEST CHILDREN'S HOME             2019   grade_4 0 0 0   1 0     0   0   1 0             *         1 0 0 0   1 0     0   0   1 0                 1
1309516 ID     school 1600163 483   CHIEF TAHGEE ELEMENTARY ACADEMY, INC. 160016301040 1347 CHIEF TAHGEE ELEMENTARY ACADEMY   Regular School Yes Elementary KG 7.0 2019   grade_4 0 0 0   7 0     0   0   5 2             *         7 0 0 0   7 0     0   0   5 2                 7
1682598 ID     school 1600270 55   BLACKFOOT DISTRICT 160027000026 387 FORT HALL ELEMENTARY SCHOOL   Regular School No 1.0 PK 05 2015   grade_4 0 0 6   24 0     0   1   13 18             *         31 0 0 6   24 0     0   1   13 18                 31
1685063 ID     school   341   LAPWAI DISTRICT   1050 NORTHWEST CHILDREN'S HOME             2015   grade_4 0 0 0   1 0     0   0   1 0             *         1 0 0 0   1 0     0   0   1 0                 1
1685999 ID     school 1600163 483   CHIEF TAHGEE ELEMENTARY ACADEMY, INC. 160016301040 1347 CHIEF TAHGEE ELEMENTARY ACADEMY   Regular School Yes 1.0 KG 06 2015   grade_4 0 0 3   5 0     0   1   4 5             *         9 0 0 3   5 0     0   1   4 5                 9
1726638 ID     school 1600270 55   BLACKFOOT DISTRICT 160027000026 387 FORT HALL ELEMENTARY SCHOOL   Regular School No Elementary PK 5.0 2017   grade_4 0 0 6   10 0     0   2   12 6             8         18 0 0 6   10 0     0   2   12 6         8       18
1728360 ID     school 1601590 261   JEROME JOINT DISTRICT 160159000289 297 JEROME ACADEMY   Special Education School No Other 01 12.0 2017   grade_4 0 0 1   0 0     0   1   2 0             *         2 0 0 1   0 0     0   1   2 0                 2
1730088 ID     school 1600163 483   CHIEF TAHGEE ELEMENTARY ACADEMY, INC. 160016301040 1347 CHIEF TAHGEE ELEMENTARY ACADEMY   Regular School Yes Elementary KG 6.0 2017   grade_4 0 0 3   9 0     0   0   7 5             *         12 0 0 3   9 0     0   0   7 5                 12
1821634 ID     school 1600270 55   BLACKFOOT DISTRICT 160027000026 387 FORT HALL ELEMENTARY SCHOOL   Regular School No 1.0 PK 05 2016   grade_4 0 0 5   12 0     0   0   9 8             12         17 0 0 5   12 0     0   0   9 8         12       17
1824022 ID     school   340   LEWISTON INDEPENDENT DISTRICT   611 NORTHWEST CHILDRENS HOME             2016   grade_4 0 0 0   0 0     0   1   0 1             *         1 0 0 0   0 0     0   1   0 1                 1
1824376 ID     school 1600150 394   AVERY SCHOOL DISTRICT 160015001010 820 CALDER SCHOOL   Regular School No 4.0 KG 12 2016   grade_4 0 0 0   0 0     0   1   1 0             *         1 0 0 0   0 0     0   1   1 0                 1
1825034 ID     school 1600163 483   CHIEF TAHGEE ELEMENTARY ACADEMY, INC. 160016301040 1347 CHIEF TAHGEE ELEMENTARY ACADEMY   Regular School Yes 1.0 KG 06 2016   grade_4 0 0 0   13 0     0   0   8 5             *         13 0 0 0   13 0     0   0   8 5                 13
704333 ID     school   92   SWAN VALLEY ELEMENTARY DISTRICT   1014 BORDER DISTRICT - STAR VALLEY ELEMENTARY SCHOOL             2021   grade_4 1 0 0   0 0     0   0   1 0             *         1 1 0 0   0 0     0   0   1 0                 1
705146 ID     school 1600750 161   CLARK COUNTY DISTRICT 160075000145 478 LINDY ROSS ELEMENTARY SCHOOL   Regular School No Elementary PK 08 2021   grade_4 1 0 3   0 0     0   0   3 1             *         4 1 0 3   0 0     0   0   3 1                 4
705176 ID     school 1602520 171   OROFINO JOINT DISTRICT 160252000436 481 CAVENDISH-TEAKEAN ELEMENTARY SCHOOL   Regular School No Elementary PK 06 2021   grade_4 1 0 0   0 0     0   0   1 0             *         1 1 0 0   0 0     0   0   1 0                 1
705294 ID     school 1602250 193   MOUNTAIN HOME DISTRICT 160225000266 517 PINE ELEM/JR HIGH SCHOOL   Regular School No Elementary PK 08 2021   grade_4 1 0 0   0 0     0   0   0 1             *         1 1 0 0   0 0     0   0   0 1                 1
705585 ID     school 1600139 244   MOUNTAIN VIEW SCHOOL DISTRICT 160013900933 1287 ELK CITY SCHOOL   Regular School No Elementary PK 08 2021   grade_4 1 0 0   0 0     0   0   0 1             *         1 1 0 0   0 0     0   0   0 1                 1
706394 ID     school   340   LEWISTON INDEPENDENT DISTRICT   611 NORTHWEST CHILDRENS HOME             2021   grade_4 1 0 0   0 0     0   0   1 0             *         1 1 0 0   0 0     0   0   1 0                 1
706539 ID     school 1602610 364   PLEASANT VALLEY ELEMENTARY DISTRICT 160261000459 800 PLEASANT VALLEY ELEM/JR HIGH   Regular School No Elementary PK 08 2021   grade_4 1 0 0   0 0     0   0   0 1             *         1 1 0 0   0 0     0   0   0 1                 1
706930 ID     school 1601050 413   FILER DISTRICT 160105000195 832 HOLLISTER ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2021   grade_4 1 0 4   0 0     0   0   4 1             *         5 1 0 4   0 0     0   0   4 1                 5
707693 ID     school 1600192 540   ISLAND PARK CHARTER SCHOOL, INC. 160019201125 1435 ISLAND PARK CHARTER SCHOOL   Regular School Yes Elementary KG 04 2021   grade_4 1 0 0   0 0     0   0   0 1             *         1 1 0 0   0 0     0   0   0 1                 1
850723 ID     school   150   SODA SPRINGS JOINT DISTRICT   1025 BORDER DISTRICT - FREEDOM ELEMENTARY             2020   grade_4 1 0 0   0 0     0   0   1 0             *         1 1 0 0   0 0     0   0   1 0                 1
850889 ID     school 1602520 171   OROFINO JOINT DISTRICT 160252000442 482 PECK ELEMENTARY SCHOOL   Regular School No Elementary PK 06 2020   grade_4 1 0 0   0 0     0   0   0 1             *         1 1 0 0   0 0     0   0   0 1                 1
850915 ID     school 1600720 181   CHALLIS JOINT DISTRICT 160072000143 486 STANLEY ELEM/JR HIGH SCHOOL   Regular School No Elementary KG 08 2020   grade_4 1 0 0   0 0     0   0   1 0             *         1 1 0 0   0 0     0   0   1 0                 1
850942 ID     school 1602730 191   PRAIRIE ELEMENTARY DISTRICT 160273000496 491 PRAIRIE ELEM/JR HIGH SCHOOL   Regular School No Elementary KG 08 2020   grade_4 1 0 0   0 0     0   0   0 1             *         1 1 0 0   0 0     0   0   0 1                 1
850994 ID     school 1602250 193   MOUNTAIN HOME DISTRICT 160225000266 517 PINE ELEM/JR HIGH SCHOOL   Regular School No Elementary PK 08 2020   grade_4 1 0 0   0 0     0   0   0 1             *         1 1 0 0   0 0     0   0   0 1                 1
851267 ID     school 1600139 244   MOUNTAIN VIEW SCHOOL DISTRICT 160013900933 1287 ELK CITY SCHOOL   Regular School No Elementary PK 08 2020   grade_4 1 0 0   0 0     0   0   0 1             *         1 1 0 0   0 0     0   0   0 1                 1
851802 ID     school 1603030 292   SOUTH LEMHI DISTRICT 160303000529 765 TENDOY ELEMENTARY SCHOOL   Regular School No Elementary KG 05 2020   grade_4 1 0 0   0 0     0   0   0 1             *         1 1 0 0   0 0     0   0   0 1                 1
852203 ID     school 1602610 364   PLEASANT VALLEY ELEMENTARY DISTRICT 160261000459 800 PLEASANT VALLEY ELEM/JR HIGH   Regular School No Elementary PK 08 2020   grade_4 1 0 0   0 0     0   0   0 1             *         1 1 0 0   0 0     0   0   0 1                 1
852625 ID     school 1603210 416   THREE CREEK JOINT ELEMENTARY DISTRICT 160321000546 835 THREE CREEK ELEM/JR HIGH SCHOOL   Regular School No Elementary PK 08 2020   grade_4 1 0 0   0 0     0   0   0 1             *         1 1 0 0   0 0     0   0   0 1                 1
1277313 ID     school 1601170 71   GARDEN VALLEY DISTRICT 160117000216 398 LOWMAN ELEMENTARY SCHOOL   Regular School No Elementary PK 6.0 2018   grade_4 1 0 0   0 0     0   0   1 0             *         1 1 0 0   0 0     0   0   1 0                 1
1278266 ID     school   150   SODA SPRINGS JOINT DISTRICT   1025 BORDER DISTRICT - FREEDOM ELEMENTARY             2018   grade_4 1 0 1   0 0     0   0   0 2             *         2 1 0 1   0 0     0   0   0 2                 2
1278412 ID     school 1602520 171   OROFINO JOINT DISTRICT 160252000442 482 PECK ELEMENTARY SCHOOL   Regular School No Elementary PK 6.0 2018   grade_4 1 0 0   0 1     0   0   1 1             *         2 1 0 0   0 1     0   0   1 1                 2
1278467 ID     school 1602730 191   PRAIRIE ELEMENTARY DISTRICT 160273000496 491 PRAIRIE ELEM/JR HIGH SCHOOL   Regular School No Elementary KG 8.0 2018   grade_4 1 0 0   0 0     0   0   1 0             *         1 1 0 0   0 0     0   0   1 0                 1
1278791 ID     school 1600139 244   MOUNTAIN VIEW SCHOOL DISTRICT 160013900933 1287 ELK CITY 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
1279329 ID     school 1603030 292   SOUTH LEMHI DISTRICT 160303000529 765 TENDOY ELEMENTARY SCHOOL   Regular School No Elementary KG 5.0 2018   grade_4 1 0 0   0 0     0   1   0 2             *         2 1 0 0   0 0     0   1   0 2                 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
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
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
1307526 ID     school 1601020 221   EMMETT INDEPENDENT DISTRICT 160102000190 710 OLA ELEMENTARY SCHOOL   Regular School No Elementary KG 6.0 2019   grade_4 1 0 0   0 0     0   0   0 1             *         1 1 0 0   0 0     0   0   0 1                 1
1308443 ID     school   340   LEWISTON INDEPENDENT DISTRICT   611 NORTHWEST CHILDRENS HOME             2019   grade_4 1 0 0   0 0     0   0   1 0             *         1 1 0 0   0 0     0   0   1 0                 1
1308524 ID     school 1601830 341   LAPWAI DISTRICT 160183000317 844 LAPWAI ELEMENTARY SCHOOL   Regular School No Elementary PK 5.0 2019   grade_4 1 0 1   29 0     0   1   17 15             12         32 1 0 1   29 0     0   1   17 15         12       32
1308598 ID     school 1602610 364   PLEASANT VALLEY ELEMENTARY DISTRICT 160261000459 800 PLEASANT VALLEY ELEM/JR HIGH   Regular School No Elementary PK 8.0 2019   grade_4 1 0 0   0 0     0   0   0 1             *         1 1 0 0   0 0     0   0   0 1                 1
1308795 ID     school 1600150 394   AVERY SCHOOL DISTRICT 160015001010 820 CALDER SCHOOL   Regular School No Elementary KG 8.0 2019   grade_4 1 0 0   0 0     0   0   1 0             *         1 1 0 0   0 0     0   0   1 0                 1
1682739 ID     school 1601170 71   GARDEN VALLEY DISTRICT 160117000216 398 LOWMAN ELEMENTARY SCHOOL   Regular School No 1.0 PK 06 2015   grade_4 1 0 1   0 0     0   0   2 0             *         2 1 0 1   0 0     0   0   2 0                 2
1683846 ID     school 1600720 181   CHALLIS JOINT DISTRICT 160072000142 487 PATTERSON ELEMENTARY SCHOOL   Regular School No 1.0 KG 06 2015   grade_4 1 0 1   0 0     0   0   1 1             *         2 1 0 1   0 0     0   0   1 1                 2
1684056 ID     school 1601020 221   EMMETT INDEPENDENT DISTRICT 160102000190 710 OLA ELEMENTARY SCHOOL   Regular School No 1.0 PK 06 2015   grade_4 1 0 1   0 0     0   0   1 1             *         2 1 0 1   0 0     0   0   1 1                 2
1684300 ID     school 1601590 261   JEROME JOINT DISTRICT 160159000289 297 JEROME ACADEMY   Special Education School No 4.0 01 12 2015   grade_4 1 0 0   0 0     0   0   1 0             *         1 1 0 0   0 0     0   0   1 0                 1
1684976 ID     school   340   LEWISTON INDEPENDENT DISTRICT   611 NORTHWEST CHILDRENS HOME             2015   grade_4 1 0 0   0 0     0   0   1 0             *         1 1 0 0   0 0     0   0   1 0                 1
1685127 ID     school 1602610 364   PLEASANT VALLEY ELEMENTARY DISTRICT 160261000459 800 PLEASANT VALLEY ELEM/JR HIGH   Regular School No 1.0 PK 08 2015   grade_4 1 0 0   0 0     0   0   0 1             *         1 1 0 0   0 0     0   0   0 1                 1
1686122 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_4 1 0 1   0 0     0   0   1 1             *         2 1 0 1   0 0     0   0   1 1                 2
1727817 ID     school 1600660 151   CASSIA COUNTY JOINT DISTRICT 160066001072 1377 CASSIA COUNTY DAY TREATMENT CENTER   Special Education School No Elementary KG 8.0 2017   grade_4 1 0 0   0 0     0   0   1 0             *         1 1 0 0   0 0     0   0   1 0                 1
1727894 ID     school 1600720 181   CHALLIS JOINT DISTRICT 160072000143 486 STANLEY ELEM/JR HIGH SCHOOL   Regular School No Elementary KG 8.0 2017   grade_4 1 0 0   0 0     0   0   1 0             *         1 1 0 0   0 0     0   0   1 0                 1
1728115 ID     school 1601020 221   EMMETT INDEPENDENT DISTRICT 160102000190 710 OLA ELEMENTARY SCHOOL   Regular School No Elementary PK 6.0 2017   grade_4 1 0 0   0 0     0   0   1 0             *         1 1 0 0   0 0     0   0   1 0                 1
1729194 ID     school 1602610 364   PLEASANT VALLEY ELEMENTARY DISTRICT 160261000459 800 PLEASANT VALLEY ELEM/JR HIGH   Regular School No Elementary PK 8.0 2017   grade_4 1 0 0   0 0     0   0   0 1             *         1 1 0 0   0 0     0   0   0 1                 1
1729408 ID     school 1600150 394   AVERY SCHOOL DISTRICT 160015001010 820 CALDER SCHOOL   Regular School No Other KG 12.0 2017   grade_4 1 0 0   0 0     0   0   1 0             *         1 1 0 0   0 0     0   0   1 0                 1
1729613 ID     school 1603210 416   THREE CREEK JOINT ELEMENTARY DISTRICT 160321000546 835 THREE CREEK ELEM/JR HIGH SCHOOL   Regular School No Elementary PK 8.0 2017   grade_4 1 0 0   0 0     0   0   1 0             *         1 1 0 0   0 0     0   0   1 0                 1
1823247 ID     school 1600139 244   MOUNTAIN VIEW SCHOOL DISTRICT 160013900933 1287 ELK CITY SCHOOL   Regular School No 1.0 PK 08 2016   grade_4 1 0 0   0 0     0   0   0 1             *         1 1 0 0   0 0     0   0   0 1                 1
1823772 ID     school 1603030 292   SOUTH LEMHI DISTRICT 160303000529 765 TENDOY ELEMENTARY SCHOOL   Regular School No 1.0 KG 06 2016   grade_4 1 0 0   0 0     0   0   1 0             *         1 1 0 0   0 0     0   0   1 0                 1
1824565 ID     school 1603210 416   THREE CREEK JOINT ELEMENTARY DISTRICT 160321000546 835 THREE CREEK ELEM/JR HIGH SCHOOL   Regular School No 1.0 PK 08 2016   grade_4 1 0 0   0 0     0   0   0 1             *         1 1 0 0   0 0     0   0   0 1                 1
703966 ID     school 1600300 61   BLAINE COUNTY DISTRICT 160030000034 197 CAREY PUBLIC SCHOOL   Regular School No Other PK 12 2021   grade_4 10 0 3   0 0     0   0   7 6             *         13 10 0 3   0 0     0   0   7 6                 13
706677 ID     school 1602820 382   ROCKLAND DISTRICT 160282000501 169 ROCKLAND PUBLIC SCHOOL   Regular School No Other PK 12 2021   grade_4 10 0 0   0 0     0   0   3 7             *         10 10 0 0   0 0     0   0   3 7                 10
849703 ID     school 1600300 61   BLAINE COUNTY DISTRICT 160030000034 197 CAREY PUBLIC SCHOOL   Regular School No Other PK 12 2020   grade_4 10 0 5   0 0     0   1   8 8             7         16 10 0 5   0 0     0   1   8 8         7       16
850937 ID     school 1601900 182   MACKAY JOINT DISTRICT 160190000331 490 MACKAY ELEMENTARY SCHOOL   Regular School No Elementary PK 06 2020   grade_4 10 0 0   0 0     0   0   7 3             5         10 10 0 0   0 0     0   0   7 3         5       10
851298 ID     school 1601570 251   JEFFERSON COUNTY JOINT DISTRICT 160157000278 726 ROBERTS ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2020   grade_4 10 0 6   0 0     0   0   9 7             *         16 10 0 6   0 0     0   0   9 7                 16
851889 ID     school 1602760 316   RICHFIELD DISTRICT 160276000497 144 RICHFIELD SCHOOL   Regular School No Other PK 12 2020   grade_4 10 1 4   0 0     0   0   10 5             *         15 10 1 4   0 0     0   0   10 5                 15
852364 ID     school 1601650 391   KELLOGG JOINT DISTRICT 160165000290 812 CANYON ELEMENTARY SCHOOL   Regular School No Elementary KG 05 2020   grade_4 10 0 0   0 0     0   0   4 6             *         10 10 0 0   0 0     0   0   4 6                 10
1279339 ID     school 1602400 302   NEZPERCE JOINT DISTRICT 160240000848 272 NEZPERCE SCHOOL   Regular School No Other PK 12.0 2018   grade_4 10 0 0   0 0     0   2   4 8             *         12 10 0 0   0 0     0   2   4 8                 12
1280590 ID     school 1600159 479   HERITAGE ACADEMY, INC. 160015901017 1341 HERITAGE ACADEMY   Regular School Yes Elementary PK 8.0 2018   grade_4 10 0 6   1 0     0   0   12 5             *         17 10 0 6   1 0     0   0   12 5                 17
1305738 ID     school 1601950 21   MARSH VALLEY JOINT DISTRICT 160195000344 350 DOWNEY ELEMENTARY SCHOOL   Regular School No Elementary PK 6.0 2019   grade_4 10 0 1   0 0     0   0   9 2             *         11 10 0 1   0 0     0   0   9 2                 11
1307218 ID     school 1600660 151   CASSIA COUNTY JOINT DISTRICT 160066000122 475 ALBION ELEMENTARY SCHOOL   Regular School No Elementary PK 5.0 2019   grade_4 10 0 0   0 0     0   0   5 5             *         10 10 0 0   0 0     0   0   5 5                 10
1308049 ID     school 1601740 274   KOOTENAI DISTRICT 160174000302 751 HARRISON ELEMENTARY SCHOOL   Regular School No Elementary KG 5.0 2019   grade_4 10 0 0   0 0     0   0   2 8             *         10 10 0 0   0 0     0   0   2 8                 10
1308257 ID     school 1602940 312   SHOSHONE JOINT DISTRICT 160294000512 770 SHOSHONE ELEMENTARY SCHOOL   Regular School No Elementary PK 5.0 2019   grade_4 10 0 29   0 0     1   0   19 21             *         40 10 0 29   0 0     1   0   19 21                 40
1308272 ID     school 1600900 314   DIETRICH DISTRICT 160090000165 143 DIETRICH SCHOOL   Regular School No Other PK 12.0 2019   grade_4 10 0 6   0 0     0   0   7 9             *         16 10 0 6   0 0     0   0   7 9                 16
1308759 ID     school 1601650 391   KELLOGG JOINT DISTRICT 160165000290 812 CANYON ELEMENTARY SCHOOL   Regular School No Elementary KG 5.0 2019   grade_4 10 0 0   0 0     0   0   7 3             *         10 10 0 0   0 0     0   0   7 3                 10
1309141 ID     school 1602160 433   MIDVALE DISTRICT 160216000857 286 MIDVALE SCHOOL   Regular School No Other PK 12.0 2019   grade_4 10 0 3   0 0     0   0   8 5             6         13 10 0 3   0 0     0   0   8 5         6       13
1309468 ID     school 1600159 479   HERITAGE ACADEMY, INC. 160015901017 1341 HERITAGE ACADEMY   Regular School Yes Elementary PK 8.0 2019   grade_4 10 0 6   0 0     0   1   7 10             10         17 10 0 6   0 0     0   1   7 10         10       17
1309530 ID     school 1600170 486   UPPER CARMEN PUBLIC CHARTER SCHOOL, INC. 160017000847 1366 UPPER CARMEN PUBLIC CHARTER SCHOOL   Regular School Yes Elementary PK 8.0 2019   grade_4 10 0 0   0 0     0   0   5 5             *         10 10 0 0   0 0     0   0   5 5                 10
1682834 ID     school 1600002 84   LAKE PEND OREILLE SCHOOL DISTRICT 160000200614 401 HOPE ELEMENTARY SCHOOL   Regular School No 1.0 PK 06 2015   grade_4 10 0 1   0 0     0   1   5 7             6         12 10 0 1   0 0     0   1   5 7         6       12
1684153 ID     school 1600138 243   SALMON RIVER JOINT SCHOOL DISTRICT 160013800959 1280 RIGGINS ELEMENTARY SCHOOL   Regular School No 1.0 PK 05 2015   grade_4 10 0 0   0 0     0   0   4 6             *         10 10 0 0   0 0     0   0   4 6                 10
1729372 ID     school 1601650 391   KELLOGG JOINT DISTRICT 160165000290 812 CANYON ELEMENTARY SCHOOL   Regular School No Elementary KG 5.0 2017   grade_4 10 0 0   0 0     0   0   6 4             *         10 10 0 0   0 0     0   0   6 4                 10
1729721 ID     school 1600570 432   CAMBRIDGE JOINT DISTRICT 160057000112 841 CAMBRIDGE ELEMENTARY SCHOOL   Regular School No Elementary PK 5.0 2017   grade_4 10 0 0   0 0     0   0   3 7             *         10 10 0 0   0 0     0   0   3 7                 10
1821715 ID     school 1600300 61   BLAINE COUNTY DISTRICT 160030000034 197 CAREY PUBLIC SCHOOL   Regular School No 4.0 PK 12 2016   grade_4 10 0 3   0 0     0   0   5 8             *         13 10 0 3   0 0     0   0   5 8                 13
1823204 ID     school 1600138 243   SALMON RIVER JOINT SCHOOL DISTRICT 160013800959 1280 RIGGINS ELEMENTARY SCHOOL   Regular School No 1.0 PK 05 2016   grade_4 10 0 1   0 0     0   0   5 6             *         11 10 0 1   0 0     0   0   5 6                 11
1823336 ID     school 1603400 253   WEST JEFFERSON DISTRICT 160340000273 729 HAMER ELEMENTARY SCHOOL   Regular School No 1.0 KG 04 2016   grade_4 10 0 3   0 0     0   0   6 7             *         13 10 0 3   0 0     0   0   6 7                 13
1823862 ID     school 1602760 316   RICHFIELD DISTRICT 160276000497 144 RICHFIELD SCHOOL   Regular School No 4.0 PK 12 2016   grade_4 10 0 2   0 0     0   0   6 6             *         12 10 0 2   0 0     0   0   6 6                 12
1825046 ID     school 1600170 486   UPPER CARMEN PUBLIC CHARTER SCHOOL, INC. 160017000847 1366 UPPER CARMEN PUBLIC CHARTER SCHOOL   Regular School Yes 1.0 PK 08 2016   grade_4 10 0 0   0 0     0   0   2 8             *         10 10 0 0   0 0     0   0   2 8                 10
849073 ID     school 1602100 2   JOINT SCHOOL DISTRICT NO. 2 160210000010 507 PIONEER SCHOOL OF THE ARTS   Regular School No Elementary PK 05 2020   grade_4 100 1 8   0 2     0   6   48 69             15         117 100 1 8   0 2     0   6   48 69         15       117
849202 ID     school 1602100 2   JOINT SCHOOL DISTRICT NO. 2 160210001081 1383 HILLSDALE ELEMENTARY   Regular School No Elementary PK 05 2020   grade_4 100 0 10   2 0     0   4   68 48             13         116 100 0 10   2 0     0   4   68 48         13       116
1306920 ID     school 1602130 134   MIDDLETON DISTRICT 160213000376 453 MIDDLETON MILL CREEK ELEMENTARY   Regular School No Elementary PK 5.0 2019   grade_4 100 0 6   1 0     0   3   52 58             32         110 100 0 6   1 0     0   3   52 58         32       110
1726269 ID     school 1601770 3   KUNA JOINT DISTRICT 160177000805 850 FREMONT H TEED MIDDLE SCHOOL   Regular School No Elementary 02 6.0 2017   grade_4 100 0 11   1 0     2   5   66 53             58         119 100 0 11   1 0     2   5   66 53         58       119
1821088 ID     school 1602100 2   JOINT SCHOOL DISTRICT NO. 2 160210000010 507 PIONEER SCHOOL OF THE ARTS   Regular School No 1.0 PK 05 2016   grade_4 100 3 6   0 1     0   5   45 70             20         115 100 3 6   0 1     0   5   45 70         20       115

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