Data source: Big Local News · About: Big Local

2,670 rows where grade = "grade_5" and state = "ID" sorted by white

View and edit SQL

year

grade

  • grade_5 · 2,670
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
703878 ID     school 1600270 55   BLACKFOOT DISTRICT 160027000026 387 FORT HALL ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2021   grade_5 0 0 4   19 0     0   1   10 14             16         24 0 0 4   19 0     0   1   10 14         16       24
707480 ID     school 1600163 483   CHIEF TAHGEE ELEMENTARY ACADEMY, INC. 160016301040 1347 CHIEF TAHGEE ELEMENTARY ACADEMY   Regular School Yes Elementary KG 07 2021   grade_5 0 0 0   9 0     0   0   9 0             *         9 0 0 0   9 0     0   0   9 0                 9
849626 ID     school 1600270 55   BLACKFOOT DISTRICT 160027000026 387 FORT HALL ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2020   grade_5 0 0 5   17 0     0   1   11 12             15         23 0 0 5   17 0     0   1   11 12         15       23
852149 ID     school   342   CULDESAC JOINT DISTRICT   1373 NORTHWEST CHILDREN'S HOME             2020   grade_5 0 0 0   1 0     0   0   1 0             *         1 0 0 0   1 0     0   0   1 0                 1
853127 ID     school 1600163 483   CHIEF TAHGEE ELEMENTARY ACADEMY, INC. 160016301040 1347 CHIEF TAHGEE ELEMENTARY ACADEMY   Regular School Yes Elementary KG 07 2020   grade_5 0 0 0   10 0     0   0   5 5             *         10 0 0 0   10 0     0   0   5 5                 10
1277174 ID     school 1600270 55   BLACKFOOT DISTRICT 160027000026 387 FORT HALL ELEMENTARY SCHOOL   Regular School No Elementary PK 5.0 2018   grade_5 0 0 6   13 0     0   2   14 7             *         21 0 0 6   13 0     0   2   14 7                 21
1280639 ID     school 1600163 483   CHIEF TAHGEE ELEMENTARY ACADEMY, INC. 160016301040 1347 CHIEF TAHGEE ELEMENTARY ACADEMY   Regular School Yes Elementary KG 6.0 2018   grade_5 0 0 1   8 0     0   0   5 4             *         9 0 0 1   8 0     0   0   5 4                 9
1306034 ID     school 1600270 55   BLACKFOOT DISTRICT 160027000026 387 FORT HALL ELEMENTARY SCHOOL   Regular School No Elementary PK 5.0 2019   grade_5 0 0 2   18 0     0   1   10 11             *         21 0 0 2   18 0     0   1   10 11                 21
1307393 ID     school 1602250 193   MOUNTAIN HOME DISTRICT 160225000266 517 PINE ELEM/JR HIGH SCHOOL   Regular School No Elementary PK 8.0 2019   grade_5 0 0 0   1 0     0   0   0 1             *         1 0 0 0   1 0     0   0   0 1                 1
1307766 ID     school 1601590 261   JEROME JOINT DISTRICT 160159000289 297 JEROME ACADEMY   Special Education School No Other KG 12.0 2019   grade_5 0 0 1   0 0     0   0   0 1             *         1 0 0 1   0 0     0   0   0 1                 1
1685064 ID     school   341   LAPWAI DISTRICT   1050 NORTHWEST CHILDREN'S HOME             2015   grade_5 0 0 0   1 0     0   0   1 0             *         1 0 0 0   1 0     0   0   1 0                 1
1685068 ID     school   341   LAPWAI DISTRICT   9503 NEZ PERCE TRIBE HEAD START             2015   grade_5 0 0 0   1 0     0   0   1 0             *         1 0 0 0   1 0     0   0   1 0                 1
1685192 ID     school 1602580 371   PAYETTE JOINT DISTRICT 160258001051 1318 PAYETTE ALTERNATIVE CENTER   Special Education School No 4.0 PK 12 2015   grade_5 0 0 0   1 0     0   0   1 0             *         1 0 0 0   1 0     0   0   1 0                 1
1685537 ID     school 1603210 416   THREE CREEK JOINT ELEMENTARY DISTRICT 160321000546 835 THREE CREEK ELEM/JR HIGH SCHOOL   Regular School No 1.0 PK 08 2015   grade_5 0 0 1   0 0     0   0   0 1             *         1 0 0 1   0 0     0   0   0 1                 1
1686000 ID     school 1600163 483   CHIEF TAHGEE ELEMENTARY ACADEMY, INC. 160016301040 1347 CHIEF TAHGEE ELEMENTARY ACADEMY   Regular School Yes 1.0 KG 06 2015   grade_5 0 0 0   11 0     0   0   7 4             *         11 0 0 0   11 0     0   0   7 4                 11
1726639 ID     school 1600270 55   BLACKFOOT DISTRICT 160027000026 387 FORT HALL ELEMENTARY SCHOOL   Regular School No Elementary PK 5.0 2017   grade_5 0 0 4   14 0     0   0   10 8             13         18 0 0 4   14 0     0   0   10 8         13       18
1727818 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_5 0 0 1   0 0     0   0   1 0             *         1 0 0 1   0 0     0   0   1 0                 1
1728164 ID     school 1603360 232   WENDELL DISTRICT 160336000570 712 WENDELL ELEMENTARY SCHOOL   Regular School No Elementary PK 4.0 2017   grade_5 0 0 1   0 0     0   0   1 0             *         1 0 0 1   0 0     0   0   1 0                 1
1729409 ID     school 1600150 394   AVERY SCHOOL DISTRICT 160015001010 820 CALDER SCHOOL   Regular School No Other KG 12.0 2017   grade_5 0 0 0   0 0     0   1   1 0             *         1 0 0 0   0 0     0   1   1 0                 1
1730089 ID     school 1600163 483   CHIEF TAHGEE ELEMENTARY ACADEMY, INC. 160016301040 1347 CHIEF TAHGEE ELEMENTARY ACADEMY   Regular School Yes Elementary KG 6.0 2017   grade_5 0 0 0   12 0     0   0   8 4             *         12 0 0 0   12 0     0   0   8 4                 12
1825035 ID     school 1600163 483   CHIEF TAHGEE ELEMENTARY ACADEMY, INC. 160016301040 1347 CHIEF TAHGEE ELEMENTARY ACADEMY   Regular School Yes 1.0 KG 06 2016   grade_5 0 0 2   8 0     0   2   5 7             *         12 0 0 2   8 0     0   2   5 7                 12
705011 ID     school   150   SODA SPRINGS JOINT DISTRICT   1025 BORDER DISTRICT - FREEDOM ELEMENTARY             2021   grade_5 1 0 0   0 0     0   0   1 0             *         1 1 0 0   0 0     0   0   1 0                 1
705211 ID     school 1600720 181   CHALLIS JOINT DISTRICT 160072000143 486 STANLEY ELEM/JR HIGH SCHOOL   Regular School No Elementary KG 08 2021   grade_5 1 0 0   0 0     0   0   1 0             *         1 1 0 0   0 0     0   0   1 0                 1
705295 ID     school 1602250 193   MOUNTAIN HOME DISTRICT 160225000266 517 PINE ELEM/JR HIGH SCHOOL   Regular School No Elementary PK 08 2021   grade_5 1 0 0   0 0     0   0   0 1             *         1 1 0 0   0 0     0   0   0 1                 1
705586 ID     school 1600139 244   MOUNTAIN VIEW SCHOOL DISTRICT 160013900933 1287 ELK CITY SCHOOL   Regular School No Elementary PK 08 2021   grade_5 1 0 0   0 0     0   0   0 1             *         1 1 0 0   0 0     0   0   0 1                 1
706150 ID     school 1603030 292   SOUTH LEMHI DISTRICT 160303000529 765 TENDOY ELEMENTARY SCHOOL   Regular School No Elementary KG 05 2021   grade_5 1 0 0   0 0     0   0   0 1             *         1 1 0 0   0 0     0   0   0 1                 1
706977 ID     school 1603210 416   THREE CREEK JOINT ELEMENTARY DISTRICT 160321000546 835 THREE CREEK ELEM/JR HIGH SCHOOL   Regular School No Elementary PK 08 2021   grade_5 1 0 0   0 0     0   0   0 1             *         1 1 0 0   0 0     0   0   0 1                 1
850890 ID     school 1602520 171   OROFINO JOINT DISTRICT 160252000442 482 PECK ELEMENTARY SCHOOL   Regular School No Elementary PK 06 2020   grade_5 1 0 0   0 0     0   0   1 0             *         1 1 0 0   0 0     0   0   1 0                 1
851128 ID     school 1601020 221   EMMETT INDEPENDENT DISTRICT 160102000190 710 OLA ELEMENTARY SCHOOL   Regular School No Elementary KG 06 2020   grade_5 1 0 0   0 0     0   0   0 1             *         1 1 0 0   0 0     0   0   0 1                 1
851370 ID     school 1601590 261   JEROME JOINT DISTRICT 160159000289 297 JEROME ACADEMY   Special Education School No Other KG 12 2020   grade_5 1 0 0   0 0     0   0   1 0             *         1 1 0 0   0 0     0   0   1 0                 1
852130 ID     school 1601830 341   LAPWAI DISTRICT 160183000317 844 LAPWAI ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2020   grade_5 1 0 1   31 0     0   1   17 17             13         34 1 0 1   31 0     0   1   17 17         13       34
852401 ID     school 1600150 394   AVERY SCHOOL DISTRICT 160015001010 820 CALDER SCHOOL   Regular School No Elementary KG 08 2020   grade_5 1 0 0   0 0     0   0   1 0             *         1 1 0 0   0 0     0   0   1 0                 1
1278438 ID     school 1600720 181   CHALLIS JOINT DISTRICT 160072000143 486 STANLEY ELEM/JR HIGH 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
1278653 ID     school 1601020 221   EMMETT INDEPENDENT DISTRICT 160102000190 710 OLA ELEMENTARY SCHOOL   Regular School No Elementary KG 6.0 2018   grade_5 1 0 0   0 0     0   0   1 0             *         1 1 0 0   0 0     0   0   1 0                 1
1278896 ID     school 1601590 261   JEROME JOINT DISTRICT 160159000289 297 JEROME ACADEMY   Special Education School No Other KG 12.0 2018   grade_5 1 0 1   0 0     0   0   1 1             *         2 1 0 1   0 0     0   0   1 1                 2
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
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
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
1307313 ID     school 1600720 181   CHALLIS JOINT DISTRICT 160072000143 486 STANLEY ELEM/JR HIGH SCHOOL   Regular School No Elementary KG 8.0 2019   grade_5 1 0 0   0 0     0   0   0 1             *         1 1 0 0   0 0     0   0   0 1                 1
1307663 ID     school 1600139 244   MOUNTAIN VIEW SCHOOL DISTRICT 160013900933 1287 ELK CITY SCHOOL   Regular School No Elementary PK 8.0 2019   grade_5 1 0 0   0 0     0   0   0 1             *         1 1 0 0   0 0     0   0   0 1                 1
1308444 ID     school   340   LEWISTON INDEPENDENT DISTRICT   611 NORTHWEST CHILDRENS HOME             2019   grade_5 1 0 0   0 0     0   0   1 0             *         1 1 0 0   0 0     0   0   1 0                 1
1308599 ID     school 1602610 364   PLEASANT VALLEY ELEMENTARY DISTRICT 160261000459 800 PLEASANT VALLEY ELEM/JR HIGH   Regular School No Elementary PK 8.0 2019   grade_5 1 0 0   0 0     0   0   1 0             *         1 1 0 0   0 0     0   0   1 0                 1
1309022 ID     school 1603210 416   THREE CREEK JOINT ELEMENTARY DISTRICT 160321000546 835 THREE CREEK ELEM/JR HIGH SCHOOL   Regular School No Elementary PK 8.0 2019   grade_5 1 0 0   0 0     0   0   0 1             *         1 1 0 0   0 0     0   0   0 1                 1
1309517 ID     school 1600163 483   CHIEF TAHGEE ELEMENTARY ACADEMY, INC. 160016301040 1347 CHIEF TAHGEE ELEMENTARY ACADEMY   Regular School Yes Elementary KG 7.0 2019   grade_5 1 0 2   11 0     0   0   7 7             *         14 1 0 2   11 0     0   0   7 7                 14
1682173 ID     school 1602100 2   JOINT SCHOOL DISTRICT NO. 2 160210001070 1374 VIRTUAL SCHOOL HOUSE   Regular School No 1.0 PK 08 2015   grade_5 1 0 0   0 0     0   0   1 0             *         1 1 0 0   0 0     0   0   1 0                 1
1682599 ID     school 1600270 55   BLACKFOOT DISTRICT 160027000026 387 FORT HALL ELEMENTARY SCHOOL   Regular School No 1.0 PK 05 2015   grade_5 1 0 5   21 0     0   0   11 16             *         27 1 0 5   21 0     0   0   11 16                 27
1684301 ID     school 1601590 261   JEROME JOINT DISTRICT 160159000289 297 JEROME ACADEMY   Special Education School No 4.0 01 12 2015   grade_5 1 0 0   0 0     0   0   1 0             *         1 1 0 0   0 0     0   0   1 0                 1
1684977 ID     school   340   LEWISTON INDEPENDENT DISTRICT   611 NORTHWEST CHILDRENS HOME             2015   grade_5 1 0 0   0 0     0   0   1 0             *         1 1 0 0   0 0     0   0   1 0                 1
1686123 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_5 1 0 3   0 0     0   0   1 3             *         4 1 0 3   0 0     0   0   1 3                 4
1727721 ID     school   150   SODA SPRINGS JOINT DISTRICT   1025 BORDER DISTRICT - FREEDOM ELEMENTARY             2017   grade_5 1 0 0   0 0     0   0   1 0             *         1 1 0 0   0 0     0   0   1 0                 1
1728257 ID     school 1600139 244   MOUNTAIN VIEW SCHOOL DISTRICT 160013900933 1287 ELK CITY SCHOOL   Regular School No Elementary PK 8.0 2017   grade_5 1 0 0   0 0     0   0   0 1             *         1 1 0 0   0 0     0   0   0 1                 1
1728361 ID     school 1601590 261   JEROME JOINT DISTRICT 160159000289 297 JEROME ACADEMY   Special Education School No Other 01 12.0 2017   grade_5 1 0 0   0 0     0   0   1 0             *         1 1 0 0   0 0     0   0   1 0                 1
1728788 ID     school 1603030 292   SOUTH LEMHI DISTRICT 160303000529 765 TENDOY ELEMENTARY SCHOOL   Regular School No Elementary KG 6.0 2017   grade_5 1 0 0   0 0     0   0   1 0             *         1 1 0 0   0 0     0   0   1 0                 1
1729040 ID     school   340   LEWISTON INDEPENDENT DISTRICT   611 NORTHWEST CHILDRENS HOME             2017   grade_5 1 0 0   0 0     0   1   1 1             *         2 1 0 0   0 0     0   1   1 1                 2
1729614 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_5 1 0 0   0 0     0   0   0 1             *         1 1 0 0   0 0     0   0   0 1                 1
1821635 ID     school 1600270 55   BLACKFOOT DISTRICT 160027000026 387 FORT HALL ELEMENTARY SCHOOL   Regular School No 1.0 PK 05 2016   grade_5 1 0 8   16 0     0   0   12 13             19         25 1 0 8   16 0     0   0   12 13         19       25
1822276 ID     school 1600490 111   BUTTE COUNTY JOINT DISTRICT 160049000011 438 HOWE ELEMENTARY SCHOOL   Regular School No 1.0 PK 05 2016   grade_5 1 0 2   2 0     0   0   3 2             *         5 1 0 2   2 0     0   0   3 2                 5
1822808 ID     school 1600660 151   CASSIA COUNTY JOINT DISTRICT 160066001072 1377 CASSIA COUNTY DAY TREATMENT CENTER   Special Education School No 1.0 KG 08 2016   grade_5 1 0 0   0 0     0   0   1 0             *         1 1 0 0   0 0     0   0   1 0                 1
1822894 ID     school 1600720 181   CHALLIS JOINT DISTRICT 160072000142 487 PATTERSON ELEMENTARY SCHOOL   Regular School No 1.0 KG 06 2016   grade_5 1 0 1   0 0     0   0   1 1             *         2 1 0 1   0 0     0   0   1 1                 2
1823773 ID     school 1603030 292   SOUTH LEMHI DISTRICT 160303000529 765 TENDOY ELEMENTARY SCHOOL   Regular School No 1.0 KG 06 2016   grade_5 1 0 0   0 0     0   0   1 0             *         1 1 0 0   0 0     0   0   1 0                 1
1824023 ID     school   340   LEWISTON INDEPENDENT DISTRICT   611 NORTHWEST CHILDRENS HOME             2016   grade_5 1 0 0   0 0     0   0   1 0             *         1 1 0 0   0 0     0   0   1 0                 1
1824164 ID     school 1602610 364   PLEASANT VALLEY ELEMENTARY DISTRICT 160261000459 800 PLEASANT VALLEY ELEM/JR HIGH   Regular School No 1.0 PK 08 2016   grade_5 1 0 0   0 0     0   0   0 1             *         1 1 0 0   0 0     0   0   0 1                 1
1824235 ID     school 1602580 371   PAYETTE JOINT DISTRICT 160258001051 1318 PAYETTE ALTERNATIVE CENTER   Special Education School No 4.0 PK 12 2016   grade_5 1 0 0   1 0     0   0   1 1             *         2 1 0 0   1 0     0   0   1 1                 2
704077 ID     school 1600001 83   WEST BONNER COUNTY DISTRICT 160000100620 406 PRIEST LAKE ELEMENTARY SCHOOL   Regular School No Elementary PK 06 2021   grade_5 10 0 0   0 0     0   1   5 6             *         11 10 0 0   0 0     0   1   5 6                 11
704124 ID     school 1600002 84   LAKE PEND OREILLE SCHOOL DISTRICT 160000200614 401 HOPE ELEMENTARY SCHOOL   Regular School No Elementary PK 06 2021   grade_5 10 0 0   0 0     0   1   6 5             *         11 10 0 0   0 0     0   1   6 5                 11
705198 ID     school 1602520 171   OROFINO JOINT DISTRICT 160252000983 2520 TIMBERLINE ELEMENTARY   Regular School No Elementary PK 05 2021   grade_5 10 0 0   1 0     0   0   5 6             *         11 10 0 0   1 0     0   0   5 6                 11
706711 ID     school 1601650 391   KELLOGG JOINT DISTRICT 160165000290 812 CANYON ELEMENTARY SCHOOL   Regular School No Elementary KG 05 2021   grade_5 10 0 0   0 0     0   0   3 7             *         10 10 0 0   0 0     0   0   3 7                 10
707432 ID     school 1600159 479   HERITAGE ACADEMY, INC. 160015901017 1341 HERITAGE ACADEMY   Regular School Yes Elementary PK 08 2021   grade_5 10 0 4   0 0     0   0   3 11             7         14 10 0 4   0 0     0   0   3 11         7       14
849329 ID     school 1601950 21   MARSH VALLEY JOINT DISTRICT 160195000344 350 DOWNEY ELEMENTARY SCHOOL   Regular School No Elementary PK 06 2020   grade_5 10 0 1   0 0     0   0   9 2             *         11 10 0 1   0 0     0   0   9 2                 11
849506 ID     school 1600240 33   BEAR LAKE COUNTY DISTRICT 160024000021 371 GEORGETOWN ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2020   grade_5 10 0 0   0 0     0   0   5 5             *         10 10 0 0   0 0     0   0   5 5                 10
853288 ID     school 1600186 531   FERN-WATERS PUBLIC CHARTER SCHOOL, INC. 160018601114 1423 FERN-WATERS PUBLIC CHARTER SCHOOL   Regular School Yes Middle 04 08 2020   grade_5 10 0 0   0 0     0   0   5 5             *         10 10 0 0   0 0     0   0   5 5                 10
1279890 ID     school 1601650 391   KELLOGG JOINT DISTRICT 160165000290 812 CANYON ELEMENTARY SCHOOL   Regular School No Elementary KG 5.0 2018   grade_5 10 0 0   0 0     0   0   7 3             *         10 10 0 0   0 0     0   0   7 3                 10
1280515 ID     school 1600151 472   PALOUSE PRAIRIE EDUCATIONAL ORGANIZATION, INC. 160015100994 1234 PALOUSE PRAIRIE CHARTER SCHOOL   Regular School Yes Elementary KG 8.0 2018   grade_5 10 1 1   1 1     0   1   4 11             *         15 10 1 1   1 1     0   1   4 11                 15
1280591 ID     school 1600159 479   HERITAGE ACADEMY, INC. 160015901017 1341 HERITAGE ACADEMY   Regular School Yes Elementary PK 8.0 2018   grade_5 10 0 3   0 0     0   0   6 7             *         13 10 0 3   0 0     0   0   6 7                 13
1306901 ID     school 1603480 133   WILDER DISTRICT 160348000585 452 WILDER ELEMENTARY SCHOOL   Regular School No Elementary PK 6.0 2019   grade_5 10 0 37   1 0     0   0   21 27             *         48 10 0 37   1 0     0   0   21 27                 48
1307484 ID     school 1601110 215   FREMONT COUNTY JOINT DISTRICT 160111000207 703 TETON ELEMENTARY SCHOOL   Regular School No Elementary PK 5.0 2019   grade_5 10 0 2   0 0     0   0   5 7             *         12 10 0 2   0 0     0   0   5 7                 12
1308208 ID     school 1602400 302   NEZPERCE JOINT DISTRICT 160240000848 272 NEZPERCE SCHOOL   Regular School No Other PK 12.0 2019   grade_5 10 0 0   0 0     0   2   4 8             *         12 10 0 0   0 0     0   2   4 8                 12
1682262 ID     school 1602060 11   MEADOWS VALLEY DISTRICT 160206000826 342 MEADOWS VALLEY SCHOOL   Regular School No 4.0 PK 12 2015   grade_5 10 0 0   0 0     0   1   4 7             *         11 10 0 0   0 0     0   1   4 7                 11
1682513 ID     school 1603060 41   ST MARIES JOINT DISTRICT 160306000536 374 UPRIVER ELEMENTARY SCHOOL   Regular School No 1.0 KG 06 2015   grade_5 10 0 0   0 0     0   2   8 4             7         12 10 0 0   0 0     0   2   8 4         7       12
1682533 ID     school 1600815 44   PLUMMER-WORLEY JOINT DISTRICT 160081500719 752 LAKESIDE ELEMENTARY SCHOOL   Regular School No 1.0 PK 06 2015   grade_5 10 0 0   18 0     0   6   18 16             *         34 10 0 0   18 0     0   6   18 16                 34
1683867 ID     school 1601900 182   MACKAY JOINT DISTRICT 160190000331 490 MACKAY ELEMENTARY SCHOOL   Regular School No 1.0 PK 06 2015   grade_5 10 1 1   0 0     0   0   4 8             7         12 10 1 1   0 0     0   0   4 8         7       12
1685529 ID     school 1601410 415   HANSEN DISTRICT 160141000241 834 HANSEN ELEMENTARY SCHOOL   Regular School No 1.0 PK 06 2015   grade_5 10 0 7   0 0     0   0   8 9             12         17 10 0 7   0 0     0   0   8 9         12       17
1685657 ID     school 1602160 433   MIDVALE DISTRICT 160216000857 286 MIDVALE SCHOOL   Regular School No 4.0 PK 12 2015   grade_5 10 0 0   0 0     0   0   4 6             5         10 10 0 0   0 0     0   0   4 6         5       10
1685930 ID     school 1600155 476   ANOTHER CHOICE VIRTUAL CHARTER SCHOOL, INC. 160015501008 1247 ANOTHER CHOICE VIRTUAL CHARTER   Regular School Yes 4.0 PK 12 2015   grade_5 10 0 6   0 0     0   0   7 9             10         16 10 0 6   0 0     0   0   7 9         10       16
1726200 ID     school 1602100 2   JOINT SCHOOL DISTRICT NO. 2 160210001070 1374 VIRTUAL SCHOOL HOUSE   Regular School No Elementary PK 8.0 2017   grade_5 10 0 0   0 0     0   0   3 7             *         10 10 0 0   0 0     0   0   3 7                 10
1726717 ID     school 1600300 61   BLAINE COUNTY DISTRICT 160030000034 197 CAREY PUBLIC SCHOOL   Regular School No Other PK 12.0 2017   grade_5 10 0 3   0 0     0   0   5 8             *         13 10 0 3   0 0     0   0   5 8                 13
1726749 ID     school 1600300 61   BLAINE COUNTY DISTRICT 160030000908 636 ALTURAS ELEMENTARY SCHOOL   Regular School No Elementary PK 5.0 2017   grade_5 10 0 49   0 0     0   1   31 29             39         60 10 0 49   0 0     0   1   31 29         39       60
1727698 ID     school 1602430 149   NORTH GEM DISTRICT 160243000427 464 NORTH GEM ELEMENTARY   Regular School No Elementary PK 6.0 2017   grade_5 10 0 0   0 0     0   0   4 6             *         10 10 0 0   0 0     0   0   4 6                 10
1728061 ID     school 1601110 215   FREMONT COUNTY JOINT DISTRICT 160111000204 700 PARKER-EGIN ELEMENTARY SCHOOL   Regular School No Elementary PK 5.0 2017   grade_5 10 1 1   0 0     0   0   8 4             *         12 10 1 1   0 0     0   0   8 4                 12
1728214 ID     school 1600138 243   SALMON RIVER JOINT SCHOOL DISTRICT 160013800959 1280 RIGGINS ELEMENTARY SCHOOL   Regular School No Elementary PK 5.0 2017   grade_5 10 0 1   0 0     0   0   5 6             *         11 10 0 1   0 0     0   0   5 6                 11
1730102 ID     school 1600170 486   UPPER CARMEN PUBLIC CHARTER SCHOOL, INC. 160017000847 1366 UPPER CARMEN PUBLIC CHARTER SCHOOL   Regular School Yes Elementary PK 8.0 2017   grade_5 10 0 0   0 0     0   0   2 8             *         10 10 0 0   0 0     0   0   2 8                 10
1821549 ID     school 1603060 41   ST MARIES JOINT DISTRICT 160306000536 374 UPRIVER ELEMENTARY SCHOOL   Regular School No 1.0 KG 06 2016   grade_5 10 0 0   0 0     0   1   6 5             *         11 10 0 0   0 0     0   1   6 5                 11
1823063 ID     school 1601110 215   FREMONT COUNTY JOINT DISTRICT 160111000207 703 TETON ELEMENTARY SCHOOL   Regular School No 1.0 PK 05 2016   grade_5 10 0 2   0 0     0   0   10 2             6         12 10 0 2   0 0     0   0   10 2         6       12
1823179 ID     school 1600330 234   BLISS JOINT DISTRICT 160033000040 714 BLISS SCHOOL   Regular School No 4.0 PK 12 2016   grade_5 10 0 4   0 0     0   0   6 8             *         14 10 0 4   0 0     0   0   6 8                 14
1823205 ID     school 1600138 243   SALMON RIVER JOINT SCHOOL DISTRICT 160013800959 1280 RIGGINS ELEMENTARY SCHOOL   Regular School No 1.0 PK 05 2016   grade_5 10 0 0   0 0     0   0   4 6             *         10 10 0 0   0 0     0   0   4 6                 10
707207 ID     school 1600011 457   INSPIRE ACADEMICS, INC. 160001100866 578 INSPIRE VIRTUAL CHARTER SCHOOL   Regular School Yes Other PK 12 2021   grade_5 100 0 13   1 1     0   4   66 53             47         119 100 0 13   1 1     0   4   66 53         47       119
1276628 ID     school 1602100 2   JOINT SCHOOL DISTRICT NO. 2 160210000010 507 PIONEER SCHOOL OF THE ARTS   Regular School No Elementary PK 5.0 2018   grade_5 100 1 5   0 1     0   8   45 70             23         115 100 1 5   0 1     0   8   45 70         23       115
1305585 ID     school 1602100 2   JOINT SCHOOL DISTRICT NO. 2 160210000955 1290 PARAMOUNT ELEMENTARY SCHOOL   Regular School No Elementary PK 5.0 2019   grade_5 100 3 8   0 2     0   2   61 54             16         115 100 3 8   0 2     0   2   61 54         16       115
1823287 ID     school 1601570 251   JEFFERSON COUNTY JOINT DISTRICT 160157001001 1110 SOUTH FORK ELEMENTARY SCHOOL   Regular School No 1.0 PK 05 2016   grade_5 100 0 4   0 0     0   2   57 49             29         106 100 0 4   0 0     0   2   57 49         29       106
849003 ID     school 1602100 2   JOINT SCHOOL DISTRICT NO. 2 160210000373 334 STAR ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2020   grade_5 101 0 9   0 1     0   4   59 56             21         115 101 0 9   0 1     0   4   59 56         21       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]);