Data source: Big Local News · About: Big Local

4,856 rows where state = "ID" and year = 2020 sorted by ccd_school_low_grade

View and edit SQL

grade

year

  • 2020 · 4,814
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
849479 ID     school 1602640 25   POCATELLO DISTRICT 160264000186 9034 POCATELLO JUVENILE DETENTION   Alternative School No Other 01 12 2020   grade_10 1 0 0   0 0     0   0   1 0             *         1 1 0 0   0 0     0   0   1 0                 1
849480 ID     school 1602640 25   POCATELLO DISTRICT 160264000186 9034 POCATELLO JUVENILE DETENTION   Alternative School No Other 01 12 2020   grade_11 2 0 0   1 0     0   0   1 2             *         3 2 0 0   1 0     0   0   1 2                 3
849481 ID     school 1602640 25   POCATELLO DISTRICT 160264000186 9034 POCATELLO JUVENILE DETENTION   Alternative School No Other 01 12 2020   grade_12 2 0 0   1 0     0   0   2 1             *         3 2 0 0   1 0     0   0   2 1                 3
849482 ID     school 1602640 25   POCATELLO DISTRICT 160264000186 9034 POCATELLO JUVENILE DETENTION   Alternative School No Other 01 12 2020   grade_7 0 0 1   0 0     0   0   1 0             *         1 0 0 1   0 0     0   0   1 0                 1
849483 ID     school 1602640 25   POCATELLO DISTRICT 160264000186 9034 POCATELLO JUVENILE DETENTION   Alternative School No Other 01 12 2020   grade_8 0 0 1   1 0     0   0   2 0             *         2 0 0 1   1 0     0   0   2 0                 2
849484 ID     school 1602640 25   POCATELLO DISTRICT 160264000186 9034 POCATELLO JUVENILE DETENTION   Alternative School No Other 01 12 2020   grade_9 3 0 2   0 0     0   0   4 1             *         5 3 0 2   0 0     0   0   4 1                 5
849485 ID     school 1602640 25   POCATELLO DISTRICT 160264000186 9034 POCATELLO JUVENILE DETENTION   Alternative School No Other 01 12 2020   k_12_total 8 0 4   3 0     0   0   11 4             *         15 8 0 4   3 0     0   0   11 4                 15
850482 ID     school 1600510 132   CALDWELL DISTRICT 160051000043 1087 SOUTHWEST IDAHO JUVENILE DETENTION   Alternative School No Other 01 12 2020   grade_10 1 0 1   0 0     0   0   2 0             *         2 1 0 1   0 0     0   0   2 0                 2
850483 ID     school 1600510 132   CALDWELL DISTRICT 160051000043 1087 SOUTHWEST IDAHO JUVENILE DETENTION   Alternative School No Other 01 12 2020   grade_11 2 0 4   0 0     0   0   5 1             *         6 2 0 4   0 0     0   0   5 1                 6
850484 ID     school 1600510 132   CALDWELL DISTRICT 160051000043 1087 SOUTHWEST IDAHO JUVENILE DETENTION   Alternative School No Other 01 12 2020   grade_12 1 0 4   0 0     0   0   5 0             *         5 1 0 4   0 0     0   0   5 0                 5
850485 ID     school 1600510 132   CALDWELL DISTRICT 160051000043 1087 SOUTHWEST IDAHO JUVENILE DETENTION   Alternative School No Other 01 12 2020   grade_9 1 0 2   0 0     0   0   2 1             *         3 1 0 2   0 0     0   0   2 1                 3
850486 ID     school 1600510 132   CALDWELL DISTRICT 160051000043 1087 SOUTHWEST IDAHO JUVENILE DETENTION   Alternative School No Other 01 12 2020   k_12_total 5 0 11   0 0     0   0   14 2             5         16 5 0 11   0 0     0   0   14 2         5       16
850674 ID     school 1601290 148   GRACE JOINT DISTRICT 160129000228 462 THATCHER ELEMENTARY SCHOOL   Regular School No Elementary 01 05 2020   grade_1 19 0 0   0 0     0   0   8 11             14         19 19 0 0   0 0     0   0   8 11         14       19
850675 ID     school 1601290 148   GRACE JOINT DISTRICT 160129000228 462 THATCHER ELEMENTARY SCHOOL   Regular School No Elementary 01 05 2020   grade_2 17 0 0   0 0     0   0   9 8             12         17 17 0 0   0 0     0   0   9 8         12       17
850676 ID     school 1601290 148   GRACE JOINT DISTRICT 160129000228 462 THATCHER ELEMENTARY SCHOOL   Regular School No Elementary 01 05 2020   grade_3 16 0 1   0 0     0   0   10 7             *         17 16 0 1   0 0     0   0   10 7                 17
850677 ID     school 1601290 148   GRACE JOINT DISTRICT 160129000228 462 THATCHER ELEMENTARY SCHOOL   Regular School No Elementary 01 05 2020   grade_4 25 0 0   0 0     0   0   10 15             14         25 25 0 0   0 0     0   0   10 15         14       25
850678 ID     school 1601290 148   GRACE JOINT DISTRICT 160129000228 462 THATCHER ELEMENTARY SCHOOL   Regular School No Elementary 01 05 2020   grade_5 12 0 1   0 0     0   0   9 4             *         13 12 0 1   0 0     0   0   9 4                 13
850679 ID     school 1601290 148   GRACE JOINT DISTRICT 160129000228 462 THATCHER ELEMENTARY SCHOOL   Regular School No Elementary 01 05 2020   k_12_total 89 0 2   0 0     0   0   46 45             56         91 89 0 2   0 0     0   0   46 45         56       91
851604 ID     school 1602670 273   POST FALLS DISTRICT 160267000209 736 PRAIRIE VIEW ELEMENTARY   Regular School No Elementary 01 05 2020   grade_1 75 3 7   2 1     0   1   48 41             45         89 75 3 7   2 1     0   1   48 41         45       89
851605 ID     school 1602670 273   POST FALLS DISTRICT 160267000209 736 PRAIRIE VIEW ELEMENTARY   Regular School No Elementary 01 05 2020   grade_2 79 1 3   1 0     0   5   50 39             39         89 79 1 3   1 0     0   5   50 39         39       89
851606 ID     school 1602670 273   POST FALLS DISTRICT 160267000209 736 PRAIRIE VIEW ELEMENTARY   Regular School No Elementary 01 05 2020   grade_3 81 1 6   0 1     0   2   43 48             47         91 81 1 6   0 1     0   2   43 48         47       91
851607 ID     school 1602670 273   POST FALLS DISTRICT 160267000209 736 PRAIRIE VIEW ELEMENTARY   Regular School No Elementary 01 05 2020   grade_4 89 1 8   1 1     0   6   50 56             46         106 89 1 8   1 1     0   6   50 56         46       106
851608 ID     school 1602670 273   POST FALLS DISTRICT 160267000209 736 PRAIRIE VIEW ELEMENTARY   Regular School No Elementary 01 05 2020   grade_5 75 0 8   0 1     0   4   38 50             46         88 75 0 8   0 1     0   4   38 50         46       88
851609 ID     school 1602670 273   POST FALLS DISTRICT 160267000209 736 PRAIRIE VIEW ELEMENTARY   Regular School No Elementary 01 05 2020   k_12_total 399 6 32   4 4     0   18   229 234             223         463 399 6 32   4 4     0   18   229 234         223       463
851631 ID     school 1602670 273   POST FALLS DISTRICT 160267001085 1388 GREENSFERRY ELEMENTARY SCHOOL   Regular School No Elementary 01 05 2020   grade_1 70 0 5   0 0     0   4   42 37             27         79 70 0 5   0 0     0   4   42 37         27       79
851632 ID     school 1602670 273   POST FALLS DISTRICT 160267001085 1388 GREENSFERRY ELEMENTARY SCHOOL   Regular School No Elementary 01 05 2020   grade_2 69 1 6   1 0     0   1   43 35             32         78 69 1 6   1 0     0   1   43 35         32       78
851633 ID     school 1602670 273   POST FALLS DISTRICT 160267001085 1388 GREENSFERRY ELEMENTARY SCHOOL   Regular School No Elementary 01 05 2020   grade_3 64 0 7   0 1     0   7   51 28             32         79 64 0 7   0 1     0   7   51 28         32       79
851634 ID     school 1602670 273   POST FALLS DISTRICT 160267001085 1388 GREENSFERRY ELEMENTARY SCHOOL   Regular School No Elementary 01 05 2020   grade_4 79 0 6   3 0     1   2   44 47             38         91 79 0 6   3 0     1   2   44 47         38       91
851635 ID     school 1602670 273   POST FALLS DISTRICT 160267001085 1388 GREENSFERRY ELEMENTARY SCHOOL   Regular School No Elementary 01 05 2020   grade_5 68 0 5   2 0     1   9   43 42             28         85 68 0 5   2 0     1   9   43 42         28       85
851636 ID     school 1602670 273   POST FALLS DISTRICT 160267001085 1388 GREENSFERRY ELEMENTARY SCHOOL   Regular School No Elementary 01 05 2020   k_12_total 350 1 29   6 1     2   23   223 189             157         412 350 1 29   6 1     2   23   223 189         157       412
851637 ID     school 1602670 273   POST FALLS DISTRICT 160267000970 2517 WEST RIDGE ELEMENTARY SCHOOL   Regular School No Elementary 01 05 2020   grade_1 60 0 4   1 1     0   3   29 40             28         69 60 0 4   1 1     0   3   29 40         28       69
851638 ID     school 1602670 273   POST FALLS DISTRICT 160267000970 2517 WEST RIDGE ELEMENTARY SCHOOL   Regular School No Elementary 01 05 2020   grade_2 76 0 7   0 0     0   4   46 41             44         87 76 0 7   0 0     0   4   46 41         44       87
851639 ID     school 1602670 273   POST FALLS DISTRICT 160267000970 2517 WEST RIDGE ELEMENTARY SCHOOL   Regular School No Elementary 01 05 2020   grade_3 68 1 6   0 0     0   6   43 38             40         81 68 1 6   0 0     0   6   43 38         40       81
851640 ID     school 1602670 273   POST FALLS DISTRICT 160267000970 2517 WEST RIDGE ELEMENTARY SCHOOL   Regular School No Elementary 01 05 2020   grade_4 71 0 5   0 0     1   5   37 45             35         82 71 0 5   0 0     1   5   37 45         35       82
851641 ID     school 1602670 273   POST FALLS DISTRICT 160267000970 2517 WEST RIDGE ELEMENTARY SCHOOL   Regular School No Elementary 01 05 2020   grade_5 81 1 10   2 1     0   4   54 45             45         99 81 1 10   2 1     0   4   54 45         45       99
851642 ID     school 1602670 273   POST FALLS DISTRICT 160267000970 2517 WEST RIDGE ELEMENTARY SCHOOL   Regular School No Elementary 01 05 2020   k_12_total 356 2 32   3 2     1   22   209 209             192         418 356 2 32   3 2     1   22   209 209         192       418
852513 ID     school 1603240 411   TWIN FALLS DISTRICT 160324000739 1260 SNAKE RIVER JUVENILE DETENTION   Alternative School No Other 01 12 2020   grade_10 1 0 1   0 0     0   1   2 1             *         3 1 0 1   0 0     0   1   2 1                 3
852514 ID     school 1603240 411   TWIN FALLS DISTRICT 160324000739 1260 SNAKE RIVER JUVENILE DETENTION   Alternative School No Other 01 12 2020   grade_11 1 0 1   0 0     0   0   2 0             *         2 1 0 1   0 0     0   0   2 0                 2
852515 ID     school 1603240 411   TWIN FALLS DISTRICT 160324000739 1260 SNAKE RIVER JUVENILE DETENTION   Alternative School No Other 01 12 2020   grade_12 1 0 1   0 0     0   0   1 1             *         2 1 0 1   0 0     0   0   1 1                 2
852516 ID     school 1603240 411   TWIN FALLS DISTRICT 160324000739 1260 SNAKE RIVER JUVENILE DETENTION   Alternative School No Other 01 12 2020   grade_8 1 0 1   0 0     0   0   2 0             *         2 1 0 1   0 0     0   0   2 0                 2
852517 ID     school 1603240 411   TWIN FALLS DISTRICT 160324000739 1260 SNAKE RIVER JUVENILE DETENTION   Alternative School No Other 01 12 2020   grade_9 1 0 0   0 0     0   0   0 1             *         1 1 0 0   0 0     0   0   0 1                 1
852518 ID     school 1603240 411   TWIN FALLS DISTRICT 160324000739 1260 SNAKE RIVER JUVENILE DETENTION   Alternative School No Other 01 12 2020   k_12_total 5 0 4   0 0     0   1   7 3             *         10 5 0 4   0 0     0   1   7 3                 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
849573 ID     school 1602970 52   SNAKE RIVER DISTRICT 160297000518 376 RIVERSIDE ELEMENTARY SCHOOL   Regular School No Elementary 02 03 2020   grade_3 104 0 24   1 1     0   2   74 58             53         132 104 0 24   1 1     0   2   74 58         53       132
849574 ID     school 1602970 52   SNAKE RIVER DISTRICT 160297000518 376 RIVERSIDE ELEMENTARY SCHOOL   Regular School No Elementary 02 03 2020   k_12_total 213 0 43   1 1     0   4   142 120             112         262 213 0 43   1 1     0   4   142 120         112       262
849689 ID     school 1602910 60   SHELLEY JOINT DISTRICT 160291001012 1251 RIVERVIEW ELEMENTARY SCHOOL   Regular School No Elementary 03 04 2020   grade_3 153 1 19   1 2     0   3   96 83             82         179 153 1 19   1 2     0   3   96 83         82       179
849690 ID     school 1602910 60   SHELLEY JOINT DISTRICT 160291001012 1251 RIVERVIEW ELEMENTARY SCHOOL   Regular School No Elementary 03 04 2020   grade_4 159 2 21   0 3     0   1   86 100             91         186 159 2 21   0 3     0   1   86 100         91       186
849691 ID     school 1602910 60   SHELLEY JOINT DISTRICT 160291001012 1251 RIVERVIEW ELEMENTARY SCHOOL   Regular School No Elementary 03 04 2020   k_12_total 312 3 40   1 5     0   4   182 183             173         365 312 3 40   1 5     0   4   182 183         173       365
851016 ID     school 1600960 201   PRESTON JOINT DISTRICT 160096000181 497 OAKWOOD ELEMENTARY SCHOOL   Regular School No Elementary 03 05 2020   grade_3 149 2 23   2 0     0   1   92 85             75         177 149 2 23   2 0     0   1   92 85         75       177
851017 ID     school 1600960 201   PRESTON JOINT DISTRICT 160096000181 497 OAKWOOD ELEMENTARY SCHOOL   Regular School No Elementary 03 05 2020   grade_4 141 0 21   2 0     0   2   83 83             71         166 141 0 21   2 0     0   2   83 83         71       166
851018 ID     school 1600960 201   PRESTON JOINT DISTRICT 160096000181 497 OAKWOOD ELEMENTARY SCHOOL   Regular School No Elementary 03 05 2020   grade_5 156 2 22   2 0     1   0   90 93             100         183 156 2 22   2 0     1   0   90 93         100       183
851019 ID     school 1600960 201   PRESTON JOINT DISTRICT 160096000181 497 OAKWOOD ELEMENTARY SCHOOL   Regular School No Elementary 03 05 2020   k_12_total 446 4 66   6 0     1   3   265 261             246         526 446 4 66   6 0     1   3   265 261         246       526
851318 ID     school 1601570 251   JEFFERSON COUNTY JOINT DISTRICT 160157001064 1359 PHILO T FARNSWORTH ELEMENTARY SCHOOL   Regular School No Elementary 03 05 2020   grade_3 202 2 23   1 0     0   2   106 124             66         230 202 2 23   1 0     0   2   106 124         66       230
851319 ID     school 1601570 251   JEFFERSON COUNTY JOINT DISTRICT 160157001064 1359 PHILO T FARNSWORTH ELEMENTARY SCHOOL   Regular School No Elementary 03 05 2020   grade_4 219 0 16   2 0     0   5   124 118             78         242 219 0 16   2 0     0   5   124 118         78       242
851320 ID     school 1601570 251   JEFFERSON COUNTY JOINT DISTRICT 160157001064 1359 PHILO T FARNSWORTH ELEMENTARY SCHOOL   Regular School No Elementary 03 05 2020   grade_5 236 0 18   0 0     0   0   128 126             73         254 236 0 18   0 0     0   0   128 126         73       254
851321 ID     school 1601570 251   JEFFERSON COUNTY JOINT DISTRICT 160157001064 1359 PHILO T FARNSWORTH ELEMENTARY SCHOOL   Regular School No Elementary 03 05 2020   k_12_total 657 2 57   3 0     0   7   358 368             217         726 657 2 57   3 0     0   7   358 368         217       726
851671 ID     school 1602220 281   MOSCOW DISTRICT 160222000391 753 J RUSSELL ELEMENTARY SCHOOL   Regular School No Elementary 03 05 2020   grade_3 50 2 5   0 5     0   3   30 35             35         65 50 2 5   0 5     0   3   30 35         35       65
851672 ID     school 1602220 281   MOSCOW DISTRICT 160222000391 753 J RUSSELL ELEMENTARY SCHOOL   Regular School No Elementary 03 05 2020   grade_4 48 2 4   2 1     0   6   30 33             20         63 48 2 4   2 1     0   6   30 33         20       63
851673 ID     school 1602220 281   MOSCOW DISTRICT 160222000391 753 J RUSSELL ELEMENTARY SCHOOL   Regular School No Elementary 03 05 2020   grade_5 50 0 2   0 1     0   5   23 35             22         58 50 0 2   0 1     0   5   23 35         22       58
851674 ID     school 1602220 281   MOSCOW DISTRICT 160222000391 753 J RUSSELL ELEMENTARY SCHOOL   Regular School No Elementary 03 05 2020   k_12_total 148 4 11   2 7     0   14   83 103             77         186 148 4 11   2 7     0   14   83 103         77       186
852024 ID     school 1602190 331   MINIDOKA COUNTY JOINT DISTRICT 160219000166 1100 MINI-CASSIA JUVENILE DETENTION CENTER   Alternative School No Other 03 12 2020   grade_11 1 0 0   0 0     0   0   0 1             *         1 1 0 0   0 0     0   0   0 1                 1
852025 ID     school 1602190 331   MINIDOKA COUNTY JOINT DISTRICT 160219000166 1100 MINI-CASSIA JUVENILE DETENTION CENTER   Alternative School No Other 03 12 2020   grade_12 0 0 1   0 0     0   0   1 0             *         1 0 0 1   0 0     0   0   1 0                 1
852026 ID     school 1602190 331   MINIDOKA COUNTY JOINT DISTRICT 160219000166 1100 MINI-CASSIA JUVENILE DETENTION CENTER   Alternative School No Other 03 12 2020   grade_8 1 0 0   0 0     0   0   0 1             *         1 1 0 0   0 0     0   0   0 1                 1
852027 ID     school 1602190 331   MINIDOKA COUNTY JOINT DISTRICT 160219000166 1100 MINI-CASSIA JUVENILE DETENTION CENTER   Alternative School No Other 03 12 2020   k_12_total 2 0 1   0 0     0   0   1 2             *         3 2 0 1   0 0     0   0   1 2                 3
852112 ID     school 1601860 340   LEWISTON INDEPENDENT DISTRICT 160186000170 1266 REGION 2 JUVENILE DETENTION CENTER   Alternative School No Other 03 12 2020   grade_10 1 0 0   0 0     0   0   1 0             *         1 1 0 0   0 0     0   0   1 0                 1
852113 ID     school 1601860 340   LEWISTON INDEPENDENT DISTRICT 160186000170 1266 REGION 2 JUVENILE DETENTION CENTER   Alternative School No Other 03 12 2020   grade_11 0 1 0   0 0     0   0   1 0             *         1 0 1 0   0 0     0   0   1 0                 1
852114 ID     school 1601860 340   LEWISTON INDEPENDENT DISTRICT 160186000170 1266 REGION 2 JUVENILE DETENTION CENTER   Alternative School No Other 03 12 2020   grade_12 0 0 0   1 0     0   0   1 0             *         1 0 0 0   1 0     0   0   1 0                 1
852115 ID     school 1601860 340   LEWISTON INDEPENDENT DISTRICT 160186000170 1266 REGION 2 JUVENILE DETENTION CENTER   Alternative School No Other 03 12 2020   grade_8 0 0 1   0 0     0   0   0 1             *         1 0 0 1   0 0     0   0   0 1                 1
852116 ID     school 1601860 340   LEWISTON INDEPENDENT DISTRICT 160186000170 1266 REGION 2 JUVENILE DETENTION CENTER   Alternative School No Other 03 12 2020   grade_9 1 0 0   0 0     0   0   1 0             *         1 1 0 0   0 0     0   0   1 0                 1
852117 ID     school 1601860 340   LEWISTON INDEPENDENT DISTRICT 160186000170 1266 REGION 2 JUVENILE DETENTION CENTER   Alternative School No Other 03 12 2020   k_12_total 2 1 1   1 0     0   0   4 1             *         5 2 1 1   1 0     0   0   4 1                 5
852321 ID     school 1600060 381   AMERICAN FALLS JOINT DISTRICT 160006000816 849 J.R. SIMPLOT ELEMENTARY SCHOOL   Regular School No Elementary 03 05 2020   grade_3 54 0 55   6 0     0   1   57 59             79         116 54 0 55   6 0     0   1   57 59         79       116
852322 ID     school 1600060 381   AMERICAN FALLS JOINT DISTRICT 160006000816 849 J.R. SIMPLOT ELEMENTARY SCHOOL   Regular School No Elementary 03 05 2020   grade_4 70 1 55   1 0     0   0   64 63             83         127 70 1 55   1 0     0   0   64 63         83       127
852323 ID     school 1600060 381   AMERICAN FALLS JOINT DISTRICT 160006000816 849 J.R. SIMPLOT ELEMENTARY SCHOOL   Regular School No Elementary 03 05 2020   grade_5 49 3 70   2 0     0   0   61 63             93         124 49 3 70   2 0     0   0   61 63         93       124
852324 ID     school 1600060 381   AMERICAN FALLS JOINT DISTRICT 160006000816 849 J.R. SIMPLOT ELEMENTARY SCHOOL   Regular School No Elementary 03 05 2020   k_12_total 173 4 180   9 0     0   1   182 185             255         367 173 4 180   9 0     0   1   182 185         255       367
848820 ID     school 1600360 1   BOISE INDEPENDENT DISTRICT 160036000823 573 TREASURE VALLEY MATH/SCIENCE   Regular School No Other 04 12 2020   grade_10 6 0 0   0 3     0   0   6 3             *         9 6 0 0   0 3     0   0   6 3                 9
848821 ID     school 1600360 1   BOISE INDEPENDENT DISTRICT 160036000823 573 TREASURE VALLEY MATH/SCIENCE   Regular School No Other 04 12 2020   grade_11 4 0 0   0 1     0   0   3 2             *         5 4 0 0   0 1     0   0   3 2                 5
848822 ID     school 1600360 1   BOISE INDEPENDENT DISTRICT 160036000823 573 TREASURE VALLEY MATH/SCIENCE   Regular School No Other 04 12 2020   grade_12 6 0 0   0 0     0   0   4 2             *         6 6 0 0   0 0     0   0   4 2                 6
848823 ID     school 1600360 1   BOISE INDEPENDENT DISTRICT 160036000823 573 TREASURE VALLEY MATH/SCIENCE   Regular School No Other 04 12 2020   grade_6 6 0 0   0 1     0   0   7 0             *         7 6 0 0   0 1     0   0   7 0                 7
848824 ID     school 1600360 1   BOISE INDEPENDENT DISTRICT 160036000823 573 TREASURE VALLEY MATH/SCIENCE   Regular School No Other 04 12 2020   grade_7 8 0 1   1 4     0   0   9 5             *         14 8 0 1   1 4     0   0   9 5                 14
848825 ID     school 1600360 1   BOISE INDEPENDENT DISTRICT 160036000823 573 TREASURE VALLEY MATH/SCIENCE   Regular School No Other 04 12 2020   grade_8 19 0 1   0 0     0   0   14 6             *         20 19 0 1   0 0     0   0   14 6                 20
848826 ID     school 1600360 1   BOISE INDEPENDENT DISTRICT 160036000823 573 TREASURE VALLEY MATH/SCIENCE   Regular School No Other 04 12 2020   grade_9 7 0 1   0 2     0   0   8 2             *         10 7 0 1   0 2     0   0   8 2                 10
848827 ID     school 1600360 1   BOISE INDEPENDENT DISTRICT 160036000823 573 TREASURE VALLEY MATH/SCIENCE   Regular School No Other 04 12 2020   k_12_total 56 0 3   1 11     0   0   51 20             *         71 56 0 3   1 11     0   0   51 20                 71
849254 ID     school 1601770 3   KUNA JOINT DISTRICT 160177000915 635 ROSS ELEMENTARY SCHOOL   Regular School No Elementary 04 05 2020   grade_4 96 1 10   0 1     0   3   71 40             53         111 96 1 10   0 1     0   3   71 40         53       111
849255 ID     school 1601770 3   KUNA JOINT DISTRICT 160177000915 635 ROSS ELEMENTARY SCHOOL   Regular School No Elementary 04 05 2020   grade_5 114 0 18   0 0     2   3   65 72             54         137 114 0 18   0 0     2   3   65 72         54       137
849256 ID     school 1601770 3   KUNA JOINT DISTRICT 160177000915 635 ROSS ELEMENTARY SCHOOL   Regular School No Elementary 04 05 2020   k_12_total 210 1 28   0 1     2   6   136 112             107         248 210 1 28   0 1     2   6   136 112         107       248
849578 ID     school 1602970 52   SNAKE RIVER DISTRICT 160297000519 378 ROCKFORD ELEMENTARY SCHOOL   Regular School No Elementary 04 04 2020   grade_4 118 1 16   2 0     0   2   69 70             49         139 118 1 16   2 0     0   2   69 70         49       139
849579 ID     school 1602970 52   SNAKE RIVER DISTRICT 160297000519 378 ROCKFORD ELEMENTARY SCHOOL   Regular School No Elementary 04 04 2020   k_12_total 118 1 16   2 0     0   2   69 70             49         139 118 1 16   2 0     0   2   69 70         49       139
850034 ID     school 1601530 91   IDAHO FALLS DISTRICT 160153000605 1152 3B JUVENILE DETENTION CENTER   Alternative School No Other 04 12 2020   grade_10 4 0 2   1 0     0   0   4 3             *         7 4 0 2   1 0     0   0   4 3                 7
850035 ID     school 1601530 91   IDAHO FALLS DISTRICT 160153000605 1152 3B JUVENILE DETENTION CENTER   Alternative School No Other 04 12 2020   grade_11 2 0 2   0 0     0   0   4 0             *         4 2 0 2   0 0     0   0   4 0                 4
850036 ID     school 1601530 91   IDAHO FALLS DISTRICT 160153000605 1152 3B JUVENILE DETENTION CENTER   Alternative School No Other 04 12 2020   grade_12 2 0 0   0 0     0   0   2 0             *         2 2 0 0   0 0     0   0   2 0                 2
850037 ID     school 1601530 91   IDAHO FALLS DISTRICT 160153000605 1152 3B JUVENILE DETENTION CENTER   Alternative School No Other 04 12 2020   grade_9 3 1 0   0 0     0   0   3 1             *         4 3 1 0   0 0     0   0   3 1                 4
850038 ID     school 1601530 91   IDAHO FALLS DISTRICT 160153000605 1152 3B JUVENILE DETENTION CENTER   Alternative School No Other 04 12 2020   k_12_total 11 1 4   1 0     0   0   13 4             *         17 11 1 4   1 0     0   0   13 4                 17
851389 ID     school 1601590 261   JEROME JOINT DISTRICT 160159000972 2516 SUMMIT ELEMENTARY   Regular School No Elementary 04 05 2020   grade_4 142 0 162   1 1     1   2   158 151             *         309 142 0 162   1 1     1   2   158 151                 309
851390 ID     school 1601590 261   JEROME JOINT DISTRICT 160159000972 2516 SUMMIT ELEMENTARY   Regular School No Elementary 04 05 2020   grade_5 126 0 187   3 1     2   1   157 163             *         320 126 0 187   3 1     2   1   157 163                 320
851391 ID     school 1601590 261   JEROME JOINT DISTRICT 160159000972 2516 SUMMIT ELEMENTARY   Regular School No Elementary 04 05 2020   k_12_total 268 0 349   4 2     3   3   315 314             439         629 268 0 349   4 2     3   3   315 314         439       629
851503 ID     school 1600780 271   COEUR D'ALENE DISTRICT 160078000704 1038 CDA JUVENILE DETENTION CENTER   Alternative School No Other 04 12 2020   grade_10 4 1 0   0 0     0   0   3 2             *         5 4 1 0   0 0     0   0   3 2                 5
851504 ID     school 1600780 271   COEUR D'ALENE DISTRICT 160078000704 1038 CDA JUVENILE DETENTION CENTER   Alternative School No Other 04 12 2020   grade_11 7 0 0   1 0     0   0   5 3             *         8 7 0 0   1 0     0   0   5 3                 8
851505 ID     school 1600780 271   COEUR D'ALENE DISTRICT 160078000704 1038 CDA JUVENILE DETENTION CENTER   Alternative School No Other 04 12 2020   grade_12 5 0 1   0 0     0   0   5 1             *         6 5 0 1   0 0     0   0   5 1                 6
851506 ID     school 1600780 271   COEUR D'ALENE DISTRICT 160078000704 1038 CDA JUVENILE DETENTION CENTER   Alternative School No Other 04 12 2020   grade_7 1 0 0   0 0     0   0   1 0             *         1 1 0 0   0 0     0   0   1 0                 1
851507 ID     school 1600780 271   COEUR D'ALENE DISTRICT 160078000704 1038 CDA JUVENILE DETENTION CENTER   Alternative School No Other 04 12 2020   grade_9 9 0 1   1 0     0   0   6 5             *         11 9 0 1   1 0     0   0   6 5                 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]);