Data source: Big Local News · About: Big Local

2,772 rows where grade = "grade_2" and state = "ID" sorted by female

View and edit SQL

year

grade

  • grade_2 · 2,772
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
705583 ID     school 1600139 244   MOUNTAIN VIEW SCHOOL DISTRICT 160013900933 1287 ELK CITY SCHOOL   Regular School No Elementary PK 08 2021   grade_2 3 0 0   0 0     0   0   3 0             *         3 3 0 0   0 0     0   0   3 0                 3
705727 ID     school 1601590 261   JEROME JOINT DISTRICT 160159000972 2516 SUMMIT ELEMENTARY   Regular School No Elementary 02 05 2021   grade_2 1 0 1   0 0     0   0   2 0             *         2 1 0 1   0 0     0   0   2 0                 2
706744 ID     school 1600150 394   AVERY SCHOOL DISTRICT 160015001010 820 CALDER SCHOOL   Regular School No Elementary KG 08 2021   grade_2 1 0 0   0 0     0   0   1 0             *         1 1 0 0   0 0     0   0   1 0                 1
849766 ID     school 1601170 71   GARDEN VALLEY DISTRICT 160117000216 398 LOWMAN ELEMENTARY SCHOOL   Regular School No Elementary PK 06 2020   grade_2 2 0 0   0 0     0   0   2 0             *         2 2 0 0   0 0     0   0   2 0                 2
850261 ID     school 1600490 111   BUTTE COUNTY JOINT DISTRICT 160049000011 438 HOWE ELEMENTARY SCHOOL   Regular School No Elementary KG 03 2020   grade_2 2 0 0   0 0     0   0   2 0             *         2 2 0 0   0 0     0   0   2 0                 2
851265 ID     school 1600139 244   MOUNTAIN VIEW SCHOOL DISTRICT 160013900933 1287 ELK CITY SCHOOL   Regular School No Elementary PK 08 2020   grade_2 1 0 0   0 0     0   0   1 0             *         1 1 0 0   0 0     0   0   1 0                 1
851350 ID     school 1603400 253   WEST JEFFERSON DISTRICT 160340000273 729 HAMER ELEMENTARY SCHOOL   Regular School No Elementary KG 04 2020   grade_2 2 0 0   0 0     0   1   3 0             *         3 2 0 0   0 0     0   1   3 0                 3
851367 ID     school 1601590 261   JEROME JOINT DISTRICT 160159000289 297 JEROME ACADEMY   Special Education School No Other KG 12 2020   grade_2 2 0 0   0 0     0   0   2 0             *         2 2 0 0   0 0     0   0   2 0                 2
852201 ID     school 1602610 364   PLEASANT VALLEY ELEMENTARY DISTRICT 160261000459 800 PLEASANT VALLEY ELEM/JR HIGH   Regular School No Elementary PK 08 2020   grade_2 3 0 0   0 0     0   0   3 0             *         3 3 0 0   0 0     0   0   3 0                 3
1277312 ID     school 1601170 71   GARDEN VALLEY DISTRICT 160117000216 398 LOWMAN ELEMENTARY SCHOOL   Regular School No Elementary PK 6.0 2018   grade_2 1 0 0   0 0     0   0   1 0             *         1 1 0 0   0 0     0   0   1 0                 1
1278264 ID     school   150   SODA SPRINGS JOINT DISTRICT   1025 BORDER DISTRICT - FREEDOM ELEMENTARY             2018   grade_2 1 0 0   0 0     0   0   1 0             *         1 1 0 0   0 0     0   0   1 0                 1
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
1278790 ID     school 1600139 244   MOUNTAIN VIEW SCHOOL DISTRICT 160013900933 1287 ELK CITY SCHOOL   Regular School No Elementary PK 8.0 2018   grade_2 0 0 1   0 0     0   0   1 0             *         1 0 0 1   0 0     0   0   1 0                 1
1278893 ID     school 1601590 261   JEROME JOINT DISTRICT 160159000289 297 JEROME ACADEMY   Special Education School No Other KG 12.0 2018   grade_2 1 0 0   0 0     0   0   1 0             *         1 1 0 0   0 0     0   0   1 0                 1
1279556 ID     school 1602190 331   MINIDOKA COUNTY JOINT DISTRICT 160219001028 1263 DAY TREATMENT ELEMENTARY   Special Education School No Elementary KG 6.0 2018   grade_2 1 0 1   0 0     0   0   2 0             *         2 1 0 1   0 0     0   0   2 0                 2
1307172 ID     school 1600660 151   CASSIA COUNTY JOINT DISTRICT 160066000123 468 ALMO ELEMENTARY SCHOOL   Regular School No Elementary PK 6.0 2019   grade_2 3 0 0   0 0     0   0   3 0             *         3 3 0 0   0 0     0   0   3 0                 3
1307763 ID     school 1601590 261   JEROME JOINT DISTRICT 160159000289 297 JEROME ACADEMY   Special Education School No Other KG 12.0 2019   grade_2 1 0 0   0 0     0   0   1 0             *         1 1 0 0   0 0     0   0   1 0                 1
1308441 ID     school   340   LEWISTON INDEPENDENT DISTRICT   611 NORTHWEST CHILDRENS HOME             2019   grade_2 1 0 0   0 0     0   0   1 0             *         1 1 0 0   0 0     0   0   1 0                 1
1308793 ID     school 1600150 394   AVERY SCHOOL DISTRICT 160015001010 820 CALDER SCHOOL   Regular School No Elementary KG 8.0 2019   grade_2 1 0 0   0 0     0   0   1 0             *         1 1 0 0   0 0     0   0   1 0                 1
1682172 ID     school 1602100 2   JOINT SCHOOL DISTRICT NO. 2 160210001070 1374 VIRTUAL SCHOOL HOUSE   Regular School No 1.0 PK 08 2015   grade_2 1 0 0   0 0     0   0   1 0             *         1 1 0 0   0 0     0   0   1 0                 1
1682738 ID     school 1601170 71   GARDEN VALLEY DISTRICT 160117000216 398 LOWMAN ELEMENTARY SCHOOL   Regular School No 1.0 PK 06 2015   grade_2 0 0 1   0 0     0   0   1 0             *         1 0 0 1   0 0     0   0   1 0                 1
1683809 ID     school 1602520 171   OROFINO JOINT DISTRICT 160252000442 482 PECK ELEMENTARY SCHOOL   Regular School No 1.0 PK 06 2015   grade_2 3 0 0   0 0     0   0   3 0             *         3 3 0 0   0 0     0   0   3 0                 3
1683835 ID     school 1600720 181   CHALLIS JOINT DISTRICT 160072000143 486 STANLEY ELEM/JR HIGH SCHOOL   Regular School No 1.0 KG 08 2015   grade_2 2 0 0   0 0     0   0   2 0             *         2 2 0 0   0 0     0   0   2 0                 2
1684298 ID     school 1601590 261   JEROME JOINT DISTRICT 160159000289 297 JEROME ACADEMY   Special Education School No 4.0 01 12 2015   grade_2 1 0 1   0 0     0   0   2 0             *         2 1 0 1   0 0     0   0   2 0                 2
1684955 ID     school 1602190 331   MINIDOKA COUNTY JOINT DISTRICT 160219001028 1263 DAY TREATMENT ELEMENTARY   Special Education School No 1.0 KG 06 2015   grade_2 2 0 1   0 0     0   0   3 0             *         3 2 0 1   0 0     0   0   3 0                 3
1727869 ID     school 1602520 171   OROFINO JOINT DISTRICT 160252000442 482 PECK ELEMENTARY SCHOOL   Regular School No Elementary PK 6.0 2017   grade_2 2 0 0   0 0     0   0   2 0             *         2 2 0 0   0 0     0   0   2 0                 2
1727900 ID     school 1600720 181   CHALLIS JOINT DISTRICT 160072000142 487 PATTERSON ELEMENTARY SCHOOL   Regular School No Elementary KG 6.0 2017   grade_2 1 0 0   0 0     0   0   1 0             *         1 1 0 0   0 0     0   0   1 0                 1
1728358 ID     school 1601590 261   JEROME JOINT DISTRICT 160159000289 297 JEROME ACADEMY   Special Education School No Other 01 12.0 2017   grade_2 0 0 1   0 0     0   0   1 0             *         1 0 0 1   0 0     0   0   1 0                 1
1728785 ID     school 1603030 292   SOUTH LEMHI DISTRICT 160303000529 765 TENDOY ELEMENTARY SCHOOL   Regular School No Elementary KG 6.0 2017   grade_2 3 0 0   0 0     0   0   3 0             *         3 3 0 0   0 0     0   0   3 0                 3
1729017 ID     school 1602190 331   MINIDOKA COUNTY JOINT DISTRICT 160219001028 1263 DAY TREATMENT ELEMENTARY   Special Education School No Elementary KG 6.0 2017   grade_2 2 0 0   0 0     0   0   2 0             *         2 2 0 0   0 0     0   0   2 0                 2
1729038 ID     school   340   LEWISTON INDEPENDENT DISTRICT   611 NORTHWEST CHILDRENS HOME             2017   grade_2 1 0 0   1 0     0   0   2 0             *         2 1 0 0   1 0     0   0   2 0                 2
1729611 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_2 1 0 0   0 0     0   0   1 0             *         1 1 0 0   0 0     0   0   1 0                 1
1821774 ID     school 1601170 71   GARDEN VALLEY DISTRICT 160117000216 398 LOWMAN ELEMENTARY SCHOOL   Regular School No 1.0 PK 06 2016   grade_2 1 0 0   0 0     0   0   1 0             *         1 1 0 0   0 0     0   0   1 0                 1
1822892 ID     school 1600720 181   CHALLIS JOINT DISTRICT 160072000142 487 PATTERSON ELEMENTARY SCHOOL   Regular School No 1.0 KG 06 2016   grade_2 1 0 0   0 0     0   0   1 0             *         1 1 0 0   0 0     0   0   1 0                 1
1822920 ID     school 1602730 191   PRAIRIE ELEMENTARY DISTRICT 160273000496 491 PRAIRIE ELEM/JR HIGH SCHOOL   Regular School No 1.0 KG 08 2016   grade_2 2 0 0   0 0     0   0   2 0             *         2 2 0 0   0 0     0   0   2 0                 2
1824000 ID     school 1602190 331   MINIDOKA COUNTY JOINT DISTRICT 160219001028 1263 DAY TREATMENT ELEMENTARY   Special Education School No 1.0 KG 06 2016   grade_2 1 0 2   0 0     0   0   3 0             *         3 1 0 2   0 0     0   0   3 0                 3
1824021 ID     school   340   LEWISTON INDEPENDENT DISTRICT   611 NORTHWEST CHILDRENS HOME             2016   grade_2 1 0 0   0 0     0   0   1 0             *         1 1 0 0   0 0     0   0   1 0                 1
703559 ID     school 1601950 21   MARSH VALLEY JOINT DISTRICT 160195000344 350 DOWNEY ELEMENTARY SCHOOL   Regular School No Elementary PK 06 2021   grade_2 7 0 0   0 0     0   0   6 1             *         7 7 0 0   0 0     0   0   6 1                 7
705008 ID     school   150   SODA SPRINGS JOINT DISTRICT   1025 BORDER DISTRICT - FREEDOM ELEMENTARY             2021   grade_2 2 0 0   0 0     0   0   1 1             *         2 2 0 0   0 0     0   0   1 1                 2
705430 ID     school 1601020 221   EMMETT INDEPENDENT DISTRICT 160102000190 710 OLA ELEMENTARY SCHOOL   Regular School No Elementary KG 06 2021   grade_2 3 0 0   0 0     0   0   2 1             *         3 3 0 0   0 0     0   0   2 1                 3
706498 ID     school 1602490 351   ONEIDA COUNTY DISTRICT 160249000434 797 STONE ELEMENTARY SCHOOL   Regular School No Elementary PK 03 2021   grade_2 4 0 1   0 0     0   0   4 1             *         5 4 0 1   0 0     0   0   4 1                 5
706718 ID     school 1602280 392   MULLAN DISTRICT 160228000405 172 MULLAN SCHOOLS   Regular School No Other KG 12 2021   grade_2 2 0 0   0 0     0   0   1 1             *         2 2 0 0   0 0     0   0   1 1                 2
707691 ID     school 1600192 540   ISLAND PARK CHARTER SCHOOL, INC. 160019201125 1435 ISLAND PARK CHARTER SCHOOL   Regular School Yes Elementary KG 04 2021   grade_2 2 0 0   0 0     0   0   1 1             *         2 2 0 0   0 0     0   0   1 1                 2
707741 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_2 1 2 1   0 0     0   0   3 1             *         4 1 2 1   0 0     0   0   3 1                 4
849810 ID     school 1600001 83   WEST BONNER COUNTY DISTRICT 160000100620 406 PRIEST LAKE ELEMENTARY SCHOOL   Regular School No Elementary PK 06 2020   grade_2 5 0 1   0 0     0   0   5 1             *         6 5 0 1   0 0     0   0   5 1                 6
850055 ID     school   92   SWAN VALLEY ELEMENTARY DISTRICT   1014 BORDER DISTRICT - STAR VALLEY ELEMENTARY SCHOOL             2020   grade_2 1 0 0   0 0     0   0   0 1             *         1 1 0 0   0 0     0   0   0 1                 1
850775 ID     school 1600660 151   CASSIA COUNTY JOINT DISTRICT 160066000123 468 ALMO ELEMENTARY SCHOOL   Regular School No Elementary PK 06 2020   grade_2 2 0 0   0 0     0   0   1 1             *         2 2 0 0   0 0     0   0   1 1                 2
850913 ID     school 1600720 181   CHALLIS JOINT DISTRICT 160072000143 486 STANLEY ELEM/JR HIGH SCHOOL   Regular School No Elementary KG 08 2020   grade_2 2 0 0   0 0     0   0   1 1             *         2 2 0 0   0 0     0   0   1 1                 2
851652 ID     school 1601740 274   KOOTENAI DISTRICT 160174000302 751 HARRISON ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2020   grade_2 4 0 0   0 0     0   2   5 1             *         6 4 0 0   0 0     0   2   5 1                 6
851800 ID     school 1603030 292   SOUTH LEMHI DISTRICT 160303000529 765 TENDOY ELEMENTARY SCHOOL   Regular School No Elementary KG 05 2020   grade_2 1 0 0   0 0     0   0   0 1             *         1 1 0 0   0 0     0   0   0 1                 1
852398 ID     school 1600150 394   AVERY SCHOOL DISTRICT 160015001010 820 CALDER SCHOOL   Regular School No Elementary KG 08 2020   grade_2 2 0 0   0 0     0   0   1 1             *         2 2 0 0   0 0     0   0   1 1                 2
852740 ID     school 1602160 433   MIDVALE DISTRICT 160216000857 286 MIDVALE SCHOOL   Regular School No Other PK 12 2020   grade_2 6 0 0   0 0     0   0   5 1             *         6 6 0 0   0 0     0   0   5 1                 6
1277593 ID     school 1603120 92   SWAN VALLEY ELEMENTARY DISTRICT 160312000541 424 SWAN VALLEY ELEMENTARY 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
1278402 ID     school 1602520 171   OROFINO JOINT DISTRICT 160252000436 481 CAVENDISH-TEAKEAN ELEMENTARY SCHOOL   Regular School No Elementary PK 6.0 2018   grade_2 3 0 0   0 0     0   0   2 1             *         3 3 0 0   0 0     0   0   2 1                 3
1278875 ID     school 1603400 253   WEST JEFFERSON DISTRICT 160340000273 729 HAMER ELEMENTARY SCHOOL   Regular School No Elementary KG 4.0 2018   grade_2 4 0 2   0 0     0   0   5 1             *         6 4 0 2   0 0     0   0   5 1                 6
1279665 ID     school 1600870 342   CULDESAC JOINT DISTRICT 160087000164 795 CULDESAC SCHOOL   Regular School No Other PK 12.0 2018   grade_2 7 0 0   0 0     0   0   6 1             *         7 7 0 0   0 0     0   0   6 1                 7
1279688 ID     school 1602490 351   ONEIDA COUNTY DISTRICT 160249000434 797 STONE ELEMENTARY SCHOOL   Regular School No Elementary PK 3.0 2018   grade_2 3 0 1   0 0     0   0   3 1             *         4 3 0 1   0 0     0   0   3 1                 4
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
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
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
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
1306173 ID     school 1601170 71   GARDEN VALLEY DISTRICT 160117000216 398 LOWMAN ELEMENTARY SCHOOL   Regular School No Elementary PK 6.0 2019   grade_2 1 0 0   0 0     0   0   0 1             *         1 1 0 0   0 0     0   0   0 1                 1
1306660 ID     school 1600490 111   BUTTE COUNTY JOINT DISTRICT 160049000011 438 HOWE ELEMENTARY SCHOOL   Regular School No Elementary PK 5.0 2019   grade_2 3 0 0   0 0     0   0   2 1             *         3 3 0 0   0 0     0   0   2 1                 3
1307246 ID     school 1600750 161   CLARK COUNTY DISTRICT 160075000145 478 LINDY ROSS ELEMENTARY SCHOOL   Regular School No Elementary PK 8.0 2019   grade_2 1 0 4   0 0     0   0   4 1             *         5 1 0 4   0 0     0   0   4 1                 5
1308735 ID     school 1600090 383   ARBON ELEMENTARY DISTRICT 160009000006 810 ARBON ELEMENTARY SCHOOL   Regular School No Elementary KG 6.0 2019   grade_2 3 0 1   0 0     0   0   3 1             *         4 3 0 1   0 0     0   0   3 1                 4
1309546 ID     school 1600166 488   SYRINGA MOUNTAIN SCHOOL, INC. 160016601066 1367 SYRINGA MOUNTAIN CHARTER SCHOOL   Regular School Yes Elementary KG 7.0 2019   grade_2 7 0 1   0 0     0   0   7 1             *         8 7 0 1   0 0     0   0   7 1                 8
1683223 ID     school 1600490 111   BUTTE COUNTY JOINT DISTRICT 160049000011 438 HOWE ELEMENTARY SCHOOL   Regular School No 1.0 PK 05 2015   grade_2 4 0 1   0 0     0   0   4 1             *         5 4 0 1   0 0     0   0   4 1                 5
1683710 ID     school 1600660 151   CASSIA COUNTY JOINT DISTRICT 160066000123 468 ALMO ELEMENTARY SCHOOL   Regular School No 1.0 PK 06 2015   grade_2 2 0 0   0 0     0   0   1 1             *         2 2 0 0   0 0     0   0   1 1                 2
1683802 ID     school 1602520 171   OROFINO JOINT DISTRICT 160252000436 481 CAVENDISH-TEAKEAN ELEMENTARY SCHOOL   Regular School No 1.0 PK 06 2015   grade_2 4 0 0   0 0     0   0   3 1             *         4 4 0 0   0 0     0   0   3 1                 4
1684046 ID     school 1601020 221   EMMETT INDEPENDENT DISTRICT 160102000192 707 SWEET MONTOUR ELEMENTARY SCHOOL   Regular School No 1.0 KG 06 2015   grade_2 5 0 1   0 0     0   0   5 1             *         6 5 0 1   0 0     0   0   5 1                 6
1684724 ID     school 1603030 292   SOUTH LEMHI DISTRICT 160303000529 765 TENDOY ELEMENTARY SCHOOL   Regular School No 1.0 KG 06 2015   grade_2 3 0 0   0 0     0   0   2 1             *         3 3 0 0   0 0     0   0   2 1                 3
1685074 ID     school 1600870 342   CULDESAC JOINT DISTRICT 160087000164 795 CULDESAC SCHOOL   Regular School No 4.0 PK 12 2015   grade_2 5 0 0   1 0     0   0   5 1             *         6 5 0 0   1 0     0   0   5 1                 6
1685271 ID     school 1600090 383   ARBON ELEMENTARY DISTRICT 160009000006 810 ARBON ELEMENTARY SCHOOL   Regular School No 1.0 KG 06 2015   grade_2 2 0 0   0 0     0   0   1 1             *         2 2 0 0   0 0     0   0   1 1                 2
1685339 ID     school 1600150 394   AVERY SCHOOL DISTRICT 160015001010 820 CALDER SCHOOL   Regular School No 1.0 KG 08 2015   grade_2 1 0 0   0 0     0   0   0 1             *         1 1 0 0   0 0     0   0   0 1                 1
1685534 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_2 1 0 1   0 0     0   0   1 1             *         2 1 0 1   0 0     0   0   1 1                 2
1727719 ID     school   150   SODA SPRINGS JOINT DISTRICT   1025 BORDER DISTRICT - FREEDOM ELEMENTARY             2017   grade_2 1 0 0   0 0     0   0   0 1             *         1 1 0 0   0 0     0   0   0 1                 1
1727766 ID     school 1600660 151   CASSIA COUNTY JOINT DISTRICT 160066000123 468 ALMO ELEMENTARY SCHOOL   Regular School No Elementary PK 6.0 2017   grade_2 3 0 0   0 0     0   0   2 1             *         3 3 0 0   0 0     0   0   2 1                 3
1728058 ID     school 1601110 215   FREMONT COUNTY JOINT DISTRICT 160111000204 700 PARKER-EGIN ELEMENTARY SCHOOL   Regular School No Elementary PK 5.0 2017   grade_2 5 0 0   0 0     1   0   5 1             *         6 5 0 0   0 0     1   0   5 1                 6
1728341 ID     school 1603400 253   WEST JEFFERSON DISTRICT 160340000273 729 HAMER ELEMENTARY SCHOOL   Regular School No Elementary KG 4.0 2017   grade_2 4 0 1   0 0     0   0   4 1             *         5 4 0 1   0 0     0   0   4 1                 5
1729155 ID     school 1602490 351   ONEIDA COUNTY DISTRICT 160249000434 797 STONE ELEMENTARY SCHOOL   Regular School No Elementary PK 3.0 2017   grade_2 1 0 0   0 0     0   0   0 1             *         1 1 0 0   0 0     0   0   0 1                 1
1729346 ID     school 1600090 383   ARBON ELEMENTARY DISTRICT 160009000006 810 ARBON ELEMENTARY SCHOOL   Regular School No Elementary KG 6.0 2017   grade_2 3 0 0   0 0     0   0   2 1             *         3 3 0 0   0 0     0   0   2 1                 3
1729406 ID     school 1600150 394   AVERY SCHOOL DISTRICT 160015001010 820 CALDER SCHOOL   Regular School No Other KG 12.0 2017   grade_2 1 0 0   0 0     0   0   0 1             *         1 1 0 0   0 0     0   0   0 1                 1
1821816 ID     school 1600001 83   WEST BONNER COUNTY DISTRICT 160000100620 406 PRIEST LAKE ELEMENTARY SCHOOL   Regular School No 1.0 PK 06 2016   grade_2 4 0 0   0 0     0   0   3 1             *         4 4 0 0   0 0     0   0   3 1                 4
1822516 ID     school 1603480 133   WILDER DISTRICT 160348000682 1022 COSSA - WILDER   Special Education School No 4.0 PK 12 2016   grade_2 1 0 0   0 0     0   0   0 1             *         1 1 0 0   0 0     0   0   0 1                 1
1822756 ID     school 1600660 151   CASSIA COUNTY JOINT DISTRICT 160066000123 468 ALMO ELEMENTARY SCHOOL   Regular School No 1.0 PK 06 2016   grade_2 3 0 0   0 0     0   0   2 1             *         3 3 0 0   0 0     0   0   2 1                 3
1822858 ID     school 1602520 171   OROFINO JOINT DISTRICT 160252000442 482 PECK ELEMENTARY SCHOOL   Regular School No 1.0 PK 06 2016   grade_2 2 0 0   0 1     0   1   3 1             *         4 2 0 0   0 1     0   1   3 1                 4
1822973 ID     school 1602250 193   MOUNTAIN HOME DISTRICT 160225000266 517 PINE ELEM/JR HIGH SCHOOL   Regular School No 1.0 PK 08 2016   grade_2 1 0 0   1 0     0   0   1 1             *         2 1 0 0   1 0     0   0   1 1                 2
1823096 ID     school 1601020 221   EMMETT INDEPENDENT DISTRICT 160102000192 707 SWEET MONTOUR ELEMENTARY SCHOOL   Regular School No 1.0 KG 06 2016   grade_2 6 0 0   0 0     0   0   5 1             *         6 6 0 0   0 0     0   0   5 1                 6
1823104 ID     school 1601020 221   EMMETT INDEPENDENT DISTRICT 160102000190 710 OLA ELEMENTARY SCHOOL   Regular School No 1.0 PK 06 2016   grade_2 4 0 0   0 0     0   0   3 1             *         4 4 0 0   0 0     0   0   3 1                 4
1823202 ID     school 1600138 243   SALMON RIVER JOINT SCHOOL DISTRICT 160013800959 1280 RIGGINS ELEMENTARY SCHOOL   Regular School No 1.0 PK 05 2016   grade_2 4 0 0   0 0     0   0   3 1             *         4 4 0 0   0 0     0   0   3 1                 4
1823246 ID     school 1600139 244   MOUNTAIN VIEW SCHOOL DISTRICT 160013900933 1287 ELK CITY SCHOOL   Regular School No 1.0 PK 08 2016   grade_2 1 0 0   0 0     0   0   0 1             *         1 1 0 0   0 0     0   0   0 1                 1
1824133 ID     school 1602490 351   ONEIDA COUNTY DISTRICT 160249000434 797 STONE ELEMENTARY SCHOOL   Regular School No 1.0 PK 03 2016   grade_2 4 0 0   0 0     0   0   3 1             *         4 4 0 0   0 0     0   0   3 1                 4
1824161 ID     school 1602610 364   PLEASANT VALLEY ELEMENTARY DISTRICT 160261000459 800 PLEASANT VALLEY ELEM/JR HIGH   Regular School No 1.0 PK 08 2016   grade_2 4 0 0   0 0     0   0   3 1             *         4 4 0 0   0 0     0   0   3 1                 4
1824563 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_2 2 0 0   0 0     0   0   1 1             *         2 2 0 0   0 0     0   0   1 1                 2
702881 ID     school 1600360 1   BOISE INDEPENDENT DISTRICT 160036000054 308 HAWTHORNE ELEMENTARY SCHOOL   Regular School No Elementary PK 06 2021   grade_2 12 0 6   0 3     0   2   13 10             9         23 12 0 6   0 3     0   2   13 10         9       23
704145 ID     school 1600002 84   LAKE PEND OREILLE SCHOOL DISTRICT 160000200616 405 SOUTHSIDE ELEMENTARY SCHOOL   Regular School No Elementary PK 06 2021   grade_2 15 1 1   0 0     0   4   11 10             14         21 15 1 1   0 0     0   4   11 10         14       21
704508 ID     school 1600420 101   BOUNDARY COUNTY DISTRICT 160042000092 433 NAPLES ELEMENTARY SCHOOL   Regular School No Elementary KG 05 2021   grade_2 22 0 0   0 0     1   0   13 10             10         23 22 0 0   0 0     1   0   13 10         10       23
705218 ID     school 1600720 181   CHALLIS JOINT DISTRICT 160072000139 489 CHALLIS ELEMENTARY SCHOOL   Regular School No Elementary PK 06 2021   grade_2 21 0 2   0 0     0   1   14 10             14         24 21 0 2   0 0     0   1   14 10         14       24
705233 ID     school 1601900 182   MACKAY JOINT DISTRICT 160190000331 490 MACKAY ELEMENTARY SCHOOL   Regular School No Elementary PK 06 2021   grade_2 18 0 1   0 0     0   0   9 10             *         19 18 0 1   0 0     0   0   9 10                 19
705566 ID     school 1600139 244   MOUNTAIN VIEW SCHOOL DISTRICT 160013900961 1285 CLEARWATER VALLEY ELEMENTARY   Regular School No Elementary PK 05 2021   grade_2 18 0 1   1 0     0   1   11 10             *         21 18 0 1   1 0     0   1   11 10                 21

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