Data source: Big Local News · About: Big Local

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

View and edit SQL

grade

year

  • 2021 · 4,950
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
703484 ID     school 1601770 3   KUNA JOINT DISTRICT 160177000915 635 ROSS ELEMENTARY SCHOOL   Regular School No Elementary 04 05 2021   k_12_total 207 1 26   1 2     0   5   134 108             81         242 207 1 26   1 2     0   5   134 108         81       242
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
704298 ID     school 1601530 91   IDAHO FALLS DISTRICT 160153000605 1152 3B JUVENILE DETENTION CENTER   Alternative School No Other 04 12 2021   grade_10 1 0 0   0 0     0   0   1 0             *         1 1 0 0   0 0     0   0   1 0                 1
704299 ID     school 1601530 91   IDAHO FALLS DISTRICT 160153000605 1152 3B JUVENILE DETENTION CENTER   Alternative School No Other 04 12 2021   grade_11 1 0 1   0 0     0   1   2 1             *         3 1 0 1   0 0     0   1   2 1                 3
704300 ID     school 1601530 91   IDAHO FALLS DISTRICT 160153000605 1152 3B JUVENILE DETENTION CENTER   Alternative School No Other 04 12 2021   grade_8 1 0 0   0 0     0   0   1 0             *         1 1 0 0   0 0     0   0   1 0                 1
704301 ID     school 1601530 91   IDAHO FALLS DISTRICT 160153000605 1152 3B JUVENILE DETENTION CENTER   Alternative School No Other 04 12 2021   k_12_total 3 0 1   0 0     0   1   4 1             *         5 3 0 1   0 0     0   1   4 1                 5
705843 ID     school 1600780 271   COEUR D'ALENE DISTRICT 160078000704 1038 CDA JUVENILE DETENTION CENTER   Alternative School No Other 04 12 2021   grade_10 7 0 0   0 0     0   1   5 3             *         8 7 0 0   0 0     0   1   5 3                 8
705844 ID     school 1600780 271   COEUR D'ALENE DISTRICT 160078000704 1038 CDA JUVENILE DETENTION CENTER   Alternative School No Other 04 12 2021   grade_11 11 0 0   0 0     0   0   8 3             *         11 11 0 0   0 0     0   0   8 3                 11
705845 ID     school 1600780 271   COEUR D'ALENE DISTRICT 160078000704 1038 CDA JUVENILE DETENTION CENTER   Alternative School No Other 04 12 2021   grade_12 2 0 2   0 0     0   0   1 3             *         4 2 0 2   0 0     0   0   1 3                 4
705846 ID     school 1600780 271   COEUR D'ALENE DISTRICT 160078000704 1038 CDA JUVENILE DETENTION CENTER   Alternative School No Other 04 12 2021   grade_7 1 0 0   0 0     0   0   1 0             *         1 1 0 0   0 0     0   0   1 0                 1
705847 ID     school 1600780 271   COEUR D'ALENE DISTRICT 160078000704 1038 CDA JUVENILE DETENTION CENTER   Alternative School No Other 04 12 2021   grade_8 1 0 0   0 0     0   1   2 0             *         2 1 0 0   0 0     0   1   2 0                 2
705848 ID     school 1600780 271   COEUR D'ALENE DISTRICT 160078000704 1038 CDA JUVENILE DETENTION CENTER   Alternative School No Other 04 12 2021   grade_9 2 0 0   1 0     0   0   1 2             *         3 2 0 0   1 0     0   0   1 2                 3
705849 ID     school 1600780 271   COEUR D'ALENE DISTRICT 160078000704 1038 CDA JUVENILE DETENTION CENTER   Alternative School No Other 04 12 2021   k_12_total 24 0 2   1 0     0   2   18 11             11         29 24 0 2   1 0     0   2   18 11         11       29
706105 ID     school 1600010 288   WHITEPINE JOINT SCHOOL DISTRICT 160001000579 794 DEARY SCHOOL   Regular School No Other 04 12 2021   grade_10 21 0 0   0 0     0   0   9 12             7         21 21 0 0   0 0     0   0   9 12         7       21
706106 ID     school 1600010 288   WHITEPINE JOINT SCHOOL DISTRICT 160001000579 794 DEARY SCHOOL   Regular School No Other 04 12 2021   grade_11 12 0 1   0 0     0   0   9 4             *         13 12 0 1   0 0     0   0   9 4                 13
706107 ID     school 1600010 288   WHITEPINE JOINT SCHOOL DISTRICT 160001000579 794 DEARY SCHOOL   Regular School No Other 04 12 2021   grade_12 22 0 1   0 0     0   0   12 11             5         23 22 0 1   0 0     0   0   12 11         5       23
706108 ID     school 1600010 288   WHITEPINE JOINT SCHOOL DISTRICT 160001000579 794 DEARY SCHOOL   Regular School No Other 04 12 2021   grade_4 12 0 0   0 0     0   0   9 3             *         12 12 0 0   0 0     0   0   9 3                 12
706109 ID     school 1600010 288   WHITEPINE JOINT SCHOOL DISTRICT 160001000579 794 DEARY SCHOOL   Regular School No Other 04 12 2021   grade_5 11 0 0   0 0     0   0   7 4             5         11 11 0 0   0 0     0   0   7 4         5       11
706110 ID     school 1600010 288   WHITEPINE JOINT SCHOOL DISTRICT 160001000579 794 DEARY SCHOOL   Regular School No Other 04 12 2021   grade_6 16 0 0   0 0     0   0   9 7             11         16 16 0 0   0 0     0   0   9 7         11       16
706111 ID     school 1600010 288   WHITEPINE JOINT SCHOOL DISTRICT 160001000579 794 DEARY SCHOOL   Regular School No Other 04 12 2021   grade_7 20 0 1   0 0     0   0   8 13             9         21 20 0 1   0 0     0   0   8 13         9       21
706112 ID     school 1600010 288   WHITEPINE JOINT SCHOOL DISTRICT 160001000579 794 DEARY SCHOOL   Regular School No Other 04 12 2021   grade_8 12 0 0   0 0     0   0   9 3             6         12 12 0 0   0 0     0   0   9 3         6       12
706113 ID     school 1600010 288   WHITEPINE JOINT SCHOOL DISTRICT 160001000579 794 DEARY SCHOOL   Regular School No Other 04 12 2021   grade_9 19 0 0   0 0     0   0   7 12             11         19 19 0 0   0 0     0   0   7 12         11       19
706114 ID     school 1600010 288   WHITEPINE JOINT SCHOOL DISTRICT 160001000579 794 DEARY SCHOOL   Regular School No Other 04 12 2021   k_12_total 145 0 3   0 0     0   0   79 69             71         148 145 0 3   0 0     0   0   79 69         71       148
706172 ID     school 1601620 304   KAMIAH JOINT DISTRICT 160162000458 232 KAMIAH MIDDLE SCHOOL   Regular School No Middle 04 08 2021   grade_4 20 0 2   8 0     0   1   16 15             10         31 20 0 2   8 0     0   1   16 15         10       31
706173 ID     school 1601620 304   KAMIAH JOINT DISTRICT 160162000458 232 KAMIAH MIDDLE SCHOOL   Regular School No Middle 04 08 2021   grade_5 13 0 2   4 0     0   3   10 12             7         22 13 0 2   4 0     0   3   10 12         7       22
706174 ID     school 1601620 304   KAMIAH JOINT DISTRICT 160162000458 232 KAMIAH MIDDLE SCHOOL   Regular School No Middle 04 08 2021   grade_6 21 0 2   4 0     0   2   20 9             12         29 21 0 2   4 0     0   2   20 9         12       29
706175 ID     school 1601620 304   KAMIAH JOINT DISTRICT 160162000458 232 KAMIAH MIDDLE SCHOOL   Regular School No Middle 04 08 2021   grade_7 22 0 3   4 0     0   2   19 12             13         31 22 0 3   4 0     0   2   19 12         13       31
706176 ID     school 1601620 304   KAMIAH JOINT DISTRICT 160162000458 232 KAMIAH MIDDLE SCHOOL   Regular School No Middle 04 08 2021   grade_8 17 0 4   8 0     0   5   17 17             13         34 17 0 4   8 0     0   5   17 17         13       34
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
706254 ID     school 1601920 321   MADISON DISTRICT 160192000210 250 MADISON MIDDLE SCHOOL   Regular School No Middle 04 06 2021   grade_4 21 0 0   0 0     0   0   12 9             9         21 21 0 0   0 0     0   0   12 9         9       21
706255 ID     school 1601920 321   MADISON DISTRICT 160192000210 250 MADISON MIDDLE SCHOOL   Regular School No Middle 04 06 2021   grade_5 335 4 38   0 1     2   1   194 187             133         381 335 4 38   0 1     2   1   194 187         133       381
706256 ID     school 1601920 321   MADISON DISTRICT 160192000210 250 MADISON MIDDLE SCHOOL   Regular School No Middle 04 06 2021   grade_6 350 2 38   1 0     3   1   209 186             143         395 350 2 38   1 0     3   1   209 186         143       395
706257 ID     school 1601920 321   MADISON DISTRICT 160192000210 250 MADISON MIDDLE SCHOOL   Regular School No Middle 04 06 2021   k_12_total 706 6 76   1 1     5   2   415 382             285         797 706 6 76   1 1     5   2   415 382         285       797
706306 ID     school 1603090 322   SUGAR-SALEM JOINT DISTRICT 160309000645 225 KERSHAW INTERMEDIATE SCHOOL   Regular School No Middle 04 06 2021   grade_4 80 0 4   0 0     0   3   42 45             32         87 80 0 4   0 0     0   3   42 45         32       87
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
706308 ID     school 1603090 322   SUGAR-SALEM JOINT DISTRICT 160309000645 225 KERSHAW INTERMEDIATE SCHOOL   Regular School No Middle 04 06 2021   grade_6 127 2 7   2 0     0   1   72 67             51         139 127 2 7   2 0     0   1   72 67         51       139
706309 ID     school 1603090 322   SUGAR-SALEM JOINT DISTRICT 160309000645 225 KERSHAW INTERMEDIATE SCHOOL   Regular School No Middle 04 06 2021   k_12_total 305 4 15   3 0     0   8   168 167             128         335 305 4 15   3 0     0   8   168 167         128       335
706599 ID     school 1602580 371   PAYETTE JOINT DISTRICT 160258000456 805 WESTSIDE ELEMENTARY SCHOOL   Regular School No Elementary 04 05 2021   grade_4 58 0 38   0 1     1   2   50 50             45         100 58 0 38   0 1     1   2   50 50         45       100
706600 ID     school 1602580 371   PAYETTE JOINT DISTRICT 160258000456 805 WESTSIDE ELEMENTARY SCHOOL   Regular School No Elementary 04 05 2021   grade_5 60 0 35   1 0     0   2   42 56             36         98 60 0 35   1 0     0   2   42 56         36       98
706601 ID     school 1602580 371   PAYETTE JOINT DISTRICT 160258000456 805 WESTSIDE ELEMENTARY SCHOOL   Regular School No Elementary 04 05 2021   k_12_total 118 0 73   1 1     1   4   92 106             81         198 118 0 73   1 1     1   4   92 106         81       198
706781 ID     school 1603180 401   TETON COUNTY DISTRICT 160318001022 1236 RENDEZVOUS UPPER ELEMENTARY SCHOOL   Regular School No Elementary 04 05 2021   grade_4 73 0 36   0 0     1   2   52 60             36         112 73 0 36   0 0     1   2   52 60         36       112
706782 ID     school 1603180 401   TETON COUNTY DISTRICT 160318001022 1236 RENDEZVOUS UPPER ELEMENTARY SCHOOL   Regular School No Elementary 04 05 2021   grade_5 84 0 49   0 0     0   1   74 60             50         134 84 0 49   0 0     0   1   74 60         50       134
706783 ID     school 1603180 401   TETON COUNTY DISTRICT 160318001022 1236 RENDEZVOUS UPPER ELEMENTARY SCHOOL   Regular School No Elementary 04 05 2021   k_12_total 157 0 85   0 0     1   3   126 120             86         246 157 0 85   0 0     1   3   126 120         86       246
706934 ID     school 1601050 413   FILER DISTRICT 160105001006 1244 FILER INTERMEDIATE SCHOOL   Regular School No Middle 04 06 2021   grade_4 87 0 15   0 0     0   0   48 54             *         102 87 0 15   0 0     0   0   48 54                 102
706935 ID     school 1601050 413   FILER DISTRICT 160105001006 1244 FILER INTERMEDIATE SCHOOL   Regular School No Middle 04 06 2021   grade_5 109 1 13   1 0     0   1   69 56             40         125 109 1 13   1 0     0   1   69 56         40       125
706936 ID     school 1601050 413   FILER DISTRICT 160105001006 1244 FILER INTERMEDIATE SCHOOL   Regular School No Middle 04 06 2021   grade_6 86 1 21   0 0     0   0   60 48             *         108 86 1 21   0 0     0   0   60 48                 108
706937 ID     school 1601050 413   FILER DISTRICT 160105001006 1244 FILER INTERMEDIATE SCHOOL   Regular School No Middle 04 06 2021   k_12_total 282 2 49   1 0     0   1   177 158             105         335 282 2 49   1 0     0   1   177 158         105       335
707065 ID     school 1603330 431   WEISER DISTRICT 160333000566 840 PARK INTERMEDIATE SCHOOL   Regular School No Elementary 04 05 2021   grade_4 73 0 30   1 0     0   2   58 48             *         106 73 0 30   1 0     0   2   58 48                 106
707066 ID     school 1603330 431   WEISER DISTRICT 160333000566 840 PARK INTERMEDIATE SCHOOL   Regular School No Elementary 04 05 2021   grade_5 68 0 25   2 0     0   2   50 47             50         97 68 0 25   2 0     0   2   50 47         50       97
707067 ID     school 1603330 431   WEISER DISTRICT 160333000566 840 PARK INTERMEDIATE SCHOOL   Regular School No Elementary 04 05 2021   k_12_total 141 0 55   3 0     0   4   108 95             *         203 141 0 55   3 0     0   4   108 95                 203
707661 ID     school 1600186 531   FERN-WATERS PUBLIC CHARTER SCHOOL, INC. 160018601114 1423 FERN-WATERS PUBLIC CHARTER SCHOOL   Regular School Yes Middle 04 08 2021   grade_4 12 0 0   0 0     0   0   6 6             *         12 12 0 0   0 0     0   0   6 6                 12
707662 ID     school 1600186 531   FERN-WATERS PUBLIC CHARTER SCHOOL, INC. 160018601114 1423 FERN-WATERS PUBLIC CHARTER SCHOOL   Regular School Yes Middle 04 08 2021   grade_5 13 0 0   0 0     0   0   6 7             8         13 13 0 0   0 0     0   0   6 7         8       13
707663 ID     school 1600186 531   FERN-WATERS PUBLIC CHARTER SCHOOL, INC. 160018601114 1423 FERN-WATERS PUBLIC CHARTER SCHOOL   Regular School Yes Middle 04 08 2021   grade_6 12 0 0   0 0     0   0   5 7             7         12 12 0 0   0 0     0   0   5 7         7       12
707664 ID     school 1600186 531   FERN-WATERS PUBLIC CHARTER SCHOOL, INC. 160018601114 1423 FERN-WATERS PUBLIC CHARTER SCHOOL   Regular School Yes Middle 04 08 2021   grade_7 12 0 0   0 0     0   1   5 8             7         13 12 0 0   0 0     0   1   5 8         7       13
707665 ID     school 1600186 531   FERN-WATERS PUBLIC CHARTER SCHOOL, INC. 160018601114 1423 FERN-WATERS PUBLIC CHARTER SCHOOL   Regular School Yes Middle 04 08 2021   grade_8 9 0 1   0 0     0   1   5 6             *         11 9 0 1   0 0     0   1   5 6                 11
707666 ID     school 1600186 531   FERN-WATERS PUBLIC CHARTER SCHOOL, INC. 160018601114 1423 FERN-WATERS PUBLIC CHARTER SCHOOL   Regular School Yes Middle 04 08 2021   k_12_total 58 0 1   0 0     0   2   27 34             35         61 58 0 1   0 0     0   2   27 34         35       61
703092 ID     school 1600360 1   BOISE INDEPENDENT DISTRICT 160036000708 9002 ADA COUNTY JUVENILE CENTER   Alternative School No High 05 12 2021   grade_10 2 0 1   0 0     0   0   3 0             *         3 2 0 1   0 0     0   0   3 0                 3
703093 ID     school 1600360 1   BOISE INDEPENDENT DISTRICT 160036000708 9002 ADA COUNTY JUVENILE CENTER   Alternative School No High 05 12 2021   grade_11 3 3 0   0 0     0   2   6 2             *         8 3 3 0   0 0     0   2   6 2                 8
703094 ID     school 1600360 1   BOISE INDEPENDENT DISTRICT 160036000708 9002 ADA COUNTY JUVENILE CENTER   Alternative School No High 05 12 2021   grade_12 1 0 0   0 0     0   0   1 0             *         1 1 0 0   0 0     0   0   1 0                 1
703095 ID     school 1600360 1   BOISE INDEPENDENT DISTRICT 160036000708 9002 ADA COUNTY JUVENILE CENTER   Alternative School No High 05 12 2021   grade_9 1 1 1   0 0     0   0   2 1             *         3 1 1 1   0 0     0   0   2 1                 3
703096 ID     school 1600360 1   BOISE INDEPENDENT DISTRICT 160036000708 9002 ADA COUNTY JUVENILE CENTER   Alternative School No High 05 12 2021   k_12_total 7 4 2   0 0     0   2   12 3             8         15 7 4 2   0 0     0   2   12 3         8       15
703822 ID     school 1602970 52   SNAKE RIVER DISTRICT 160297000644 380 SNAKE RIVER MIDDLE SCHOOL   Regular School No Middle 05 06 2021   grade_5 121 1 13   1 0     0   2   64 74             *         138 121 1 13   1 0     0   2   64 74                 138
703823 ID     school 1602970 52   SNAKE RIVER DISTRICT 160297000644 380 SNAKE RIVER MIDDLE SCHOOL   Regular School No Middle 05 06 2021   grade_6 114 3 18   1 0     2   1   70 69             *         139 114 3 18   1 0     2   1   70 69                 139
703824 ID     school 1602970 52   SNAKE RIVER DISTRICT 160297000644 380 SNAKE RIVER MIDDLE SCHOOL   Regular School No Middle 05 06 2021   k_12_total 235 4 31   2 0     2   3   134 143             90         277 235 4 31   2 0     2   3   134 143         90       277
703926 ID     school 1601080 59   FIRTH DISTRICT 160108000326 155 FIRTH MIDDLE SCHOOL   Regular School No Middle 05 08 2021   grade_5 75 1 8   0 1     0   0   43 42             33         85 75 1 8   0 1     0   0   43 42         33       85
703927 ID     school 1601080 59   FIRTH DISTRICT 160108000326 155 FIRTH MIDDLE SCHOOL   Regular School No Middle 05 08 2021   grade_6 56 1 7   1 2     0   0   31 36             26         67 56 1 7   1 2     0   0   31 36         26       67
703928 ID     school 1601080 59   FIRTH DISTRICT 160108000326 155 FIRTH MIDDLE SCHOOL   Regular School No Middle 05 08 2021   grade_7 53 2 10   0 0     0   0   37 28             23         65 53 2 10   0 0     0   0   37 28         23       65
703929 ID     school 1601080 59   FIRTH DISTRICT 160108000326 155 FIRTH MIDDLE SCHOOL   Regular School No Middle 05 08 2021   grade_8 63 0 8   2 0     0   0   37 36             28         73 63 0 8   2 0     0   0   37 36         28       73
703930 ID     school 1601080 59   FIRTH DISTRICT 160108000326 155 FIRTH MIDDLE SCHOOL   Regular School No Middle 05 08 2021   k_12_total 247 4 33   3 3     0   0   148 142             110         290 247 4 33   3 3     0   0   148 142         110       290
703949 ID     school 1602910 60   SHELLEY JOINT DISTRICT 160291000511 392 HAZEL STUART ELEMENTARY SCHOOL   Regular School No Middle 05 06 2021   grade_5 158 1 19   0 3     0   0   85 96             67         181 158 1 19   0 3     0   0   85 96         67       181
703950 ID     school 1602910 60   SHELLEY JOINT DISTRICT 160291000511 392 HAZEL STUART ELEMENTARY SCHOOL   Regular School No Middle 05 06 2021   grade_6 153 2 26   0 0     0   0   90 91             64         181 153 2 26   0 0     0   0   90 91         64       181
703951 ID     school 1602910 60   SHELLEY JOINT DISTRICT 160291000511 392 HAZEL STUART ELEMENTARY SCHOOL   Regular School No Middle 05 06 2021   k_12_total 311 3 45   0 3     0   0   175 187             131         362 311 3 45   0 3     0   0   175 187         131       362
704168 ID     school 1600002 84   LAKE PEND OREILLE SCHOOL DISTRICT 160000200604 997 SANDPOINT JUVENILE DETENTION   Alternative School No High 05 12 2021   grade_10 2 0 0   0 0     0   0   1 1             *         2 2 0 0   0 0     0   0   1 1                 2
704169 ID     school 1600002 84   LAKE PEND OREILLE SCHOOL DISTRICT 160000200604 997 SANDPOINT JUVENILE DETENTION   Alternative School No High 05 12 2021   grade_12 1 0 0   0 0     0   0   1 0             *         1 1 0 0   0 0     0   0   1 0                 1
704170 ID     school 1600002 84   LAKE PEND OREILLE SCHOOL DISTRICT 160000200604 997 SANDPOINT JUVENILE DETENTION   Alternative School No High 05 12 2021   k_12_total 3 0 0   0 0     0   0   2 1             *         3 3 0 0   0 0     0   0   2 1                 3
704869 ID     school 1602550 137   PARMA DISTRICT 160255000080 282 PARMA MIDDLE SCHOOL   Regular School No Middle 05 08 2021   grade_5 48 0 21   1 0     0   3   32 41             36         73 48 0 21   1 0     0   3   32 41         36       73
704870 ID     school 1602550 137   PARMA DISTRICT 160255000080 282 PARMA MIDDLE SCHOOL   Regular School No Middle 05 08 2021   grade_6 47 0 28   0 0     0   4   38 41             37         79 47 0 28   0 0     0   4   38 41         37       79
704871 ID     school 1602550 137   PARMA DISTRICT 160255000080 282 PARMA MIDDLE SCHOOL   Regular School No Middle 05 08 2021   grade_7 61 1 24   0 0     0   2   46 42             37         88 61 1 24   0 0     0   2   46 42         37       88
704872 ID     school 1602550 137   PARMA DISTRICT 160255000080 282 PARMA MIDDLE SCHOOL   Regular School No Middle 05 08 2021   grade_8 61 0 30   0 1     0   1   45 48             40         93 61 0 30   0 1     0   1   45 48         40       93
704873 ID     school 1602550 137   PARMA DISTRICT 160255000080 282 PARMA MIDDLE SCHOOL   Regular School No Middle 05 08 2021   k_12_total 217 1 103   1 1     0   10   161 172             150         333 217 1 103   1 1     0   10   161 172         150       333
704991 ID     school 1603000 150   SODA SPRINGS JOINT DISTRICT 160300000527 78 TIGERT MIDDLE SCHOOL   Regular School No Middle 05 08 2021   grade_5 55 0 4   0 1     0   2   41 21             *         62 55 0 4   0 1     0   2   41 21                 62
704992 ID     school 1603000 150   SODA SPRINGS JOINT DISTRICT 160300000527 78 TIGERT MIDDLE SCHOOL   Regular School No Middle 05 08 2021   grade_6 60 0 2   0 0     0   2   32 32             *         64 60 0 2   0 0     0   2   32 32                 64
704993 ID     school 1603000 150   SODA SPRINGS JOINT DISTRICT 160300000527 78 TIGERT MIDDLE SCHOOL   Regular School No Middle 05 08 2021   grade_7 67 0 2   0 1     0   1   35 36             *         71 67 0 2   0 1     0   1   35 36                 71
704994 ID     school 1603000 150   SODA SPRINGS JOINT DISTRICT 160300000527 78 TIGERT MIDDLE SCHOOL   Regular School No Middle 05 08 2021   grade_8 57 0 3   0 0     0   1   23 38             19         61 57 0 3   0 0     0   1   23 38         19       61
704995 ID     school 1603000 150   SODA SPRINGS JOINT DISTRICT 160300000527 78 TIGERT MIDDLE SCHOOL   Regular School No Middle 05 08 2021   k_12_total 239 0 11   0 2     0   6   131 127             86         258 239 0 11   0 2     0   6   131 127         86       258
705298 ID     school 1602250 193   MOUNTAIN HOME DISTRICT 160225000745 556 HACKER MIDDLE SCHOOL   Regular School No Middle 05 06 2021   grade_5 175 7 67   2 2     2   28   150 133             *         283 175 7 67   2 2     2   28   150 133                 283
705299 ID     school 1602250 193   MOUNTAIN HOME DISTRICT 160225000745 556 HACKER MIDDLE SCHOOL   Regular School No Middle 05 06 2021   grade_6 197 1 75   1 2     2   20   164 134             *         298 197 1 75   1 2     2   20   164 134                 298
705300 ID     school 1602250 193   MOUNTAIN HOME DISTRICT 160225000745 556 HACKER MIDDLE SCHOOL   Regular School No Middle 05 06 2021   k_12_total 372 8 142   3 4     4   48   314 267             234         581 372 8 142   3 4     4   48   314 267         234       581
705390 ID     school 1601110 215   FREMONT COUNTY JOINT DISTRICT 160111000912 1271 FIVE-COUNTY DETENTION CENTER   Alternative School No High 05 12 2021   grade_10 2 0 0   1 0     0   0   1 2             *         3 2 0 0   1 0     0   0   1 2                 3
705391 ID     school 1601110 215   FREMONT COUNTY JOINT DISTRICT 160111000912 1271 FIVE-COUNTY DETENTION CENTER   Alternative School No High 05 12 2021   grade_11 0 0 0   1 0     0   0   0 1             *         1 0 0 0   1 0     0   0   0 1                 1
705392 ID     school 1601110 215   FREMONT COUNTY JOINT DISTRICT 160111000912 1271 FIVE-COUNTY DETENTION CENTER   Alternative School No High 05 12 2021   grade_12 1 0 0   0 0     0   0   1 0             *         1 1 0 0   0 0     0   0   1 0                 1
705393 ID     school 1601110 215   FREMONT COUNTY JOINT DISTRICT 160111000912 1271 FIVE-COUNTY DETENTION CENTER   Alternative School No High 05 12 2021   grade_8 1 0 0   0 0     0   0   1 0             *         1 1 0 0   0 0     0   0   1 0                 1
705394 ID     school 1601110 215   FREMONT COUNTY JOINT DISTRICT 160111000912 1271 FIVE-COUNTY DETENTION CENTER   Alternative School No High 05 12 2021   grade_9 1 0 0   0 0     0   1   1 1             *         2 1 0 0   0 0     0   1   1 1                 2
705395 ID     school 1601110 215   FREMONT COUNTY JOINT DISTRICT 160111000912 1271 FIVE-COUNTY DETENTION CENTER   Alternative School No High 05 12 2021   k_12_total 5 0 0   2 0     0   1   4 4             *         8 5 0 0   2 0     0   1   4 4                 8
705468 ID     school 1603360 232   WENDELL DISTRICT 160336000571 104 WENDELL MIDDLE SCHOOL   Regular School No Middle 05 08 2021   grade_5 24 0 57   0 0     0   1   49 33             61         82 24 0 57   0 0     0   1   49 33         61       82
705469 ID     school 1603360 232   WENDELL DISTRICT 160336000571 104 WENDELL MIDDLE SCHOOL   Regular School No Middle 05 08 2021   grade_6 35 0 64   1 0     0   0   58 42             67         100 35 0 64   1 0     0   0   58 42         67       100
705470 ID     school 1603360 232   WENDELL DISTRICT 160336000571 104 WENDELL MIDDLE SCHOOL   Regular School No Middle 05 08 2021   grade_7 37 0 56   0 0     0   0   51 42             66         93 37 0 56   0 0     0   0   51 42         66       93
705471 ID     school 1603360 232   WENDELL DISTRICT 160336000571 104 WENDELL MIDDLE SCHOOL   Regular School No Middle 05 08 2021   grade_8 23 0 45   0 0     1   1   37 33             46         70 23 0 45   0 0     1   1   37 33         46       70
705472 ID     school 1603360 232   WENDELL DISTRICT 160336000571 104 WENDELL MIDDLE SCHOOL   Regular School No Middle 05 08 2021   k_12_total 119 0 222   1 0     1   2   195 150             240         345 119 0 222   1 0     1   2   195 150         240       345

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