Data source: Big Local News · About: Big Local

235 rows where grade = "grade_9", state = "ID" and year = 2019 sorted by school_state_id

View and edit SQL

year

  • 2019 · 235

grade

  • grade_9 · 235
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
1304974 ID     school 1600360 1   BOISE INDEPENDENT DISTRICT 160036000051 2 FAIRMONT JUNIOR HIGH SCHOOL   Regular School No Middle 07 9.0 2019   grade_9 157 18 63   1 10     1   8   146 112             96         258 157 18 63   1 10     1   8   146 112         96       258
1304978 ID     school 1600360 1   BOISE INDEPENDENT DISTRICT 160036000057 3 HILLSIDE JUNIOR HIGH SCHOOL   Regular School No Middle 07 9.0 2019   grade_9 170 23 16   2 8     0   6   116 109             69         225 170 23 16   2 8     0   6   116 109         69       225
1304982 ID     school 1600360 1   BOISE INDEPENDENT DISTRICT 160036000069 4 NORTH JUNIOR HIGH SCHOOL   Regular School No Middle 07 9.0 2019   grade_9 298 5 23   1 11     1   7   152 194             57         346 298 5 23   1 11     1   7   152 194         57       346
1304986 ID     school 1600360 1   BOISE INDEPENDENT DISTRICT 160036000073 5 SOUTH JUNIOR HIGH SCHOOL   Regular School No Middle 07 9.0 2019   grade_9 155 11 35   1 4     1   2   118 91             74         209 155 11 35   1 4     1   2   118 91         74       209
1304995 ID     school 1600360 1   BOISE INDEPENDENT DISTRICT 160036000045 8 BORAH SENIOR HIGH SCHOOL   Regular School No High 09 12.0 2019   grade_9 0 7 0   0 0     0   0   4 3             *         7 0 7 0   0 0     0   0   4 3                 7
1305311 ID     school 1602100 2   JOINT SCHOOL DISTRICT NO. 2 160210000372 12 MERIDIAN HIGH SCHOOL   Regular School No High 09 12.0 2019   grade_9 369 10 79   4 7     3   13   260 225             131         485 369 10 79   4 7     3   13   260 225         131       485
1305645 ID     school 1601770 3   KUNA JOINT DISTRICT 160177000307 14 KUNA HIGH SCHOOL   Regular School No High 09 12.0 2019   grade_9 377 4 53   3 7     1   11   235 221             *         456 377 4 53   3 7     1   11   235 221                 456
1305316 ID     school 1602100 2   JOINT SCHOOL DISTRICT NO. 2 160210000674 15 CENTENNIAL HIGH SCHOOL   Regular School No High 09 12.0 2019   grade_9 447 19 81   6 21     2   21   310 287             160         597 447 19 81   6 21     2   21   310 287         160       597
1305709 ID     school 1600840 13   COUNCIL DISTRICT 160084000163 17 COUNCIL JR/SR HIGH SCHOOL   Regular School No High 07 12.0 2019   grade_9 17 0 0   0 0     0   3   10 10             11         20 17 0 0   0 0     0   3   10 10         11       20
1305725 ID     school 1601950 21   MARSH VALLEY JOINT DISTRICT 160195000347 19 MARSH VALLEY HIGH SCHOOL   Regular School No High 07 12.0 2019   grade_9 112 2 2   1 0     1   1   70 49             47         119 112 2 2   1 0     1   1   70 49         47       119
1305778 ID     school 1602640 25   POCATELLO DISTRICT 160264000478 24 POCATELLO HIGH SCHOOL   Regular School No High 09 12.0 2019   grade_9 226 5 36   8 1     2   8   137 149             128         286 226 5 36   8 1     2   8   137 149         128       286
1305783 ID     school 1602640 25   POCATELLO DISTRICT 160264000472 25 HIGHLAND HIGH SCHOOL   Regular School No High 09 12.0 2019   grade_9 327 2 32   23 2     5   9   218 182             128         400 327 2 32   23 2     5   9   218 182         128       400
1305901 ID     school 1600240 33   BEAR LAKE COUNTY DISTRICT 160024000018 27 BEAR LAKE HIGH SCHOOL   Regular School No High 09 12.0 2019   grade_9 80 1 2   1 0     1   0   39 46             38         85 80 1 2   1 0     1   0   39 46         38       85
1305935 ID     school 1603060 41   ST MARIES JOINT DISTRICT 160306000532 29 ST MARIES HIGH SCHOOL   Regular School No High 09 12.0 2019   grade_9 64 0 1   1 0     0   5   39 32             37         71 64 0 1   1 0     0   5   39 32         37       71
1305959 ID     school 1600815 44   PLUMMER-WORLEY JOINT DISTRICT 160081500720 30 LAKESIDE HIGH SCHOOL   Regular School No High 09 12.0 2019   grade_9 15 0 1   23 0     0   9   28 20             *         48 15 0 1   23 0     0   9   28 20                 48
1305978 ID     school 1602970 52   SNAKE RIVER DISTRICT 160297000521 32 SNAKE RIVER HIGH SCHOOL   Regular School No High 09 12.0 2019   grade_9 127 0 20   4 0     0   6   87 70             52         157 127 0 20   4 0     0   6   87 70         52       157
1305998 ID     school 1600270 55   BLACKFOOT DISTRICT 160027000022 34 BLACKFOOT HIGH SCHOOL   Regular School No High 09 12.0 2019   grade_9 192 0 73   37 2     0   11   136 179             *         315 192 0 73   37 2     0   11   136 179                 315
1306085 ID     school 1602910 60   SHELLEY JOINT DISTRICT 160291000510 35 SHELLEY SENIOR HIGH SCHOOL   Regular School No High 09 12.0 2019   grade_9 149 2 25   1 1     0   1   86 93             71         179 149 2 25   1 1     0   1   86 93         71       179
1306053 ID     school 1600030 58   ABERDEEN DISTRICT 160003000002 36 ABERDEEN HIGH SCHOOL   Regular School No High 09 12.0 2019   grade_9 23 1 25   1 0     1   2   26 27             *         53 23 1 25   1 0     1   2   26 27                 53
1306069 ID     school 1601080 59   FIRTH DISTRICT 160108000198 38 FIRTH HIGH SCHOOL   Regular School No High 07 12.0 2019   grade_9 46 0 8   2 0     0   0   31 25             16         56 46 0 8   2 0     0   0   31 25         16       56
1306103 ID     school 1600300 61   BLAINE COUNTY DISTRICT 160030000038 42 WOOD RIVER HIGH SCHOOL   Regular School No High 09 12.0 2019   grade_9 136 0 97   1 0     0   2   133 103             67         236 136 0 97   1 0     0   2   133 103         67       236
1306214 ID     school 1600001 83   WEST BONNER COUNTY DISTRICT 160000100084 48 PRIEST RIVER LAMANNA HIGH   Regular School No High 09 12.0 2019   grade_9 74 0 2   1 0     0   1   54 24             39         78 74 0 2   1 0     0   1   54 24         39       78
1306248 ID     school 1600002 84   LAKE PEND OREILLE SCHOOL DISTRICT 160000200082 49 CLARK FORK JR/SR HIGH SCHOOL   Regular School No High 07 12.0 2019   grade_9 24 0 0   0 0     0   0   14 10             *         24 24 0 0   0 0     0   0   14 10                 24
1306324 ID     school 1601530 91   IDAHO FALLS DISTRICT 160153000268 53 SKYLINE SENIOR HIGH SCHOOL   Regular School No High 09 12.0 2019   grade_9 224 2 81   1 4     2   10   168 156             138         324 224 2 81   1 4     2   10   168 156         138       324
1306329 ID     school 1601530 91   IDAHO FALLS DISTRICT 160153000262 54 IDAHO FALLS SENIOR HIGH SCHOOL   Regular School No High 09 12.0 2019   grade_9 268 3 46   2 3     1   8   176 155             125         331 268 3 46   2 3     1   8   176 155         125       331
1306467 ID     school 1600930 93   BONNEVILLE JOINT DISTRICT 160093000169 56 BONNEVILLE HIGH SCHOOL   Regular School No High 09 12.0 2019   grade_9 204 1 37   0 1     0   7   139 111             103         250 204 1 37   0 1     0   7   139 111         103       250
1306624 ID     school 1600420 101   BOUNDARY COUNTY DISTRICT 160042000089 57 BONNERS FERRY HIGH SCHOOL   Regular School No High 09 12.0 2019   grade_9 89 2 5   2 2     1   3   50 54             49         104 89 2 5   2 2     1   3   50 54         49       104
1306657 ID     school 1600490 111   BUTTE COUNTY JOINT DISTRICT 160049000008 59 BUTTE COUNTY MIDDLE/HIGH SCHOOL   Regular School No High 06 12.0 2019   grade_9 22 2 2   2 0     0   0   11 17             15         28 22 2 2   2 0     0   0   11 17         15       28
1306675 ID     school 1600540 121   CAMAS COUNTY DISTRICT 160054000111 60 CAMAS COUNTY HIGH SCHOOL   Regular School No High 09 12.0 2019   grade_9 16 0 2   0 0     0   0   5 13             6         18 16 0 2   0 0     0   0   5 13         6       18
1306831 ID     school 1600510 132   CALDWELL DISTRICT 160051000104 65 CALDWELL SENIOR HIGH SCHOOL   Regular School No High 09 12.0 2019   grade_9 140 2 274   1 1     0   10   211 217             164         428 140 2 274   1 1     0   10   211 217         164       428
1306915 ID     school 1602130 134   MIDDLETON DISTRICT 160213000377 68 MIDDLETON HIGH SCHOOL   Regular School No High 09 12.0 2019   grade_9 268 1 40   0 0     0   8   153 164             *         317 268 1 40   0 0     0   8   153 164                 317
1306963 ID     school 1602070 136   MELBA JOINT DISTRICT 160207000836 70 MELBA HIGH SCHOOL   Regular School No High 07 12.0 2019   grade_9 58 1 10   0 0     0   1   36 34             23         70 58 1 10   0 0     0   1   36 34         23       70
1306976 ID     school 1602550 137   PARMA DISTRICT 160255000451 72 PARMA HIGH SCHOOL   Regular School No High 09 12.0 2019   grade_9 48 0 24   0 0     0   4   40 36             37         76 48 0 24   0 0     0   4   40 36         37       76
1306992 ID     school 1600600 139   VALLIVUE SCHOOL DISTRICT 160060000118 74 VALLIVUE HIGH SCHOOL   Regular School No High 09 12.0 2019   grade_9 178 2 154   1 3     0   7   160 185             *         345 178 2 154   1 3     0   7   160 185                 345
1307089 ID     school 1602430 149   NORTH GEM DISTRICT 160243000428 77 NORTH GEM HIGH SCHOOL   Regular School No High 07 12.0 2019   grade_9 15 0 0   0 0     0   0   10 5             *         15 15 0 0   0 0     0   0   10 5                 15
1307110 ID     school 1603000 150   SODA SPRINGS JOINT DISTRICT 160300000526 79 SODA SPRINGS HIGH SCHOOL   Regular School No High 09 12.0 2019   grade_9 59 0 2   0 0     0   1   29 33             *         62 59 0 2   0 0     0   1   29 33                 62
1307138 ID     school 1600660 151   CASSIA COUNTY JOINT DISTRICT 160066000124 81 BURLEY SENIOR HIGH SCHOOL   Regular School No High 09 12.0 2019   grade_9 146 0 117   3 0     1   5   155 117             136         272 146 0 117   3 0     1   5   155 117         136       272
1307145 ID     school 1600660 151   CASSIA COUNTY JOINT DISTRICT 160066000132 82 OAKLEY JR/SR HIGH SCHOOL   Regular School No High 07 12.0 2019   grade_9 25 0 11   0 0     0   0   15 21             14         36 25 0 11   0 0     0   0   15 21         14       36
1307152 ID     school 1600660 151   CASSIA COUNTY JOINT DISTRICT 160066000134 83 RAFT RIVER JR/SR HIGH SCHOOL   Regular School No High 07 12.0 2019   grade_9 26 0 4   0 0     0   0   14 16             *         30 26 0 4   0 0     0   0   14 16                 30
1307157 ID     school 1600660 151   CASSIA COUNTY JOINT DISTRICT 160066000127 84 DECLO SENIOR HIGH SCHOOL   Regular School No High 09 12.0 2019   grade_9 61 0 15   0 0     0   2   41 37             23         78 61 0 15   0 0     0   2   41 37         23       78
1307243 ID     school 1600750 161   CLARK COUNTY DISTRICT 160075000144 85 CLARK COUNTY JR/SR HIGH SCHOOL   Regular School No High 06 12.0 2019   grade_9 2 0 8   0 0     0   0   3 7             *         10 2 0 8   0 0     0   0   3 7                 10
1307258 ID     school 1602520 171   OROFINO JOINT DISTRICT 160252000445 87 TIMBERLINE HIGH SCHOOL   Regular School No High 06 12.0 2019   grade_9 17 0 1   0 0     0   1   5 14             *         19 17 0 1   0 0     0   1   5 14                 19
1307265 ID     school 1602520 171   OROFINO JOINT DISTRICT 160252000440 88 OROFINO HIGH SCHOOL   Regular School No High 07 12.0 2019   grade_9 55 2 1   1 0     0   1   32 28             36         60 55 2 1   1 0     0   1   32 28         36       60
1307308 ID     school 1600720 181   CHALLIS JOINT DISTRICT 160072000140 89 CHALLIS JR/SR HIGH SCHOOL   Regular School No High 07 12.0 2019   grade_9 18 0 2   0 0     1   0   10 11             10         21 18 0 2   0 0     1   0   10 11         10       21
1307331 ID     school 1601900 182   MACKAY JOINT DISTRICT 160190000332 90 MACKAY JR/SR HIGH SCHOOL   Regular School No High 07 12.0 2019   grade_9 15 0 1   0 0     0   0   9 7             6         16 15 0 1   0 0     0   0   9 7         6       16
1307347 ID     school 1601230 192   GLENNS FERRY JOINT DISTRICT 160123000220 92 GLENNS FERRY HIGH SCHOOL   Regular School No High 09 12.0 2019   grade_9 27 0 9   0 0     0   1   17 20             25         37 27 0 9   0 0     0   1   17 20         25       37
1307366 ID     school 1602250 193   MOUNTAIN HOME DISTRICT 160225000397 95 MOUNTAIN HOME SR HIGH SCHOOL   Regular School No High 09 12.0 2019   grade_9 183 11 70   1 6     1   11   139 144             *         283 183 11 70   1 6     1   11   139 144                 283
1307408 ID     school 1600960 201   PRESTON JOINT DISTRICT 160096000182 96 PRESTON HIGH SCHOOL   Regular School No High 09 12.0 2019   grade_9 186 0 20   1 1     0   3   114 97             76         211 186 0 20   1 1     0   3   114 97         76       211
1307449 ID     school 1601110 215   FREMONT COUNTY JOINT DISTRICT 160111000205 99 SOUTH FREMONT HIGH SCHOOL   Regular School No High 09 12.0 2019   grade_9 103 0 30   0 0     0   1   60 74             67         134 103 0 30   0 0     0   1   60 74         67       134
1307457 ID     school 1601110 215   FREMONT COUNTY JOINT DISTRICT 160111000203 100 NORTH FREMONT JR/SR HIGH SCHOOL   Regular School No High 06 12.0 2019   grade_9 35 0 9   0 0     0   2   21 25             *         46 35 0 9   0 0     0   2   21 25                 46
1307496 ID     school 1601020 221   EMMETT INDEPENDENT DISTRICT 160102000187 101 EMMETT HIGH SCHOOL   Regular School No High 09 12.0 2019   grade_9 147 1 27   1 0     2   1   100 79             75         179 147 1 27   1 0     2   1   100 79         75       179
1307549 ID     school 1601260 231   GOODING JOINT DISTRICT 160126000224 103 GOODING HIGH SCHOOL   Regular School No High 09 12.0 2019   grade_9 84 1 40   1 0     0   0   54 72             57         126 84 1 40   1 0     0   0   54 72         57       126
1307607 ID     school 1600810 242   COTTONWOOD JOINT DISTRICT 160081000161 111 PRAIRIE JR/SR HIGH SCHOOL   Regular School No High 07 12.0 2019   grade_9 30 1 2   0 0     0   0   18 15             17         33 30 1 2   0 0     0   0   18 15         17       33
1305325 ID     school 1602100 2   JOINT SCHOOL DISTRICT NO. 2 160210000318 112 EAGLE HIGH SCHOOL   Regular School No High 09 12.0 2019   grade_9 427 3 36   4 6     0   21   254 243             47         497 427 3 36   4 6     0   21   254 243         47       497
1307670 ID     school 1601570 251   JEFFERSON COUNTY JOINT DISTRICT 160157000277 114 RIGBY HIGH SCHOOL   Regular School No High 09 12.0 2019   grade_9 370 1 60   0 0     1   9   223 218             *         441 370 1 60   0 0     1   9   223 218                 441
1307735 ID     school 1603400 253   WEST JEFFERSON DISTRICT 160340000281 115 WEST JEFFERSON HIGH SCHOOL   Regular School No High 09 12.0 2019   grade_9 37 1 9   0 0     0   2   24 25             18         49 37 1 9   0 0     0   2   24 25         18       49
1307760 ID     school 1601590 261   JEROME JOINT DISTRICT 160159000284 118 JEROME HIGH SCHOOL   Regular School No High 09 12.0 2019   grade_9 157 0 183   1 0     0   4   189 156             *         345 157 0 183   1 0     0   4   189 156                 345
1307799 ID     school 1603270 262   VALLEY DISTRICT 160327000558 119 VALLEY SCHOOL   Regular School No Other PK 12.0 2019   grade_9 30 0 17   0 0     0   1   23 25             28         48 30 0 17   0 0     0   1   23 25         28       48
1307813 ID     school 1600780 271   COEUR D'ALENE DISTRICT 160078000149 122 COEUR D'ALENE HIGH SCHOOL   Regular School No High 09 12.0 2019   grade_9 300 2 28   3 6     1   15   187 168             79         355 300 2 28   3 6     1   15   187 168         79       355
1307919 ID     school 1601800 272   LAKELAND DISTRICT 160180000311 124 LAKELAND SENIOR HIGH SCHOOL   Regular School No High 09 12.0 2019   grade_9 196 0 9   1 0     0   13   108 111             71         219 196 0 9   1 0     0   13   108 111         71       219
1307989 ID     school 1602670 273   POST FALLS DISTRICT 160267000488 126 POST FALLS HIGH SCHOOL   Regular School No High 09 12.0 2019   grade_9 406 1 23   3 6     3   13   217 238             *         455 406 1 23   3 6     3   13   217 238                 455
1308044 ID     school 1601740 274   KOOTENAI DISTRICT 160174000303 127 KOOTENAI JR/SR HIGH SCHOOL   Regular School No High 06 12.0 2019   grade_9 15 0 2   0 1     0   0   11 7             7         18 15 0 2   0 1     0   0   11 7         7       18
1308060 ID     school 1602220 281   MOSCOW DISTRICT 160222000394 130 MOSCOW HIGH SCHOOL   Regular School No High 09 12.0 2019   grade_9 165 3 12   3 5     3   5   117 79             57         196 165 3 12   3 5     3   5   117 79         57       196
1308106 ID     school 1601680 283   KENDRICK JOINT DISTRICT 160168000299 132 KENDRICK JR/SR HIGH SCHOOL   Regular School No High 07 12.0 2019   grade_9 18 0 1   0 0     0   0   13 6             7         19 18 0 1   0 0     0   0   13 6         7       19
1308121 ID     school 1602700 285   POTLATCH DISTRICT 160270000495 135 POTLATCH JR/SR HIGH SCHOOL   Regular School No High 07 12.0 2019   grade_9 31 0 0   0 0     0   1   19 13             11         32 31 0 0   0 0     0   1   19 13         11       32
1308167 ID     school 1602850 291   SALMON DISTRICT 160285000504 136 SALMON JR/SR HIGH SCHOOL   Regular School No High 06 12.0 2019   grade_9 63 1 2   2 0     0   2   40 30             *         70 63 1 2   2 0     0   2   40 30                 70
1308191 ID     school 1603030 292   SOUTH LEMHI DISTRICT 160303000528 137 LEADORE SCHOOL   Regular School No Other PK 12.0 2019   grade_9 1 0 0   0 0     0   0   0 1             *         1 1 0 0   0 0     0   0   0 1                 1
1308277 ID     school 1600900 314   DIETRICH DISTRICT 160090000165 143 DIETRICH SCHOOL   Regular School No Other PK 12.0 2019   grade_9 12 0 3   0 0     0   0   6 9             8         15 12 0 3   0 0     0   0   6 9         8       15
1308291 ID     school 1602760 316   RICHFIELD DISTRICT 160276000497 144 RICHFIELD SCHOOL   Regular School No Other PK 12.0 2019   grade_9 6 0 3   0 0     0   1   3 7             *         10 6 0 3   0 0     0   1   3 7                 10
1308296 ID     school 1601920 321   MADISON DISTRICT 160192000340 145 MADISON JUNIOR HIGH SCHOOL   Regular School No Middle 07 9.0 2019   grade_9 356 3 26   1 3     1   0   206 184             *         390 356 3 26   1 3     1   0   206 184                 390
1308353 ID     school 1603090 322   SUGAR-SALEM JOINT DISTRICT 160309000538 147 SUGAR-SALEM HIGH SCHOOL   Regular School No High 09 12.0 2019   grade_9 136 1 6   0 1     0   1   77 68             44         145 136 1 6   0 1     0   1   77 68         44       145
1308382 ID     school 1602190 331   MINIDOKA COUNTY JOINT DISTRICT 160219000385 150 MINICO SENIOR HIGH SCHOOL   Regular School No High 09 12.0 2019   grade_9 152 0 149   2 0     0   2   157 148             206         305 152 0 149   2 0     0   2   157 148         206       305
1308428 ID     school 1601860 340   LEWISTON INDEPENDENT DISTRICT 160186000328 151 SACAJAWEA MIDDLE SCHOOL   Regular School No Middle 07 9.0 2019   grade_9 163 3 7   3 2     1   9   108 80             *         188 163 3 7   3 2     1   9   108 80                 188
1308432 ID     school 1601860 340   LEWISTON INDEPENDENT DISTRICT 160186000322 152 JENIFER MIDDLE SCHOOL   Regular School No Middle 07 9.0 2019   grade_9 170 0 10   1 2     0   20   96 107             59         203 170 0 10   1 2     0   20   96 107         59       203
1308437 ID     school 1601860 340   LEWISTON INDEPENDENT DISTRICT 160186000323 153 LEWISTON HIGH SCHOOL   Regular School No High 09 12.0 2019   grade_9 1 0 0   0 0     0   0   0 1             *         1 1 0 0   0 0     0   0   0 1                 1
1308549 ID     school 1602490 351   ONEIDA COUNTY DISTRICT 160249000433 156 MALAD SENIOR HIGH SCHOOL   Regular School No High 09 12.0 2019   grade_9 64 0 3   1 1     0   0   40 29             29         69 64 0 3   1 1     0   0   40 29         29       69
1308583 ID     school 1601980 363   MARSING JOINT DISTRICT 160198000352 157 MARSING HIGH SCHOOL   Regular School No High 09 12.0 2019   grade_9 53 0 29   0 0     0   3   52 33             50         85 53 0 29   0 0     0   3   52 33         50       85
1308610 ID     school 1600450 365   BRUNEAU-GRAND VIEW JOINT SCHOOL DISTRICT 160045000100 158 RIMROCK JR/SR HIGH SCHOOL   Regular School No High 06 12.0 2019   grade_9 17 0 11   1 0     0   0   15 14             17         29 17 0 11   1 0     0   0   15 14         17       29
1308629 ID     school 1601470 370   HOMEDALE JOINT DISTRICT 160147000248 160 HOMEDALE HIGH SCHOOL   Regular School No High 09 12.0 2019   grade_9 52 0 35   1 0     0   1   45 44             52         89 52 0 35   1 0     0   1   45 44         52       89
1308649 ID     school 1602580 371   PAYETTE JOINT DISTRICT 160258000454 162 PAYETTE HIGH SCHOOL   Regular School No High 09 12.0 2019   grade_9 99 0 40   1 0     0   4   73 71             *         144 99 0 40   1 0     0   4   73 71                 144
1308662 ID     school 1602370 372   NEW PLYMOUTH DISTRICT 160237000736 164 NEW PLYMOUTH HIGH SCHOOL   Regular School No High 09 12.0 2019   grade_9 74 1 11   0 0     0   1   49 38             34         87 74 1 11   0 0     0   1   49 38         34       87
1308683 ID     school 1601140 373   FRUITLAND DISTRICT 160114000212 166 FRUITLAND HIGH SCHOOL   Regular School No High 09 12.0 2019   grade_9 112 0 37   0 2     0   4   78 77             53         155 112 0 37   0 2     0   4   78 77         53       155
1308703 ID     school 1600060 381   AMERICAN FALLS JOINT DISTRICT 160006000003 168 AMERICAN FALLS HIGH SCHOOL   Regular School No High 09 12.0 2019   grade_9 46 0 54   3 0     1   0   51 53             76         104 46 0 54   3 0     1   0   51 53         76       104
1308731 ID     school 1602820 382   ROCKLAND DISTRICT 160282000501 169 ROCKLAND PUBLIC SCHOOL   Regular School No Other PK 12.0 2019   grade_9 14 0 0   0 0     0   0   8 6             5         14 14 0 0   0 0     0   0   8 6         5       14
1308747 ID     school 1601650 391   KELLOGG JOINT DISTRICT 160165000293 171 KELLOGG HIGH SCHOOL   Regular School No High 09 12.0 2019   grade_9 74 0 3   2 2     0   0   45 36             31         81 74 0 3   2 2     0   0   45 36         31       81
1308774 ID     school 1602280 392   MULLAN DISTRICT 160228000405 172 MULLAN SCHOOLS   Regular School No Other KG 12.0 2019   grade_9 3 0 1   0 0     0   0   2 2             *         4 3 0 1   0 0     0   0   2 2                 4
1308790 ID     school 1603300 393   WALLACE DISTRICT 160330000565 174 WALLACE JR/SR HIGH SCHOOL   Regular School No High 07 12.0 2019   grade_9 36 1 1   0 0     0   0   18 20             16         38 36 1 1   0 0     0   0   18 20         16       38
1308804 ID     school 1603180 401   TETON COUNTY DISTRICT 160318000543 175 TETON HIGH SCHOOL   Regular School No High 09 12.0 2019   grade_9 87 0 36   1 1     0   3   76 52             45         128 87 0 36   1 1     0   3   76 52         45       128
1308842 ID     school 1603240 411   TWIN FALLS DISTRICT 160324000555 178 TWIN FALLS HIGH SCHOOL   Regular School No High 09 12.0 2019   grade_9 275 4 57   3 3     6   5   175 178             *         353 275 4 57   3 3     6   5   175 178                 353
1308945 ID     school 1600480 412   BUHL JOINT DISTRICT 160048000102 180 BUHL HIGH SCHOOL   Regular School No High 09 12.0 2019   grade_9 55 0 36   1 0     0   1   46 47             *         93 55 0 36   1 0     0   1   46 47                 93
1308962 ID     school 1601050 413   FILER DISTRICT 160105000194 181 FILER HIGH SCHOOL   Regular School No High 09 12.0 2019   grade_9 102 0 26   1 0     0   2   74 57             42         131 102 0 26   1 0     0   2   74 57         42       131
1308986 ID     school 1601710 414   KIMBERLY DISTRICT 160171000635 182 KIMBERLY HIGH SCHOOL   Regular School No High 09 12.0 2019   grade_9 126 0 21   0 0     0   0   78 69             45         147 126 0 21   0 0     0   0   78 69         45       147
1306191 ID     school 1600180 72   BASIN SCHOOL DISTRICT 160018000350 183 IDAHO CITY HIGH SCHOOL   Regular School No High 07 12.0 2019   grade_9 31 0 2   0 0     0   1   16 18             13         34 31 0 2   0 0     0   1   16 18         13       34
1309038 ID     school 1600690 417   CASTLEFORD DISTRICT 160069000137 185 CASTLEFORD SCHOOL   Regular School No Other PK 12.0 2019   grade_9 17 0 11   0 0     0   0   13 15             18         28 17 0 11   0 0     0   0   13 15         18       28
1309058 ID     school 1602030 421   MCCALL-DONNELLY JOINT SCHOOL DISTRICT 160203000354 189 MCCALL-DONNELLY HIGH SCHOOL   Regular School No High 09 12.0 2019   grade_9 81 0 6   0 1     0   2   46 44             *         90 81 0 6   0 1     0   2   46 44                 90
1309088 ID     school 1600630 422   CASCADE DISTRICT 160063000121 190 CASCADE JR/SR HIGH SCHOOL   Regular School No High 07 12.0 2019   grade_9 16 0 1   1 0     0   0   7 11             9         18 16 0 1   1 0     0   0   7 11         9       18
1309105 ID     school 1603330 431   WEISER DISTRICT 160333000568 192 WEISER HIGH SCHOOL   Regular School No High 09 12.0 2019   grade_9 93 0 41   0 0     0   2   65 71             *         136 93 0 41   0 0     0   2   65 71                 136
1309126 ID     school 1600570 432   CAMBRIDGE JOINT DISTRICT 160057000113 193 CAMBRIDGE MIDDLE/HIGH SCHOOL   Regular School No High 06 12.0 2019   grade_9 1 0 0   0 0     0   0   0 1             *         1 1 0 0   0 0     0   0   0 1                 1
1306116 ID     school 1600300 61   BLAINE COUNTY DISTRICT 160030000034 197 CAREY PUBLIC SCHOOL   Regular School No Other PK 12.0 2019   grade_9 14 0 5   0 0     0   0   12 7             *         19 14 0 5   0 0     0   0   12 7                 19
1306472 ID     school 1600930 93   BONNEVILLE JOINT DISTRICT 160093000024 200 HILLCREST HIGH SCHOOL   Regular School No High 09 12.0 2019   grade_9 249 4 44   0 1     2   10   149 161             107         310 249 4 44   0 1     2   10   149 161         107       310

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