Data source: Big Local News · About: Big Local

5,050 rows where state = "ID" and year = 2021 sorted by white descending

View and edit SQL

grade

year

  • 2021 · 5,050
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
707188 ID     school 1600007 455   COMPASS PUBLIC CHARTER SCHOOL, INC. 160000700864 575 COMPASS PUBLIC CHARTER SCHOOL   Regular School Yes Other KG 12 2021   k_12_total 998 16 118   1 39     2   39   601 612             161         1213 998 16 118   1 39     2   39   601 612         161       1213
703545 ID     school 1601950 21   MARSH VALLEY JOINT DISTRICT 160195000347 19 MARSH VALLEY HIGH SCHOOL   Regular School No High 07 12 2021   grade_10 99 1 5   1 0     0   0   54 52             24         106 99 1 5   1 0     0   0   54 52         24       106
703817 ID     school 1602970 52   SNAKE RIVER DISTRICT 160297000516 377 MORELAND ELEMENTARY SCHOOL   Regular School No Elementary PK 01 2021   grade_1 99 0 17   0 0     0   3   57 62             *         119 99 0 17   0 0     0   3   57 62                 119
703820 ID     school 1602970 52   SNAKE RIVER DISTRICT 160297000519 378 ROCKFORD ELEMENTARY SCHOOL   Regular School No Elementary 04 04 2021   grade_4 99 0 22   1 0     0   0   69 53             *         122 99 0 22   1 0     0   0   69 53                 122
703821 ID     school 1602970 52   SNAKE RIVER DISTRICT 160297000519 378 ROCKFORD ELEMENTARY SCHOOL   Regular School No Elementary 04 04 2021   k_12_total 99 0 22   1 0     0   0   69 53             39         122 99 0 22   1 0     0   0   69 53         39       122
704304 ID     school 1601530 91   IDAHO FALLS DISTRICT 160153001043 1350 COMPASS ACADEMY   Regular School No High 09 12 2021   grade_12 99 1 5   2 3     0   2   46 66             *         112 99 1 5   2 3     0   2   46 66                 112
704687 ID     school 1602340 131   NAMPA SCHOOL DISTRICT 160234000762 1154 UNION HIGH SCHOOL   Alternative School No High 08 12 2021   k_12_total 99 0 40   1 0     0   4   67 77             77         144 99 0 40   1 0     0   4   67 77         77       144
706303 ID     school 1603090 322   SUGAR-SALEM JOINT DISTRICT 160309000538 147 SUGAR-SALEM HIGH SCHOOL   Regular School No High 09 12 2021   grade_12 99 1 5   0 0     0   0   49 56             *         105 99 1 5   0 0     0   0   49 56                 105
706756 ID     school 1603180 401   TETON COUNTY DISTRICT 160318000543 175 TETON HIGH SCHOOL   Regular School No High 09 12 2021   grade_9 99 0 47   0 0     0   3   82 67             38         149 99 0 47   0 0     0   3   82 67         38       149
707436 ID     school 1600159 479   HERITAGE ACADEMY, INC. 160015901017 1341 HERITAGE ACADEMY   Regular School Yes Elementary PK 08 2021   k_12_total 99 0 63   2 0     0   1   75 90             74         165 99 0 63   2 0     0   1   75 90         74       165
707754 ID     school 1600960 751   S E I TEC CHARTER SCHOOL, INC. 160096001045 1349 SOUTHEAST IDAHO PROFESSIONAL TECHNICAL SCHOOL   Career and Technical School Yes High 09 12 2021   grade_10 99 1 6   0 2     0   0   46 62             *         108 99 1 6   0 2     0   0   46 62                 108
703356 ID     school 1602100 2   JOINT SCHOOL DISTRICT NO. 2 160210000989 899 SIENA ELEMENTARY   Regular School No Elementary PK 05 2021   grade_5 98 0 11   1 3     0   7   67 53             12         120 98 0 11   1 3     0   7   67 53         12       120
703367 ID     school 1602100 2   JOINT SCHOOL DISTRICT NO. 2 160210000602 1145 CROSSROADS MIDDLE SCHOOL   Alternative School No Middle 06 08 2021   k_12_total 98 0 16   0 0     1   7   78 44             51         122 98 0 16   0 0     1   7   78 44         51       122
703483 ID     school 1601770 3   KUNA JOINT DISTRICT 160177000915 635 ROSS ELEMENTARY SCHOOL   Regular School No Elementary 04 05 2021   grade_5 98 1 14   1 1     0   3   74 44             45         118 98 1 14   1 1     0   3   74 44         45       118
706307 ID     school 1603090 322   SUGAR-SALEM JOINT DISTRICT 160309000645 225 KERSHAW INTERMEDIATE SCHOOL   Regular School No Middle 04 06 2021   grade_5 98 2 4   1 0     0   4   54 55             45         109 98 2 4   1 0     0   4   54 55         45       109
706633 ID     school 1601140 373   FRUITLAND DISTRICT 160114000212 166 FRUITLAND HIGH SCHOOL   Regular School No High 09 12 2021   grade_11 98 0 34   0 2     0   6   74 66             *         140 98 0 34   0 2     0   6   74 66                 140
706924 ID     school 1601050 413   FILER DISTRICT 160105000193 831 FILER ELEMENTARY SCHOOL   Regular School No Elementary PK 03 2021   grade_3 98 1 11   0 0     0   0   55 55             37         110 98 1 11   0 0     0   0   55 55         37       110
707183 ID     school 1600007 455   COMPASS PUBLIC CHARTER SCHOOL, INC. 160000700864 575 COMPASS PUBLIC CHARTER SCHOOL   Regular School Yes Other KG 12 2021   grade_5 98 0 10   0 6     0   3   58 59             17         117 98 0 10   0 6     0   3   58 59         17       117
703542 ID     school 1601950 21   MARSH VALLEY JOINT DISTRICT 160195000348 18 MARSH VALLEY MIDDLE SCHOOL   Regular School No Middle 07 08 2021   grade_7 97 0 2   1 0     1   1   51 51             28         102 97 0 2   1 0     1   1   51 51         28       102
705238 ID     school 1601900 182   MACKAY JOINT DISTRICT 160190000331 490 MACKAY ELEMENTARY SCHOOL   Regular School No Elementary PK 06 2021   k_12_total 97 0 6   1 0     1   0   55 50             47         105 97 0 6   1 0     1   0   55 50         47       105
707055 ID     school 1603330 431   WEISER DISTRICT 160333000568 192 WEISER HIGH SCHOOL   Regular School No High 09 12 2021   grade_10 97 1 44   2 2     0   2   67 81             *         148 97 1 44   2 2     0   2   67 81                 148
703703 ID     school 1602640 25   POCATELLO DISTRICT 160264000646 956 CENTURY HIGH SCHOOL   Regular School No High 09 12 2021   k_12_total 961 9 134   16 19     4   41   596 588             467         1184 961 9 134   16 19     4   41   596 588         467       1184
704297 ID     school 1601530 91   IDAHO FALLS DISTRICT 160153000697 1048 EMERSON HIGH SCHOOL   Alternative School No High 09 12 2021   k_12_total 96 2 50   4 0     0   5   87 70             90         157 96 2 50   4 0     0   5   87 70         90       157
704808 ID     school 1602130 134   MIDDLETON DISTRICT 160213000376 453 MIDDLETON MILL CREEK ELEMENTARY   Regular School No Elementary PK 05 2021   grade_1 96 0 12   1 1     0   1   53 58             30         111 96 0 12   1 1     0   1   53 58         30       111
704809 ID     school 1602130 134   MIDDLETON DISTRICT 160213000376 453 MIDDLETON MILL CREEK ELEMENTARY   Regular School No Elementary PK 05 2021   grade_2 96 0 8   1 3     1   3   60 52             21         112 96 0 8   1 3     1   3   60 52         21       112
704811 ID     school 1602130 134   MIDDLETON DISTRICT 160213000376 453 MIDDLETON MILL CREEK ELEMENTARY   Regular School No Elementary PK 05 2021   grade_4 96 2 9   0 0     0   0   55 52             19         107 96 2 9   0 0     0   0   55 52         19       107
705231 ID     school 1601900 182   MACKAY JOINT DISTRICT 160190000332 90 MACKAY JR/SR HIGH SCHOOL   Regular School No High 07 12 2021   k_12_total 96 0 10   1 0     2   1   51 59             45         110 96 0 10   1 0     2   1   51 59         45       110
705643 ID     school 1601570 251   JEFFERSON COUNTY JOINT DISTRICT 160157001128 1437 COTTONWOOD ELEMENTARY   Regular School No Elementary KG 05 2021   grade_5 96 0 8   0 0     0   3   52 55             26         107 96 0 8   0 0     0   3   52 55         26       107
705798 ID     school 1600780 271   COEUR D'ALENE DISTRICT 160078000155 738 RAMSEY MAGNET SCHOOL OF SCIENCE   Regular School No Elementary PK 05 2021   grade_3 96 0 7   0 1     1   3   58 50             30         108 96 0 7   0 1     1   3   58 50         30       108
706753 ID     school 1603180 401   TETON COUNTY DISTRICT 160318000543 175 TETON HIGH SCHOOL   Regular School No High 09 12 2021   grade_10 96 0 43   1 0     0   2   79 63             *         142 96 0 43   1 0     0   2   79 63                 142
707043 ID     school 1600630 422   CASCADE DISTRICT 160063000121 190 CASCADE JR/SR HIGH SCHOOL   Regular School No High 06 12 2021   k_12_total 96 2 5   4 1     0   1   62 47             21         109 96 2 5   4 1     0   1   62 47         21       109
703420 ID     school 1602100 2   JOINT SCHOOL DISTRICT NO. 2 160210001081 1383 HILLSDALE ELEMENTARY   Regular School No Elementary PK 05 2021   grade_1 95 1 6   1 1     0   6   58 52             *         110 95 1 6   1 1     0   6   58 52                 110
703738 ID     school 1600240 33   BEAR LAKE COUNTY DISTRICT 160024000021 371 GEORGETOWN ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2021   k_12_total 95 0 0   0 0     0   1   55 41             32         96 95 0 0   0 0     0   1   55 41         32       96
704562 ID     school 1602340 131   NAMPA SCHOOL DISTRICT 160234000422 61 WEST MIDDLE SCHOOL   Regular School No Middle 06 08 2021   grade_8 95 0 111   1 0     1   12   115 105             116         220 95 0 111   1 0     1   12   115 105         116       220
707756 ID     school 1600960 751   S E I TEC CHARTER SCHOOL, INC. 160096001045 1349 SOUTHEAST IDAHO PROFESSIONAL TECHNICAL SCHOOL   Career and Technical School Yes High 09 12 2021   grade_12 95 1 6   2 2     0   0   58 48             *         106 95 1 6   2 2     0   0   58 48                 106
703602 ID     school 1602640 25   POCATELLO DISTRICT 160264000478 24 POCATELLO HIGH SCHOOL   Regular School No High 09 12 2021   k_12_total 947 11 139   26 3     5   41   567 605             452         1172 947 11 139   26 3     5   41   567 605         452       1172
703811 ID     school 1602970 52   SNAKE RIVER DISTRICT 160297000521 32 SNAKE RIVER HIGH SCHOOL   Regular School No High 09 12 2021   grade_12 94 0 19   0 0     0   2   66 49             20         115 94 0 19   0 0     0   2   66 49         20       115
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
704126 ID     school 1600002 84   LAKE PEND OREILLE SCHOOL DISTRICT 160000200614 401 HOPE ELEMENTARY SCHOOL   Regular School No Elementary PK 06 2021   k_12_total 94 0 3   0 0     2   2   61 40             45         101 94 0 3   0 0     2   2   61 40         45       101
704500 ID     school 1600420 101   BOUNDARY COUNTY DISTRICT 160042000089 57 BONNERS FERRY HIGH SCHOOL   Regular School No High 09 12 2021   grade_12 94 0 7   1 2     0   2   47 59             44         106 94 0 7   1 2     0   2   47 59         44       106
705349 ID     school 1601110 215   FREMONT COUNTY JOINT DISTRICT 160111000205 99 SOUTH FREMONT HIGH SCHOOL   Regular School No High 09 12 2021   grade_10 94 0 28   0 0     1   2   66 59             52         125 94 0 28   0 0     1   2   66 59         52       125
705626 ID     school 1601570 251   JEFFERSON COUNTY JOINT DISTRICT 160157001001 1110 SOUTH FORK ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2021   grade_4 94 0 5   0 1     0   2   46 56             17         102 94 0 5   0 1     0   2   46 56         17       102
705629 ID     school 1601570 251   JEFFERSON COUNTY JOINT DISTRICT 160157001001 1110 SOUTH FORK ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2021   kindergarten 94 0 4   0 0     0   4   50 52             17         102 94 0 4   0 0     0   4   50 52         17       102
706875 ID     school 1603240 411   TWIN FALLS DISTRICT 160324001076 1382 ROCK CREEK ELEMENTARY   Regular School No Elementary KG 05 2021   grade_4 94 1 17   0 0     0   2   53 61             29         114 94 1 17   0 0     0   2   53 61         29       114
703422 ID     school 1602100 2   JOINT SCHOOL DISTRICT NO. 2 160210001081 1383 HILLSDALE ELEMENTARY   Regular School No Elementary PK 05 2021   grade_3 93 1 2   1 0     0   6   50 53             13         103 93 1 2   1 0     0   6   50 53         13       103
704501 ID     school 1600420 101   BOUNDARY COUNTY DISTRICT 160042000089 57 BONNERS FERRY HIGH SCHOOL   Regular School No High 09 12 2021   grade_9 93 0 7   2 0     0   6   53 55             50         108 93 0 7   2 0     0   6   53 55         50       108
705352 ID     school 1601110 215   FREMONT COUNTY JOINT DISTRICT 160111000205 99 SOUTH FREMONT HIGH SCHOOL   Regular School No High 09 12 2021   grade_9 93 1 20   0 1     0   2   61 56             70         117 93 1 20   0 1     0   2   61 56         70       117
706177 ID     school 1601620 304   KAMIAH JOINT DISTRICT 160162000458 232 KAMIAH MIDDLE SCHOOL   Regular School No Middle 04 08 2021   k_12_total 93 0 13   28 0     0   13   82 65             55         147 93 0 13   28 0     0   13   82 65         55       147
706315 ID     school 1603090 322   SUGAR-SALEM JOINT DISTRICT 160309000537 781 CENTRAL ELEMENTARY SCHOOL   Regular School No Elementary PK 03 2021   grade_3 93 2 5   0 0     0   1   51 50             44         101 93 2 5   0 0     0   1   51 50         44       101
707056 ID     school 1603330 431   WEISER DISTRICT 160333000568 192 WEISER HIGH SCHOOL   Regular School No High 09 12 2021   grade_11 93 1 35   0 1     0   1   60 71             *         131 93 1 35   0 1     0   1   60 71                 131
704349 ID     school 1600930 93   BONNEVILLE JOINT DISTRICT 160093000024 200 HILLCREST HIGH SCHOOL   Regular School No High 09 12 2021   k_12_total 926 6 132   3 10     4   43   588 536             241         1124 926 6 132   3 10     4   43   588 536         241       1124
703915 ID     school 1600030 58   ABERDEEN DISTRICT 160003000828 298 ABERDEEN ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2021   k_12_total 92 2 196   1 0     0   3   135 159             *         294 92 2 196   1 0     0   3   135 159                 294
704561 ID     school 1602340 131   NAMPA SCHOOL DISTRICT 160234000422 61 WEST MIDDLE SCHOOL   Regular School No Middle 06 08 2021   grade_7 92 1 81   0 2     1   6   101 82             113         183 92 1 81   0 2     1   6   101 82         113       183
705762 ID     school 1600780 271   COEUR D'ALENE DISTRICT 160078000799 217 SKYWAY ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2021   grade_4 92 0 9   1 1     0   6   61 48             22         109 92 0 9   1 1     0   6   61 48         22       109
706869 ID     school 1603240 411   TWIN FALLS DISTRICT 160324001075 1381 PILLAR FALLS ELEMENTARY   Regular School No Elementary PK 05 2021   grade_5 92 2 12   0 2     0   2   47 63             25         110 92 2 12   0 2     0   2   47 63         25       110
706967 ID     school 1601410 415   HANSEN DISTRICT 160141000757 620 HANSEN JR/SR HIGH SCHOOL   Regular School No High 07 12 2021   k_12_total 92 2 59   1 0     0   1   69 86             105         155 92 2 59   1 0     0   1   69 86         105       155
707523 ID     school 1600173 491   COEUR D'ALENE CHARTER ACADEMY, INC. 160017300765 1370 COEUR D'ALENE CHARTER ACADEMY SCHOOL   Regular School Yes High 06 12 2021   grade_8 92 0 3   0 2     0   7   37 67             10         104 92 0 3   0 2     0   7   37 67         10       104
704190 ID     school 1601530 91   IDAHO FALLS DISTRICT 160153000262 54 IDAHO FALLS SENIOR HIGH SCHOOL   Regular School No High 09 12 2021   k_12_total 917 7 191   5 12     2   37   610 561             226         1171 917 7 191   5 12     2   37   610 561         226       1171
703423 ID     school 1602100 2   JOINT SCHOOL DISTRICT NO. 2 160210001081 1383 HILLSDALE ELEMENTARY   Regular School No Elementary PK 05 2021   grade_4 91 1 7   0 0     0   9   59 49             9         108 91 1 7   0 0     0   9   59 49         9       108
704560 ID     school 1602340 131   NAMPA SCHOOL DISTRICT 160234000422 61 WEST MIDDLE SCHOOL   Regular School No Middle 06 08 2021   grade_6 91 0 87   0 0     1   9   103 85             118         188 91 0 87   0 0     1   9   103 85         118       188
705345 ID     school 1601110 215   FREMONT COUNTY JOINT DISTRICT 160111000625 98 SOUTH FREMONT JR HIGH   Regular School No Middle 06 08 2021   grade_6 91 0 28   0 1     1   1   63 59             74         122 91 0 28   0 1     1   1   63 59         74       122
705642 ID     school 1601570 251   JEFFERSON COUNTY JOINT DISTRICT 160157001128 1437 COTTONWOOD ELEMENTARY   Regular School No Elementary KG 05 2021   grade_4 91 2 17   0 0     0   1   54 57             33         111 91 2 17   0 0     0   1   54 57         33       111
706146 ID     school 1603030 292   SOUTH LEMHI DISTRICT 160303000528 137 LEADORE SCHOOL   Regular School No Other PK 12 2021   k_12_total 91 1 3   0 0     0   4   46 53             *         99 91 1 3   0 0     0   4   46 53                 99
704290 ID     school 1601530 91   IDAHO FALLS DISTRICT 160153000725 668 SUNNYSIDE ELEMENTARY SCHOOL   Regular School No Elementary PK 06 2021   grade_6 90 0 7   0 0     0   1   47 51             *         98 90 0 7   0 0     0   1   47 51                 98
704812 ID     school 1602130 134   MIDDLETON DISTRICT 160213000376 453 MIDDLETON MILL CREEK ELEMENTARY   Regular School No Elementary PK 05 2021   grade_5 90 1 12   2 1     0   1   57 50             18         107 90 1 12   2 1     0   1   57 50         18       107
706317 ID     school 1603090 322   SUGAR-SALEM JOINT DISTRICT 160309000537 781 CENTRAL ELEMENTARY SCHOOL   Regular School No Elementary PK 03 2021   kindergarten 90 1 7   0 0     1   0   42 57             43         99 90 1 7   0 0     1   0   42 57         43       99
707722 ID     school 1600152 555   CANYON-OWYHEE SCHOOL SERVICE AGENCY (COSSA) 160015200304 1291 COSSA ACADEMY   Alternative School No High 07 12 2021   k_12_total 90 0 39   0 0     0   1   80 50             75         130 90 0 39   0 0     0   1   80 50         75       130
703518 ID     school 1602060 11   MEADOWS VALLEY DISTRICT 160206000826 342 MEADOWS VALLEY SCHOOL   Regular School No Other PK 12 2021   grade_3 9 0 3   0 0     0   0   8 4             7         12 9 0 3   0 0     0   0   8 4         7       12
703526 ID     school 1602060 11   MEADOWS VALLEY DISTRICT 160206000826 342 MEADOWS VALLEY SCHOOL   Regular School No Other PK 12 2021   kindergarten 9 0 3   0 0     0   0   4 8             6         12 9 0 3   0 0     0   0   4 8         6       12
703552 ID     school 1601950 21   MARSH VALLEY JOINT DISTRICT 160195000346 349 LAVA ELEMENTARY SCHOOL   Regular School No Elementary PK 06 2021   grade_3 9 0 0   0 0     0   0   6 3             *         9 9 0 0   0 0     0   0   6 3                 9
703563 ID     school 1601950 21   MARSH VALLEY JOINT DISTRICT 160195000344 350 DOWNEY ELEMENTARY SCHOOL   Regular School No Elementary PK 06 2021   grade_6 9 0 1   0 0     0   0   9 1             *         10 9 0 1   0 0     0   0   9 1                 10
703565 ID     school 1601950 21   MARSH VALLEY JOINT DISTRICT 160195000344 350 DOWNEY ELEMENTARY SCHOOL   Regular School No Elementary PK 06 2021   kindergarten 9 0 1   0 0     0   0   6 4             *         10 9 0 1   0 0     0   0   6 4                 10
703779 ID     school 1603060 41   ST MARIES JOINT DISTRICT 160306000536 374 UPRIVER ELEMENTARY SCHOOL   Regular School No Elementary KG 06 2021   grade_2 9 0 0   0 0     0   0   2 7             *         9 9 0 0   0 0     0   0   2 7                 9
703782 ID     school 1603060 41   ST MARIES JOINT DISTRICT 160306000536 374 UPRIVER ELEMENTARY SCHOOL   Regular School No Elementary KG 06 2021   grade_5 9 0 0   1 0     0   0   5 5             *         10 9 0 0   1 0     0   0   5 5                 10
703785 ID     school 1603060 41   ST MARIES JOINT DISTRICT 160306000536 374 UPRIVER ELEMENTARY SCHOOL   Regular School No Elementary KG 06 2021   kindergarten 9 0 0   0 0     0   0   4 5             *         9 9 0 0   0 0     0   0   4 5                 9
703805 ID     school 1600815 44   PLUMMER-WORLEY JOINT DISTRICT 160081500719 752 LAKESIDE ELEMENTARY SCHOOL   Regular School No Elementary PK 06 2021   kindergarten 9 0 4   12 0     0   4   16 13             15         29 9 0 4   12 0     0   4   16 13         15       29
703849 ID     school 1600270 55   BLACKFOOT DISTRICT 160027000031 382 DONALD D STALKER ELEMENTARY   Regular School No Elementary PK 05 2021   grade_4 9 0 11   4 0     0   1   12 13             10         25 9 0 11   4 0     0   1   12 13         10       25
703890 ID     school 1600270 55   BLACKFOOT DISTRICT 160027001138 1452 BLACKFOOT ONLINE SCHOOL SOLUTION   Regular School No Elementary KG 08 2021   grade_3 9 0 6   3 0     0   0   10 8             9         18 9 0 6   3 0     0   0   10 8         9       18
704052 ID     school 1601500 73   HORSESHOE BEND SCHOOL DISTRICT 160150000506 256 HORSESHOE BEND ELEMENTARY   Regular School No Elementary PK 05 2021   grade_3 9 0 0   0 0     0   2   5 6             6         11 9 0 0   0 0     0   2   5 6         6       11
704078 ID     school 1600001 83   WEST BONNER COUNTY DISTRICT 160000100620 406 PRIEST LAKE ELEMENTARY SCHOOL   Regular School No Elementary PK 06 2021   grade_6 9 0 0   0 0     0   0   5 4             *         9 9 0 0   0 0     0   0   5 4                 9
704120 ID     school 1600002 84   LAKE PEND OREILLE SCHOOL DISTRICT 160000200614 401 HOPE ELEMENTARY SCHOOL   Regular School No Elementary PK 06 2021   grade_1 9 0 0   0 0     0   1   6 4             5         10 9 0 0   0 0     0   1   6 4         5       10
704174 ID     school 1600002 84   LAKE PEND OREILLE SCHOOL DISTRICT 160000200691 1045 LAKE PEND OREILLE HIGH SCHOOL   Alternative School No High 09 12 2021   grade_9 9 0 0   0 0     0   1   3 7             *         10 9 0 0   0 0     0   1   3 7                 10
704328 ID     school 1603120 92   SWAN VALLEY ELEMENTARY DISTRICT 160312000541 424 SWAN VALLEY ELEMENTARY SCHOOL   Regular School No Elementary PK 08 2021   grade_7 9 0 0   0 0     0   0   5 4             *         9 9 0 0   0 0     0   0   5 4                 9
704331 ID     school 1603120 92   SWAN VALLEY ELEMENTARY DISTRICT 160312000541 424 SWAN VALLEY ELEMENTARY SCHOOL   Regular School No Elementary PK 08 2021   kindergarten 9 0 0   0 0     0   0   4 5             *         9 9 0 0   0 0     0   0   4 5                 9
704547 ID     school 1600540 121   CAMAS COUNTY DISTRICT 160054000111 60 CAMAS COUNTY HIGH SCHOOL   Regular School No High 09 12 2021   grade_12 9 0 2   0 0     0   0   6 5             5         11 9 0 2   0 0     0   0   6 5         5       11
704554 ID     school 1600540 121   CAMAS COUNTY DISTRICT 160054000110 440 CAMAS COUNTY ELEM/JR HIGH SCHOOL   Regular School No Elementary PK 08 2021   grade_5 9 0 0   0 0     0   0   4 5             *         9 9 0 0   0 0     0   0   4 5                 9
704559 ID     school 1600540 121   CAMAS COUNTY DISTRICT 160054000110 440 CAMAS COUNTY ELEM/JR HIGH SCHOOL   Regular School No Elementary PK 08 2021   kindergarten 9 0 1   0 0     0   0   6 4             *         10 9 0 1   0 0     0   0   6 4                 10
704715 ID     school 1602340 131   NAMPA SCHOOL DISTRICT 160234000941 2889 NEW HORIZON MAGNET SCHOOL   Regular School No Elementary KG 07 2021   kindergarten 9 0 85   0 0     0   0   52 42             45         94 9 0 85   0 0     0   0   52 42         45       94
704764 ID     school 1600510 132   CALDWELL DISTRICT 160051000731 457 SACAJAWEA ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2021   grade_1 9 0 55   1 0     0   2   34 33             34         67 9 0 55   1 0     0   2   34 33         34       67
704788 ID     school 1603480 133   WILDER DISTRICT 160348000585 452 WILDER ELEMENTARY SCHOOL   Regular School No Elementary KG 05 2021   grade_1 9 0 18   0 0     0   2   13 16             *         29 9 0 18   0 0     0   2   13 16                 29
704789 ID     school 1603480 133   WILDER DISTRICT 160348000585 452 WILDER ELEMENTARY SCHOOL   Regular School No Elementary KG 05 2021   grade_2 9 0 27   0 0     0   2   19 19             *         38 9 0 27   0 0     0   2   19 19                 38
704790 ID     school 1603480 133   WILDER DISTRICT 160348000585 452 WILDER ELEMENTARY SCHOOL   Regular School No Elementary KG 05 2021   grade_3 9 0 25   0 0     0   1   23 12             *         35 9 0 25   0 0     0   1   23 12                 35
704797 ID     school 1603480 133   WILDER DISTRICT 160348001091 1389 WILDER MIDDLE SCHOOL   Regular School No Middle 06 08 2021   grade_8 9 0 18   0 0     0   0   14 13             *         27 9 0 18   0 0     0   0   14 13                 27
704832 ID     school 1602130 134   MIDDLETON DISTRICT 160213000777 1168 MIDDLETON ACADEMY   Alternative School No High 07 12 2021   grade_9 9 0 2   0 0     0   0   9 2             6         11 9 0 2   0 0     0   0   9 2         6       11
704978 ID     school 1602430 149   NORTH GEM DISTRICT 160243000428 77 NORTH GEM HIGH SCHOOL   Regular School No High 07 12 2021   grade_9 9 0 0   0 0     0   0   3 6             *         9 9 0 0   0 0     0   0   3 6                 9
705100 ID     school 1600660 151   CASSIA COUNTY JOINT DISTRICT 160066000122 475 ALBION ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2021   grade_2 9 0 0   0 0     0   0   6 3             *         9 9 0 0   0 0     0   0   6 3                 9
705103 ID     school 1600660 151   CASSIA COUNTY JOINT DISTRICT 160066000122 475 ALBION ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2021   grade_5 9 0 0   0 0     0   0   5 4             *         9 9 0 0   0 0     0   0   5 4                 9
705125 ID     school 1600660 151   CASSIA COUNTY JOINT DISTRICT 160066001141 1441 MINI-CASSIA ONLINE LEARNING ACADEMY   Regular School No Other KG 12 2021   grade_2 9 0 4   0 0     0   1   6 8             *         14 9 0 4   0 0     0   1   6 8                 14
705128 ID     school 1600660 151   CASSIA COUNTY JOINT DISTRICT 160066001141 1441 MINI-CASSIA ONLINE LEARNING ACADEMY   Regular School No Other KG 12 2021   grade_5 9 0 6   0 0     0   0   8 7             *         15 9 0 6   0 0     0   0   8 7                 15
705130 ID     school 1600660 151   CASSIA COUNTY JOINT DISTRICT 160066001141 1441 MINI-CASSIA ONLINE LEARNING ACADEMY   Regular School No Other KG 12 2021   grade_7 9 0 7   0 0     0   0   9 7             *         16 9 0 7   0 0     0   0   9 7                 16

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