Data source: Big Local News · About: Big Local

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

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 ▲
706511 ID     school 1602490 351   ONEIDA COUNTY DISTRICT 160249001094 1390 IDAHO HOME LEARNING ACADEMY   Regular School No Other PK 10 2021   grade_2 809 7 79   2 8     2   0   433 474             *         907 809 7 79   2 8     2   0   433 474                 907
852176 ID     school 1602490 351   ONEIDA COUNTY DISTRICT 160249001094 1390 IDAHO HOME LEARNING ACADEMY   Regular School No Elementary KG 08 2020   grade_2 297 2 25   1 8     2   2   166 171             *         337 297 2 25   1 8     2   2   166 171                 337
702905 ID     school 1600360 1   BOISE INDEPENDENT DISTRICT 160036000070 313 OWYHEE ELEMENTARY SCHOOL   Regular School No Elementary PK 06 2021   grade_2 194 3 59   1 35     3   23   152 166             87         318 194 3 59   1 35     3   23   152 166         87       318
707124 ID     school 1600004 452   IDAHO VIRTUAL ACADEMY, INC. 160000400859 869 IDAHO VIRTUAL ACADEMY   Regular School Yes Other KG 12 2021   grade_2 235 2 33   2 1     0   17   149 141             168         290 235 2 33   2 1     0   17   149 141         168       290
703402 ID     school 1602100 2   JOINT SCHOOL DISTRICT NO. 2 160210001070 1374 VIRTUAL SCHOOL HOUSE   Regular School No Other PK 12 2021   grade_2 181 3 29   0 11     1   12   105 132             31         237 181 3 29   0 11     1   12   105 132         31       237
1728282 ID     school 1601570 251   JEFFERSON COUNTY JOINT DISTRICT 160157000276 725 JEFFERSON ELEMENTARY SCHOOL   Regular School No Elementary PK 2.0 2017   grade_2 211 0 20   0 0     0   0   116 115             88         231 211 0 20   0 0     0   0   116 115         88       231
1278816 ID     school 1601570 251   JEFFERSON COUNTY JOINT DISTRICT 160157000276 725 JEFFERSON ELEMENTARY SCHOOL   Regular School No Elementary PK 2.0 2018   grade_2 207 0 15   2 0     0   4   113 115             83         228 207 0 15   2 0     0   4   113 115         83       228
1307687 ID     school 1601570 251   JEFFERSON COUNTY JOINT DISTRICT 160157000276 725 JEFFERSON ELEMENTARY SCHOOL   Regular School No Elementary PK 2.0 2019   grade_2 195 3 24   1 0     0   3   102 124             71         226 195 3 24   1 0     0   3   102 124         71       226
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
1308571 ID     school 1602490 351   ONEIDA COUNTY DISTRICT 160249001094 1390 IDAHO HOME LEARNING ACADEMY   Regular School No Elementary KG 8.0 2019   grade_2 190 3 17   2 4     0   2   109 109             *         218 190 3 17   2 4     0   2   109 109                 218
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
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
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
1277231 ID     school 1602910 60   SHELLEY JOINT DISTRICT 160291000508 391 SUNRISE ELEMENTARY SCHOOL   Regular School No Elementary KG 2.0 2018   grade_2 161 3 22   0 3     0   2   86 105             98         191 161 3 22   0 3     0   2   86 105         98       191
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
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
1306091 ID     school 1602910 60   SHELLEY JOINT DISTRICT 160291000508 391 SUNRISE ELEMENTARY SCHOOL   Regular School No Elementary KG 2.0 2019   grade_2 156 0 20   1 2     1   3   98 85             86         183 156 0 20   1 2     1   3   98 85         86       183
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
1726696 ID     school 1602910 60   SHELLEY JOINT DISTRICT 160291000508 391 SUNRISE ELEMENTARY SCHOOL   Regular School No Elementary KG 2.0 2017   grade_2 156 1 25   0 0     0   0   91 91             93         182 156 1 25   0 0     0   0   91 91         93       182
1728009 ID     school 1600960 201   PRESTON JOINT DISTRICT 160096000709 499 PIONEER ELEMENTARY SCHOOL   Regular School No Elementary PK 2.0 2017   grade_2 156 2 21   3 0     0   0   95 87             100         182 156 2 21   3 0     0   0   95 87         100       182
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
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
1307419 ID     school 1600960 201   PRESTON JOINT DISTRICT 160096000709 499 PIONEER ELEMENTARY SCHOOL   Regular School No Elementary PK 2.0 2019   grade_2 144 2 18   2 0     1   2   87 82             77         169 144 2 18   2 0     1   2   87 82         77       169
1280124 ID     school 1601710 414   KIMBERLY DISTRICT 160171000300 833 KIMBERLY ELEMENTARY SCHOOL   Regular School No Elementary PK 5.0 2018   grade_2 145 0 17   1 0     1   3   76 91             62         167 145 0 17   1 0     1   3   76 91         62       167
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
1684533 ID     school 1602670 273   POST FALLS DISTRICT 160267000209 736 PRAIRIE VIEW ELEMENTARY   Regular School No 1.0 01 05 2015   grade_2 142 0 12   1 1     0   9   90 75             82         165 142 0 12   1 1     0   9   90 75         82       165
1278546 ID     school 1600960 201   PRESTON JOINT DISTRICT 160096000709 499 PIONEER ELEMENTARY SCHOOL   Regular School No Elementary PK 2.0 2018   grade_2 136 0 24   2 0     0   2   81 83             85         164 136 0 24   2 0     0   2   81 83         85       164
1728364 ID     school 1601590 261   JEROME JOINT DISTRICT 160159000272 516 HORIZON ELEMENTARY SCHOOL   Regular School No Elementary PK 3.0 2017   grade_2 76 0 86   1 0     1   0   88 76             *         164 76 0 86   1 0     1   0   88 76                 164
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
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
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
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
1278899 ID     school 1601590 261   JEROME JOINT DISTRICT 160159000272 516 HORIZON ELEMENTARY SCHOOL   Regular School No Elementary PK 3.0 2018   grade_2 68 0 88   0 0     0   1   86 71             107         157 68 0 88   0 0     0   1   86 71         107       157
1728369 ID     school 1601590 261   JEROME JOINT DISTRICT 160159000283 731 JEFFERSON ELEMENTARY SCHOOL   Regular School No Elementary KG 3.0 2017   grade_2 53 0 100   2 1     1   0   77 80             119         157 53 0 100   2 1     1   0   77 80         119       157
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
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
1307774 ID     school 1601590 261   JEROME JOINT DISTRICT 160159000283 731 JEFFERSON ELEMENTARY SCHOOL   Regular School No Elementary KG 3.0 2019   grade_2 67 0 86   0 1     0   2   73 83             110         156 67 0 86   0 1     0   2   73 83         110       156
1824541 ID     school 1601710 414   KIMBERLY DISTRICT 160171000300 833 KIMBERLY ELEMENTARY SCHOOL   Regular School No 1.0 PK 05 2016   grade_2 123 0 30   0 0     0   0   74 79             63         153 123 0 30   0 0     0   0   74 79         63       153
1278904 ID     school 1601590 261   JEROME JOINT DISTRICT 160159000283 731 JEFFERSON ELEMENTARY SCHOOL   Regular School No Elementary KG 3.0 2018   grade_2 80 0 71   0 0     1   0   76 76             *         152 80 0 71   0 0     1   0   76 76                 152
1307769 ID     school 1601590 261   JEROME JOINT DISTRICT 160159000272 516 HORIZON ELEMENTARY SCHOOL   Regular School No Elementary PK 3.0 2019   grade_2 68 0 82   0 1     0   0   89 62             *         151 68 0 82   0 1     0   0   89 62                 151
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
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
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
1683576 ID     school 1600600 139   VALLIVUE SCHOOL DISTRICT 160060000083 505 CENTRAL CANYON ELEMENTARY SCHOOL   Regular School No 1.0 PK 05 2015   grade_2 76 0 61   0 0     0   7   73 71             112         144 76 0 61   0 0     0   7   73 71         112       144
1685512 ID     school 1601710 414   KIMBERLY DISTRICT 160171000300 833 KIMBERLY ELEMENTARY SCHOOL   Regular School No 1.0 PK 05 2015   grade_2 119 3 19   0 0     0   2   82 61             63         143 119 3 19   0 0     0   2   82 61         63       143
1278345 ID     school 1600660 151   CASSIA COUNTY JOINT DISTRICT 160066000128 474 DWORSHAK ELEMENTARY SCHOOL   Regular School No Elementary PK 3.0 2018   grade_2 67 0 73   1 0     0   1   72 70             85         142 67 0 73   1 0     0   1   72 70         85       142
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
1685688 ID     school 1600004 452   IDAHO VIRTUAL ACADEMY, INC. 160000400859 869 IDAHO VIRTUAL ACADEMY   Regular School Yes 4.0 PK 12 2015   grade_2 123 1 11   0 3     0   4   65 77             108         142 123 1 11   0 3     0   4   65 77         108       142
1821160 ID     school 1602100 2   JOINT SCHOOL DISTRICT NO. 2 160210000989 899 SIENA ELEMENTARY   Regular School No 1.0 PK 07 2016   grade_2 119 2 12   1 2     0   6   70 72             11         142 119 2 12   1 2     0   6   70 72         11       142
1821140 ID     school 1602100 2   JOINT SCHOOL DISTRICT NO. 2 160210000902 593 PROSPECT ELEMENTARY SCHOOL   Regular School No 1.0 PK 05 2016   grade_2 114 1 19   0 3     0   4   79 62             22         141 114 1 19   0 3     0   4   79 62         22       141
1729297 ID     school 1601140 373   FRUITLAND DISTRICT 160114000211 807 FRUITLAND ELEMENTARY SCHOOL   Regular School No Elementary PK 4.0 2017   grade_2 91 0 43   0 2     0   4   64 76             62         140 91 0 43   0 2     0   4   64 76         62       140
1729589 ID     school 1601710 414   KIMBERLY DISTRICT 160171000300 833 KIMBERLY ELEMENTARY SCHOOL   Regular School No Elementary PK 5.0 2017   grade_2 129 1 8   1 0     0   1   71 69             51         140 129 1 8   1 0     0   1   71 69         51       140
704918 ID     school 1600600 139   VALLIVUE SCHOOL DISTRICT 160060000976 646 LAKEVUE ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2021   grade_2 72 3 59   0 0     1   4   76 63             48         139 72 3 59   0 0     1   4   76 63         48       139
1683601 ID     school 1600600 139   VALLIVUE SCHOOL DISTRICT 160060000935 892 DESERT SPRINGS ELEMENTARY SCHOOL   Regular School No 1.0 PK 05 2015   grade_2 81 1 54   1 1     0   1   81 58             94         139 81 1 54   1 1     0   1   81 58         94       139
1277120 ID     school 1602970 52   SNAKE RIVER DISTRICT 160297000518 376 RIVERSIDE ELEMENTARY SCHOOL   Regular School No Elementary 02 3.0 2018   grade_2 114 1 20   2 0     0   1   72 66             62         138 114 1 20   2 0     0   1   72 66         62       138
1684388 ID     school 1600780 271   COEUR D'ALENE DISTRICT 160078000155 738 RAMSEY MAGNET SCHOOL OF SCIENCE   Regular School No 1.0 PK 05 2015   grade_2 123 1 6   0 4     0   4   76 62             49         138 123 1 6   0 4     0   4   76 62         49       138
1685406 ID     school 1603240 411   TWIN FALLS DISTRICT 160324000551 825 MORNINGSIDE ELEMENTARY SCHOOL   Regular School No 1.0 PK 05 2015   grade_2 113 1 15   1 4     0   3   64 73             79         137 113 1 15   1 4     0   3   64 73         79       137
1727778 ID     school 1600660 151   CASSIA COUNTY JOINT DISTRICT 160066000130 470 MOUNTAIN VIEW ELEMENTARY   Regular School No Elementary PK 3.0 2017   grade_2 86 0 46   0 1     0   4   68 69             89         137 86 0 46   0 1     0   4   68 69         89       137
1822614 ID     school 1600600 139   VALLIVUE SCHOOL DISTRICT 160060000119 461 WEST CANYON ELEMENTARY SCHOOL   Regular School No 1.0 PK 05 2016   grade_2 83 2 46   0 0     0   6   78 59             88         137 83 2 46   0 0     0   6   78 59         88       137
1307054 ID     school 1600600 139   VALLIVUE SCHOOL DISTRICT 160060001092 1397 SKYWAY ELEMENTARY   Regular School No Elementary KG 5.0 2019   grade_2 70 0 65   1 0     0   0   64 72             82         136 70 0 65   1 0     0   0   64 72         82       136
1727799 ID     school 1600660 151   CASSIA COUNTY JOINT DISTRICT 160066000128 474 DWORSHAK ELEMENTARY SCHOOL   Regular School No Elementary PK 3.0 2017   grade_2 61 1 70   2 0     1   1   73 63             104         136 61 1 70   2 0     1   1   73 63         104       136
1308652 ID     school 1602580 371   PAYETTE JOINT DISTRICT 160258000171 508 PAYETTE PRIMARY SCHOOL   Regular School No Elementary PK 3.0 2019   grade_2 87 1 41   1 1     0   4   66 69             *         135 87 1 41   1 1     0   4   66 69                 135
1824431 ID     school 1603240 411   TWIN FALLS DISTRICT 160324000660 824 I B PERRINE ELEMENTARY SCHOOL   Regular School No 1.0 PK 05 2016   grade_2 112 1 13   2 4     0   3   68 67             73         135 112 1 13   2 4     0   3   68 67         73       135
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
1824438 ID     school 1603240 411   TWIN FALLS DISTRICT 160324000551 825 MORNINGSIDE ELEMENTARY SCHOOL   Regular School No 1.0 PK 05 2016   grade_2 107 2 20   0 2     0   3   78 56             68         134 107 2 20   0 2     0   3   78 56         68       134
1278008 ID     school 1600510 132   CALDWELL DISTRICT 160051000107 451 VAN BUREN ELEMENTARY SCHOOL   Regular School No Elementary KG 5.0 2018   grade_2 42 1 86   1 0     0   3   75 58             *         133 42 1 86   1 0     0   3   75 58                 133
1279816 ID     school 1601140 373   FRUITLAND DISTRICT 160114000211 807 FRUITLAND ELEMENTARY SCHOOL   Regular School No Elementary PK 4.0 2018   grade_2 88 0 41   1 1     0   2   75 58             73         133 88 0 41   1 1     0   2   75 58         73       133
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
849200 ID     school 1602100 2   JOINT SCHOOL DISTRICT NO. 2 160210001081 1383 HILLSDALE ELEMENTARY   Regular School No Elementary PK 05 2020   grade_2 121 1 2   2 0     0   6   67 65             16         132 121 1 2   2 0     0   6   67 65         16       132
1682130 ID     school 1602100 2   JOINT SCHOOL DISTRICT NO. 2 160210000989 899 SIENA ELEMENTARY   Regular School No 1.0 PK 07 2015   grade_2 112 1 10   0 5     0   4   69 63             22         132 112 1 10   0 5     0   4   69 63         22       132
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
1728449 ID     school 1600780 271   COEUR D'ALENE DISTRICT 160078000155 738 RAMSEY MAGNET SCHOOL OF SCIENCE   Regular School No Elementary PK 5.0 2017   grade_2 109 1 10   1 0     1   10   64 68             60         132 109 1 10   1 0     1   10   64 68         60       132
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
1823981 ID     school 1602190 331   MINIDOKA COUNTY JOINT DISTRICT 160219000666 845 RUPERT ELEMENTARY SCHOOL   Regular School No 1.0 PK 05 2016   grade_2 60 0 71   0 0     0   1   72 60             *         132 60 0 71   0 0     0   1   72 60                 132
1278324 ID     school 1600660 151   CASSIA COUNTY JOINT DISTRICT 160066000130 470 MOUNTAIN VIEW ELEMENTARY   Regular School No Elementary PK 3.0 2018   grade_2 80 0 50   0 0     0   1   65 66             75         131 80 0 50   0 0     0   1   65 66         75       131
1728463 ID     school 1600780 271   COEUR D'ALENE DISTRICT 160078000152 740 ATLAS ELEMENTARY SCHOOL   Regular School No Elementary PK 5.0 2017   grade_2 119 0 8   0 1     0   3   60 71             55         131 119 0 8   0 1     0   3   60 71         55       131
1728953 ID     school 1603090 322   SUGAR-SALEM JOINT DISTRICT 160309000537 781 CENTRAL ELEMENTARY SCHOOL   Regular School No Elementary PK 3.0 2017   grade_2 122 1 6   2 0     0   0   63 68             62         131 122 1 6   2 0     0   0   63 68         62       131
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
851303 ID     school 1601570 251   JEFFERSON COUNTY JOINT DISTRICT 160157001001 1110 SOUTH FORK ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2020   grade_2 115 0 10   1 1     0   3   62 68             48         130 115 0 10   1 1     0   3   62 68         48       130
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
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
1685399 ID     school 1603240 411   TWIN FALLS DISTRICT 160324000660 824 I B PERRINE ELEMENTARY SCHOOL   Regular School No 1.0 PK 05 2015   grade_2 109 2 16   0 2     1   0   64 66             63         130 109 2 16   0 2     1   0   64 66         63       130
1823440 ID     school 1600780 271   COEUR D'ALENE DISTRICT 160078000155 738 RAMSEY MAGNET SCHOOL OF SCIENCE   Regular School No 1.0 PK 05 2016   grade_2 117 0 9   0 0     1   3   69 61             51         130 117 0 9   0 0     1   3   69 61         51       130
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
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
851457 ID     school 1600780 271   COEUR D'ALENE DISTRICT 160078000155 738 RAMSEY MAGNET SCHOOL OF SCIENCE   Regular School No Elementary PK 05 2020   grade_2 111 0 11   1 2     1   3   70 59             43         129 111 0 11   1 2     1   3   70 59         43       129
852292 ID     school 1601140 373   FRUITLAND DISTRICT 160114000211 807 FRUITLAND ELEMENTARY SCHOOL   Regular School No Elementary PK 04 2020   grade_2 81 0 37   0 1     1   9   69 60             65         129 81 0 37   0 1     1   9   69 60         65       129
1278983 ID     school 1600780 271   COEUR D'ALENE DISTRICT 160078000155 738 RAMSEY MAGNET SCHOOL OF SCIENCE   Regular School No Elementary PK 5.0 2018   grade_2 110 0 13   2 3     0   1   65 64             50         129 110 0 13   2 3     0   1   65 64         50       129
1729324 ID     school 1600060 381   AMERICAN FALLS JOINT DISTRICT 160006000005 808 HILLCREST ELEMENTARY SCHOOL   Regular School No Elementary PK 3.0 2017   grade_2 57 2 68   2 0     0   0   64 65             99         129 57 2 68   2 0     0   0   64 65         99       129
1276505 ID     school 1602100 2   JOINT SCHOOL DISTRICT NO. 2 160210000824 296 HUNTER ELEMENTARY SCHOOL   Regular School No Elementary PK 5.0 2018   grade_2 109 1 12   0 2     0   4   66 62             13         128 109 1 12   0 2     0   4   66 62         13       128
1279782 ID     school 1602580 371   PAYETTE JOINT DISTRICT 160258000171 508 PAYETTE PRIMARY SCHOOL   Regular School No Elementary PK 3.0 2018   grade_2 78 0 47   0 0     0   3   60 68             *         128 78 0 47   0 0     0   3   60 68                 128
1681936 ID     school 1602100 2   JOINT SCHOOL DISTRICT NO. 2 160210000824 296 HUNTER ELEMENTARY SCHOOL   Regular School No 1.0 PK 05 2015   grade_2 114 1 7   0 0     0   5   66 61             13         127 114 1 7   0 0     0   5   66 61         13       127
1822621 ID     school 1600600 139   VALLIVUE SCHOOL DISTRICT 160060000083 505 CENTRAL CANYON ELEMENTARY SCHOOL   Regular School No 1.0 PK 05 2016   grade_2 66 0 58   0 0     0   3   66 61             95         127 66 0 58   0 0     0   3   66 61         95       127
1276679 ID     school 1602100 2   JOINT SCHOOL DISTRICT NO. 2 160210000902 593 PROSPECT ELEMENTARY SCHOOL   Regular School No Elementary PK 5.0 2018   grade_2 107 1 10   0 4     0   4   77 49             28         126 107 1 10   0 4     0   4   77 49         28       126
1305361 ID     school 1602100 2   JOINT SCHOOL DISTRICT NO. 2 160210000824 296 HUNTER ELEMENTARY SCHOOL   Regular School No Elementary PK 5.0 2019   grade_2 107 1 15   0 1     0   2   61 65             20         126 107 1 15   0 1     0   2   61 65         20       126
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
1823419 ID     school 1600780 271   COEUR D'ALENE DISTRICT 160078000114 506 HAYDEN MEADOWS ELEMENTARY SCHOOL   Regular School No 1.0 PK 05 2016   grade_2 115 0 6   1 0     0   4   60 66             47         126 115 0 6   1 0     0   4   60 66         47       126
1823582 ID     school 1602670 273   POST FALLS DISTRICT 160267000209 736 PRAIRIE VIEW ELEMENTARY   Regular School No 1.0 01 05 2016   grade_2 112 1 8   2 0     0   3   53 73             48         126 112 1 8   2 0     0   3   53 73         48       126

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