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,756
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
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
851508 ID     school 1600780 271   COEUR D'ALENE DISTRICT 160078000704 1038 CDA JUVENILE DETENTION CENTER   Alternative School No Other 04 12 2020   k_12_total 26 1 2   2 0     0   0   20 11             18         31 26 1 2   2 0     0   0   20 11         18       31
851757 ID     school 1600010 288   WHITEPINE JOINT SCHOOL DISTRICT 160001000579 794 DEARY SCHOOL   Regular School No Other 04 12 2020   grade_10 13 0 1   0 0     0   0   10 4             *         14 13 0 1   0 0     0   0   10 4                 14
851758 ID     school 1600010 288   WHITEPINE JOINT SCHOOL DISTRICT 160001000579 794 DEARY SCHOOL   Regular School No Other 04 12 2020   grade_11 19 0 1   0 0     0   0   10 10             *         20 19 0 1   0 0     0   0   10 10                 20
851759 ID     school 1600010 288   WHITEPINE JOINT SCHOOL DISTRICT 160001000579 794 DEARY SCHOOL   Regular School No Other 04 12 2020   grade_12 16 0 0   0 0     0   0   9 7             6         16 16 0 0   0 0     0   0   9 7         6       16
851760 ID     school 1600010 288   WHITEPINE JOINT SCHOOL DISTRICT 160001000579 794 DEARY SCHOOL   Regular School No Other 04 12 2020   grade_4 16 0 0   0 0     0   0   9 7             8         16 16 0 0   0 0     0   0   9 7         8       16
851761 ID     school 1600010 288   WHITEPINE JOINT SCHOOL DISTRICT 160001000579 794 DEARY SCHOOL   Regular School No Other 04 12 2020   grade_5 18 0 0   0 0     0   0   11 7             12         18 18 0 0   0 0     0   0   11 7         12       18
851762 ID     school 1600010 288   WHITEPINE JOINT SCHOOL DISTRICT 160001000579 794 DEARY SCHOOL   Regular School No Other 04 12 2020   grade_6 22 0 2   0 0     0   0   13 11             15         24 22 0 2   0 0     0   0   13 11         15       24
851763 ID     school 1600010 288   WHITEPINE JOINT SCHOOL DISTRICT 160001000579 794 DEARY SCHOOL   Regular School No Other 04 12 2020   grade_7 14 0 0   0 0     0   0   11 3             8         14 14 0 0   0 0     0   0   11 3         8       14
851764 ID     school 1600010 288   WHITEPINE JOINT SCHOOL DISTRICT 160001000579 794 DEARY SCHOOL   Regular School No Other 04 12 2020   grade_8 21 0 0   0 0     0   0   9 12             11         21 21 0 0   0 0     0   0   9 12         11       21
851765 ID     school 1600010 288   WHITEPINE JOINT SCHOOL DISTRICT 160001000579 794 DEARY SCHOOL   Regular School No Other 04 12 2020   grade_9 20 0 0   0 0     0   0   9 11             8         20 20 0 0   0 0     0   0   9 11         8       20
851766 ID     school 1600010 288   WHITEPINE JOINT SCHOOL DISTRICT 160001000579 794 DEARY SCHOOL   Regular School No Other 04 12 2020   k_12_total 159 0 4   0 0     0   0   91 72             83         163 159 0 4   0 0     0   0   91 72         83       163
851905 ID     school 1601920 321   MADISON DISTRICT 160192000210 250 MADISON MIDDLE SCHOOL   Regular School No Middle 04 06 2020   grade_4 22 0 1   0 0     0   0   15 8             *         23 22 0 1   0 0     0   0   15 8                 23
851906 ID     school 1601920 321   MADISON DISTRICT 160192000210 250 MADISON MIDDLE SCHOOL   Regular School No Middle 04 06 2020   grade_5 362 2 44   1 1     3   2   223 192             158         415 362 2 44   1 1     3   2   223 192         158       415
851907 ID     school 1601920 321   MADISON DISTRICT 160192000210 250 MADISON MIDDLE SCHOOL   Regular School No Middle 04 06 2020   grade_6 375 2 29   1 2     2   0   214 197             *         411 375 2 29   1 2     2   0   214 197                 411
851908 ID     school 1601920 321   MADISON DISTRICT 160192000210 250 MADISON MIDDLE SCHOOL   Regular School No Middle 04 06 2020   k_12_total 759 4 74   2 3     5   2   452 397             311         849 759 4 74   2 3     5   2   452 397         311       849
851958 ID     school 1603090 322   SUGAR-SALEM JOINT DISTRICT 160309000645 225 KERSHAW INTERMEDIATE SCHOOL   Regular School No Middle 04 06 2020   grade_4 96 2 5   1 0     0   2   54 52             47         106 96 2 5   1 0     0   2   54 52         47       106
851959 ID     school 1603090 322   SUGAR-SALEM JOINT DISTRICT 160309000645 225 KERSHAW INTERMEDIATE SCHOOL   Regular School No Middle 04 06 2020   grade_5 121 3 6   2 0     0   0   70 62             56         132 121 3 6   2 0     0   0   70 62         56       132
851960 ID     school 1603090 322   SUGAR-SALEM JOINT DISTRICT 160309000645 225 KERSHAW INTERMEDIATE SCHOOL   Regular School No Middle 04 06 2020   grade_6 94 0 10   0 2     1   0   50 57             48         107 94 0 10   0 2     1   0   50 57         48       107
851961 ID     school 1603090 322   SUGAR-SALEM JOINT DISTRICT 160309000645 225 KERSHAW INTERMEDIATE SCHOOL   Regular School No Middle 04 06 2020   k_12_total 311 5 21   3 2     1   2   174 171             151         345 311 5 21   3 2     1   2   174 171         151       345
852262 ID     school 1602580 371   PAYETTE JOINT DISTRICT 160258000456 805 WESTSIDE ELEMENTARY SCHOOL   Regular School No Elementary 04 05 2020   grade_4 67 0 39   1 0     0   3   48 62             62         110 67 0 39   1 0     0   3   48 62         62       110
852263 ID     school 1602580 371   PAYETTE JOINT DISTRICT 160258000456 805 WESTSIDE ELEMENTARY SCHOOL   Regular School No Elementary 04 05 2020   grade_5 66 0 29   2 0     1   1   52 47             47         99 66 0 29   2 0     1   1   52 47         47       99
852264 ID     school 1602580 371   PAYETTE JOINT DISTRICT 160258000456 805 WESTSIDE ELEMENTARY SCHOOL   Regular School No Elementary 04 05 2020   k_12_total 133 0 68   3 0     1   4   100 109             109         209 133 0 68   3 0     1   4   100 109         109       209
852435 ID     school 1603180 401   TETON COUNTY DISTRICT 160318001022 1236 RENDEZVOUS UPPER ELEMENTARY SCHOOL   Regular School No Elementary 04 05 2020   grade_4 92 1 49   1 0     0   1   76 68             65         144 92 1 49   1 0     0   1   76 68         65       144
852436 ID     school 1603180 401   TETON COUNTY DISTRICT 160318001022 1236 RENDEZVOUS UPPER ELEMENTARY SCHOOL   Regular School No Elementary 04 05 2020   grade_5 111 0 47   0 0     0   2   76 84             52         160 111 0 47   0 0     0   2   76 84         52       160
852437 ID     school 1603180 401   TETON COUNTY DISTRICT 160318001022 1236 RENDEZVOUS UPPER ELEMENTARY SCHOOL   Regular School No Elementary 04 05 2020   k_12_total 203 1 96   1 0     0   3   152 152             117         304 203 1 96   1 0     0   3   152 152         117       304
852581 ID     school 1601050 413   FILER DISTRICT 160105001006 1244 FILER INTERMEDIATE SCHOOL   Regular School No Middle 04 06 2020   grade_4 108 1 13   2 0     0   1   68 57             *         125 108 1 13   2 0     0   1   68 57                 125
852582 ID     school 1601050 413   FILER DISTRICT 160105001006 1244 FILER INTERMEDIATE SCHOOL   Regular School No Middle 04 06 2020   grade_5 83 1 17   0 0     0   1   59 43             *         102 83 1 17   0 0     0   1   59 43                 102
852583 ID     school 1601050 413   FILER DISTRICT 160105001006 1244 FILER INTERMEDIATE SCHOOL   Regular School No Middle 04 06 2020   grade_6 127 1 20   1 0     0   0   77 72             63         149 127 1 20   1 0     0   0   77 72         63       149
852584 ID     school 1601050 413   FILER DISTRICT 160105001006 1244 FILER INTERMEDIATE SCHOOL   Regular School No Middle 04 06 2020   k_12_total 318 3 50   3 0     0   2   204 172             167         376 318 3 50   3 0     0   2   204 172         167       376
852714 ID     school 1603330 431   WEISER DISTRICT 160333000566 840 PARK INTERMEDIATE SCHOOL   Regular School No Elementary 04 05 2020   grade_4 66 0 27   2 0     0   3   49 49             55         98 66 0 27   2 0     0   3   49 49         55       98
852715 ID     school 1603330 431   WEISER DISTRICT 160333000566 840 PARK INTERMEDIATE SCHOOL   Regular School No Elementary 04 05 2020   grade_5 65 1 29   0 0     0   4   48 51             56         99 65 1 29   0 0     0   4   48 51         56       99
852716 ID     school 1603330 431   WEISER DISTRICT 160333000566 840 PARK INTERMEDIATE SCHOOL   Regular School No Elementary 04 05 2020   k_12_total 131 1 56   2 0     0   7   97 100             111         197 131 1 56   2 0     0   7   97 100         111       197
853287 ID     school 1600186 531   FERN-WATERS PUBLIC CHARTER SCHOOL, INC. 160018601114 1423 FERN-WATERS PUBLIC CHARTER SCHOOL   Regular School Yes Middle 04 08 2020   grade_4 14 0 0   0 0     0   0   6 8             *         14 14 0 0   0 0     0   0   6 8                 14
853288 ID     school 1600186 531   FERN-WATERS PUBLIC CHARTER SCHOOL, INC. 160018601114 1423 FERN-WATERS PUBLIC CHARTER SCHOOL   Regular School Yes Middle 04 08 2020   grade_5 10 0 0   0 0     0   0   5 5             *         10 10 0 0   0 0     0   0   5 5                 10
853289 ID     school 1600186 531   FERN-WATERS PUBLIC CHARTER SCHOOL, INC. 160018601114 1423 FERN-WATERS PUBLIC CHARTER SCHOOL   Regular School Yes Middle 04 08 2020   grade_6 12 0 0   0 0     0   1   5 8             *         13 12 0 0   0 0     0   1   5 8                 13
853290 ID     school 1600186 531   FERN-WATERS PUBLIC CHARTER SCHOOL, INC. 160018601114 1423 FERN-WATERS PUBLIC CHARTER SCHOOL   Regular School Yes Middle 04 08 2020   grade_7 11 0 1   0 0     0   1   5 8             *         13 11 0 1   0 0     0   1   5 8                 13
853291 ID     school 1600186 531   FERN-WATERS PUBLIC CHARTER SCHOOL, INC. 160018601114 1423 FERN-WATERS PUBLIC CHARTER SCHOOL   Regular School Yes Middle 04 08 2020   grade_8 7 0 0   0 0     0   0   3 4             *         7 7 0 0   0 0     0   0   3 4                 7
853292 ID     school 1600186 531   FERN-WATERS PUBLIC CHARTER SCHOOL, INC. 160018601114 1423 FERN-WATERS PUBLIC CHARTER SCHOOL   Regular School Yes Middle 04 08 2020   k_12_total 54 0 1   0 0     0   2   24 33             *         57 54 0 1   0 0     0   2   24 33                 57
848883 ID     school 1600360 1   BOISE INDEPENDENT DISTRICT 160036000708 9002 ADA COUNTY JUVENILE CENTER   Alternative School No High 05 12 2020   grade_10 5 0 0   0 0     0   0   5 0             *         5 5 0 0   0 0     0   0   5 0                 5
848884 ID     school 1600360 1   BOISE INDEPENDENT DISTRICT 160036000708 9002 ADA COUNTY JUVENILE CENTER   Alternative School No High 05 12 2020   grade_11 4 0 1   0 0     0   0   4 1             *         5 4 0 1   0 0     0   0   4 1                 5
848885 ID     school 1600360 1   BOISE INDEPENDENT DISTRICT 160036000708 9002 ADA COUNTY JUVENILE CENTER   Alternative School No High 05 12 2020   grade_12 2 0 0   0 0     0   0   2 0             *         2 2 0 0   0 0     0   0   2 0                 2
848886 ID     school 1600360 1   BOISE INDEPENDENT DISTRICT 160036000708 9002 ADA COUNTY JUVENILE CENTER   Alternative School No High 05 12 2020   grade_6 1 0 0   0 0     0   0   1 0             *         1 1 0 0   0 0     0   0   1 0                 1
848887 ID     school 1600360 1   BOISE INDEPENDENT DISTRICT 160036000708 9002 ADA COUNTY JUVENILE CENTER   Alternative School No High 05 12 2020   grade_8 1 0 0   0 0     0   0   1 0             *         1 1 0 0   0 0     0   0   1 0                 1
848888 ID     school 1600360 1   BOISE INDEPENDENT DISTRICT 160036000708 9002 ADA COUNTY JUVENILE CENTER   Alternative School No High 05 12 2020   grade_9 7 0 0   0 0     0   0   6 1             *         7 7 0 0   0 0     0   0   6 1                 7
848889 ID     school 1600360 1   BOISE INDEPENDENT DISTRICT 160036000708 9002 ADA COUNTY JUVENILE CENTER   Alternative School No High 05 12 2020   k_12_total 20 0 1   0 0     0   0   19 2             *         21 20 0 1   0 0     0   0   19 2                 21
849580 ID     school 1602970 52   SNAKE RIVER DISTRICT 160297000644 380 SNAKE RIVER MIDDLE SCHOOL   Regular School No Middle 05 06 2020   grade_5 113 3 24   1 0     2   1   73 71             48         144 113 3 24   1 0     2   1   73 71         48       144
849581 ID     school 1602970 52   SNAKE RIVER DISTRICT 160297000644 380 SNAKE RIVER MIDDLE SCHOOL   Regular School No Middle 05 06 2020   grade_6 111 1 21   0 0     0   3   79 57             48         136 111 1 21   0 0     0   3   79 57         48       136
849582 ID     school 1602970 52   SNAKE RIVER DISTRICT 160297000644 380 SNAKE RIVER MIDDLE SCHOOL   Regular School No Middle 05 06 2020   k_12_total 224 4 45   1 0     2   4   152 128             96         280 224 4 45   1 0     2   4   152 128         96       280
849663 ID     school 1601080 59   FIRTH DISTRICT 160108000326 155 FIRTH MIDDLE SCHOOL   Regular School No Middle 05 08 2020   grade_5 53 1 9   1 1     0   0   27 38             27         65 53 1 9   1 1     0   0   27 38         27       65
849664 ID     school 1601080 59   FIRTH DISTRICT 160108000326 155 FIRTH MIDDLE SCHOOL   Regular School No Middle 05 08 2020   grade_6 50 2 11   0 0     0   0   38 25             25         63 50 2 11   0 0     0   0   38 25         25       63
849665 ID     school 1601080 59   FIRTH DISTRICT 160108000326 155 FIRTH MIDDLE SCHOOL   Regular School No Middle 05 08 2020   grade_7 62 0 9   2 0     0   0   38 35             29         73 62 0 9   2 0     0   0   38 35         29       73
849666 ID     school 1601080 59   FIRTH DISTRICT 160108000326 155 FIRTH MIDDLE SCHOOL   Regular School No Middle 05 08 2020   grade_8 59 0 10   0 0     0   0   36 33             33         69 59 0 10   0 0     0   0   36 33         33       69
849667 ID     school 1601080 59   FIRTH DISTRICT 160108000326 155 FIRTH MIDDLE SCHOOL   Regular School No Middle 05 08 2020   k_12_total 224 3 39   3 1     0   0   139 131             114         270 224 3 39   3 1     0   0   139 131         114       270
849686 ID     school 1602910 60   SHELLEY JOINT DISTRICT 160291000511 392 HAZEL STUART ELEMENTARY SCHOOL   Regular School No Middle 05 06 2020   grade_5 161 2 25   0 0     0   0   90 98             87         188 161 2 25   0 0     0   0   90 98         87       188
849687 ID     school 1602910 60   SHELLEY JOINT DISTRICT 160291000511 392 HAZEL STUART ELEMENTARY SCHOOL   Regular School No Middle 05 06 2020   grade_6 159 0 27   0 1     0   1   109 79             76         188 159 0 27   0 1     0   1   109 79         76       188
849688 ID     school 1602910 60   SHELLEY JOINT DISTRICT 160291000511 392 HAZEL STUART ELEMENTARY SCHOOL   Regular School No Middle 05 06 2020   k_12_total 320 2 52   0 1     0   1   199 177             163         376 320 2 52   0 1     0   1   199 177         163       376
849904 ID     school 1600002 84   LAKE PEND OREILLE SCHOOL DISTRICT 160000200604 997 SANDPOINT JUVENILE DETENTION   Alternative School No High 05 12 2020   grade_11 1 0 0   0 0     0   0   1 0             *         1 1 0 0   0 0     0   0   1 0                 1
849905 ID     school 1600002 84   LAKE PEND OREILLE SCHOOL DISTRICT 160000200604 997 SANDPOINT JUVENILE DETENTION   Alternative School No High 05 12 2020   grade_12 2 0 0   0 0     0   0   2 0             *         2 2 0 0   0 0     0   0   2 0                 2

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