Data source: Big Local News · About: Big Local

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

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
703875 ID     school 1600270 55   BLACKFOOT DISTRICT 160027000026 387 FORT HALL ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2021   grade_2 0 0 4   16 0     0   2   11 11             13         22 0 0 4   16 0     0   2   11 11         13       22
707477 ID     school 1600163 483   CHIEF TAHGEE ELEMENTARY ACADEMY, INC. 160016301040 1347 CHIEF TAHGEE ELEMENTARY ACADEMY   Regular School Yes Elementary KG 07 2021   grade_2 0 0 0   18 0     0   0   12 6             *         18 0 0 0   18 0     0   0   12 6                 18
853124 ID     school 1600163 483   CHIEF TAHGEE ELEMENTARY ACADEMY, INC. 160016301040 1347 CHIEF TAHGEE ELEMENTARY ACADEMY   Regular School Yes Elementary KG 07 2020   grade_2 0 0 1   15 0     0   0   6 10             *         16 0 0 1   15 0     0   0   6 10                 16
1277171 ID     school 1600270 55   BLACKFOOT DISTRICT 160027000026 387 FORT HALL ELEMENTARY SCHOOL   Regular School No Elementary PK 5.0 2018   grade_2 0 0 3   27 0     0   1   14 17             *         31 0 0 3   27 0     0   1   14 17                 31
1278372 ID     school 1600750 161   CLARK COUNTY DISTRICT 160075000145 478 LINDY ROSS ELEMENTARY SCHOOL   Regular School No Elementary PK 8.0 2018   grade_2 0 0 8   0 0     0   0   4 4             *         8 0 0 8   0 0     0   0   4 4                 8
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
1280636 ID     school 1600163 483   CHIEF TAHGEE ELEMENTARY ACADEMY, INC. 160016301040 1347 CHIEF TAHGEE ELEMENTARY ACADEMY   Regular School Yes Elementary KG 6.0 2018   grade_2 0 0 1   13 0     1   0   12 3             *         15 0 0 1   13 0     1   0   12 3                 15
1306031 ID     school 1600270 55   BLACKFOOT DISTRICT 160027000026 387 FORT HALL ELEMENTARY SCHOOL   Regular School No Elementary PK 5.0 2019   grade_2 0 0 5   13 0     0   1   9 10             *         19 0 0 5   13 0     0   1   9 10                 19
1309514 ID     school 1600163 483   CHIEF TAHGEE ELEMENTARY ACADEMY, INC. 160016301040 1347 CHIEF TAHGEE ELEMENTARY ACADEMY   Regular School Yes Elementary KG 7.0 2019   grade_2 0 0 0   9 0     0   0   5 4             *         9 0 0 0   9 0     0   0   5 4                 9
1682596 ID     school 1600270 55   BLACKFOOT DISTRICT 160027000026 387 FORT HALL ELEMENTARY SCHOOL   Regular School No 1.0 PK 05 2015   grade_2 0 0 5   13 0     0   1   13 6             *         19 0 0 5   13 0     0   1   13 6                 19
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
1683844 ID     school 1600720 181   CHALLIS JOINT DISTRICT 160072000142 487 PATTERSON ELEMENTARY SCHOOL   Regular School No 1.0 KG 06 2015   grade_2 0 0 2   0 0     0   0   0 2             *         2 0 0 2   0 0     0   0   0 2                 2
1685997 ID     school 1600163 483   CHIEF TAHGEE ELEMENTARY ACADEMY, INC. 160016301040 1347 CHIEF TAHGEE ELEMENTARY ACADEMY   Regular School Yes 1.0 KG 06 2015   grade_2 0 0 4   11 0     0   1   7 9             *         16 0 0 4   11 0     0   1   7 9                 16
1726636 ID     school 1600270 55   BLACKFOOT DISTRICT 160027000026 387 FORT HALL ELEMENTARY SCHOOL   Regular School No Elementary PK 5.0 2017   grade_2 0 0 6   17 0     0   0   9 14             18         23 0 0 6   17 0     0   0   9 14         18       23
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
1730086 ID     school 1600163 483   CHIEF TAHGEE ELEMENTARY ACADEMY, INC. 160016301040 1347 CHIEF TAHGEE ELEMENTARY ACADEMY   Regular School Yes Elementary KG 6.0 2017   grade_2 0 0 0   14 0     0   0   8 6             *         14 0 0 0   14 0     0   0   8 6                 14
1821632 ID     school 1600270 55   BLACKFOOT DISTRICT 160027000026 387 FORT HALL ELEMENTARY SCHOOL   Regular School No 1.0 PK 05 2016   grade_2 0 0 1   18 0     0   1   11 9             *         20 0 0 1   18 0     0   1   11 9                 20
1825032 ID     school 1600163 483   CHIEF TAHGEE ELEMENTARY ACADEMY, INC. 160016301040 1347 CHIEF TAHGEE ELEMENTARY ACADEMY   Regular School Yes 1.0 KG 06 2016   grade_2 0 0 3   14 0     0   1   7 11             *         18 0 0 3   14 0     0   1   7 11                 18
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
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
849623 ID     school 1600270 55   BLACKFOOT DISTRICT 160027000026 387 FORT HALL ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2020   grade_2 1 0 0   18 0     0   5   15 9             15         24 1 0 0   18 0     0   5   15 9         15       24
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
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
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
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
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
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
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
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
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
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
1307524 ID     school 1601020 221   EMMETT INDEPENDENT DISTRICT 160102000190 710 OLA ELEMENTARY SCHOOL   Regular School No Elementary KG 6.0 2019   grade_2 1 0 2   0 0     0   0   1 2             *         3 1 0 2   0 0     0   0   1 2                 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
1308973 ID     school 1601050 413   FILER DISTRICT 160105000195 832 HOLLISTER ELEMENTARY SCHOOL   Regular School No Elementary PK 5.0 2019   grade_2 1 0 4   0 0     0   0   3 2             *         5 1 0 4   0 0     0   0   3 2                 5
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
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
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
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
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
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
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
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
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
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
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
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
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
704551 ID     school 1600540 121   CAMAS COUNTY DISTRICT 160054000110 440 CAMAS COUNTY ELEM/JR HIGH SCHOOL   Regular School No Elementary PK 08 2021   grade_2 10 0 1   0 0     0   0   5 6             6         11 10 0 1   0 0     0   0   5 6         6       11
704981 ID     school 1602430 149   NORTH GEM DISTRICT 160243000427 464 NORTH GEM ELEMENTARY   Regular School No Elementary PK 06 2021   grade_2 10 0 0   0 0     0   0   5 5             5         10 10 0 0   0 0     0   0   5 5         5       10
707300 ID     school 1600143 465   NORTH VALLEY ACADEMY, INC. 160014300968 653 NORTH VALLEY ACADEMY   Regular School Yes Other KG 12 2021   grade_2 10 0 4   0 0     0   0   6 8             9         14 10 0 4   0 0     0   0   6 8         9       14
707491 ID     school 1600170 486   UPPER CARMEN PUBLIC CHARTER SCHOOL, INC. 160017000847 1366 UPPER CARMEN PUBLIC CHARTER SCHOOL   Regular School Yes Elementary KG 03 2021   grade_2 10 0 0   0 0     0   0   4 6             *         10 10 0 0   0 0     0   0   4 6                 10
850500 ID     school 1603480 133   WILDER DISTRICT 160348000585 452 WILDER ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2020   grade_2 10 0 26   0 0     0   1   26 11             *         37 10 0 26   0 0     0   1   26 11                 37
851715 ID     school 1601680 283   KENDRICK JOINT DISTRICT 160168000298 758 JULIAETTA ELEMENTARY SCHOOL   Regular School No Elementary PK 06 2020   grade_2 10 1 0   0 0     0   1   8 4             5         12 10 1 0   0 0     0   1   8 4         5       12
851839 ID     school 1601440 305   HIGHLAND JOINT DISTRICT 160144000849 285 HIGHLAND SCHOOL   Regular School No Other PK 12 2020   grade_2 10 0 1   1 0     0   0   8 4             6         12 10 0 1   1 0     0   0   8 4         6       12
851887 ID     school 1602760 316   RICHFIELD DISTRICT 160276000497 144 RICHFIELD SCHOOL   Regular School No Other PK 12 2020   grade_2 10 0 6   0 0     0   0   5 11             11         16 10 0 6   0 0     0   0   5 11         11       16
852633 ID     school 1600690 417   CASTLEFORD DISTRICT 160069000137 185 CASTLEFORD SCHOOL   Regular School No Other PK 12 2020   grade_2 10 0 7   0 0     0   0   9 8             *         17 10 0 7   0 0     0   0   9 8                 17
1277085 ID     school 1603060 41   ST MARIES JOINT DISTRICT 160306000536 374 UPRIVER ELEMENTARY SCHOOL   Regular School No Elementary KG 6.0 2018   grade_2 10 0 0   1 0     0   0   4 7             *         11 10 0 0   1 0     0   0   4 7                 11
1277407 ID     school 1600002 84   LAKE PEND OREILLE SCHOOL DISTRICT 160000200614 401 HOPE ELEMENTARY SCHOOL   Regular School No Elementary PK 6.0 2018   grade_2 10 0 0   0 0     0   1   5 6             *         11 10 0 0   0 0     0   1   5 6                 11
1279367 ID     school 1601440 305   HIGHLAND JOINT DISTRICT 160144000849 285 HIGHLAND SCHOOL   Regular School No Other PK 12.0 2018   grade_2 10 0 0   1 0     0   0   6 5             *         11 10 0 0   1 0     0   0   6 5                 11
1280104 ID     school 1601050 413   FILER DISTRICT 160105000195 832 HOLLISTER ELEMENTARY SCHOOL   Regular School No Elementary PK 5.0 2018   grade_2 10 0 2   0 0     0   0   7 5             6         12 10 0 2   0 0     0   0   7 5         6       12
1306003 ID     school 1600270 55   BLACKFOOT DISTRICT 160027000031 382 DONALD D STALKER ELEMENTARY   Regular School No Elementary PK 5.0 2019   grade_2 10 0 18   6 0     0   2   17 19             *         36 10 0 18   6 0     0   2   17 19                 36
1306109 ID     school 1600300 61   BLAINE COUNTY DISTRICT 160030000034 197 CAREY PUBLIC SCHOOL   Regular School No Other PK 12.0 2019   grade_2 10 0 3   0 0     0   0   5 8             6         13 10 0 3   0 0     0   0   5 8         6       13
1306233 ID     school 1600001 83   WEST BONNER COUNTY DISTRICT 160000100613 411 IDAHO HILL ELEMENTARY SCHOOL   Regular School No Elementary PK 6.0 2019   grade_2 10 0 1   0 0     0   0   4 7             *         11 10 0 1   0 0     0   0   4 7                 11
1308205 ID     school 1602400 302   NEZPERCE JOINT DISTRICT 160240000848 272 NEZPERCE SCHOOL   Regular School No Other PK 12.0 2019   grade_2 10 0 0   0 0     0   0   6 4             *         10 10 0 0   0 0     0   0   6 4                 10
1308929 ID     school 1603240 411   TWIN FALLS DISTRICT 160324001105 1402 TWIN FALLS VIRTUAL SCHOOLHOUSE   Regular School No Elementary PK 8.0 2019   grade_2 10 0 0   0 0     0   0   5 5             *         10 10 0 0   0 0     0   0   5 5                 10
1685883 ID     school 1600151 472   PALOUSE PRAIRIE EDUCATIONAL ORGANIZATION, INC. 160015100994 1234 PALOUSE PRAIRIE CHARTER SCHOOL   Regular School Yes 1.0 PK 08 2015   grade_2 10 0 2   0 0     0   2   5 9             6         14 10 0 2   0 0     0   2   5 9         6       14
1726795 ID     school 1601500 73   HORSESHOE BEND SCHOOL DISTRICT 160150000506 256 HORSESHOE BEND ELEMENTARY   Regular School No Elementary PK 5.0 2017   grade_2 10 0 2   0 0     0   0   6 6             *         12 10 0 2   0 0     0   0   6 6                 12
1727169 ID     school 1600930 93   BONNEVILLE JOINT DISTRICT 160093000999 1238 BONNEVILLE ONLINE ELEMENTARY   Regular School No Elementary PK 8.0 2017   grade_2 10 0 0   0 0     0   0   6 4             *         10 10 0 0   0 0     0   0   6 4                 10
1727286 ID     school 1600540 121   CAMAS COUNTY DISTRICT 160054000110 440 CAMAS COUNTY ELEM/JR HIGH SCHOOL   Regular School No Elementary PK 8.0 2017   grade_2 10 0 2   0 0     0   0   6 6             7         12 10 0 2   0 0     0   0   6 6         7       12
1730099 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_2 10 0 0   0 0     0   0   5 5             *         10 10 0 0   0 0     0   0   5 5                 10
1821296 ID     school 1602060 11   MEADOWS VALLEY DISTRICT 160206000826 342 MEADOWS VALLEY SCHOOL   Regular School No 4.0 PK 12 2016   grade_2 10 0 0   0 0     0   0   7 3             *         10 10 0 0   0 0     0   0   7 3                 10
1821793 ID     school 1601500 73   HORSESHOE BEND SCHOOL DISTRICT 160150000506 256 HORSESHOE BEND ELEMENTARY   Regular School No 1.0 PK 05 2016   grade_2 10 0 1   0 0     0   1   7 5             *         12 10 0 1   0 0     0   1   7 5                 12
1822243 ID     school 1600420 101   BOUNDARY COUNTY DISTRICT 160042000092 433 NAPLES ELEMENTARY SCHOOL   Regular School No 1.0 KG 05 2016   grade_2 10 0 1   1 0     0   1   9 4             *         13 10 0 1   1 0     0   1   9 4                 13
1823060 ID     school 1601110 215   FREMONT COUNTY JOINT DISTRICT 160111000207 703 TETON ELEMENTARY SCHOOL   Regular School No 1.0 PK 05 2016   grade_2 10 0 2   0 0     0   0   6 6             7         12 10 0 2   0 0     0   0   6 6         7       12
1825044 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_2 10 0 0   0 0     0   0   4 6             *         10 10 0 0   0 0     0   0   4 6                 10
1307853 ID     school 1600780 271   COEUR D'ALENE DISTRICT 160078000155 738 RAMSEY MAGNET SCHOOL OF SCIENCE   Regular School No Elementary PK 5.0 2019   grade_2 100 0 13   0 1     0   7   72 49             47         121 100 0 13   0 1     0   7   72 49         47       121
1821580 ID     school 1602970 52   SNAKE RIVER DISTRICT 160297000518 376 RIVERSIDE ELEMENTARY SCHOOL   Regular School No 1.0 02 03 2016   grade_2 100 1 26   2 0     0   3   71 61             67         132 100 1 26   2 0     0   3   71 61         67       132
706314 ID     school 1603090 322   SUGAR-SALEM JOINT DISTRICT 160309000537 781 CENTRAL ELEMENTARY SCHOOL   Regular School No Elementary PK 03 2021   grade_2 101 0 7   0 3     1   1   59 54             36         113 101 0 7   0 3     1   1   59 54         36       113
851966 ID     school 1603090 322   SUGAR-SALEM JOINT DISTRICT 160309000537 781 CENTRAL ELEMENTARY SCHOOL   Regular School No Elementary PK 03 2020   grade_2 101 2 5   0 0     0   0   54 54             47         108 101 2 5   0 0     0   0   54 54         47       108
1305595 ID     school 1602100 2   JOINT SCHOOL DISTRICT NO. 2 160210001060 1356 WILLOW CREEK ELEMENTARY SCHOOL   Regular School No Elementary PK 5.0 2019   grade_2 101 0 19   2 1     2   5   75 55             17         130 101 0 19   2 1     2   5   75 55         17       130
1276625 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_2 102 1 10   0 2     0   6   51 70             23         121 102 1 10   0 2     0   6   51 70         23       121
1307698 ID     school 1601570 251   JEFFERSON COUNTY JOINT DISTRICT 160157001001 1110 SOUTH FORK ELEMENTARY SCHOOL   Regular School No Elementary PK 5.0 2019   grade_2 102 0 8   0 1     0   2   52 61             42         113 102 0 8   0 1     0   2   52 61         42       113
1685223 ID     school 1601140 373   FRUITLAND DISTRICT 160114000211 807 FRUITLAND ELEMENTARY SCHOOL   Regular School No 1.0 PK 04 2015   grade_2 102 2 38   1 2     0   2   80 67             81         147 102 2 38   1 2     0   2   80 67         81       147
1726105 ID     school 1602100 2   JOINT SCHOOL DISTRICT NO. 2 160210000595 525 ELIZA HART SPALDING STEM ACADEMY   Regular School No Elementary PK 5.0 2017   grade_2 102 0 12   2 2     0   7   68 57             29         125 102 0 12   2 2     0   7   68 57         29       125
1305481 ID     school 1602100 2   JOINT SCHOOL DISTRICT NO. 2 160210000010 507 PIONEER SCHOOL OF THE ARTS   Regular School No Elementary PK 5.0 2019   grade_2 103 2 6   0 4     0   6   52 69             19         121 103 2 6   0 4     0   6   52 69         19       121
1820955 ID     school 1602100 2   JOINT SCHOOL DISTRICT NO. 2 160210000818 283 PEPPER RIDGE ELEMENTARY   Regular School No 1.0 PK 05 2016   grade_2 103 1 7   0 1     0   6   58 60             15         118 103 1 7   0 1     0   6   58 60         15       118
1727220 ID     school 1600930 93   BONNEVILLE JOINT DISTRICT 160093000971 2519 DISCOVERY ELEMENTARY SCHOOL   Regular School No Elementary PK 6.0 2017   grade_2 104 0 16   1 0     0   1   70 52             53         122 104 0 16   1 0     0   1   70 52         53       122
1821079 ID     school 1602100 2   JOINT SCHOOL DISTRICT NO. 2 160210000770 504 PONDEROSA ELEMENTARY SCHOOL   Regular School No 1.0 PK 05 2016   grade_2 104 0 7   0 0     0   6   61 56             27         117 104 0 7   0 0     0   6   61 56         27       117
1821086 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_2 104 0 6   1 1     1   4   50 67             19         117 104 0 6   1 1     1   4   50 67         19       117
1822528 ID     school 1602130 134   MIDDLETON DISTRICT 160213000376 453 MIDDLETON MILL CREEK ELEMENTARY   Regular School No 1.0 PK 05 2016   grade_2 104 1 13   0 1     0   4   64 59             54         123 104 1 13   0 1     0   4   64 59         54       123

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