Data source: Big Local News · About: Big Local

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

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
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
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
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
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
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
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
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
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
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
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
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
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
705144 ID     school 1600750 161   CLARK COUNTY DISTRICT 160075000145 478 LINDY ROSS ELEMENTARY SCHOOL   Regular School No Elementary PK 08 2021   grade_2 4 0 6   0 0     0   0   5 5             *         10 4 0 6   0 0     0   0   5 5                 10
705512 ID     school 1600330 234   BLISS JOINT DISTRICT 160033000040 714 BLISS SCHOOL   Regular School No Other PK 12 2021   grade_2 5 0 5   0 0     0   0   8 2             *         10 5 0 5   0 0     0   0   8 2                 10
705538 ID     school 1600138 243   SALMON RIVER JOINT SCHOOL DISTRICT 160013800959 1280 RIGGINS ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2021   grade_2 9 0 1   0 0     0   0   6 4             5         10 9 0 1   0 0     0   0   6 4         5       10
706928 ID     school 1601050 413   FILER DISTRICT 160105000195 832 HOLLISTER ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2021   grade_2 8 0 2   0 0     0   0   5 5             5         10 8 0 2   0 0     0   0   5 5         5       10
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
849284 ID     school 1602060 11   MEADOWS VALLEY DISTRICT 160206000826 342 MEADOWS VALLEY SCHOOL   Regular School No Other PK 12 2020   grade_2 7 0 3   0 0     0   0   7 3             *         10 7 0 3   0 0     0   0   7 3                 10
850694 ID     school 1602430 149   NORTH GEM DISTRICT 160243000427 464 NORTH GEM ELEMENTARY   Regular School No Elementary PK 06 2020   grade_2 8 0 0   0 0     2   0   7 3             *         10 8 0 0   0 0     2   0   7 3                 10
852139 ID     school 1600870 342   CULDESAC JOINT DISTRICT 160087000164 795 CULDESAC SCHOOL   Regular School No Other PK 12 2020   grade_2 6 1 0   3 0     0   0   7 3             *         10 6 1 0   3 0     0   0   7 3                 10
852226 ID     school 1600450 365   BRUNEAU-GRAND VIEW JOINT SCHOOL DISTRICT 160045000099 802 GRAND VIEW ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2020   grade_2 4 0 5   1 0     0   0   4 6             *         10 4 0 5   1 0     0   0   4 6                 10
852730 ID     school 1600570 432   CAMBRIDGE JOINT DISTRICT 160057000112 841 CAMBRIDGE ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2020   grade_2 9 0 0   0 0     0   1   8 2             *         10 9 0 0   0 0     0   1   8 2                 10
1278746 ID     school 1600138 243   SALMON RIVER JOINT SCHOOL DISTRICT 160013800959 1280 RIGGINS ELEMENTARY SCHOOL   Regular School No Elementary PK 5.0 2018   grade_2 9 0 0   0 0     0   1   6 4             *         10 9 0 0   0 0     0   1   6 4                 10
1279750 ID     school 1600450 365   BRUNEAU-GRAND VIEW JOINT SCHOOL DISTRICT 160045000099 802 GRAND VIEW ELEMENTARY SCHOOL   Regular School No Elementary PK 5.0 2018   grade_2 5 0 5   0 0     0   0   4 6             *         10 5 0 5   0 0     0   0   4 6                 10
1307618 ID     school 1600138 243   SALMON RIVER JOINT SCHOOL DISTRICT 160013800959 1280 RIGGINS ELEMENTARY SCHOOL   Regular School No Elementary PK 5.0 2019   grade_2 9 0 1   0 0     0   0   7 3             *         10 9 0 1   0 0     0   0   7 3                 10
1308184 ID     school 1603030 292   SOUTH LEMHI DISTRICT 160303000528 137 LEADORE SCHOOL   Regular School No Other PK 12.0 2019   grade_2 9 0 1   0 0     0   0   3 7             *         10 9 0 1   0 0     0   0   3 7                 10
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
1308613 ID     school 1600450 365   BRUNEAU-GRAND VIEW JOINT SCHOOL DISTRICT 160045000098 801 BRUNEAU ELEMENTARY SCHOOL   Regular School No Elementary PK 5.0 2019   grade_2 6 0 2   1 0     0   1   8 2             *         10 6 0 2   1 0     0   1   8 2                 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
1685143 ID     school 1600450 365   BRUNEAU-GRAND VIEW JOINT SCHOOL DISTRICT 160045000098 801 BRUNEAU ELEMENTARY SCHOOL   Regular School No 1.0 PK 05 2015   grade_2 7 0 3   0 0     0   0   3 7             *         10 7 0 3   0 0     0   0   3 7                 10
1685492 ID     school 1601050 413   FILER DISTRICT 160105000195 832 HOLLISTER ELEMENTARY SCHOOL   Regular School No 1.0 PK 05 2015   grade_2 6 0 2   1 0     0   1   4 6             *         10 6 0 2   1 0     0   1   4 6                 10
1686008 ID     school 1600170 486   UPPER CARMEN PUBLIC CHARTER SCHOOL, INC. 160017000847 1366 UPPER CARMEN PUBLIC CHARTER SCHOOL   Regular School Yes 1.0 PK 08 2015   grade_2 8 0 1   0 0     0   1   3 7             *         10 8 0 1   0 0     0   1   3 7                 10
1726550 ID     school 1603060 41   ST MARIES JOINT DISTRICT 160306000536 374 UPRIVER ELEMENTARY SCHOOL   Regular School No Elementary KG 6.0 2017   grade_2 7 0 0   0 0     0   3   5 5             *         10 7 0 0   0 0     0   3   5 5                 10
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
1728211 ID     school 1600138 243   SALMON RIVER JOINT SCHOOL DISTRICT 160013800959 1280 RIGGINS ELEMENTARY SCHOOL   Regular School No Elementary PK 5.0 2017   grade_2 8 0 1   0 0     0   1   6 4             5         10 8 0 1   0 0     0   1   6 4         5       10
1729130 ID     school 1600870 342   CULDESAC JOINT DISTRICT 160087000164 795 CULDESAC SCHOOL   Regular School No Other PK 12.0 2017   grade_2 9 0 1   0 0     0   0   8 2             *         10 9 0 1   0 0     0   0   8 2                 10
1729370 ID     school 1601650 391   KELLOGG JOINT DISTRICT 160165000290 812 CANYON ELEMENTARY SCHOOL   Regular School No Elementary KG 5.0 2017   grade_2 9 0 0   1 0     0   0   8 2             *         10 9 0 0   1 0     0   0   8 2                 10
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
1822175 ID     school 1600930 93   BONNEVILLE JOINT DISTRICT 160093000999 1238 BONNEVILLE ONLINE ELEMENTARY   Regular School No 1.0 PK 08 2016   grade_2 9 0 1   0 0     0   0   4 6             *         10 9 0 1   0 0     0   0   4 6                 10
1822273 ID     school 1600490 111   BUTTE COUNTY JOINT DISTRICT 160049000011 438 HOWE ELEMENTARY SCHOOL   Regular School No 1.0 PK 05 2016   grade_2 7 0 2   1 0     0   0   3 7             *         10 7 0 2   1 0     0   0   3 7                 10
1822292 ID     school 1600540 121   CAMAS COUNTY DISTRICT 160054000110 440 CAMAS COUNTY ELEM/JR HIGH SCHOOL   Regular School No 1.0 PK 08 2016   grade_2 9 0 0   0 0     1   0   3 7             *         10 9 0 0   0 0     1   0   3 7                 10
1822819 ID     school 1600750 161   CLARK COUNTY DISTRICT 160075000145 478 LINDY ROSS ELEMENTARY SCHOOL   Regular School No 1.0 PK 08 2016   grade_2 3 0 7   0 0     0   0   3 7             *         10 3 0 7   0 0     0   0   3 7                 10
1823334 ID     school 1603400 253   WEST JEFFERSON DISTRICT 160340000273 729 HAMER ELEMENTARY SCHOOL   Regular School No 1.0 KG 04 2016   grade_2 5 0 4   0 0     0   1   8 2             5         10 5 0 4   0 0     0   1   8 2         5       10
1823781 ID     school 1602400 302   NEZPERCE JOINT DISTRICT 160240000848 272 NEZPERCE SCHOOL   Regular School No 4.0 PK 12 2016   grade_2 8 0 0   0 0     0   2   3 7             *         10 8 0 0   0 0     0   2   3 7                 10
1824521 ID     school 1601050 413   FILER DISTRICT 160105000195 832 HOLLISTER ELEMENTARY SCHOOL   Regular School No 1.0 PK 05 2016   grade_2 6 0 4   0 0     0   0   2 8             *         10 6 0 4   0 0     0   0   2 8                 10
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
705760 ID     school 1600780 271   COEUR D'ALENE DISTRICT 160078000799 217 SKYWAY ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2021   grade_2 88 0 9   0 0     1   2   57 43             23         100 88 0 9   0 0     1   2   57 43         23       100
706358 ID     school 1602190 331   MINIDOKA COUNTY JOINT DISTRICT 160219000666 845 RUPERT ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2021   grade_2 53 1 43   1 0     0   2   55 45             58         100 53 1 43   1 0     0   2   55 45         58       100
706873 ID     school 1603240 411   TWIN FALLS DISTRICT 160324001076 1382 ROCK CREEK ELEMENTARY   Regular School No Elementary KG 05 2021   grade_2 76 0 16   2 3     0   3   49 51             25         100 76 0 16   2 3     0   3   49 51         25       100
848951 ID     school 1602100 2   JOINT SCHOOL DISTRICT NO. 2 160210000824 296 HUNTER ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2020   grade_2 81 2 8   0 2     1   6   55 45             16         100 81 2 8   0 2     1   6   55 45         16       100
849243 ID     school 1601770 3   KUNA JOINT DISTRICT 160177000904 595 REED ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2020   grade_2 71 2 24   1 0     0   2   52 48             47         100 71 2 24   1 0     0   2   52 48         47       100
850022 ID     school 1601530 91   IDAHO FALLS DISTRICT 160153000725 668 SUNNYSIDE ELEMENTARY SCHOOL   Regular School No Elementary PK 06 2020   grade_2 89 0 3   0 3     0   5   51 49             9         100 89 0 3   0 3     0   5   51 49         9       100
852010 ID     school 1602190 331   MINIDOKA COUNTY JOINT DISTRICT 160219000666 845 RUPERT ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2020   grade_2 33 0 65   0 0     1   1   57 43             77         100 33 0 65   0 0     1   1   57 43         77       100
1278178 ID     school 1600600 139   VALLIVUE SCHOOL DISTRICT 160060000935 892 DESERT SPRINGS ELEMENTARY SCHOOL   Regular School No Elementary PK 5.0 2018   grade_2 56 0 42   0 0     0   2   60 40             61         100 56 0 42   0 0     0   2   60 40         61       100
1305336 ID     school 1602100 2   JOINT SCHOOL DISTRICT NO. 2 160210000794 239 PEREGRINE ELEMENTARY SCHOOL   Regular School No Elementary PK 5.0 2019   grade_2 71 2 20   1 0     0   6   51 49             42         100 71 2 20   1 0     0   6   51 49         42       100
1305453 ID     school 1602100 2   JOINT SCHOOL DISTRICT NO. 2 160210000624 340 EAGLE HILLS ELEMENTARY SCHOOL   Regular School No Elementary PK 5.0 2019   grade_2 84 0 13   0 1     1   1   51 49             20         100 84 0 13   0 1     1   1   51 49         20       100
1306771 ID     school 1602340 131   NAMPA SCHOOL DISTRICT 160234000986 647 LAKE RIDGE ELEMENTARY   Regular School No Elementary PK 5.0 2019   grade_2 73 0 25   1 0     0   1   59 41             41         100 73 0 25   1 0     0   1   59 41         41       100
1306925 ID     school 1602130 134   MIDDLETON DISTRICT 160213000675 500 MIDDLETON HEIGHTS ELEMENTARY   Regular School No Elementary PK 5.0 2019   grade_2 83 1 14   0 0     0   2   47 53             44         100 83 1 14   0 0     0   2   47 53         44       100
1682994 ID     school 1601530 91   IDAHO FALLS DISTRICT 160153000725 668 SUNNYSIDE ELEMENTARY SCHOOL   Regular School No 1.0 PK 06 2015   grade_2 97 0 0   0 2     0   1   43 57             15         100 97 0 0   0 2     0   1   43 57         15       100
1822456 ID     school 1600510 132   CALDWELL DISTRICT 160051000609 289 WILSON ELEMENTARY SCHOOL   Regular School No 1.0 PK 05 2016   grade_2 44 1 51   1 0     1   2   45 55             *         100 44 1 51   1 0     1   2   45 55                 100
848979 ID     school 1602100 2   JOINT SCHOOL DISTRICT NO. 2 160210000365 331 LAKE HAZEL ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2020   grade_2 81 0 10   0 3     2   5   46 55             22         101 81 0 10   0 3     2   5   46 55         22       101
849043 ID     school 1602100 2   JOINT SCHOOL DISTRICT NO. 2 160210000624 340 EAGLE HILLS ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2020   grade_2 91 0 4   0 1     0   5   48 53             12         101 91 0 4   0 1     0   5   48 53         12       101
849146 ID     school 1602100 2   JOINT SCHOOL DISTRICT NO. 2 160210000989 899 SIENA ELEMENTARY   Regular School No Elementary PK 05 2020   grade_2 89 1 5   0 4     0   2   43 58             9         101 89 1 5   0 4     0   2   43 58         9       101
851471 ID     school 1600780 271   COEUR D'ALENE DISTRICT 160078000152 740 ATLAS ELEMENTARY SCHOOL   Regular School No Elementary KG 05 2020   grade_2 85 0 8   0 1     0   7   48 53             35         101 85 0 8   0 1     0   7   48 53         35       101
852550 ID     school 1600480 412   BUHL JOINT DISTRICT 160048000101 830 POPPLEWELL ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2020   grade_2 68 1 30   2 0     0   0   52 49             64         101 68 1 30   2 0     0   0   52 49         64       101
1277987 ID     school 1600510 132   CALDWELL DISTRICT 160051000609 289 WILSON ELEMENTARY SCHOOL   Regular School No Elementary PK 5.0 2018   grade_2 44 0 51   0 1     0   5   46 55             *         101 44 0 51   0 1     0   5   46 55                 101
1278997 ID     school 1600780 271   COEUR D'ALENE DISTRICT 160078000152 740 ATLAS ELEMENTARY SCHOOL   Regular School No Elementary PK 5.0 2018   grade_2 88 0 10   0 1     0   2   51 50             44         101 88 0 10   0 1     0   2   51 50         44       101
1280080 ID     school 1600480 412   BUHL JOINT DISTRICT 160048000101 830 POPPLEWELL ELEMENTARY SCHOOL   Regular School No Elementary PK 5.0 2018   grade_2 55 0 44   0 0     1   1   49 52             37         101 55 0 44   0 0     1   1   49 52         37       101
1305528 ID     school 1602100 2   JOINT SCHOOL DISTRICT NO. 2 160210000901 592 DESERT SAGE ELEMENTARY SCHOOL   Regular School No Elementary PK 5.0 2019   grade_2 62 9 18   0 7     2   3   44 57             *         101 62 9 18   0 7     2   3   44 57                 101
1683325 ID     school 1602340 131   NAMPA SCHOOL DISTRICT 160234000833 581 WILLOW CREEK ELEMENTARY   Regular School No 1.0 PK 05 2015   grade_2 46 1 52   0 0     0   2   52 49             72         101 46 1 52   0 0     0   2   52 49         72       101
1684367 ID     school 1600780 271   COEUR D'ALENE DISTRICT 160078000114 506 HAYDEN MEADOWS ELEMENTARY SCHOOL   Regular School No 1.0 PK 05 2015   grade_2 86 0 10   0 1     0   4   53 48             40         101 86 0 10   0 1     0   4   53 48         40       101
1684934 ID     school 1602190 331   MINIDOKA COUNTY JOINT DISTRICT 160219000666 845 RUPERT ELEMENTARY SCHOOL   Regular School No 1.0 PK 05 2015   grade_2 35 0 65   1 0     0   0   53 48             *         101 35 0 65   1 0     0   0   53 48                 101
1729533 ID     school 1603240 411   TWIN FALLS DISTRICT 160324001076 1382 ROCK CREEK ELEMENTARY   Regular School No Elementary KG 5.0 2017   grade_2 89 0 9   0 2     0   1   54 47             32         101 89 0 9   0 2     0   1   54 47         32       101
1822317 ID     school 1602340 131   NAMPA SCHOOL DISTRICT 160234000379 214 SHERMAN ELEMENTARY   Regular School No 1.0 PK 05 2016   grade_2 43 0 46   1 1     1   9   40 61             *         101 43 0 46   1 1     1   9   40 61                 101
1822331 ID     school 1602340 131   NAMPA SCHOOL DISTRICT 160234000409 444 CENTENNIAL ELEMENTARY SCHOOL   Regular School No 1.0 PK 05 2016   grade_2 58 0 39   1 1     0   2   47 54             *         101 58 0 39   1 1     0   2   47 54                 101
1823454 ID     school 1600780 271   COEUR D'ALENE DISTRICT 160078000152 740 ATLAS ELEMENTARY SCHOOL   Regular School No 1.0 PK 05 2016   grade_2 87 1 6   1 0     0   6   54 47             49         101 87 1 6   1 0     0   6   54 47         49       101
704886 ID     school 1600600 139   VALLIVUE SCHOOL DISTRICT 160060000115 460 EAST CANYON ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2021   grade_2 61 1 38   0 0     0   2   58 44             30         102 61 1 38   0 0     0   2   58 44         30       102
705640 ID     school 1601570 251   JEFFERSON COUNTY JOINT DISTRICT 160157001128 1437 COTTONWOOD ELEMENTARY   Regular School No Elementary KG 05 2021   grade_2 83 0 16   0 1     0   2   56 46             29         102 83 0 16   0 1     0   2   56 46         29       102
1276672 ID     school 1602100 2   JOINT SCHOOL DISTRICT NO. 2 160210000901 592 DESERT SAGE ELEMENTARY SCHOOL   Regular School No Elementary PK 5.0 2018   grade_2 65 6 16   0 8     0   7   51 51             43         102 65 6 16   0 8     0   7   51 51         43       102
1277011 ID     school 1602640 25   POCATELLO DISTRICT 160264000476 368 LEWIS & CLARK ELEMENTARY SCHOOL   Regular School No Elementary KG 5.0 2018   grade_2 64 1 28   1 0     0   8   50 52             83         102 64 1 28   1 0     0   8   50 52         83       102

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