Data source: Big Local News · About: Big Local

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

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
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
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
850721 ID     school   150   SODA SPRINGS JOINT DISTRICT   1025 BORDER DISTRICT - FREEDOM ELEMENTARY             2020   grade_2 6 0 0   0 0     0   0   1 5             *         6 6 0 0   0 0     0   0   1 5                 6
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
1307119 ID     school   150   SODA SPRINGS JOINT DISTRICT   1025 BORDER DISTRICT - FREEDOM ELEMENTARY             2019   grade_2 2 0 0   0 0     0   0   0 2             *         2 2 0 0   0 0     0   0   0 2                 2
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
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
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
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
703946 ID     school 1602910 60   SHELLEY JOINT DISTRICT 160291000508 391 SUNRISE ELEMENTARY SCHOOL   Regular School No Elementary KG 02 2021   grade_2 142 0 15   1 0     0   2   94 66             52         160 142 0 15   1 0     0   2   94 66         52       160
705322 ID     school 1600960 201   PRESTON JOINT DISTRICT 160096000709 499 PIONEER ELEMENTARY SCHOOL   Regular School No Elementary PK 02 2021   grade_2 136 2 16   2 2     0   1   80 79             63         159 136 2 16   2 2     0   1   80 79         63       159
706031 ID     school 1602220 281   MOSCOW DISTRICT 160222000395 755 WEST PARK ELEMENTARY SCHOOL   Regular School No Elementary KG 02 2021   grade_2 42 2 4   1 3     0   0   35 17             21         52 42 2 4   1 3     0   0   35 17         21       52
706664 ID     school 1600060 381   AMERICAN FALLS JOINT DISTRICT 160006000005 808 HILLCREST ELEMENTARY SCHOOL   Regular School No Elementary PK 02 2021   grade_2 57 0 49   2 0     0   0   55 53             78         108 57 0 49   2 0     0   0   55 53         78       108
849683 ID     school 1602910 60   SHELLEY JOINT DISTRICT 160291000508 391 SUNRISE ELEMENTARY SCHOOL   Regular School No Elementary KG 02 2020   grade_2 160 4 18   0 1     0   2   91 94             84         185 160 4 18   0 1     0   2   91 94         84       185
851021 ID     school 1600960 201   PRESTON JOINT DISTRICT 160096000709 499 PIONEER ELEMENTARY SCHOOL   Regular School No Elementary PK 02 2020   grade_2 148 0 7   2 0     0   0   82 75             74         157 148 0 7   2 0     0   0   82 75         74       157
851292 ID     school 1601570 251   JEFFERSON COUNTY JOINT DISTRICT 160157000276 725 JEFFERSON ELEMENTARY SCHOOL   Regular School No Elementary PK 02 2020   grade_2 189 1 19   1 0     0   5   93 122             67         215 189 1 19   1 0     0   5   93 122         67       215
851683 ID     school 1602220 281   MOSCOW DISTRICT 160222000395 755 WEST PARK ELEMENTARY SCHOOL   Regular School No Elementary KG 02 2020   grade_2 46 0 4   2 2     0   7   28 33             28         61 46 0 4   2 2     0   7   28 33         28       61
852318 ID     school 1600060 381   AMERICAN FALLS JOINT DISTRICT 160006000005 808 HILLCREST ELEMENTARY SCHOOL   Regular School No Elementary PK 02 2020   grade_2 51 0 57   1 0     0   1   54 56             83         110 51 0 57   1 0     0   1   54 56         83       110
1682658 ID     school 1602910 60   SHELLEY JOINT DISTRICT 160291000508 391 SUNRISE ELEMENTARY SCHOOL   Regular School No 1.0 KG 02 2015   grade_2 149 0 30   2 2     0   0   96 87             96         183 149 0 30   2 2     0   0   96 87         96       183
1683948 ID     school 1600960 201   PRESTON JOINT DISTRICT 160096000709 499 PIONEER ELEMENTARY SCHOOL   Regular School No 1.0 PK 02 2015   grade_2 135 1 21   3 1     0   1   87 75             83         162 135 1 21   3 1     0   1   87 75         83       162
1684222 ID     school 1601570 251   JEFFERSON COUNTY JOINT DISTRICT 160157000276 725 JEFFERSON ELEMENTARY SCHOOL   Regular School No 1.0 PK 02 2015   grade_2 189 0 16   1 0     0   4   121 89             83         210 189 0 16   1 0     0   4   121 89         83       210
1684603 ID     school 1602220 281   MOSCOW DISTRICT 160222000395 755 WEST PARK ELEMENTARY SCHOOL   Regular School No 1.0 KG 02 2015   grade_2 56 5 1   0 6     0   5   31 42             38         73 56 5 1   0 6     0   5   31 42         38       73
1821246 ID     school 1601770 3   KUNA JOINT DISTRICT 160177000596 345 HUBBARD ELEMENTARY SCHOOL   Regular School No 1.0 KG 02 2016   grade_2 88 1 11   0 0     0   7   61 46             61         107 88 1 11   0 0     0   7   61 46         61       107
1821694 ID     school 1602910 60   SHELLEY JOINT DISTRICT 160291000508 391 SUNRISE ELEMENTARY SCHOOL   Regular School No 1.0 KG 02 2016   grade_2 161 1 25   0 1     0   1   113 76             88         189 161 1 25   0 1     0   1   113 76         88       189
1822998 ID     school 1600960 201   PRESTON JOINT DISTRICT 160096000709 499 PIONEER ELEMENTARY SCHOOL   Regular School No 1.0 PK 02 2016   grade_2 171 0 21   3 1     0   4   107 93             96         200 171 0 21   3 1     0   4   107 93         96       200
1823273 ID     school 1601570 251   JEFFERSON COUNTY JOINT DISTRICT 160157000276 725 JEFFERSON ELEMENTARY SCHOOL   Regular School No 1.0 PK 02 2016   grade_2 204 0 18   0 1     0   1   105 119             76         224 204 0 18   0 1     0   1   105 119         76       224
1823652 ID     school 1602220 281   MOSCOW DISTRICT 160222000395 755 WEST PARK ELEMENTARY SCHOOL   Regular School No 1.0 KG 02 2016   grade_2 62 1 4   0 5     0   2   36 38             38         74 62 1 4   0 5     0   2   36 38         38       74
703814 ID     school 1602970 52   SNAKE RIVER DISTRICT 160297000518 376 RIVERSIDE ELEMENTARY SCHOOL   Regular School No Elementary 02 03 2021   grade_2 94 0 14   1 1     0   0   57 53             *         110 94 0 14   1 1     0   0   57 53                 110
705712 ID     school 1601590 261   JEROME JOINT DISTRICT 160159000272 516 HORIZON ELEMENTARY SCHOOL   Regular School No Elementary PK 03 2021   grade_2 55 0 94   0 0     0   1   78 72             80         150 55 0 94   0 0     0   1   78 72         80       150
705717 ID     school 1601590 261   JEROME JOINT DISTRICT 160159000283 731 JEFFERSON ELEMENTARY SCHOOL   Regular School No Elementary KG 03 2021   grade_2 66 0 90   0 0     0   0   76 80             *         156 66 0 90   0 0     0   0   76 80                 156
706101 ID     school 1600010 288   WHITEPINE JOINT SCHOOL DISTRICT 160001000578 771 BOVILL ELEMENTARY SCHOOL   Regular School No Elementary PK 03 2021   grade_2 17 0 0   0 0     0   2   6 13             8         19 17 0 0   0 0     0   2   6 13         8       19
706179 ID     school 1601620 304   KAMIAH JOINT DISTRICT 160162000286 768 KAMIAH ELEMENTARY SCHOOL   Regular School No Elementary KG 03 2021   grade_2 20 0 1   3 0     0   2   14 12             9         26 20 0 1   3 0     0   2   14 12         9       26
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
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
706595 ID     school 1602580 371   PAYETTE JOINT DISTRICT 160258000171 508 PAYETTE PRIMARY SCHOOL   Regular School No Elementary PK 03 2021   grade_2 64 0 28   0 0     0   3   48 47             36         95 64 0 28   0 0     0   3   48 47         36       95
706763 ID     school 1603180 401   TETON COUNTY DISTRICT 160318000754 249 DRIGGS ELEMENTARY SCHOOL   Regular School No Elementary PK 03 2021   grade_2 39 1 33   0 0     0   0   37 36             27         73 39 1 33   0 0     0   0   37 36         27       73
706768 ID     school 1603180 401   TETON COUNTY DISTRICT 160318000545 822 TETONIA ELEMENTARY SCHOOL   Regular School No Elementary KG 03 2021   grade_2 14 0 0   0 0     0   0   8 6             *         14 14 0 0   0 0     0   0   8 6                 14
706773 ID     school 1603180 401   TETON COUNTY DISTRICT 160318000547 823 VICTOR ELEMENTARY SCHOOL   Regular School No Elementary KG 03 2021   grade_2 28 0 5   0 0     0   1   15 19             *         34 28 0 5   0 0     0   1   15 19                 34
706923 ID     school 1601050 413   FILER DISTRICT 160105000193 831 FILER ELEMENTARY SCHOOL   Regular School No Elementary PK 03 2021   grade_2 82 0 14   0 0     0   0   51 45             39         96 82 0 14   0 0     0   0   51 45         39       96
707061 ID     school 1603330 431   WEISER DISTRICT 160333000567 839 PIONEER PRIMARY SCHOOL   Regular School No Elementary PK 03 2021   grade_2 65 0 30   0 0     0   2   44 53             46         97 65 0 30   0 0     0   2   44 53         46       97
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
849572 ID     school 1602970 52   SNAKE RIVER DISTRICT 160297000518 376 RIVERSIDE ELEMENTARY SCHOOL   Regular School No Elementary 02 03 2020   grade_2 109 0 19   0 0     0   2   68 62             59         130 109 0 19   0 0     0   2   68 62         59       130
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
851373 ID     school 1601590 261   JEROME JOINT DISTRICT 160159000272 516 HORIZON ELEMENTARY SCHOOL   Regular School No Elementary PK 03 2020   grade_2 72 0 72   1 0     0   1   76 70             *         146 72 0 72   1 0     0   1   76 70                 146
851378 ID     school 1601590 261   JEROME JOINT DISTRICT 160159000283 731 JEFFERSON ELEMENTARY SCHOOL   Regular School No Elementary KG 03 2020   grade_2 52 0 90   0 0     0   2   75 69             114         144 52 0 90   0 0     0   2   75 69         114       144
851753 ID     school 1600010 288   WHITEPINE JOINT SCHOOL DISTRICT 160001000578 771 BOVILL ELEMENTARY SCHOOL   Regular School No Elementary PK 03 2020   grade_2 20 0 0   0 0     0   0   11 9             8         20 20 0 0   0 0     0   0   11 9         8       20
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
852165 ID     school 1602490 351   ONEIDA COUNTY DISTRICT 160249000434 797 STONE ELEMENTARY SCHOOL   Regular School No Elementary PK 03 2020   grade_2 5 0 0   0 0     0   0   3 2             *         5 5 0 0   0 0     0   0   3 2                 5
852258 ID     school 1602580 371   PAYETTE JOINT DISTRICT 160258000171 508 PAYETTE PRIMARY SCHOOL   Regular School No Elementary PK 03 2020   grade_2 57 0 29   0 0     0   3   57 32             42         89 57 0 29   0 0     0   3   57 32         42       89
852417 ID     school 1603180 401   TETON COUNTY DISTRICT 160318000754 249 DRIGGS ELEMENTARY SCHOOL   Regular School No Elementary PK 03 2020   grade_2 46 0 26   0 0     0   0   37 35             26         72 46 0 26   0 0     0   0   37 35         26       72
852422 ID     school 1603180 401   TETON COUNTY DISTRICT 160318000545 822 TETONIA ELEMENTARY SCHOOL   Regular School No Elementary KG 03 2020   grade_2 16 0 4   0 0     0   0   10 10             10         20 16 0 4   0 0     0   0   10 10         10       20
852427 ID     school 1603180 401   TETON COUNTY DISTRICT 160318000547 823 VICTOR ELEMENTARY SCHOOL   Regular School No Elementary KG 03 2020   grade_2 34 0 7   0 0     0   1   24 18             13         42 34 0 7   0 0     0   1   24 18         13       42
852570 ID     school 1601050 413   FILER DISTRICT 160105000193 831 FILER ELEMENTARY SCHOOL   Regular School No Elementary PK 03 2020   grade_2 92 0 12   0 0     0   0   45 59             *         104 92 0 12   0 0     0   0   45 59                 104
852710 ID     school 1603330 431   WEISER DISTRICT 160333000567 839 PIONEER PRIMARY SCHOOL   Regular School No Elementary PK 03 2020   grade_2 72 0 29   0 0     0   4   54 51             59         105 72 0 29   0 0     0   4   54 51         59       105
853138 ID     school 1600170 486   UPPER CARMEN PUBLIC CHARTER SCHOOL, INC. 160017000847 1366 UPPER CARMEN PUBLIC CHARTER SCHOOL   Regular School Yes Elementary KG 03 2020   grade_2 14 0 0   0 0     0   0   9 5             9         14 14 0 0   0 0     0   0   9 5         9       14
1682168 ID     school 1602100 2   JOINT SCHOOL DISTRICT NO. 2 160210001060 1356 WILLOW CREEK ELEMENTARY SCHOOL   Regular School No 1.0 PK 03 2015   grade_2 64 1 4   0 1     2   0   34 38             19         72 64 1 4   0 1     2   0   34 38         19       72
1682209 ID     school 1601770 3   KUNA JOINT DISTRICT 160177000596 345 HUBBARD ELEMENTARY SCHOOL   Regular School No 1.0 PK 03 2015   grade_2 89 0 9   1 0     1   3   57 46             47         103 89 0 9   1 0     1   3   57 46         47       103
1682222 ID     school 1601770 3   KUNA JOINT DISTRICT 160177000913 596 INDIAN CREEK ELEMENTARY   Regular School No 1.0 PK 03 2015   grade_2 67 0 4   0 0     0   4   42 33             35         75 67 0 4   0 0     0   4   42 33         35       75
1682545 ID     school 1602970 52   SNAKE RIVER DISTRICT 160297000518 376 RIVERSIDE ELEMENTARY SCHOOL   Regular School No 1.0 02 03 2015   grade_2 105 0 24   4 0     0   1   73 61             67         134 105 0 24   4 0     0   1   73 61         67       134
1683722 ID     school 1600660 151   CASSIA COUNTY JOINT DISTRICT 160066000130 470 MOUNTAIN VIEW ELEMENTARY   Regular School No 1.0 PK 03 2015   grade_2 90 2 68   0 1     0   0   81 80             107         161 90 2 68   0 1     0   0   81 80         107       161
1683743 ID     school 1600660 151   CASSIA COUNTY JOINT DISTRICT 160066000128 474 DWORSHAK ELEMENTARY SCHOOL   Regular School No 1.0 PK 03 2015   grade_2 74 0 65   0 0     1   2   76 66             97         142 74 0 65   0 0     1   2   76 66         97       142
1684305 ID     school 1601590 261   JEROME JOINT DISTRICT 160159000272 516 HORIZON ELEMENTARY SCHOOL   Regular School No 1.0 PK 03 2015   grade_2 77 0 97   1 0     0   1   95 81             130         176 77 0 97   1 0     0   1   95 81         130       176
1684310 ID     school 1601590 261   JEROME JOINT DISTRICT 160159000283 731 JEFFERSON ELEMENTARY SCHOOL   Regular School No 1.0 KG 03 2015   grade_2 47 1 75   0 0     0   3   55 71             *         126 47 1 75   0 0     0   3   55 71                 126
1684673 ID     school 1600010 288   WHITEPINE JOINT SCHOOL DISTRICT 160001000578 771 BOVILL ELEMENTARY SCHOOL   Regular School No 1.0 PK 03 2015   grade_2 11 1 1   0 0     0   0   10 3             *         13 11 1 1   0 0     0   0   10 3                 13
1684891 ID     school 1603090 322   SUGAR-SALEM JOINT DISTRICT 160309000537 781 CENTRAL ELEMENTARY SCHOOL   Regular School No 1.0 PK 03 2015   grade_2 118 0 10   0 0     0   2   65 65             68         130 118 0 10   0 0     0   2   65 65         68       130
1685098 ID     school 1602490 351   ONEIDA COUNTY DISTRICT 160249000434 797 STONE ELEMENTARY SCHOOL   Regular School No 1.0 PK 03 2015   grade_2 3 0 1   0 0     0   0   1 3             *         4 3 0 1   0 0     0   0   1 3                 4
1685182 ID     school 1602580 371   PAYETTE JOINT DISTRICT 160258000171 508 PAYETTE PRIMARY SCHOOL   Regular School No 1.0 PK 03 2015   grade_2 84 0 43   0 0     0   5   71 61             101         132 84 0 43   0 0     0   5   71 61         101       132
1685249 ID     school 1600060 381   AMERICAN FALLS JOINT DISTRICT 160006000005 808 HILLCREST ELEMENTARY SCHOOL   Regular School No 1.0 PK 03 2015   grade_2 59 0 51   4 0     0   0   60 54             85         114 59 0 51   4 0     0   0   60 54         85       114
1685356 ID     school 1603180 401   TETON COUNTY DISTRICT 160318000754 249 DRIGGS ELEMENTARY SCHOOL   Regular School No 1.0 PK 03 2015   grade_2 50 0 28   0 0     0   0   46 32             39         78 50 0 28   0 0     0   0   46 32         39       78
1685361 ID     school 1603180 401   TETON COUNTY DISTRICT 160318000545 822 TETONIA ELEMENTARY SCHOOL   Regular School No 1.0 KG 03 2015   grade_2 19 0 6   0 0     0   0   11 14             15         25 19 0 6   0 0     0   0   11 14         15       25
1685366 ID     school 1603180 401   TETON COUNTY DISTRICT 160318000547 823 VICTOR ELEMENTARY SCHOOL   Regular School No 1.0 KG 03 2015   grade_2 38 0 11   0 0     0   1   28 22             13         50 38 0 11   0 0     0   1   28 22         13       50
1685487 ID     school 1601050 413   FILER DISTRICT 160105000193 831 FILER ELEMENTARY SCHOOL   Regular School No 1.0 PK 03 2015   grade_2 96 0 14   0 0     0   4   57 57             *         114 96 0 14   0 0     0   4   57 57                 114
1685624 ID     school 1603330 431   WEISER DISTRICT 160333000567 839 PIONEER PRIMARY SCHOOL   Regular School No 1.0 PK 03 2015   grade_2 67 0 39   0 2     0   3   62 49             70         111 67 0 39   0 2     0   3   62 49         70       111
1821258 ID     school 1601770 3   KUNA JOINT DISTRICT 160177000913 596 INDIAN CREEK ELEMENTARY   Regular School No 1.0 PK 03 2016   grade_2 57 0 6   0 0     0   2   31 34             34         65 57 0 6   0 0     0   2   31 34         34       65
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
1822768 ID     school 1600660 151   CASSIA COUNTY JOINT DISTRICT 160066000130 470 MOUNTAIN VIEW ELEMENTARY   Regular School No 1.0 PK 03 2016   grade_2 81 0 50   1 1     0   0   65 68             90         133 81 0 50   1 1     0   0   65 68         90       133
1822789 ID     school 1600660 151   CASSIA COUNTY JOINT DISTRICT 160066000128 474 DWORSHAK ELEMENTARY SCHOOL   Regular School No 1.0 PK 03 2016   grade_2 98 0 57   0 0     0   2   75 82             93         157 98 0 57   0 0     0   2   75 82         93       157
1823357 ID     school 1601590 261   JEROME JOINT DISTRICT 160159000272 516 HORIZON ELEMENTARY SCHOOL   Regular School No 1.0 PK 03 2016   grade_2 73 0 98   0 0     0   0   85 86             127         171 73 0 98   0 0     0   0   85 86         127       171
1823362 ID     school 1601590 261   JEROME JOINT DISTRICT 160159000283 731 JEFFERSON ELEMENTARY SCHOOL   Regular School No 1.0 KG 03 2016   grade_2 65 1 98   1 0     0   1   79 87             128         166 65 1 98   1 0     0   1   79 87         128       166
1823722 ID     school 1600010 288   WHITEPINE JOINT SCHOOL DISTRICT 160001000578 771 BOVILL ELEMENTARY SCHOOL   Regular School No 1.0 PK 03 2016   grade_2 19 0 1   0 0     0   0   11 9             13         20 19 0 1   0 0     0   0   11 9         13       20
1823937 ID     school 1603090 322   SUGAR-SALEM JOINT DISTRICT 160309000537 781 CENTRAL ELEMENTARY SCHOOL   Regular School No 1.0 PK 03 2016   grade_2 80 0 11   0 1     1   0   46 47             55         93 80 0 11   0 1     1   0   46 47         55       93
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
1824220 ID     school 1602580 371   PAYETTE JOINT DISTRICT 160258000171 508 PAYETTE PRIMARY SCHOOL   Regular School No 1.0 PK 03 2016   grade_2 60 0 44   1 0     0   6   53 58             *         111 60 0 44   1 0     0   6   53 58                 111
1824293 ID     school 1600060 381   AMERICAN FALLS JOINT DISTRICT 160006000005 808 HILLCREST ELEMENTARY SCHOOL   Regular School No 1.0 PK 03 2016   grade_2 49 0 79   2 0     0   0   68 62             100         130 49 0 79   2 0     0   0   68 62         100       130
1824389 ID     school 1603180 401   TETON COUNTY DISTRICT 160318000754 249 DRIGGS ELEMENTARY SCHOOL   Regular School No 1.0 PK 03 2016   grade_2 38 0 36   1 0     0   3   39 39             50         78 38 0 36   1 0     0   3   39 39         50       78
1824394 ID     school 1603180 401   TETON COUNTY DISTRICT 160318000545 822 TETONIA ELEMENTARY SCHOOL   Regular School No 1.0 KG 03 2016   grade_2 18 0 1   0 0     0   0   8 11             7         19 18 0 1   0 0     0   0   8 11         7       19
1824399 ID     school 1603180 401   TETON COUNTY DISTRICT 160318000547 823 VICTOR ELEMENTARY SCHOOL   Regular School No 1.0 KG 03 2016   grade_2 36 0 7   1 0     0   0   18 26             18         44 36 0 7   1 0     0   0   18 26         18       44
1824516 ID     school 1601050 413   FILER DISTRICT 160105000193 831 FILER ELEMENTARY SCHOOL   Regular School No 1.0 PK 03 2016   grade_2 110 1 18   1 0     0   0   63 67             *         130 110 1 18   1 0     0   0   63 67                 130
1824652 ID     school 1603330 431   WEISER DISTRICT 160333000567 839 PIONEER PRIMARY SCHOOL   Regular School No 1.0 PK 03 2016   grade_2 77 0 27   0 0     0   3   49 58             62         107 77 0 27   0 0     0   3   49 58         62       107
1825093 ID     school 1600172 490   IDAHO DISTANCE EDUCATION ACADEMY, INC. 160017201073 1376 GEM PREP: POCATELLO SCHOOL   Regular School Yes 1.0 KG 03 2016   grade_2 15 0 0   0 0     0   1   10 6             *         16 15 0 0   0 0     0   1   10 6                 16
703932 ID     school 1601080 59   FIRTH DISTRICT 160108000196 390 A W JOHNSON ELEMENTARY SCHOOL   Regular School No Elementary PK 04 2021   grade_2 60 0 6   0 0     0   0   37 29             31         66 60 0 6   0 0     0   0   37 29         31       66
704875 ID     school 1602550 137   PARMA DISTRICT 160255000449 456 MAXINE JOHNSON ELEMENTARY   Regular School No Elementary PK 04 2021   grade_2 50 0 21   1 0     0   4   36 40             43         76 50 0 21   1 0     0   4   36 40         43       76
705002 ID     school 1603000 150   SODA SPRINGS JOINT DISTRICT 160300000525 466 HOWARD E THIRKILL PRIMARY SCHOOL   Regular School No Elementary PK 04 2021   grade_2 73 1 4   0 1     0   0   38 41             *         79 73 1 4   0 1     0   0   38 41                 79
705270 ID     school 1602250 193   MOUNTAIN HOME DISTRICT 160225000403 493 WEST ELEMENTARY SCHOOL   Regular School No Elementary PK 04 2021   grade_2 45 1 29   0 0     0   3   39 39             32         78 45 1 29   0 0     0   3   39 39         32       78
705276 ID     school 1602250 193   MOUNTAIN HOME DISTRICT 160225000396 494 EAST ELEMENTARY SCHOOL   Regular School No Elementary PK 04 2021   grade_2 59 1 11   1 0     0   4   38 38             31         76 59 1 11   1 0     0   4   38 38         31       76
705282 ID     school 1602250 193   MOUNTAIN HOME DISTRICT 160225000402 495 NORTH ELEMENTARY SCHOOL   Regular School No Elementary PK 04 2021   grade_2 33 2 16   0 0     1   8   27 33             *         60 33 2 16   0 0     1   8   27 33                 60
705288 ID     school 1602250 193   MOUNTAIN HOME DISTRICT 160225000400 502 STEPHENSEN ELEMENTARY SCHOOL   Regular School No Elementary PK 04 2021   grade_2 37 5 10   0 3     0   6   23 38             *         61 37 5 10   0 3     0   6   23 38                 61
705479 ID     school 1603360 232   WENDELL DISTRICT 160336000570 712 WENDELL ELEMENTARY SCHOOL   Regular School No Elementary PK 04 2021   grade_2 37 0 57   0 0     0   0   35 59             73         94 37 0 57   0 0     0   0   35 59         73       94
705689 ID     school 1603400 253   WEST JEFFERSON DISTRICT 160340000273 729 HAMER ELEMENTARY SCHOOL   Regular School No Elementary KG 04 2021   grade_2 6 0 1   0 0     0   0   4 3             *         7 6 0 1   0 0     0   0   4 3                 7
706259 ID     school 1601920 321   MADISON DISTRICT 160192000338 773 KENNEDY ELEMENTARY SCHOOL   Regular School No Elementary KG 04 2021   grade_2 48 1 7   1 2     0   0   28 31             32         59 48 1 7   1 2     0   0   28 31         32       59

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