Data source: Big Local News · About: Big Local

4,737 rows where state = "ID" and year = 2018 sorted by ccd_school_low_grade

View and edit SQL

grade

year

  • 2018 · 4,737
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
1277602 ID     school   92   SWAN VALLEY ELEMENTARY DISTRICT   1014 BORDER DISTRICT - STAR VALLEY ELEMENTARY SCHOOL             2018   grade_8 1 0 0   0 0     0   0   0 1             *         1 1 0 0   0 0     0   0   0 1                 1
1277603 ID     school   92   SWAN VALLEY ELEMENTARY DISTRICT   1014 BORDER DISTRICT - STAR VALLEY ELEMENTARY SCHOOL             2018   k_12_total 1 0 0   0 0     0   0   0 1             *         1 1 0 0   0 0     0   0   0 1                 1
1277604 ID     school   92   SWAN VALLEY ELEMENTARY DISTRICT   1015 BORDER DISTRICT - STAR VALLEY JR-SR HIGH SCHOOL             2018   grade_10 2 0 0   0 0     0   0   1 1             *         2 2 0 0   0 0     0   0   1 1                 2
1277605 ID     school   92   SWAN VALLEY ELEMENTARY DISTRICT   1015 BORDER DISTRICT - STAR VALLEY JR-SR HIGH SCHOOL             2018   grade_12 1 0 0   0 0     0   0   0 1             *         1 1 0 0   0 0     0   0   0 1                 1
1277606 ID     school   92   SWAN VALLEY ELEMENTARY DISTRICT   1015 BORDER DISTRICT - STAR VALLEY JR-SR HIGH SCHOOL             2018   k_12_total 3 0 0   0 0     0   0   1 2             *         3 3 0 0   0 0     0   0   1 2                 3
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
1278265 ID     school   150   SODA SPRINGS JOINT DISTRICT   1025 BORDER DISTRICT - FREEDOM ELEMENTARY             2018   grade_3 1 0 0   0 0     0   0   0 1             *         1 1 0 0   0 0     0   0   0 1                 1
1278266 ID     school   150   SODA SPRINGS JOINT DISTRICT   1025 BORDER DISTRICT - FREEDOM ELEMENTARY             2018   grade_4 1 0 1   0 0     0   0   0 2             *         2 1 0 1   0 0     0   0   0 2                 2
1278267 ID     school   150   SODA SPRINGS JOINT DISTRICT   1025 BORDER DISTRICT - FREEDOM ELEMENTARY             2018   grade_5 2 0 0   0 0     0   0   2 0             *         2 2 0 0   0 0     0   0   2 0                 2
1278268 ID     school   150   SODA SPRINGS JOINT DISTRICT   1025 BORDER DISTRICT - FREEDOM ELEMENTARY             2018   grade_6 1 0 0   0 0     0   0   1 0             *         1 1 0 0   0 0     0   0   1 0                 1
1278269 ID     school   150   SODA SPRINGS JOINT DISTRICT   1025 BORDER DISTRICT - FREEDOM ELEMENTARY             2018   k_12_total 7 0 1   0 0     0   0   4 4             *         8 7 0 1   0 0     0   0   4 4                 8
1278270 ID     school   150   SODA SPRINGS JOINT DISTRICT   1025 BORDER DISTRICT - FREEDOM ELEMENTARY             2018   kindergarten 1 0 0   0 0     0   0   0 1             *         1 1 0 0   0 0     0   0   0 1                 1
1278271 ID     school   150   SODA SPRINGS JOINT DISTRICT   1026 BORDER DISTRICT FREEDOM - SECONDARY             2018   grade_11 1 0 2   0 0     0   0   2 1             *         3 1 0 2   0 0     0   0   2 1                 3
1278272 ID     school   150   SODA SPRINGS JOINT DISTRICT   1026 BORDER DISTRICT FREEDOM - SECONDARY             2018   grade_7 1 0 1   0 0     0   0   1 1             *         2 1 0 1   0 0     0   0   1 1                 2
1278273 ID     school   150   SODA SPRINGS JOINT DISTRICT   1026 BORDER DISTRICT FREEDOM - SECONDARY             2018   grade_8 0 0 2   0 0     0   0   2 0             *         2 0 0 2   0 0     0   0   2 0                 2
1278274 ID     school   150   SODA SPRINGS JOINT DISTRICT   1026 BORDER DISTRICT FREEDOM - SECONDARY             2018   grade_9 2 0 0   0 0     0   0   2 0             *         2 2 0 0   0 0     0   0   2 0                 2
1278275 ID     school   150   SODA SPRINGS JOINT DISTRICT   1026 BORDER DISTRICT FREEDOM - SECONDARY             2018   k_12_total 4 0 5   0 0     0   0   7 2             *         9 4 0 5   0 0     0   0   7 2                 9
1279732 ID     school   364   PLEASANT VALLEY ELEMENTARY DISTRICT   1056 BORDER DISTRICT - JORDAN VALLEY SECONDARY             2018   grade_11 1 0 0   0 0     0   0   0 1             *         1 1 0 0   0 0     0   0   0 1                 1
1279733 ID     school   364   PLEASANT VALLEY ELEMENTARY DISTRICT   1056 BORDER DISTRICT - JORDAN VALLEY SECONDARY             2018   k_12_total 1 0 0   0 0     0   0   0 1             *         1 1 0 0   0 0     0   0   0 1                 1
1280509 ID     school   470   THE KOOTENAI BRIDGE ACADEMY, INC.   2523 KOOTENAI BRIDGE ACADEMY (SUMMER)             2018   grade_11 3 0 0   0 0     0   0   1 2             *         3 3 0 0   0 0     0   0   1 2                 3
1280510 ID     school   470   THE KOOTENAI BRIDGE ACADEMY, INC.   2523 KOOTENAI BRIDGE ACADEMY (SUMMER)             2018   k_12_total 3 0 0   0 0     0   0   1 2             *         3 3 0 0   0 0     0   0   1 2                 3
1277030 ID     school 1602640 25   POCATELLO DISTRICT 160264000186 9034 POCATELLO JUVENILE DETENTION   Alternative School No Other 01 12.0 2018   grade_10 1 0 1   0 0     0   0   2 0             *         2 1 0 1   0 0     0   0   2 0                 2
1277031 ID     school 1602640 25   POCATELLO DISTRICT 160264000186 9034 POCATELLO JUVENILE DETENTION   Alternative School No Other 01 12.0 2018   grade_11 0 0 1   1 0     0   0   2 0             *         2 0 0 1   1 0     0   0   2 0                 2
1277032 ID     school 1602640 25   POCATELLO DISTRICT 160264000186 9034 POCATELLO JUVENILE DETENTION   Alternative School No Other 01 12.0 2018   k_12_total 1 0 2   1 0     0   0   4 0             *         4 1 0 2   1 0     0   0   4 0                 4
1278021 ID     school 1600510 132   CALDWELL DISTRICT 160051000043 1087 SOUTHWEST IDAHO JUVENILE DETENTION   Alternative School No Other 01 12.0 2018   grade_10 3 0 5   0 0     0   1   6 3             *         9 3 0 5   0 0     0   1   6 3                 9
1278022 ID     school 1600510 132   CALDWELL DISTRICT 160051000043 1087 SOUTHWEST IDAHO JUVENILE DETENTION   Alternative School No Other 01 12.0 2018   grade_11 5 0 1   0 0     0   1   6 1             *         7 5 0 1   0 0     0   1   6 1                 7
1278023 ID     school 1600510 132   CALDWELL DISTRICT 160051000043 1087 SOUTHWEST IDAHO JUVENILE DETENTION   Alternative School No Other 01 12.0 2018   grade_12 6 0 3   0 1     0   1   9 2             *         11 6 0 3   0 1     0   1   9 2                 11
1278024 ID     school 1600510 132   CALDWELL DISTRICT 160051000043 1087 SOUTHWEST IDAHO JUVENILE DETENTION   Alternative School No Other 01 12.0 2018   grade_8 0 0 2   0 0     0   0   0 2             *         2 0 0 2   0 0     0   0   0 2                 2
1278025 ID     school 1600510 132   CALDWELL DISTRICT 160051000043 1087 SOUTHWEST IDAHO JUVENILE DETENTION   Alternative School No Other 01 12.0 2018   grade_9 5 0 0   0 0     0   1   4 2             *         6 5 0 0   0 0     0   1   4 2                 6
1278026 ID     school 1600510 132   CALDWELL DISTRICT 160051000043 1087 SOUTHWEST IDAHO JUVENILE DETENTION   Alternative School No Other 01 12.0 2018   k_12_total 19 0 11   0 1     0   4   25 10             10         35 19 0 11   0 1     0   4   25 10         10       35
1278218 ID     school 1601290 148   GRACE JOINT DISTRICT 160129000228 462 THATCHER ELEMENTARY SCHOOL   Regular School No Elementary 01 5.0 2018   grade_1 18 0 1   0 0     0   0   13 6             12         19 18 0 1   0 0     0   0   13 6         12       19
1278219 ID     school 1601290 148   GRACE JOINT DISTRICT 160129000228 462 THATCHER ELEMENTARY SCHOOL   Regular School No Elementary 01 5.0 2018   grade_2 24 0 0   0 0     0   0   9 15             14         24 24 0 0   0 0     0   0   9 15         14       24
1278220 ID     school 1601290 148   GRACE JOINT DISTRICT 160129000228 462 THATCHER ELEMENTARY SCHOOL   Regular School No Elementary 01 5.0 2018   grade_3 13 0 0   0 0     0   0   10 3             7         13 13 0 0   0 0     0   0   10 3         7       13
1278221 ID     school 1601290 148   GRACE JOINT DISTRICT 160129000228 462 THATCHER ELEMENTARY SCHOOL   Regular School No Elementary 01 5.0 2018   grade_4 25 0 0   0 0     0   0   12 13             10         25 25 0 0   0 0     0   0   12 13         10       25
1278222 ID     school 1601290 148   GRACE JOINT DISTRICT 160129000228 462 THATCHER ELEMENTARY SCHOOL   Regular School No Elementary 01 5.0 2018   grade_5 21 0 3   0 0     0   0   16 8             15         24 21 0 3   0 0     0   0   16 8         15       24
1278223 ID     school 1601290 148   GRACE JOINT DISTRICT 160129000228 462 THATCHER ELEMENTARY SCHOOL   Regular School No Elementary 01 5.0 2018   k_12_total 101 0 4   0 0     0   0   60 45             58         105 101 0 4   0 0     0   0   60 45         58       105
1279132 ID     school 1602670 273   POST FALLS DISTRICT 160267000209 736 PRAIRIE VIEW ELEMENTARY   Regular School No Elementary 01 5.0 2018   grade_1 71 1 4   1 0     0   4   38 43             35         81 71 1 4   1 0     0   4   38 43         35       81
1279133 ID     school 1602670 273   POST FALLS DISTRICT 160267000209 736 PRAIRIE VIEW ELEMENTARY   Regular School No Elementary 01 5.0 2018   grade_2 82 1 7   0 1     0   4   47 48             38         95 82 1 7   0 1     0   4   47 48         38       95
1279134 ID     school 1602670 273   POST FALLS DISTRICT 160267000209 736 PRAIRIE VIEW ELEMENTARY   Regular School No Elementary 01 5.0 2018   grade_3 77 0 7   0 1     0   4   37 52             44         89 77 0 7   0 1     0   4   37 52         44       89
1279135 ID     school 1602670 273   POST FALLS DISTRICT 160267000209 736 PRAIRIE VIEW ELEMENTARY   Regular School No Elementary 01 5.0 2018   grade_4 72 1 5   1 0     0   3   37 45             30         82 72 1 5   1 0     0   3   37 45         30       82
1279136 ID     school 1602670 273   POST FALLS DISTRICT 160267000209 736 PRAIRIE VIEW ELEMENTARY   Regular School No Elementary 01 5.0 2018   grade_5 81 0 10   0 1     0   4   49 47             41         96 81 0 10   0 1     0   4   49 47         41       96
1279137 ID     school 1602670 273   POST FALLS DISTRICT 160267000209 736 PRAIRIE VIEW ELEMENTARY   Regular School No Elementary 01 5.0 2018   k_12_total 383 3 33   2 3     0   19   208 235             188         443 383 3 33   2 3     0   19   208 235         188       443
1279138 ID     school 1602670 273   POST FALLS DISTRICT 160267000487 748 PONDEROSA ELEMENTARY SCHOOL   Regular School No Elementary 01 5.0 2018   grade_1 87 0 6   0 0     1   0   58 36             57         94 87 0 6   0 0     1   0   58 36         57       94
1279139 ID     school 1602670 273   POST FALLS DISTRICT 160267000487 748 PONDEROSA ELEMENTARY SCHOOL   Regular School No Elementary 01 5.0 2018   grade_2 75 0 4   0 0     0   3   38 44             50         82 75 0 4   0 0     0   3   38 44         50       82
1279140 ID     school 1602670 273   POST FALLS DISTRICT 160267000487 748 PONDEROSA ELEMENTARY SCHOOL   Regular School No Elementary 01 5.0 2018   grade_3 75 0 10   0 1     0   5   37 54             53         91 75 0 10   0 1     0   5   37 54         53       91
1279141 ID     school 1602670 273   POST FALLS DISTRICT 160267000487 748 PONDEROSA ELEMENTARY SCHOOL   Regular School No Elementary 01 5.0 2018   grade_4 83 2 4   0 0     0   2   52 39             49         91 83 2 4   0 0     0   2   52 39         49       91
1279142 ID     school 1602670 273   POST FALLS DISTRICT 160267000487 748 PONDEROSA ELEMENTARY SCHOOL   Regular School No Elementary 01 5.0 2018   grade_5 70 1 10   3 0     0   4   51 37             48         88 70 1 10   3 0     0   4   51 37         48       88
1279143 ID     school 1602670 273   POST FALLS DISTRICT 160267000487 748 PONDEROSA ELEMENTARY SCHOOL   Regular School No Elementary 01 5.0 2018   k_12_total 390 3 34   3 1     1   14   236 210             257         446 390 3 34   3 1     1   14   236 210         257       446
1279144 ID     school 1602670 273   POST FALLS DISTRICT 160267000490 749 SELTICE ELEMENTARY SCHOOL   Regular School No Elementary 01 5.0 2018   grade_1 49 0 3   1 0     1   3   30 27             32         57 49 0 3   1 0     1   3   30 27         32       57
1279145 ID     school 1602670 273   POST FALLS DISTRICT 160267000490 749 SELTICE ELEMENTARY SCHOOL   Regular School No Elementary 01 5.0 2018   grade_2 56 0 5   0 0     1   4   26 40             34         66 56 0 5   0 0     1   4   26 40         34       66
1279146 ID     school 1602670 273   POST FALLS DISTRICT 160267000490 749 SELTICE ELEMENTARY SCHOOL   Regular School No Elementary 01 5.0 2018   grade_3 68 0 3   0 1     0   3   41 34             41         75 68 0 3   0 1     0   3   41 34         41       75
1279147 ID     school 1602670 273   POST FALLS DISTRICT 160267000490 749 SELTICE ELEMENTARY SCHOOL   Regular School No Elementary 01 5.0 2018   grade_4 45 1 4   0 0     0   0   23 27             22         50 45 1 4   0 0     0   0   23 27         22       50
1279148 ID     school 1602670 273   POST FALLS DISTRICT 160267000490 749 SELTICE ELEMENTARY SCHOOL   Regular School No Elementary 01 5.0 2018   grade_5 63 0 4   0 1     1   2   33 38             40         71 63 0 4   0 1     1   2   33 38         40       71
1279149 ID     school 1602670 273   POST FALLS DISTRICT 160267000490 749 SELTICE ELEMENTARY SCHOOL   Regular School No Elementary 01 5.0 2018   k_12_total 281 1 19   1 2     3   12   153 166             169         319 281 1 19   1 2     3   12   153 166         169       319
1279157 ID     school 1602670 273   POST FALLS DISTRICT 160267001085 1388 GREENSFERRY ELEMENTARY SCHOOL   Regular School No Elementary 01 5.0 2018   grade_1 60 0 8   0 2     0   3   39 34             31         73 60 0 8   0 2     0   3   39 34         31       73
1279158 ID     school 1602670 273   POST FALLS DISTRICT 160267001085 1388 GREENSFERRY ELEMENTARY SCHOOL   Regular School No Elementary 01 5.0 2018   grade_2 65 0 3   1 0     0   2   34 37             26         71 65 0 3   1 0     0   2   34 37         26       71
1279159 ID     school 1602670 273   POST FALLS DISTRICT 160267001085 1388 GREENSFERRY ELEMENTARY SCHOOL   Regular School No Elementary 01 5.0 2018   grade_3 60 0 8   2 0     0   6   33 43             29         76 60 0 8   2 0     0   6   33 43         29       76
1279160 ID     school 1602670 273   POST FALLS DISTRICT 160267001085 1388 GREENSFERRY ELEMENTARY SCHOOL   Regular School No Elementary 01 5.0 2018   grade_4 60 0 2   0 0     0   1   27 36             17         63 60 0 2   0 0     0   1   27 36         17       63
1279161 ID     school 1602670 273   POST FALLS DISTRICT 160267001085 1388 GREENSFERRY ELEMENTARY SCHOOL   Regular School No Elementary 01 5.0 2018   grade_5 73 0 4   2 0     0   2   47 34             27         81 73 0 4   2 0     0   2   47 34         27       81
1279162 ID     school 1602670 273   POST FALLS DISTRICT 160267001085 1388 GREENSFERRY ELEMENTARY SCHOOL   Regular School No Elementary 01 5.0 2018   k_12_total 318 0 25   5 2     0   14   180 184             130         364 318 0 25   5 2     0   14   180 184         130       364
1279163 ID     school 1602670 273   POST FALLS DISTRICT 160267000970 2517 WEST RIDGE ELEMENTARY SCHOOL   Regular School No Elementary 01 5.0 2018   grade_1 66 1 6   0 0     0   8   40 41             43         81 66 1 6   0 0     0   8   40 41         43       81
1279164 ID     school 1602670 273   POST FALLS DISTRICT 160267000970 2517 WEST RIDGE ELEMENTARY SCHOOL   Regular School No Elementary 01 5.0 2018   grade_2 67 0 3   1 0     0   3   39 35             35         74 67 0 3   1 0     0   3   39 35         35       74
1279165 ID     school 1602670 273   POST FALLS DISTRICT 160267000970 2517 WEST RIDGE ELEMENTARY SCHOOL   Regular School No Elementary 01 5.0 2018   grade_3 79 3 8   0 1     1   5   54 43             45         97 79 3 8   0 1     1   5   54 43         45       97
1279166 ID     school 1602670 273   POST FALLS DISTRICT 160267000970 2517 WEST RIDGE ELEMENTARY SCHOOL   Regular School No Elementary 01 5.0 2018   grade_4 81 0 3   0 2     0   4   46 44             38         90 81 0 3   0 2     0   4   46 44         38       90
1279167 ID     school 1602670 273   POST FALLS DISTRICT 160267000970 2517 WEST RIDGE ELEMENTARY SCHOOL   Regular School No Elementary 01 5.0 2018   grade_5 99 1 5   0 1     0   2   55 53             49         108 99 1 5   0 1     0   2   55 53         49       108
1279168 ID     school 1602670 273   POST FALLS DISTRICT 160267000970 2517 WEST RIDGE ELEMENTARY SCHOOL   Regular School No Elementary 01 5.0 2018   k_12_total 392 5 25   1 4     1   22   234 216             210         450 392 5 25   1 4     1   22   234 216         210       450
1280037 ID     school 1603240 411   TWIN FALLS DISTRICT 160324000739 1260 SNAKE RIVER JUVENILE DETENTION   Alternative School No Other 01 12.0 2018   grade_10 1 0 0   0 0     0   0   1 0             *         1 1 0 0   0 0     0   0   1 0                 1
1280038 ID     school 1603240 411   TWIN FALLS DISTRICT 160324000739 1260 SNAKE RIVER JUVENILE DETENTION   Alternative School No Other 01 12.0 2018   grade_11 1 0 0   0 0     0   0   1 0             *         1 1 0 0   0 0     0   0   1 0                 1
1280039 ID     school 1603240 411   TWIN FALLS DISTRICT 160324000739 1260 SNAKE RIVER JUVENILE DETENTION   Alternative School No Other 01 12.0 2018   grade_12 3 0 0   0 0     0   0   2 1             *         3 3 0 0   0 0     0   0   2 1                 3
1280040 ID     school 1603240 411   TWIN FALLS DISTRICT 160324000739 1260 SNAKE RIVER JUVENILE DETENTION   Alternative School No Other 01 12.0 2018   grade_8 2 0 0   1 0     0   0   2 1             *         3 2 0 0   1 0     0   0   2 1                 3
1280041 ID     school 1603240 411   TWIN FALLS DISTRICT 160324000739 1260 SNAKE RIVER JUVENILE DETENTION   Alternative School No Other 01 12.0 2018   grade_9 1 0 1   0 0     0   0   2 0             *         2 1 0 1   0 0     0   0   2 0                 2
1280042 ID     school 1603240 411   TWIN FALLS DISTRICT 160324000739 1260 SNAKE RIVER JUVENILE DETENTION   Alternative School No Other 01 12.0 2018   k_12_total 8 0 1   1 0     0   0   8 2             *         10 8 0 1   1 0     0   0   8 2                 10
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
1277121 ID     school 1602970 52   SNAKE RIVER DISTRICT 160297000518 376 RIVERSIDE ELEMENTARY SCHOOL   Regular School No Elementary 02 3.0 2018   grade_3 102 3 20   1 0     0   2   70 58             54         128 102 3 20   1 0     0   2   70 58         54       128
1277122 ID     school 1602970 52   SNAKE RIVER DISTRICT 160297000518 376 RIVERSIDE ELEMENTARY SCHOOL   Regular School No Elementary 02 3.0 2018   k_12_total 216 4 40   3 0     0   3   142 124             116         266 216 4 40   3 0     0   3   142 124         116       266
1277237 ID     school 1602910 60   SHELLEY JOINT DISTRICT 160291001012 1251 RIVERVIEW ELEMENTARY SCHOOL   Regular School No Elementary 03 4.0 2018   grade_3 159 1 25   0 0     0   0   88 97             99         185 159 1 25   0 0     0   0   88 97         99       185
1277238 ID     school 1602910 60   SHELLEY JOINT DISTRICT 160291001012 1251 RIVERVIEW ELEMENTARY SCHOOL   Regular School No Elementary 03 4.0 2018   grade_4 164 0 26   0 1     0   1   111 81             80         192 164 0 26   0 1     0   1   111 81         80       192
1277239 ID     school 1602910 60   SHELLEY JOINT DISTRICT 160291001012 1251 RIVERVIEW ELEMENTARY SCHOOL   Regular School No Elementary 03 4.0 2018   k_12_total 323 1 51   0 1     0   1   199 178             179         377 323 1 51   0 1     0   1   199 178         179       377
1278541 ID     school 1600960 201   PRESTON JOINT DISTRICT 160096000181 497 OAKWOOD ELEMENTARY SCHOOL   Regular School No Elementary 03 5.0 2018   grade_3 149 2 22   2 0     0   0   93 82             99         175 149 2 22   2 0     0   0   93 82         99       175
1278542 ID     school 1600960 201   PRESTON JOINT DISTRICT 160096000181 497 OAKWOOD ELEMENTARY SCHOOL   Regular School No Elementary 03 5.0 2018   grade_4 173 0 17   3 1     0   2   105 91             93         196 173 0 17   3 1     0   2   105 91         93       196
1278543 ID     school 1600960 201   PRESTON JOINT DISTRICT 160096000181 497 OAKWOOD ELEMENTARY SCHOOL   Regular School No Elementary 03 5.0 2018   grade_5 145 1 22   3 1     0   0   90 82             87         172 145 1 22   3 1     0   0   90 82         87       172
1278544 ID     school 1600960 201   PRESTON JOINT DISTRICT 160096000181 497 OAKWOOD ELEMENTARY SCHOOL   Regular School No Elementary 03 5.0 2018   k_12_total 467 3 61   8 2     0   2   288 255             279         543 467 3 61   8 2     0   2   288 255         279       543
1278842 ID     school 1601570 251   JEFFERSON COUNTY JOINT DISTRICT 160157001064 1359 PHILO T FARNSWORTH ELEMENTARY SCHOOL   Regular School No Elementary 03 5.0 2018   grade_3 227 0 17   0 0     0   0   128 116             84         244 227 0 17   0 0     0   0   128 116         84       244
1278843 ID     school 1601570 251   JEFFERSON COUNTY JOINT DISTRICT 160157001064 1359 PHILO T FARNSWORTH ELEMENTARY SCHOOL   Regular School No Elementary 03 5.0 2018   grade_4 220 0 22   0 0     0   4   113 133             81         246 220 0 22   0 0     0   4   113 133         81       246
1278844 ID     school 1601570 251   JEFFERSON COUNTY JOINT DISTRICT 160157001064 1359 PHILO T FARNSWORTH ELEMENTARY SCHOOL   Regular School No Elementary 03 5.0 2018   grade_5 219 0 17   1 0     0   3   128 112             82         240 219 0 17   1 0     0   3   128 112         82       240
1278845 ID     school 1601570 251   JEFFERSON COUNTY JOINT DISTRICT 160157001064 1359 PHILO T FARNSWORTH ELEMENTARY SCHOOL   Regular School No Elementary 03 5.0 2018   k_12_total 666 0 56   1 0     0   7   369 361             247         730 666 0 56   1 0     0   7   369 361         247       730
1279197 ID     school 1602220 281   MOSCOW DISTRICT 160222000391 753 J RUSSELL ELEMENTARY SCHOOL   Regular School No Elementary 03 5.0 2018   grade_3 44 0 5   0 0     0   6   22 33             *         55 44 0 5   0 0     0   6   22 33                 55
1279198 ID     school 1602220 281   MOSCOW DISTRICT 160222000391 753 J RUSSELL ELEMENTARY SCHOOL   Regular School No Elementary 03 5.0 2018   grade_4 47 2 4   1 4     0   4   27 35             29         62 47 2 4   1 4     0   4   27 35         29       62
1279199 ID     school 1602220 281   MOSCOW DISTRICT 160222000391 753 J RUSSELL ELEMENTARY SCHOOL   Regular School No Elementary 03 5.0 2018   grade_5 45 5 4   0 6     0   3   31 32             30         63 45 5 4   0 6     0   3   31 32         30       63
1279200 ID     school 1602220 281   MOSCOW DISTRICT 160222000391 753 J RUSSELL ELEMENTARY SCHOOL   Regular School No Elementary 03 5.0 2018   k_12_total 136 7 13   1 10     0   13   80 100             *         180 136 7 13   1 10     0   13   80 100                 180
1279549 ID     school 1602190 331   MINIDOKA COUNTY JOINT DISTRICT 160219000166 1100 MINI-CASSIA JUVENILE DETENTION CENTER   Alternative School No Other 03 12.0 2018   grade_10 3 0 0   0 0     0   0   3 0             *         3 3 0 0   0 0     0   0   3 0                 3
1279550 ID     school 1602190 331   MINIDOKA COUNTY JOINT DISTRICT 160219000166 1100 MINI-CASSIA JUVENILE DETENTION CENTER   Alternative School No Other 03 12.0 2018   grade_11 1 0 0   0 0     0   0   0 1             *         1 1 0 0   0 0     0   0   0 1                 1
1279551 ID     school 1602190 331   MINIDOKA COUNTY JOINT DISTRICT 160219000166 1100 MINI-CASSIA JUVENILE DETENTION CENTER   Alternative School No Other 03 12.0 2018   grade_12 0 0 1   0 0     0   0   0 1             *         1 0 0 1   0 0     0   0   0 1                 1
1279552 ID     school 1602190 331   MINIDOKA COUNTY JOINT DISTRICT 160219000166 1100 MINI-CASSIA JUVENILE DETENTION CENTER   Alternative School No Other 03 12.0 2018   grade_7 1 0 0   0 0     0   0   1 0             *         1 1 0 0   0 0     0   0   1 0                 1
1279553 ID     school 1602190 331   MINIDOKA COUNTY JOINT DISTRICT 160219000166 1100 MINI-CASSIA JUVENILE DETENTION CENTER   Alternative School No Other 03 12.0 2018   grade_9 2 0 0   0 0     0   0   2 0             *         2 2 0 0   0 0     0   0   2 0                 2
1279554 ID     school 1602190 331   MINIDOKA COUNTY JOINT DISTRICT 160219000166 1100 MINI-CASSIA JUVENILE DETENTION CENTER   Alternative School No Other 03 12.0 2018   k_12_total 7 0 1   0 0     0   0   6 2             *         8 7 0 1   0 0     0   0   6 2                 8
1279643 ID     school 1601860 340   LEWISTON INDEPENDENT DISTRICT 160186000170 1266 REGION 2 JUVENILE DETENTION CENTER   Alternative School No Other 03 12.0 2018   grade_8 0 0 0   3 0     0   0   3 0             *         3 0 0 0   3 0     0   0   3 0                 3
1279644 ID     school 1601860 340   LEWISTON INDEPENDENT DISTRICT 160186000170 1266 REGION 2 JUVENILE DETENTION CENTER   Alternative School No Other 03 12.0 2018   grade_9 1 0 0   0 0     0   0   1 0             *         1 1 0 0   0 0     0   0   1 0                 1
1279645 ID     school 1601860 340   LEWISTON INDEPENDENT DISTRICT 160186000170 1266 REGION 2 JUVENILE DETENTION CENTER   Alternative School No Other 03 12.0 2018   k_12_total 1 0 0   3 0     0   0   4 0             *         4 1 0 0   3 0     0   0   4 0                 4
1276374 ID     school 1600360 1   BOISE INDEPENDENT DISTRICT 160036000823 573 TREASURE VALLEY MATH/SCIENCE   Regular School No Other 04 12.0 2018   grade_10 11 0 0   0 0     0   0   8 3             *         11 11 0 0   0 0     0   0   8 3                 11

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