Data source: Big Local News · About: Big Local

4,725 rows where state = "ID" and year = 2017 sorted by ccd_school_high_grade descending

View and edit SQL

grade

year

  • 2017 · 4,725
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
1725567 ID     school 1600360 1   BOISE INDEPENDENT DISTRICT 160036000051 2 FAIRMONT JUNIOR HIGH SCHOOL   Regular School No Other 07 9.0 2017   grade_7 162 15 60   3 12     1   11   150 114             *         264 162 15 60   3 12     1   11   150 114                 264
1725568 ID     school 1600360 1   BOISE INDEPENDENT DISTRICT 160036000051 2 FAIRMONT JUNIOR HIGH SCHOOL   Regular School No Other 07 9.0 2017   grade_8 148 13 52   2 5     2   11   109 124             *         233 148 13 52   2 5     2   11   109 124                 233
1725569 ID     school 1600360 1   BOISE INDEPENDENT DISTRICT 160036000051 2 FAIRMONT JUNIOR HIGH SCHOOL   Regular School No Other 07 9.0 2017   grade_9 191 8 68   2 11     3   5   158 130             *         288 191 8 68   2 11     3   5   158 130                 288
1725570 ID     school 1600360 1   BOISE INDEPENDENT DISTRICT 160036000051 2 FAIRMONT JUNIOR HIGH SCHOOL   Regular School No Other 07 9.0 2017   k_12_total 501 36 180   7 28     6   27   417 368             *         785 501 36 180   7 28     6   27   417 368                 785
1725571 ID     school 1600360 1   BOISE INDEPENDENT DISTRICT 160036000057 3 HILLSIDE JUNIOR HIGH SCHOOL   Regular School No Other 07 9.0 2017   grade_7 169 26 18   0 12     1   5   107 124             90         231 169 26 18   0 12     1   5   107 124         90       231
1725572 ID     school 1600360 1   BOISE INDEPENDENT DISTRICT 160036000057 3 HILLSIDE JUNIOR HIGH SCHOOL   Regular School No Other 07 9.0 2017   grade_8 168 26 16   0 9     1   3   117 106             93         223 168 26 16   0 9     1   3   117 106         93       223
1725573 ID     school 1600360 1   BOISE INDEPENDENT DISTRICT 160036000057 3 HILLSIDE JUNIOR HIGH SCHOOL   Regular School No Other 07 9.0 2017   grade_9 162 24 15   1 8     0   6   116 100             85         216 162 24 15   1 8     0   6   116 100         85       216
1725574 ID     school 1600360 1   BOISE INDEPENDENT DISTRICT 160036000057 3 HILLSIDE JUNIOR HIGH SCHOOL   Regular School No Other 07 9.0 2017   k_12_total 499 76 49   1 29     2   14   340 330             268         670 499 76 49   1 29     2   14   340 330         268       670
1725575 ID     school 1600360 1   BOISE INDEPENDENT DISTRICT 160036000069 4 NORTH JUNIOR HIGH SCHOOL   Regular School No Other 07 9.0 2017   grade_7 286 2 24   1 11     2   9   143 192             65         335 286 2 24   1 11     2   9   143 192         65       335
1725576 ID     school 1600360 1   BOISE INDEPENDENT DISTRICT 160036000069 4 NORTH JUNIOR HIGH SCHOOL   Regular School No Other 07 9.0 2017   grade_8 261 3 19   1 12     1   10   150 157             55         307 261 3 19   1 12     1   10   150 157         55       307
1725577 ID     school 1600360 1   BOISE INDEPENDENT DISTRICT 160036000069 4 NORTH JUNIOR HIGH SCHOOL   Regular School No Other 07 9.0 2017   grade_9 248 3 21   0 9     1   6   130 158             41         288 248 3 21   0 9     1   6   130 158         41       288
1725578 ID     school 1600360 1   BOISE INDEPENDENT DISTRICT 160036000069 4 NORTH JUNIOR HIGH SCHOOL   Regular School No Other 07 9.0 2017   k_12_total 795 8 64   2 32     4   25   423 507             161         930 795 8 64   2 32     4   25   423 507         161       930
1725579 ID     school 1600360 1   BOISE INDEPENDENT DISTRICT 160036000073 5 SOUTH JUNIOR HIGH SCHOOL   Regular School No Other 07 9.0 2017   grade_7 163 7 43   2 2     1   3   126 95             *         221 163 7 43   2 2     1   3   126 95                 221
1725580 ID     school 1600360 1   BOISE INDEPENDENT DISTRICT 160036000073 5 SOUTH JUNIOR HIGH SCHOOL   Regular School No Other 07 9.0 2017   grade_8 136 8 39   1 9     3   8   111 93             *         204 136 8 39   1 9     3   8   111 93                 204
1725581 ID     school 1600360 1   BOISE INDEPENDENT DISTRICT 160036000073 5 SOUTH JUNIOR HIGH SCHOOL   Regular School No Other 07 9.0 2017   grade_9 137 11 30   3 3     0   2   97 89             *         186 137 11 30   3 3     0   2   97 89                 186
1725582 ID     school 1600360 1   BOISE INDEPENDENT DISTRICT 160036000073 5 SOUTH JUNIOR HIGH SCHOOL   Regular School No Other 07 9.0 2017   k_12_total 436 26 112   6 14     4   13   334 277             *         611 436 26 112   6 14     4   13   334 277                 611
1725596 ID     school 1600360 1   BOISE INDEPENDENT DISTRICT 160036000183 206 LES BOIS JUNIOR HIGH SCHOOL   Regular School No Other 06 9.0 2017   grade_7 185 3 22   4 11     1   10   126 110             58         236 185 3 22   4 11     1   10   126 110         58       236
1725597 ID     school 1600360 1   BOISE INDEPENDENT DISTRICT 160036000183 206 LES BOIS JUNIOR HIGH SCHOOL   Regular School No Other 06 9.0 2017   grade_8 179 1 16   0 10     2   7   108 107             45         215 179 1 16   0 10     2   7   108 107         45       215
1725598 ID     school 1600360 1   BOISE INDEPENDENT DISTRICT 160036000183 206 LES BOIS JUNIOR HIGH SCHOOL   Regular School No Other 06 9.0 2017   grade_9 178 5 16   0 5     3   5   109 103             56         212 178 5 16   0 5     3   5   109 103         56       212
1725599 ID     school 1600360 1   BOISE INDEPENDENT DISTRICT 160036000183 206 LES BOIS JUNIOR HIGH SCHOOL   Regular School No Other 06 9.0 2017   k_12_total 542 9 54   4 26     6   22   343 320             159         663 542 9 54   4 26     6   22   343 320         159       663
1725600 ID     school 1600360 1   BOISE INDEPENDENT DISTRICT 160036000632 242 RIVERGLEN JR HIGH SCHOOL   Regular School No Other 07 9.0 2017   grade_7 145 1 23   5 5     1   4   101 83             75         184 145 1 23   5 5     1   4   101 83         75       184
1725601 ID     school 1600360 1   BOISE INDEPENDENT DISTRICT 160036000632 242 RIVERGLEN JR HIGH SCHOOL   Regular School No Other 07 9.0 2017   grade_8 179 4 21   3 3     0   6   109 107             68         216 179 4 21   3 3     0   6   109 107         68       216
1725602 ID     school 1600360 1   BOISE INDEPENDENT DISTRICT 160036000632 242 RIVERGLEN JR HIGH SCHOOL   Regular School No Other 07 9.0 2017   grade_9 146 3 26   1 3     1   5   99 86             60         185 146 3 26   1 3     1   5   99 86         60       185
1725603 ID     school 1600360 1   BOISE INDEPENDENT DISTRICT 160036000632 242 RIVERGLEN JR HIGH SCHOOL   Regular School No Other 07 9.0 2017   k_12_total 470 8 70   9 11     2   15   309 276             203         585 470 8 70   9 11     2   15   309 276         203       585
1725873 ID     school 1600360 1   BOISE INDEPENDENT DISTRICT 160036000987 676 WEST JUNIOR HIGH   Regular School No Other 07 9.0 2017   grade_7 246 4 39   3 9     3   6   163 147             95         310 246 4 39   3 9     3   6   163 147         95       310
1725874 ID     school 1600360 1   BOISE INDEPENDENT DISTRICT 160036000987 676 WEST JUNIOR HIGH   Regular School No Other 07 9.0 2017   grade_8 224 4 25   2 10     3   8   143 133             83         276 224 4 25   2 10     3   8   143 133         83       276
1725875 ID     school 1600360 1   BOISE INDEPENDENT DISTRICT 160036000987 676 WEST JUNIOR HIGH   Regular School No Other 07 9.0 2017   grade_9 239 7 35   1 11     2   8   147 156             93         303 239 7 35   1 11     2   8   147 156         93       303
1725876 ID     school 1600360 1   BOISE INDEPENDENT DISTRICT 160036000987 676 WEST JUNIOR HIGH   Regular School No Other 07 9.0 2017   k_12_total 709 15 99   6 30     8   22   453 436             271         889 709 15 99   6 30     8   22   453 436         271       889
1725877 ID     school 1600360 1   BOISE INDEPENDENT DISTRICT 160036001002 677 EAST JUNIOR HIGH SCHOOL   Regular School No Other 07 9.0 2017   grade_7 185 6 17   3 17     1   4   128 105             53         233 185 6 17   3 17     1   4   128 105         53       233
1725878 ID     school 1600360 1   BOISE INDEPENDENT DISTRICT 160036001002 677 EAST JUNIOR HIGH SCHOOL   Regular School No Other 07 9.0 2017   grade_8 188 4 26   0 16     1   8   132 111             49         243 188 4 26   0 16     1   8   132 111         49       243
1725879 ID     school 1600360 1   BOISE INDEPENDENT DISTRICT 160036001002 677 EAST JUNIOR HIGH SCHOOL   Regular School No Other 07 9.0 2017   grade_9 168 3 14   0 23     1   4   111 102             39         213 168 3 14   0 23     1   4   111 102         39       213
1725880 ID     school 1600360 1   BOISE INDEPENDENT DISTRICT 160036001002 677 EAST JUNIOR HIGH SCHOOL   Regular School No Other 07 9.0 2017   k_12_total 541 13 57   3 56     3   16   371 318             141         689 541 13 57   3 56     3   16   371 318         141       689
1726930 ID     school 1601530 91   IDAHO FALLS DISTRICT 160153000257 50 EAGLE ROCK MIDDLE SCHOOL   Regular School No Other 07 9.0 2017   grade_7 261 1 84   1 5     0   12   194 170             *         364 261 1 84   1 5     0   12   194 170                 364
1726931 ID     school 1601530 91   IDAHO FALLS DISTRICT 160153000257 50 EAGLE ROCK MIDDLE SCHOOL   Regular School No Other 07 9.0 2017   grade_8 272 2 114   2 3     0   8   188 213             *         401 272 2 114   2 3     0   8   188 213                 401
1726932 ID     school 1601530 91   IDAHO FALLS DISTRICT 160153000257 50 EAGLE ROCK MIDDLE SCHOOL   Regular School No Other 07 9.0 2017   k_12_total 533 3 198   3 8     0   20   382 383             420         765 533 3 198   3 8     0   20   382 383         420       765
1726943 ID     school 1601530 91   IDAHO FALLS DISTRICT 160153000727 199 TAYLORVIEW MIDDLE SCHOOL   Regular School No Other 07 9.0 2017   grade_7 322 3 63   4 3     3   13   215 196             *         411 322 3 63   4 3     3   13   215 196                 411
1726944 ID     school 1601530 91   IDAHO FALLS DISTRICT 160153000727 199 TAYLORVIEW MIDDLE SCHOOL   Regular School No Other 07 9.0 2017   grade_8 320 6 56   3 7     0   13   205 200             *         405 320 6 56   3 7     0   13   205 200                 405
1726945 ID     school 1601530 91   IDAHO FALLS DISTRICT 160153000727 199 TAYLORVIEW MIDDLE SCHOOL   Regular School No Other 07 9.0 2017   k_12_total 642 9 119   7 10     3   26   420 396             360         816 642 9 119   7 10     3   26   420 396         360       816
1728885 ID     school 1601920 321   MADISON DISTRICT 160192000340 145 MADISON JUNIOR HIGH SCHOOL   Regular School No Other 07 9.0 2017   grade_7 369 3 27   2 4     2   0   210 197             *         407 369 3 27   2 4     2   0   210 197                 407
1728886 ID     school 1601920 321   MADISON DISTRICT 160192000340 145 MADISON JUNIOR HIGH SCHOOL   Regular School No Other 07 9.0 2017   grade_8 344 3 34   1 4     3   0   192 197             *         389 344 3 34   1 4     3   0   192 197                 389
1728887 ID     school 1601920 321   MADISON DISTRICT 160192000340 145 MADISON JUNIOR HIGH SCHOOL   Regular School No Other 07 9.0 2017   grade_9 362 5 29   1 3     4   2   223 183             *         406 362 5 29   1 3     4   2   223 183                 406
1728888 ID     school 1601920 321   MADISON DISTRICT 160192000340 145 MADISON JUNIOR HIGH SCHOOL   Regular School No Other 07 9.0 2017   k_12_total 1075 11 90   4 11     9   2   625 577             414         1202 1075 11 90   4 11     9   2   625 577         414       1202
1729022 ID     school 1601860 340   LEWISTON INDEPENDENT DISTRICT 160186000328 151 SACAJAWEA MIDDLE SCHOOL   Regular School No Other 07 9.0 2017   grade_7 173 2 7   6 2     1   15   118 88             *         206 173 2 7   6 2     1   15   118 88                 206
1729023 ID     school 1601860 340   LEWISTON INDEPENDENT DISTRICT 160186000328 151 SACAJAWEA MIDDLE SCHOOL   Regular School No Other 07 9.0 2017   grade_8 150 1 10   5 1     0   7   73 101             *         174 150 1 10   5 1     0   7   73 101                 174
1729024 ID     school 1601860 340   LEWISTON INDEPENDENT DISTRICT 160186000328 151 SACAJAWEA MIDDLE SCHOOL   Regular School No Other 07 9.0 2017   grade_9 151 1 8   4 1     0   10   87 88             *         175 151 1 8   4 1     0   10   87 88                 175
1729025 ID     school 1601860 340   LEWISTON INDEPENDENT DISTRICT 160186000328 151 SACAJAWEA MIDDLE SCHOOL   Regular School No Other 07 9.0 2017   k_12_total 474 4 25   15 4     1   32   278 277             179         555 474 4 25   15 4     1   32   278 277         179       555
1729026 ID     school 1601860 340   LEWISTON INDEPENDENT DISTRICT 160186000322 152 JENIFER MIDDLE SCHOOL   Regular School No Other 07 9.0 2017   grade_7 176 0 9   2 3     0   18   94 114             79         208 176 0 9   2 3     0   18   94 114         79       208
1729027 ID     school 1601860 340   LEWISTON INDEPENDENT DISTRICT 160186000322 152 JENIFER MIDDLE SCHOOL   Regular School No Other 07 9.0 2017   grade_8 144 1 14   5 1     2   10   104 73             65         177 144 1 14   5 1     2   10   104 73         65       177
1729028 ID     school 1601860 340   LEWISTON INDEPENDENT DISTRICT 160186000322 152 JENIFER MIDDLE SCHOOL   Regular School No Other 07 9.0 2017   grade_9 157 2 14   4 4     0   15   91 105             61         196 157 2 14   4 4     0   15   91 105         61       196
1729029 ID     school 1601860 340   LEWISTON INDEPENDENT DISTRICT 160186000322 152 JENIFER MIDDLE SCHOOL   Regular School No Other 07 9.0 2017   k_12_total 477 3 37   11 8     2   43   289 292             205         581 477 3 37   11 8     2   43   289 292         205       581
1725896 ID     school 1602100 2   JOINT SCHOOL DISTRICT NO. 2 160210000367 10 LOWELL SCOTT MIDDLE SCHOOL   Regular School No Middle 06 8.0 2017   grade_6 267 11 33   4 20     2   15   169 183             115         352 267 11 33   4 20     2   15   169 183         115       352
1725897 ID     school 1602100 2   JOINT SCHOOL DISTRICT NO. 2 160210000367 10 LOWELL SCOTT MIDDLE SCHOOL   Regular School No Middle 06 8.0 2017   grade_7 283 7 36   3 7     2   14   173 179             108         352 283 7 36   3 7     2   14   173 179         108       352
1725898 ID     school 1602100 2   JOINT SCHOOL DISTRICT NO. 2 160210000367 10 LOWELL SCOTT MIDDLE SCHOOL   Regular School No Middle 06 8.0 2017   grade_8 260 5 37   4 12     1   12   162 169             102         331 260 5 37   4 12     1   12   162 169         102       331
1725899 ID     school 1602100 2   JOINT SCHOOL DISTRICT NO. 2 160210000367 10 LOWELL SCOTT MIDDLE SCHOOL   Regular School No Middle 06 8.0 2017   k_12_total 810 23 106   11 39     5   41   504 531             325         1035 810 23 106   11 39     5   41   504 531         325       1035
1725900 ID     school 1602100 2   JOINT SCHOOL DISTRICT NO. 2 160210000370 11 MERIDIAN MIDDLE SCHOOL   Regular School No Middle 06 8.0 2017   grade_6 259 5 58   3 4     0   12   178 163             154         341 259 5 58   3 4     0   12   178 163         154       341
1725901 ID     school 1602100 2   JOINT SCHOOL DISTRICT NO. 2 160210000370 11 MERIDIAN MIDDLE SCHOOL   Regular School No Middle 06 8.0 2017   grade_7 245 5 57   3 9     1   8   167 161             152         328 245 5 57   3 9     1   8   167 161         152       328
1725902 ID     school 1602100 2   JOINT SCHOOL DISTRICT NO. 2 160210000370 11 MERIDIAN MIDDLE SCHOOL   Regular School No Middle 06 8.0 2017   grade_8 276 5 56   3 4     2   10   194 162             176         356 276 5 56   3 4     2   10   194 162         176       356
1725903 ID     school 1602100 2   JOINT SCHOOL DISTRICT NO. 2 160210000370 11 MERIDIAN MIDDLE SCHOOL   Regular School No Middle 06 8.0 2017   k_12_total 780 15 171   9 17     3   30   539 486             482         1025 780 15 171   9 17     3   30   539 486         482       1025
1725914 ID     school 1602100 2   JOINT SCHOOL DISTRICT NO. 2 160210000319 106 EAGLE MIDDLE SCHOOL   Regular School No Middle 06 8.0 2017   grade_6 366 3 30   2 11     1   8   195 226             74         421 366 3 30   2 11     1   8   195 226         74       421
1725915 ID     school 1602100 2   JOINT SCHOOL DISTRICT NO. 2 160210000319 106 EAGLE MIDDLE SCHOOL   Regular School No Middle 06 8.0 2017   grade_7 329 4 35   3 5     0   20   195 201             81         396 329 4 35   3 5     0   20   195 201         81       396
1725916 ID     school 1602100 2   JOINT SCHOOL DISTRICT NO. 2 160210000319 106 EAGLE MIDDLE SCHOOL   Regular School No Middle 06 8.0 2017   grade_8 383 3 44   3 7     2   18   239 221             71         460 383 3 44   3 7     2   18   239 221         71       460
1725917 ID     school 1602100 2   JOINT SCHOOL DISTRICT NO. 2 160210000319 106 EAGLE MIDDLE SCHOOL   Regular School No Middle 06 8.0 2017   k_12_total 1078 10 109   8 23     3   46   629 648             226         1277 1078 10 109   8 23     3   46   629 648         226       1277
1725923 ID     school 1602100 2   JOINT SCHOOL DISTRICT NO. 2 160210000638 207 LAKE HAZEL MIDDLE SCHOOL   Regular School No Middle 06 8.0 2017   grade_6 202 7 45   5 7     1   12   148 131             104         279 202 7 45   5 7     1   12   148 131         104       279
1725924 ID     school 1602100 2   JOINT SCHOOL DISTRICT NO. 2 160210000638 207 LAKE HAZEL MIDDLE SCHOOL   Regular School No Middle 06 8.0 2017   grade_7 233 6 47   2 9     1   21   157 162             116         319 233 6 47   2 9     1   21   157 162         116       319
1725925 ID     school 1602100 2   JOINT SCHOOL DISTRICT NO. 2 160210000638 207 LAKE HAZEL MIDDLE SCHOOL   Regular School No Middle 06 8.0 2017   grade_8 217 5 27   5 15     2   20   148 143             100         291 217 5 27   5 15     2   20   148 143         100       291
1725926 ID     school 1602100 2   JOINT SCHOOL DISTRICT NO. 2 160210000638 207 LAKE HAZEL MIDDLE SCHOOL   Regular School No Middle 06 8.0 2017   k_12_total 652 18 119   12 31     4   53   453 436             320         889 652 18 119   12 31     4   53   453 436         320       889
1725927 ID     school 1602100 2   JOINT SCHOOL DISTRICT NO. 2 160210000795 235 LEWIS & CLARK MIDDLE SCHOOL   Regular School No Middle 06 8.0 2017   grade_6 278 9 60   1 21     1   11   188 193             130         381 278 9 60   1 21     1   11   188 193         130       381
1725928 ID     school 1602100 2   JOINT SCHOOL DISTRICT NO. 2 160210000795 235 LEWIS & CLARK MIDDLE SCHOOL   Regular School No Middle 06 8.0 2017   grade_7 288 8 56   3 14     1   16   193 193             127         386 288 8 56   3 14     1   16   193 193         127       386
1725929 ID     school 1602100 2   JOINT SCHOOL DISTRICT NO. 2 160210000795 235 LEWIS & CLARK MIDDLE SCHOOL   Regular School No Middle 06 8.0 2017   grade_8 266 7 46   1 16     1   21   195 163             111         358 266 7 46   1 16     1   21   195 163         111       358
1725930 ID     school 1602100 2   JOINT SCHOOL DISTRICT NO. 2 160210000795 235 LEWIS & CLARK MIDDLE SCHOOL   Regular School No Middle 06 8.0 2017   k_12_total 832 24 162   5 51     3   48   576 549             368         1125 832 24 162   5 51     3   48   576 549         368       1125
1725952 ID     school 1602100 2   JOINT SCHOOL DISTRICT NO. 2 160210000819 284 SAWTOOTH MIDDLE SCHOOL   Regular School No Middle 06 8.0 2017   grade_6 303 1 29   0 3     1   10   189 158             68         347 303 1 29   0 3     1   10   189 158         68       347
1725953 ID     school 1602100 2   JOINT SCHOOL DISTRICT NO. 2 160210000819 284 SAWTOOTH MIDDLE SCHOOL   Regular School No Middle 06 8.0 2017   grade_7 297 2 23   2 3     0   12   152 187             68         339 297 2 23   2 3     0   12   152 187         68       339
1725954 ID     school 1602100 2   JOINT SCHOOL DISTRICT NO. 2 160210000819 284 SAWTOOTH MIDDLE SCHOOL   Regular School No Middle 06 8.0 2017   grade_8 323 5 25   2 7     1   12   204 171             58         375 323 5 25   2 7     1   12   204 171         58       375
1725955 ID     school 1602100 2   JOINT SCHOOL DISTRICT NO. 2 160210000819 284 SAWTOOTH MIDDLE SCHOOL   Regular School No Middle 06 8.0 2017   k_12_total 923 8 77   4 13     2   34   545 516             194         1061 923 8 77   4 13     2   34   545 516         194       1061
1726137 ID     school 1602100 2   JOINT SCHOOL DISTRICT NO. 2 160210000931 594 PATHWAYS MIDDLE SCHOOL   Alternative School No Middle 07 8.0 2017   grade_7 40 1 6   2 0     0   0   32 17             22         49 40 1 6   2 0     0   0   32 17         22       49
1726138 ID     school 1602100 2   JOINT SCHOOL DISTRICT NO. 2 160210000931 594 PATHWAYS MIDDLE SCHOOL   Alternative School No Middle 07 8.0 2017   grade_8 72 0 2   1 0     0   5   56 24             30         80 72 0 2   1 0     0   5   56 24         30       80
1726139 ID     school 1602100 2   JOINT SCHOOL DISTRICT NO. 2 160210000931 594 PATHWAYS MIDDLE SCHOOL   Alternative School No Middle 07 8.0 2017   k_12_total 112 1 8   3 0     0   5   88 41             52         129 112 1 8   3 0     0   5   88 41         52       129
1726162 ID     school 1602100 2   JOINT SCHOOL DISTRICT NO. 2 160210000602 1145 CROSSROADS MIDDLE SCHOOL   Alternative School No Middle 06 8.0 2017   grade_6 22 2 4   0 0     0   2   19 11             15         30 22 2 4   0 0     0   2   19 11         15       30
1726163 ID     school 1602100 2   JOINT SCHOOL DISTRICT NO. 2 160210000602 1145 CROSSROADS MIDDLE SCHOOL   Alternative School No Middle 06 8.0 2017   grade_7 44 1 7   0 1     0   1   37 17             32         54 44 1 7   0 1     0   1   37 17         32       54
1726164 ID     school 1602100 2   JOINT SCHOOL DISTRICT NO. 2 160210000602 1145 CROSSROADS MIDDLE SCHOOL   Alternative School No Middle 06 8.0 2017   grade_8 51 4 7   0 1     0   2   45 20             36         65 51 4 7   0 1     0   2   45 20         36       65
1726165 ID     school 1602100 2   JOINT SCHOOL DISTRICT NO. 2 160210000602 1145 CROSSROADS MIDDLE SCHOOL   Alternative School No Middle 06 8.0 2017   k_12_total 117 7 18   0 2     0   5   101 48             83         149 117 7 18   0 2     0   5   101 48         83       149
1726196 ID     school 1602100 2   JOINT SCHOOL DISTRICT NO. 2 160210001070 1374 VIRTUAL SCHOOL HOUSE   Regular School No Elementary PK 8.0 2017   grade_1 5 0 0   0 0     0   0   3 2             *         5 5 0 0   0 0     0   0   3 2                 5
1726197 ID     school 1602100 2   JOINT SCHOOL DISTRICT NO. 2 160210001070 1374 VIRTUAL SCHOOL HOUSE   Regular School No Elementary PK 8.0 2017   grade_2 9 0 0   0 0     0   0   4 5             *         9 9 0 0   0 0     0   0   4 5                 9
1726198 ID     school 1602100 2   JOINT SCHOOL DISTRICT NO. 2 160210001070 1374 VIRTUAL SCHOOL HOUSE   Regular School No Elementary PK 8.0 2017   grade_3 9 0 0   0 0     0   0   4 5             *         9 9 0 0   0 0     0   0   4 5                 9
1726199 ID     school 1602100 2   JOINT SCHOOL DISTRICT NO. 2 160210001070 1374 VIRTUAL SCHOOL HOUSE   Regular School No Elementary PK 8.0 2017   grade_4 7 0 0   0 0     0   0   6 1             *         7 7 0 0   0 0     0   0   6 1                 7
1726200 ID     school 1602100 2   JOINT SCHOOL DISTRICT NO. 2 160210001070 1374 VIRTUAL SCHOOL HOUSE   Regular School No Elementary PK 8.0 2017   grade_5 10 0 0   0 0     0   0   3 7             *         10 10 0 0   0 0     0   0   3 7                 10
1726201 ID     school 1602100 2   JOINT SCHOOL DISTRICT NO. 2 160210001070 1374 VIRTUAL SCHOOL HOUSE   Regular School No Elementary PK 8.0 2017   grade_6 1 0 0   0 0     0   0   0 1             *         1 1 0 0   0 0     0   0   0 1                 1
1726202 ID     school 1602100 2   JOINT SCHOOL DISTRICT NO. 2 160210001070 1374 VIRTUAL SCHOOL HOUSE   Regular School No Elementary PK 8.0 2017   grade_7 8 0 0   0 0     0   0   5 3             *         8 8 0 0   0 0     0   0   5 3                 8
1726203 ID     school 1602100 2   JOINT SCHOOL DISTRICT NO. 2 160210001070 1374 VIRTUAL SCHOOL HOUSE   Regular School No Elementary PK 8.0 2017   grade_8 2 0 0   0 0     0   0   2 0             *         2 2 0 0   0 0     0   0   2 0                 2
1726204 ID     school 1602100 2   JOINT SCHOOL DISTRICT NO. 2 160210001070 1374 VIRTUAL SCHOOL HOUSE   Regular School No Elementary PK 8.0 2017   k_12_total 59 0 0   0 0     0   0   30 29             13         59 59 0 0   0 0     0   0   30 29         13       59
1726205 ID     school 1602100 2   JOINT SCHOOL DISTRICT NO. 2 160210001070 1374 VIRTUAL SCHOOL HOUSE   Regular School No Elementary PK 8.0 2017   kindergarten 8 0 0   0 0     0   0   3 5             *         8 8 0 0   0 0     0   0   3 5                 8
1726221 ID     school 1602100 2   JOINT SCHOOL DISTRICT NO. 2 160210001084 1384 VICTORY MIDDLE SCHOOL   Regular School No Middle 06 8.0 2017   grade_6 209 5 30   0 3     0   10   150 107             43         257 209 5 30   0 3     0   10   150 107         43       257
1726222 ID     school 1602100 2   JOINT SCHOOL DISTRICT NO. 2 160210001084 1384 VICTORY MIDDLE SCHOOL   Regular School No Middle 06 8.0 2017   grade_7 227 4 28   0 4     1   12   140 136             41         276 227 4 28   0 4     1   12   140 136         41       276
1726223 ID     school 1602100 2   JOINT SCHOOL DISTRICT NO. 2 160210001084 1384 VICTORY MIDDLE SCHOOL   Regular School No Middle 06 8.0 2017   grade_8 217 1 22   0 11     2   8   128 133             39         261 217 1 22   0 11     2   8   128 133         39       261
1726224 ID     school 1602100 2   JOINT SCHOOL DISTRICT NO. 2 160210001084 1384 VICTORY MIDDLE SCHOOL   Regular School No Middle 06 8.0 2017   k_12_total 653 10 80   0 18     3   30   418 376             123         794 653 10 80   0 18     3   30   418 376         123       794
1726225 ID     school 1602100 2   JOINT SCHOOL DISTRICT NO. 2 160210000945 2511 GALILEO MAGNET SCHOOL   Regular School No Elementary PK 8.0 2017   grade_1 82 0 5   0 1     1   5   51 43             9         94 82 0 5   0 1     1   5   51 43         9       94
1726226 ID     school 1602100 2   JOINT SCHOOL DISTRICT NO. 2 160210000945 2511 GALILEO MAGNET SCHOOL   Regular School No Elementary PK 8.0 2017   grade_2 88 0 6   0 0     0   1   57 38             10         95 88 0 6   0 0     0   1   57 38         10       95
1726227 ID     school 1602100 2   JOINT SCHOOL DISTRICT NO. 2 160210000945 2511 GALILEO MAGNET SCHOOL   Regular School No Elementary PK 8.0 2017   grade_3 83 1 8   0 1     0   3   57 39             7         96 83 1 8   0 1     0   3   57 39         7       96
1726228 ID     school 1602100 2   JOINT SCHOOL DISTRICT NO. 2 160210000945 2511 GALILEO MAGNET SCHOOL   Regular School No Elementary PK 8.0 2017   grade_4 86 0 4   0 1     0   4   52 43             7         95 86 0 4   0 1     0   4   52 43         7       95
1726229 ID     school 1602100 2   JOINT SCHOOL DISTRICT NO. 2 160210000945 2511 GALILEO MAGNET SCHOOL   Regular School No Elementary PK 8.0 2017   grade_5 81 0 5   1 2     1   2   54 38             8         92 81 0 5   1 2     1   2   54 38         8       92

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