Data source: Big Local News · About: Big Local

33,441 rows where state = "ID" sorted by ccd_school_lvl descending

View and edit SQL

grade

year

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
850415 ID     school 1602340 131   NAMPA SCHOOL DISTRICT 160234001090 1394 TREASURE VALLEY LEADERSHIP ACADEMY   Regular School No Secondary 09 11 2020   grade_10 10 0 10   0 0     0   1   9 12             16         21 10 0 10   0 0     0   1   9 12         16       21
850416 ID     school 1602340 131   NAMPA SCHOOL DISTRICT 160234001090 1394 TREASURE VALLEY LEADERSHIP ACADEMY   Regular School No Secondary 09 11 2020   grade_11 12 0 3   0 0     0   1   5 11             *         16 12 0 3   0 0     0   1   5 11                 16
850417 ID     school 1602340 131   NAMPA SCHOOL DISTRICT 160234001090 1394 TREASURE VALLEY LEADERSHIP ACADEMY   Regular School No Secondary 09 11 2020   grade_9 8 1 4   0 0     0   0   5 8             *         13 8 1 4   0 0     0   0   5 8                 13
850418 ID     school 1602340 131   NAMPA SCHOOL DISTRICT 160234001090 1394 TREASURE VALLEY LEADERSHIP ACADEMY   Regular School No Secondary 09 11 2020   k_12_total 30 1 17   0 0     0   2   19 31             25         50 30 1 17   0 0     0   2   19 31         25       50
707644 ID     school 1600189 523   ELEVATE ACADEMY INC. 160018901113 1420 ELEVATE ACADEMY   Alternative School Yes Secondary 06 11 2021   grade_10 26 0 52   0 0     1   2   54 27             32         81 26 0 52   0 0     1   2   54 27         32       81
707645 ID     school 1600189 523   ELEVATE ACADEMY INC. 160018901113 1420 ELEVATE ACADEMY   Alternative School Yes Secondary 06 11 2021   grade_11 22 0 55   0 0     0   0   34 43             30         77 22 0 55   0 0     0   0   34 43         30       77
707646 ID     school 1600189 523   ELEVATE ACADEMY INC. 160018901113 1420 ELEVATE ACADEMY   Alternative School Yes Secondary 06 11 2021   grade_6 16 1 26   0 0     0   0   28 15             18         43 16 1 26   0 0     0   0   28 15         18       43
707647 ID     school 1600189 523   ELEVATE ACADEMY INC. 160018901113 1420 ELEVATE ACADEMY   Alternative School Yes Secondary 06 11 2021   grade_7 24 0 39   0 0     0   3   44 22             32         66 24 0 39   0 0     0   3   44 22         32       66
707648 ID     school 1600189 523   ELEVATE ACADEMY INC. 160018901113 1420 ELEVATE ACADEMY   Alternative School Yes Secondary 06 11 2021   grade_8 15 0 50   1 0     0   2   33 35             34         68 15 0 50   1 0     0   2   33 35         34       68
707649 ID     school 1600189 523   ELEVATE ACADEMY INC. 160018901113 1420 ELEVATE ACADEMY   Alternative School Yes Secondary 06 11 2021   grade_9 27 1 48   1 0     0   1   43 35             33         78 27 1 48   1 0     0   1   43 35         33       78
707650 ID     school 1600189 523   ELEVATE ACADEMY INC. 160018901113 1420 ELEVATE ACADEMY   Alternative School Yes Secondary 06 11 2021   k_12_total 130 2 270   2 0     1   8   236 177             179         413 130 2 270   2 0     1   8   236 177         179       413
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
1725826 ID     school 1600360 1   BOISE INDEPENDENT DISTRICT 160036000823 573 TREASURE VALLEY MATH/SCIENCE   Regular School No Other 04 12.0 2017   grade_10 4 0 1   0 2     0   0   3 4             *         7 4 0 1   0 2     0   0   3 4                 7
1725827 ID     school 1600360 1   BOISE INDEPENDENT DISTRICT 160036000823 573 TREASURE VALLEY MATH/SCIENCE   Regular School No Other 04 12.0 2017   grade_11 6 0 0   0 1     0   0   3 4             *         7 6 0 0   0 1     0   0   3 4                 7
1725828 ID     school 1600360 1   BOISE INDEPENDENT DISTRICT 160036000823 573 TREASURE VALLEY MATH/SCIENCE   Regular School No Other 04 12.0 2017   grade_12 2 0 0   0 0     0   0   1 1             *         2 2 0 0   0 0     0   0   1 1                 2
1725829 ID     school 1600360 1   BOISE INDEPENDENT DISTRICT 160036000823 573 TREASURE VALLEY MATH/SCIENCE   Regular School No Other 04 12.0 2017   grade_6 9 0 1   0 1     0   1   11 1             *         12 9 0 1   0 1     0   1   11 1                 12
1725830 ID     school 1600360 1   BOISE INDEPENDENT DISTRICT 160036000823 573 TREASURE VALLEY MATH/SCIENCE   Regular School No Other 04 12.0 2017   grade_7 18 2 2   0 6     0   0   15 13             *         28 18 2 2   0 6     0   0   15 13                 28
1725831 ID     school 1600360 1   BOISE INDEPENDENT DISTRICT 160036000823 573 TREASURE VALLEY MATH/SCIENCE   Regular School No Other 04 12.0 2017   grade_8 18 0 2   0 3     0   2   15 10             *         25 18 0 2   0 3     0   2   15 10                 25
1725832 ID     school 1600360 1   BOISE INDEPENDENT DISTRICT 160036000823 573 TREASURE VALLEY MATH/SCIENCE   Regular School No Other 04 12.0 2017   grade_9 15 0 0   0 0     0   0   10 5             *         15 15 0 0   0 0     0   0   10 5                 15
1725833 ID     school 1600360 1   BOISE INDEPENDENT DISTRICT 160036000823 573 TREASURE VALLEY MATH/SCIENCE   Regular School No Other 04 12.0 2017   k_12_total 72 2 6   0 13     0   3   58 38             *         96 72 2 6   0 13     0   3   58 38                 96
1725866 ID     school 1600360 1   BOISE INDEPENDENT DISTRICT 160036000984 675 FRANK CHURCH HIGH SCHOOL   Alternative School No Other 06 12.0 2017   grade_10 81 7 28   2 0     1   2   60 61             *         121 81 7 28   2 0     1   2   60 61                 121
1725867 ID     school 1600360 1   BOISE INDEPENDENT DISTRICT 160036000984 675 FRANK CHURCH HIGH SCHOOL   Alternative School No Other 06 12.0 2017   grade_11 82 3 26   2 3     0   2   58 60             *         118 82 3 26   2 3     0   2   58 60                 118
1725868 ID     school 1600360 1   BOISE INDEPENDENT DISTRICT 160036000984 675 FRANK CHURCH HIGH SCHOOL   Alternative School No Other 06 12.0 2017   grade_12 124 8 37   3 4     1   2   90 89             *         179 124 8 37   3 4     1   2   90 89                 179
1725869 ID     school 1600360 1   BOISE INDEPENDENT DISTRICT 160036000984 675 FRANK CHURCH HIGH SCHOOL   Alternative School No Other 06 12.0 2017   grade_7 2 1 0   0 0     0   0   2 1             *         3 2 1 0   0 0     0   0   2 1                 3
1725870 ID     school 1600360 1   BOISE INDEPENDENT DISTRICT 160036000984 675 FRANK CHURCH HIGH SCHOOL   Alternative School No Other 06 12.0 2017   grade_8 2 0 1   0 0     0   1   4 0             *         4 2 0 1   0 0     0   1   4 0                 4
1725871 ID     school 1600360 1   BOISE INDEPENDENT DISTRICT 160036000984 675 FRANK CHURCH HIGH SCHOOL   Alternative School No Other 06 12.0 2017   grade_9 68 5 30   0 1     1   1   66 40             *         106 68 5 30   0 1     1   1   66 40                 106
1725872 ID     school 1600360 1   BOISE INDEPENDENT DISTRICT 160036000984 675 FRANK CHURCH HIGH SCHOOL   Alternative School No Other 06 12.0 2017   k_12_total 359 24 122   7 8     3   8   280 251             *         531 359 24 122   7 8     3   8   280 251                 531
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
1725889 ID     school 1600360 1   BOISE INDEPENDENT DISTRICT 160036000708 9002 ADA COUNTY JUVENILE CENTER   Alternative School No Other 05 12.0 2017   grade_10 7 0 0   1 0     0   0   6 2             *         8 7 0 0   1 0     0   0   6 2                 8
1725890 ID     school 1600360 1   BOISE INDEPENDENT DISTRICT 160036000708 9002 ADA COUNTY JUVENILE CENTER   Alternative School No Other 05 12.0 2017   grade_11 4 0 1   0 0     0   0   5 0             *         5 4 0 1   0 0     0   0   5 0                 5
1725891 ID     school 1600360 1   BOISE INDEPENDENT DISTRICT 160036000708 9002 ADA COUNTY JUVENILE CENTER   Alternative School No Other 05 12.0 2017   grade_12 3 0 0   0 0     0   0   3 0             *         3 3 0 0   0 0     0   0   3 0                 3
1725892 ID     school 1600360 1   BOISE INDEPENDENT DISTRICT 160036000708 9002 ADA COUNTY JUVENILE CENTER   Alternative School No Other 05 12.0 2017   grade_6 1 0 0   0 0     0   0   1 0             *         1 1 0 0   0 0     0   0   1 0                 1
1725893 ID     school 1600360 1   BOISE INDEPENDENT DISTRICT 160036000708 9002 ADA COUNTY JUVENILE CENTER   Alternative School No Other 05 12.0 2017   grade_7 1 0 0   0 0     0   0   1 0             *         1 1 0 0   0 0     0   0   1 0                 1
1725894 ID     school 1600360 1   BOISE INDEPENDENT DISTRICT 160036000708 9002 ADA COUNTY JUVENILE CENTER   Alternative School No Other 05 12.0 2017   grade_9 5 0 0   1 0     0   0   6 0             *         6 5 0 0   1 0     0   0   6 0                 6
1725895 ID     school 1600360 1   BOISE INDEPENDENT DISTRICT 160036000708 9002 ADA COUNTY JUVENILE CENTER   Alternative School No Other 05 12.0 2017   k_12_total 21 0 1   2 0     0   0   22 2             *         24 21 0 1   2 0     0   0   22 2                 24
1726183 ID     school 1602100 2   JOINT SCHOOL DISTRICT NO. 2 160210001025 1297 REBOUND SCHOOL OF OPPORTUNITY   Alternative School No Other 06 12.0 2017   grade_10 12 1 0   0 0     0   0   10 3             *         13 12 1 0   0 0     0   0   10 3                 13
1726184 ID     school 1602100 2   JOINT SCHOOL DISTRICT NO. 2 160210001025 1297 REBOUND SCHOOL OF OPPORTUNITY   Alternative School No Other 06 12.0 2017   grade_11 14 0 5   0 0     0   1   16 4             *         20 14 0 5   0 0     0   1   16 4                 20
1726185 ID     school 1602100 2   JOINT SCHOOL DISTRICT NO. 2 160210001025 1297 REBOUND SCHOOL OF OPPORTUNITY   Alternative School No Other 06 12.0 2017   grade_12 51 1 11   0 2     0   1   39 27             29         66 51 1 11   0 2     0   1   39 27         29       66
1726186 ID     school 1602100 2   JOINT SCHOOL DISTRICT NO. 2 160210001025 1297 REBOUND SCHOOL OF OPPORTUNITY   Alternative School No Other 06 12.0 2017   grade_7 1 0 0   0 0     0   0   1 0             *         1 1 0 0   0 0     0   0   1 0                 1
1726187 ID     school 1602100 2   JOINT SCHOOL DISTRICT NO. 2 160210001025 1297 REBOUND SCHOOL OF OPPORTUNITY   Alternative School No Other 06 12.0 2017   grade_9 5 0 1   0 0     0   0   4 2             *         6 5 0 1   0 0     0   0   4 2                 6
1726188 ID     school 1602100 2   JOINT SCHOOL DISTRICT NO. 2 160210001025 1297 REBOUND SCHOOL OF OPPORTUNITY   Alternative School No Other 06 12.0 2017   k_12_total 83 2 17   0 2     0   2   70 36             49         106 83 2 17   0 2     0   2   70 36         49       106
1726206 ID     school 1602100 2   JOINT SCHOOL DISTRICT NO. 2 160210001071 1375 IDAHO FINE ARTS ACADEMY   Regular School No Other 06 12.0 2017   grade_10 23 1 1   0 1     0   1   5 22             *         27 23 1 1   0 1     0   1   5 22                 27
1726207 ID     school 1602100 2   JOINT SCHOOL DISTRICT NO. 2 160210001071 1375 IDAHO FINE ARTS ACADEMY   Regular School No Other 06 12.0 2017   grade_11 24 1 1   0 0     0   2   4 24             *         28 24 1 1   0 0     0   2   4 24                 28
1726208 ID     school 1602100 2   JOINT SCHOOL DISTRICT NO. 2 160210001071 1375 IDAHO FINE ARTS ACADEMY   Regular School No Other 06 12.0 2017   grade_12 20 0 2   0 0     0   0   5 17             *         22 20 0 2   0 0     0   0   5 17                 22
1726209 ID     school 1602100 2   JOINT SCHOOL DISTRICT NO. 2 160210001071 1375 IDAHO FINE ARTS ACADEMY   Regular School No Other 06 12.0 2017   grade_6 26 0 3   1 0     0   0   5 25             *         30 26 0 3   1 0     0   0   5 25                 30
1726210 ID     school 1602100 2   JOINT SCHOOL DISTRICT NO. 2 160210001071 1375 IDAHO FINE ARTS ACADEMY   Regular School No Other 06 12.0 2017   grade_7 24 0 2   0 0     1   0   4 23             *         27 24 0 2   0 0     1   0   4 23                 27
1726211 ID     school 1602100 2   JOINT SCHOOL DISTRICT NO. 2 160210001071 1375 IDAHO FINE ARTS ACADEMY   Regular School No Other 06 12.0 2017   grade_8 27 0 2   0 0     0   2   8 23             *         31 27 0 2   0 0     0   2   8 23                 31
1726212 ID     school 1602100 2   JOINT SCHOOL DISTRICT NO. 2 160210001071 1375 IDAHO FINE ARTS ACADEMY   Regular School No Other 06 12.0 2017   grade_9 22 0 1   0 1     0   0   5 19             *         24 22 0 1   0 1     0   0   5 19                 24
1726213 ID     school 1602100 2   JOINT SCHOOL DISTRICT NO. 2 160210001071 1375 IDAHO FINE ARTS ACADEMY   Regular School No Other 06 12.0 2017   k_12_total 166 2 12   1 2     1   5   36 153             18         189 166 2 12   1 2     1   5   36 153         18       189
1726294 ID     school 1602060 11   MEADOWS VALLEY DISTRICT 160206000826 342 MEADOWS VALLEY SCHOOL   Regular School No Other PK 12.0 2017   grade_1 6 0 1   0 0     1   1   2 7             *         9 6 0 1   0 0     1   1   2 7                 9
1726295 ID     school 1602060 11   MEADOWS VALLEY DISTRICT 160206000826 342 MEADOWS VALLEY SCHOOL   Regular School No Other PK 12.0 2017   grade_10 10 0 3   0 0     1   0   8 6             *         14 10 0 3   0 0     1   0   8 6                 14
1726296 ID     school 1602060 11   MEADOWS VALLEY DISTRICT 160206000826 342 MEADOWS VALLEY SCHOOL   Regular School No Other PK 12.0 2017   grade_11 9 0 1   0 0     1   0   3 8             6         11 9 0 1   0 0     1   0   3 8         6       11
1726297 ID     school 1602060 11   MEADOWS VALLEY DISTRICT 160206000826 342 MEADOWS VALLEY SCHOOL   Regular School No Other PK 12.0 2017   grade_12 7 0 1   0 0     0   0   4 4             *         8 7 0 1   0 0     0   0   4 4                 8
1726298 ID     school 1602060 11   MEADOWS VALLEY DISTRICT 160206000826 342 MEADOWS VALLEY SCHOOL   Regular School No Other PK 12.0 2017   grade_2 13 0 2   0 0     0   0   6 9             *         15 13 0 2   0 0     0   0   6 9                 15
1726299 ID     school 1602060 11   MEADOWS VALLEY DISTRICT 160206000826 342 MEADOWS VALLEY SCHOOL   Regular School No Other PK 12.0 2017   grade_3 10 0 0   0 0     0   0   6 4             *         10 10 0 0   0 0     0   0   6 4                 10
1726300 ID     school 1602060 11   MEADOWS VALLEY DISTRICT 160206000826 342 MEADOWS VALLEY SCHOOL   Regular School No Other PK 12.0 2017   grade_4 8 0 3   0 0     0   1   7 5             *         12 8 0 3   0 0     0   1   7 5                 12
1726301 ID     school 1602060 11   MEADOWS VALLEY DISTRICT 160206000826 342 MEADOWS VALLEY SCHOOL   Regular School No Other PK 12.0 2017   grade_5 13 0 1   1 0     0   0   7 8             *         15 13 0 1   1 0     0   0   7 8                 15
1726302 ID     school 1602060 11   MEADOWS VALLEY DISTRICT 160206000826 342 MEADOWS VALLEY SCHOOL   Regular School No Other PK 12.0 2017   grade_6 12 0 1   1 0     0   0   8 6             7         14 12 0 1   1 0     0   0   8 6         7       14
1726303 ID     school 1602060 11   MEADOWS VALLEY DISTRICT 160206000826 342 MEADOWS VALLEY SCHOOL   Regular School No Other PK 12.0 2017   grade_7 12 0 1   0 0     1   1   8 7             10         15 12 0 1   0 0     1   1   8 7         10       15
1726304 ID     school 1602060 11   MEADOWS VALLEY DISTRICT 160206000826 342 MEADOWS VALLEY SCHOOL   Regular School No Other PK 12.0 2017   grade_8 11 0 1   0 1     1   1   9 6             9         15 11 0 1   0 1     1   1   9 6         9       15
1726305 ID     school 1602060 11   MEADOWS VALLEY DISTRICT 160206000826 342 MEADOWS VALLEY SCHOOL   Regular School No Other PK 12.0 2017   grade_9 9 0 0   0 0     0   0   5 4             *         9 9 0 0   0 0     0   0   5 4                 9
1726306 ID     school 1602060 11   MEADOWS VALLEY DISTRICT 160206000826 342 MEADOWS VALLEY SCHOOL   Regular School No Other PK 12.0 2017   k_12_total 127 0 15   2 1     5   4   78 76             103         154 127 0 15   2 1     5   4   78 76         103       154
1726307 ID     school 1602060 11   MEADOWS VALLEY DISTRICT 160206000826 342 MEADOWS VALLEY SCHOOL   Regular School No Other PK 12.0 2017   kindergarten 7 0 0   0 0     0   0   5 2             *         7 7 0 0   0 0     0   0   5 2                 7
1726494 ID     school 1602640 25   POCATELLO DISTRICT 160264000186 9034 POCATELLO JUVENILE DETENTION   Alternative School No Other 01 12.0 2017   grade_10 2 0 0   0 0     0   0   2 0             *         2 2 0 0   0 0     0   0   2 0                 2
1726495 ID     school 1602640 25   POCATELLO DISTRICT 160264000186 9034 POCATELLO JUVENILE DETENTION   Alternative School No Other 01 12.0 2017   grade_12 1 0 0   0 0     0   0   1 0             *         1 1 0 0   0 0     0   0   1 0                 1
1726496 ID     school 1602640 25   POCATELLO DISTRICT 160264000186 9034 POCATELLO JUVENILE DETENTION   Alternative School No Other 01 12.0 2017   grade_7 1 0 0   0 0     0   0   0 1             *         1 1 0 0   0 0     0   0   0 1                 1
1726497 ID     school 1602640 25   POCATELLO DISTRICT 160264000186 9034 POCATELLO JUVENILE DETENTION   Alternative School No Other 01 12.0 2017   k_12_total 4 0 0   0 0     0   0   3 1             *         4 4 0 0   0 0     0   0   3 1                 4
1726710 ID     school 1600300 61   BLAINE COUNTY DISTRICT 160030000034 197 CAREY PUBLIC SCHOOL   Regular School No Other PK 12.0 2017   grade_1 8 0 4   0 0     0   1   6 7             7         13 8 0 4   0 0     0   1   6 7         7       13
1726711 ID     school 1600300 61   BLAINE COUNTY DISTRICT 160030000034 197 CAREY PUBLIC SCHOOL   Regular School No Other PK 12.0 2017   grade_10 14 0 6   0 0     0   0   9 11             10         20 14 0 6   0 0     0   0   9 11         10       20
1726712 ID     school 1600300 61   BLAINE COUNTY DISTRICT 160030000034 197 CAREY PUBLIC SCHOOL   Regular School No Other PK 12.0 2017   grade_11 14 0 1   0 0     0   0   9 6             *         15 14 0 1   0 0     0   0   9 6                 15

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