Data source: Big Local News · About: Big Local

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

View and edit SQL

year

grade

  • grade_4 · 2,643
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
1683761 ID     school 1600660 151   CASSIA COUNTY JOINT DISTRICT 160066001072 1377 CASSIA COUNTY DAY TREATMENT CENTER   Special Education School No 1.0 KG 08 2015   grade_4 2 0 0   0 0     0   0   2 0             *         2 2 0 0   0 0     0   0   2 0                 2
1683811 ID     school 1602520 171   OROFINO JOINT DISTRICT 160252000442 482 PECK ELEMENTARY SCHOOL   Regular School No 1.0 PK 06 2015   grade_4 2 0 1   0 0     0   0   2 1             *         3 2 0 1   0 0     0   0   2 1                 3
1685273 ID     school 1600090 383   ARBON ELEMENTARY DISTRICT 160009000006 810 ARBON ELEMENTARY SCHOOL   Regular School No 1.0 KG 06 2015   grade_4 3 0 0   0 0     0   0   2 1             *         3 3 0 0   0 0     0   0   2 1                 3
1726820 ID     school 1600001 83   WEST BONNER COUNTY DISTRICT 160000100620 406 PRIEST LAKE ELEMENTARY SCHOOL   Regular School No Elementary PK 6.0 2017   grade_4 3 0 0   0 0     0   0   2 1             *         3 3 0 0   0 0     0   0   2 1                 3
1726928 ID     school   84   LAKE PEND OREILLE SCHOOL DISTRICT   1391 LPOSD HOME SCHOOL ACADEMY             2017   grade_4 2 0 0   0 0     0   0   2 0             *         2 2 0 0   0 0     0   0   2 0                 2
1727063 ID     school 1603120 92   SWAN VALLEY ELEMENTARY DISTRICT 160312000541 424 SWAN VALLEY ELEMENTARY SCHOOL   Regular School No Elementary PK 8.0 2017   grade_4 5 0 0   0 0     0   0   2 3             *         5 5 0 0   0 0     0   0   2 3                 5
1727806 ID     school 1600660 151   CASSIA COUNTY JOINT DISTRICT 160066000122 475 ALBION ELEMENTARY SCHOOL   Regular School No Elementary PK 5.0 2017   grade_4 5 0 0   0 0     0   0   2 3             *         5 5 0 0   0 0     0   0   2 3                 5
1727871 ID     school 1602520 171   OROFINO JOINT DISTRICT 160252000442 482 PECK ELEMENTARY SCHOOL   Regular School No Elementary PK 6.0 2017   grade_4 2 0 0   0 0     0   0   2 0             *         2 2 0 0   0 0     0   0   2 0                 2
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
1728776 ID     school 1603030 292   SOUTH LEMHI DISTRICT 160303000528 137 LEADORE SCHOOL   Regular School No Other PK 12.0 2017   grade_4 4 0 1   0 0     0   0   2 3             *         5 4 0 1   0 0     0   0   2 3                 5
1729571 ID     school 1601050 413   FILER DISTRICT 160105000195 832 HOLLISTER ELEMENTARY SCHOOL   Regular School No Elementary PK 5.0 2017   grade_4 5 0 2   0 0     0   0   2 5             *         7 5 0 2   0 0     0   0   2 5                 7
1821332 ID     school 1601950 21   MARSH VALLEY JOINT DISTRICT 160195000346 349 LAVA ELEMENTARY SCHOOL   Regular School No 1.0 PK 06 2016   grade_4 8 0 2   0 0     0   0   2 8             5         10 8 0 2   0 0     0   0   2 8         5       10
1822860 ID     school 1602520 171   OROFINO JOINT DISTRICT 160252000442 482 PECK ELEMENTARY SCHOOL   Regular School No 1.0 PK 06 2016   grade_4 5 0 0   0 0     0   0   2 3             *         5 5 0 0   0 0     0   0   2 3                 5
1823106 ID     school 1601020 221   EMMETT INDEPENDENT DISTRICT 160102000190 710 OLA ELEMENTARY SCHOOL   Regular School No 1.0 PK 06 2016   grade_4 3 0 0   0 0     0   0   2 1             *         3 3 0 0   0 0     0   0   2 1                 3
1823352 ID     school 1601590 261   JEROME JOINT DISTRICT 160159000289 297 JEROME ACADEMY   Special Education School No 4.0 01 12 2016   grade_4 2 0 0   0 0     0   0   2 0             *         2 2 0 0   0 0     0   0   2 0                 2
1824317 ID     school 1600090 383   ARBON ELEMENTARY DISTRICT 160009000006 810 ARBON ELEMENTARY SCHOOL   Regular School No 1.0 KG 06 2016   grade_4 2 0 0   0 0     0   0   2 0             *         2 2 0 0   0 0     0   0   2 0                 2
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
703553 ID     school 1601950 21   MARSH VALLEY JOINT DISTRICT 160195000346 349 LAVA ELEMENTARY SCHOOL   Regular School No Elementary PK 06 2021   grade_4 11 0 0   0 0     0   0   3 8             *         11 11 0 0   0 0     0   0   3 8                 11
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
705432 ID     school 1601020 221   EMMETT INDEPENDENT DISTRICT 160102000190 710 OLA ELEMENTARY SCHOOL   Regular School No Elementary KG 06 2021   grade_4 8 0 1   0 0     0   0   3 6             *         9 8 0 1   0 0     0   0   3 6                 9
705514 ID     school 1600330 234   BLISS JOINT DISTRICT 160033000040 714 BLISS SCHOOL   Regular School No Other PK 12 2021   grade_4 4 0 3   0 0     0   0   3 4             *         7 4 0 3   0 0     0   0   3 4                 7
705708 ID     school 1601590 261   JEROME JOINT DISTRICT 160159000289 297 JEROME ACADEMY   Special Education School No Other KG 12 2021   grade_4 3 0 0   0 0     0   0   3 0             *         3 3 0 0   0 0     0   0   3 0                 3
706140 ID     school 1603030 292   SOUTH LEMHI DISTRICT 160303000528 137 LEADORE SCHOOL   Regular School No Other PK 12 2021   grade_4 7 0 1   0 0     0   0   3 5             *         8 7 0 1   0 0     0   0   3 5                 8
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
707093 ID     school 1602160 433   MIDVALE DISTRICT 160216000857 286 MIDVALE SCHOOL   Regular School No Other PK 12 2021   grade_4 6 0 1   0 0     0   0   3 4             *         7 6 0 1   0 0     0   0   3 4                 7
707743 ID     school 1603511 596   IDAHO BUREAU OF EDUCATIONAL SERVICES FOR THE DEAF AND THE BLIND 160351100685 948 IDAHO SCHOOL FOR THE DEAF AND THE BLIND   Special Education School No Other PK 12 2021   grade_4 3 1 3   0 0     0   0   3 4             *         7 3 1 3   0 0     0   0   3 4                 7
850281 ID     school 1600540 121   CAMAS COUNTY DISTRICT 160054000110 440 CAMAS COUNTY ELEM/JR HIGH SCHOOL   Regular School No Elementary PK 08 2020   grade_4 8 0 0   0 0     0   0   3 5             *         8 8 0 0   0 0     0   0   3 5                 8
851127 ID     school 1601020 221   EMMETT INDEPENDENT DISTRICT 160102000190 710 OLA ELEMENTARY SCHOOL   Regular School No Elementary KG 06 2020   grade_4 3 0 2   0 0     0   0   3 2             *         5 3 0 2   0 0     0   0   3 2                 5
851792 ID     school 1603030 292   SOUTH LEMHI DISTRICT 160303000528 137 LEADORE SCHOOL   Regular School No Other PK 12 2020   grade_4 6 0 0   0 0     0   1   3 4             *         7 6 0 0   0 0     0   1   3 4                 7
1277805 ID     school 1600490 111   BUTTE COUNTY JOINT DISTRICT 160049000011 438 HOWE ELEMENTARY SCHOOL   Regular School No Elementary PK 5.0 2018   grade_4 8 0 1   1 0     0   0   3 7             *         10 8 0 1   1 0     0   0   3 7                 10
1278352 ID     school 1600660 151   CASSIA COUNTY JOINT DISTRICT 160066000122 475 ALBION ELEMENTARY SCHOOL   Regular School No Elementary PK 5.0 2018   grade_4 7 0 0   0 0     0   0   3 4             *         7 7 0 0   0 0     0   0   3 4                 7
1279866 ID     school 1600090 383   ARBON ELEMENTARY DISTRICT 160009000006 810 ARBON ELEMENTARY SCHOOL   Regular School No Elementary KG 6.0 2018   grade_4 4 0 0   1 0     0   0   3 2             *         5 4 0 0   1 0     0   0   3 2                 5
1280106 ID     school 1601050 413   FILER DISTRICT 160105000195 832 HOLLISTER ELEMENTARY SCHOOL   Regular School No Elementary PK 5.0 2018   grade_4 6 0 2   0 0     0   0   3 5             *         8 6 0 2   0 0     0   0   3 5                 8
1280265 ID     school 1602160 433   MIDVALE DISTRICT 160216000857 286 MIDVALE SCHOOL   Regular School No Other PK 12.0 2018   grade_4 7 0 1   0 0     0   0   3 5             *         8 7 0 1   0 0     0   0   3 5                 8
1280789 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_4 5 0 2   0 0     0   0   3 4             *         7 5 0 2   0 0     0   0   3 4                 7
1307519 ID     school 1601020 221   EMMETT INDEPENDENT DISTRICT 160102000192 707 SWEET MONTOUR ELEMENTARY SCHOOL   Regular School No Elementary KG 5.0 2019   grade_4 5 0 2   0 0     0   0   3 4             *         7 5 0 2   0 0     0   0   3 4                 7
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
1308237 ID     school 1601440 305   HIGHLAND JOINT DISTRICT 160144000849 285 HIGHLAND SCHOOL   Regular School No Other PK 12.0 2019   grade_4 8 0 2   0 0     0   1   3 8             *         11 8 0 2   0 0     0   1   3 8                 11
1308931 ID     school 1603240 411   TWIN FALLS DISTRICT 160324001105 1402 TWIN FALLS VIRTUAL SCHOOLHOUSE   Regular School No Elementary PK 8.0 2019   grade_4 6 0 0   0 0     0   0   3 3             *         6 6 0 0   0 0     0   0   3 3                 6
1308975 ID     school 1601050 413   FILER DISTRICT 160105000195 832 HOLLISTER ELEMENTARY SCHOOL   Regular School No Elementary PK 5.0 2019   grade_4 3 0 3   0 0     0   0   3 3             *         6 3 0 3   0 0     0   0   3 3                 6
1682295 ID     school 1601950 21   MARSH VALLEY JOINT DISTRICT 160195000346 349 LAVA ELEMENTARY SCHOOL   Regular School No 1.0 PK 06 2015   grade_4 11 0 0   0 0     0   0   3 8             *         11 11 0 0   0 0     0   0   3 8                 11
1682782 ID     school 1600001 83   WEST BONNER COUNTY DISTRICT 160000100620 406 PRIEST LAKE ELEMENTARY SCHOOL   Regular School No 1.0 PK 06 2015   grade_4 3 0 0   0 0     0   1   3 1             *         4 3 0 0   0 0     0   1   3 1                 4
1683021 ID     school 1603120 92   SWAN VALLEY ELEMENTARY DISTRICT 160312000541 424 SWAN VALLEY ELEMENTARY SCHOOL   Regular School No 1.0 PK 08 2015   grade_4 5 1 1   0 0     0   0   3 4             *         7 5 1 1   0 0     0   0   3 4                 7
1683750 ID     school 1600660 151   CASSIA COUNTY JOINT DISTRICT 160066000122 475 ALBION ELEMENTARY SCHOOL   Regular School No 1.0 PK 05 2015   grade_4 5 0 0   0 0     0   0   3 2             *         5 5 0 0   0 0     0   0   3 2                 5
1683837 ID     school 1600720 181   CHALLIS JOINT DISTRICT 160072000143 486 STANLEY ELEM/JR HIGH SCHOOL   Regular School No 1.0 KG 08 2015   grade_4 3 0 0   0 0     0   0   3 0             *         3 3 0 0   0 0     0   0   3 0                 3
1684574 ID     school 1601740 274   KOOTENAI DISTRICT 160174000302 751 HARRISON ELEMENTARY SCHOOL   Regular School No 1.0 KG 05 2015   grade_4 5 0 0   0 0     0   0   3 2             *         5 5 0 0   0 0     0   0   3 2                 5
1684737 ID     school 1602400 302   NEZPERCE JOINT DISTRICT 160240000848 272 NEZPERCE SCHOOL   Regular School No 4.0 PK 12 2015   grade_4 9 0 0   0 0     0   0   3 6             *         9 9 0 0   0 0     0   0   3 6                 9
1684957 ID     school 1602190 331   MINIDOKA COUNTY JOINT DISTRICT 160219001028 1263 DAY TREATMENT ELEMENTARY   Special Education School No 1.0 KG 06 2015   grade_4 2 0 0   0 0     0   1   3 0             *         3 2 0 0   0 0     0   1   3 0                 3
1685076 ID     school 1600870 342   CULDESAC JOINT DISTRICT 160087000164 795 CULDESAC SCHOOL   Regular School No 4.0 PK 12 2015   grade_4 5 0 0   0 1     0   1   3 4             *         7 5 0 0   0 1     0   1   3 4                 7
1728108 ID     school 1601020 221   EMMETT INDEPENDENT DISTRICT 160102000192 707 SWEET MONTOUR ELEMENTARY SCHOOL   Regular School No Elementary KG 6.0 2017   grade_4 5 0 1   0 0     0   0   3 3             *         6 5 0 1   0 0     0   0   3 3                 6
1728213 ID     school 1600138 243   SALMON RIVER JOINT SCHOOL DISTRICT 160013800959 1280 RIGGINS ELEMENTARY SCHOOL   Regular School No Elementary PK 5.0 2017   grade_4 6 0 0   0 0     0   0   3 3             *         6 6 0 0   0 0     0   0   3 3                 6
1729019 ID     school 1602190 331   MINIDOKA COUNTY JOINT DISTRICT 160219001028 1263 DAY TREATMENT ELEMENTARY   Special Education School No Elementary KG 6.0 2017   grade_4 2 0 1   0 0     0   0   3 0             *         3 2 0 1   0 0     0   0   3 0                 3
1729132 ID     school 1600870 342   CULDESAC JOINT DISTRICT 160087000164 795 CULDESAC SCHOOL   Regular School No Other PK 12.0 2017   grade_4 3 0 0   0 0     0   0   3 0             *         3 3 0 0   0 0     0   0   3 0                 3
1729386 ID     school 1602280 392   MULLAN DISTRICT 160228000404 815 JOHN MULLAN ELEMENTARY SCHOOL   Regular School No Elementary PK 6.0 2017   grade_4 6 0 0   0 0     0   0   3 3             *         6 6 0 0   0 0     0   0   3 3                 6
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
1729966 ID     school 1600151 472   PALOUSE PRAIRIE EDUCATIONAL ORGANIZATION, INC. 160015100994 1234 PALOUSE PRAIRIE CHARTER SCHOOL   Regular School Yes Elementary PK 8.0 2017   grade_4 7 1 1   1 0     0   0   3 7             *         10 7 1 1   1 0     0   0   3 7                 10
1730230 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 2017   grade_4 6 0 1   0 0     0   0   3 4             *         7 6 0 1   0 0     0   0   3 4                 7
1821818 ID     school 1600001 83   WEST BONNER COUNTY DISTRICT 160000100620 406 PRIEST LAKE ELEMENTARY SCHOOL   Regular School No 1.0 PK 06 2016   grade_4 4 0 0   0 0     0   0   3 1             *         4 4 0 0   0 0     0   0   3 1                 4
1822060 ID     school 1603120 92   SWAN VALLEY ELEMENTARY DISTRICT 160312000541 424 SWAN VALLEY ELEMENTARY SCHOOL   Regular School No 1.0 PK 08 2016   grade_4 6 0 0   0 0     0   0   3 3             *         6 6 0 0   0 0     0   0   3 3                 6
1822275 ID     school 1600490 111   BUTTE COUNTY JOINT DISTRICT 160049000011 438 HOWE ELEMENTARY SCHOOL   Regular School No 1.0 PK 05 2016   grade_4 4 0 0   0 0     0   0   3 1             *         4 4 0 0   0 0     0   0   3 1                 4
1822796 ID     school 1600660 151   CASSIA COUNTY JOINT DISTRICT 160066000122 475 ALBION ELEMENTARY SCHOOL   Regular School No 1.0 PK 05 2016   grade_4 4 0 0   0 0     0   0   3 1             *         4 4 0 0   0 0     0   0   3 1                 4
1822852 ID     school 1602520 171   OROFINO JOINT DISTRICT 160252000436 481 CAVENDISH-TEAKEAN ELEMENTARY SCHOOL   Regular School No 1.0 PK 06 2016   grade_4 4 0 0   0 0     0   0   3 1             *         4 4 0 0   0 0     0   0   3 1                 4
1823178 ID     school 1600330 234   BLISS JOINT DISTRICT 160033000040 714 BLISS SCHOOL   Regular School No 4.0 PK 12 2016   grade_4 3 0 5   0 0     0   0   3 5             *         8 3 0 5   0 0     0   0   3 5                 8
1824002 ID     school 1602190 331   MINIDOKA COUNTY JOINT DISTRICT 160219001028 1263 DAY TREATMENT ELEMENTARY   Special Education School No 1.0 KG 06 2016   grade_4 3 0 0   0 0     0   0   3 0             *         3 3 0 0   0 0     0   0   3 0                 3
1824113 ID     school 1600870 342   CULDESAC JOINT DISTRICT 160087000164 795 CULDESAC SCHOOL   Regular School No 4.0 PK 12 2016   grade_4 2 0 0   0 0     0   1   3 0             *         3 2 0 0   0 0     0   1   3 0                 3
1824183 ID     school 1600450 365   BRUNEAU-GRAND VIEW JOINT SCHOOL DISTRICT 160045000098 801 BRUNEAU ELEMENTARY SCHOOL   Regular School No 1.0 PK 05 2016   grade_4 5 0 3   0 0     0   0   3 5             *         8 5 0 3   0 0     0   0   3 5                 8
704325 ID     school 1603120 92   SWAN VALLEY ELEMENTARY DISTRICT 160312000541 424 SWAN VALLEY ELEMENTARY SCHOOL   Regular School No Elementary PK 08 2021   grade_4 6 0 0   0 0     0   0   4 2             *         6 6 0 0   0 0     0   0   4 2                 6
705102 ID     school 1600660 151   CASSIA COUNTY JOINT DISTRICT 160066000122 475 ALBION ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2021   grade_4 6 0 0   0 0     0   0   4 2             *         6 6 0 0   0 0     0   0   4 2                 6
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
849859 ID     school 1600002 84   LAKE PEND OREILLE SCHOOL DISTRICT 160000200614 401 HOPE ELEMENTARY SCHOOL   Regular School No Elementary PK 06 2020   grade_4 8 0 0   0 0     0   1   4 5             *         9 8 0 0   0 0     0   1   4 5                 9
852221 ID     school 1600450 365   BRUNEAU-GRAND VIEW JOINT SCHOOL DISTRICT 160045000098 801 BRUNEAU ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2020   grade_4 5 0 2   0 0     0   0   4 3             *         7 5 0 2   0 0     0   0   4 3                 7
852228 ID     school 1600450 365   BRUNEAU-GRAND VIEW JOINT SCHOOL DISTRICT 160045000099 802 GRAND VIEW ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2020   grade_4 5 0 4   0 0     0   0   4 5             *         9 5 0 4   0 0     0   0   4 5                 9
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
852696 ID     school 1600630 422   CASCADE DISTRICT 160063000120 838 CASCADE ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2020   grade_4 7 0 0   1 0     0   1   4 5             *         9 7 0 0   1 0     0   1   4 5                 9
853307 ID     school 1600172 534   GEM PREP: ONLINE LLC 160017200846 1426 GEM PREP: ONLINE SCHOOL   Regular School Yes Other PK 12 2020   grade_4 6 0 0   0 0     0   0   4 2             *         6 6 0 0   0 0     0   0   4 2                 6
1277052 ID     school 1600240 33   BEAR LAKE COUNTY DISTRICT 160024000021 371 GEORGETOWN ELEMENTARY SCHOOL   Regular School No Elementary PK 5.0 2018   grade_4 15 0 0   0 0     0   0   4 11             *         15 15 0 0   0 0     0   0   4 11                 15
1278652 ID     school 1601020 221   EMMETT INDEPENDENT DISTRICT 160102000190 710 OLA ELEMENTARY SCHOOL   Regular School No Elementary KG 6.0 2018   grade_4 6 0 0   0 0     0   0   4 2             *         6 6 0 0   0 0     0   0   4 2                 6
1278877 ID     school 1603400 253   WEST JEFFERSON DISTRICT 160340000273 729 HAMER ELEMENTARY SCHOOL   Regular School No Elementary KG 4.0 2018   grade_4 4 0 3   0 0     0   0   4 3             *         7 4 0 3   0 0     0   0   4 3                 7
1279318 ID     school 1603030 292   SOUTH LEMHI DISTRICT 160303000528 137 LEADORE SCHOOL   Regular School No Other PK 12.0 2018   grade_4 7 0 0   0 0     0   0   4 3             *         7 7 0 0   0 0     0   0   4 3                 7
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
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
1279903 ID     school 1602280 392   MULLAN DISTRICT 160228000404 815 JOHN MULLAN ELEMENTARY SCHOOL   Regular School No Elementary PK 6.0 2018   grade_4 7 0 0   0 0     0   2   4 5             *         9 7 0 0   0 0     0   2   4 5                 9
1280674 ID     school 1600166 488   SYRINGA MOUNTAIN SCHOOL, INC. 160016601066 1367 SYRINGA MOUNTAIN CHARTER SCHOOL   Regular School Yes Elementary KG 7.0 2018   grade_4 14 0 1   0 0     0   1   4 12             *         16 14 0 1   0 0     0   1   4 12                 16
1306219 ID     school 1600001 83   WEST BONNER COUNTY DISTRICT 160000100620 406 PRIEST LAKE ELEMENTARY SCHOOL   Regular School No Elementary PK 6.0 2019   grade_4 6 0 0   0 0     0   0   4 2             *         6 6 0 0   0 0     0   0   4 2                 6
1306661 ID     school 1600490 111   BUTTE COUNTY JOINT DISTRICT 160049000011 438 HOWE ELEMENTARY SCHOOL   Regular School No Elementary PK 5.0 2019   grade_4 6 0 2   0 0     0   0   4 4             *         8 6 0 2   0 0     0   0   4 4                 8
1307094 ID     school 1602430 149   NORTH GEM DISTRICT 160243000427 464 NORTH GEM ELEMENTARY   Regular School No Elementary PK 6.0 2019   grade_4 9 0 0   0 0     0   0   4 5             *         9 9 0 0   0 0     0   0   4 5                 9
1307594 ID     school 1600330 234   BLISS JOINT DISTRICT 160033000040 714 BLISS SCHOOL   Regular School No Other PK 12.0 2019   grade_4 6 0 3   0 0     0   0   4 5             *         9 6 0 3   0 0     0   0   4 5                 9
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
1308207 ID     school 1602400 302   NEZPERCE JOINT DISTRICT 160240000848 272 NEZPERCE SCHOOL   Regular School No Other PK 12.0 2019   grade_4 7 0 0   0 0     0   1   4 4             *         8 7 0 0   0 0     0   1   4 4                 8
1683866 ID     school 1601900 182   MACKAY JOINT DISTRICT 160190000331 490 MACKAY ELEMENTARY SCHOOL   Regular School No 1.0 PK 06 2015   grade_4 13 0 0   0 0     0   0   4 9             *         13 13 0 0   0 0     0   0   4 9                 13
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
1684283 ID     school 1603400 253   WEST JEFFERSON DISTRICT 160340000273 729 HAMER ELEMENTARY SCHOOL   Regular School No 1.0 KG 04 2015   grade_4 4 0 3   0 0     0   0   4 3             *         7 4 0 3   0 0     0   0   4 3                 7
1685297 ID     school 1601650 391   KELLOGG JOINT DISTRICT 160165000290 812 CANYON ELEMENTARY SCHOOL   Regular School No 1.0 KG 05 2015   grade_4 6 0 0   0 0     0   0   4 2             *         6 6 0 0   0 0     0   0   4 2                 6
1685645 ID     school 1600570 432   CAMBRIDGE JOINT DISTRICT 160057000112 841 CAMBRIDGE ELEMENTARY SCHOOL   Regular School No 1.0 PK 06 2015   grade_4 5 0 0   0 0     0   0   4 1             *         5 5 0 0   0 0     0   0   4 1                 5
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
1727269 ID     school 1600490 111   BUTTE COUNTY JOINT DISTRICT 160049000011 438 HOWE ELEMENTARY SCHOOL   Regular School No Elementary PK 5.0 2017   grade_4 4 0 1   0 0     0   0   4 1             *         5 4 0 1   0 0     0   0   4 1                 5
1727863 ID     school 1602520 171   OROFINO JOINT DISTRICT 160252000436 481 CAVENDISH-TEAKEAN ELEMENTARY SCHOOL   Regular School No Elementary PK 6.0 2017   grade_4 5 0 0   0 0     0   0   4 1             *         5 5 0 0   0 0     0   0   4 1                 5
1728343 ID     school 1603400 253   WEST JEFFERSON DISTRICT 160340000273 729 HAMER ELEMENTARY SCHOOL   Regular School No Elementary KG 4.0 2017   grade_4 7 0 1   0 0     0   1   4 5             *         9 7 0 1   0 0     0   1   4 5                 9
1729213 ID     school 1600450 365   BRUNEAU-GRAND VIEW JOINT SCHOOL DISTRICT 160045000098 801 BRUNEAU ELEMENTARY SCHOOL   Regular School No Elementary PK 5.0 2017   grade_4 5 1 3   0 0     0   0   4 5             *         9 5 1 3   0 0     0   0   4 5                 9
1729731 ID     school 1602160 433   MIDVALE DISTRICT 160216000857 286 MIDVALE SCHOOL   Regular School No Other PK 12.0 2017   grade_4 7 0 0   0 0     0   0   4 3             *         7 7 0 0   0 0     0   0   4 3                 7

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