Data source: Big Local News · About: Big Local

1,641 rows where grade = "grade_9" and state = "ID" sorted by white descending

View and edit SQL

year

grade

  • grade_9 · 1,641
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
706756 ID     school 1603180 401   TETON COUNTY DISTRICT 160318000543 175 TETON HIGH SCHOOL   Regular School No High 09 12 2021   grade_9 99 0 47   0 0     0   3   82 67             38         149 99 0 47   0 0     0   3   82 67         38       149
850042 ID     school 1601530 91   IDAHO FALLS DISTRICT 160153001043 1350 COMPASS ACADEMY   Regular School No High 09 12 2020   grade_9 99 0 18   0 1     0   3   64 57             *         121 99 0 18   0 1     0   3   64 57                 121
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
1821813 ID     school 1600001 83   WEST BONNER COUNTY DISTRICT 160000100084 48 PRIEST RIVER LAMANNA HIGH   Regular School No 3.0 09 12 2016   grade_9 99 1 2   0 0     0   4   52 54             *         106 99 1 2   0 0     0   4   52 54                 106
1279935 ID     school 1603180 401   TETON COUNTY DISTRICT 160318000543 175 TETON HIGH SCHOOL   Regular School No High 09 12.0 2018   grade_9 98 0 37   0 0     0   1   78 58             44         136 98 0 37   0 0     0   1   78 58         44       136
1823028 ID     school 1601110 215   FREMONT COUNTY JOINT DISTRICT 160111000205 99 SOUTH FREMONT HIGH SCHOOL   Regular School No 3.0 09 12 2016   grade_9 98 1 30   0 2     1   2   68 66             70         134 98 1 30   0 2     1   2   68 66         70       134
852660 ID     school 1602030 421   MCCALL-DONNELLY JOINT SCHOOL DISTRICT 160203000354 189 MCCALL-DONNELLY HIGH SCHOOL   Regular School No High 09 12 2020   grade_9 97 0 13   1 0     0   1   56 56             *         112 97 0 13   1 0     0   1   56 56                 112
852859 ID     school 1600011 457   INSPIRE ACADEMICS, INC. 160001100866 578 INSPIRE VIRTUAL CHARTER SCHOOL   Regular School Yes Other PK 12 2020   grade_9 97 1 11   3 0     0   6   49 69             *         118 97 1 11   3 0     0   6   49 69                 118
1278576 ID     school 1601110 215   FREMONT COUNTY JOINT DISTRICT 160111000205 99 SOUTH FREMONT HIGH SCHOOL   Regular School No High 09 12.0 2018   grade_9 97 0 18   0 2     0   1   59 59             56         118 97 0 18   0 2     0   1   59 59         56       118
1280184 ID     school 1602030 421   MCCALL-DONNELLY JOINT SCHOOL DISTRICT 160203000354 189 MCCALL-DONNELLY HIGH SCHOOL   Regular School No High 09 12.0 2018   grade_9 97 1 8   1 1     0   2   62 48             *         110 97 1 8   1 1     0   2   62 48                 110
1822236 ID     school 1600420 101   BOUNDARY COUNTY DISTRICT 160042000089 57 BONNERS FERRY HIGH SCHOOL   Regular School No 3.0 09 12 2016   grade_9 97 0 8   4 0     0   2   66 45             60         111 97 0 8   4 0     0   2   66 45         60       111
1277118 ID     school 1602970 52   SNAKE RIVER DISTRICT 160297000521 32 SNAKE RIVER HIGH SCHOOL   Regular School No High 09 12.0 2018   grade_9 96 0 24   0 0     0   2   68 54             38         122 96 0 24   0 0     0   2   68 54         38       122
1729697 ID     school 1603330 431   WEISER DISTRICT 160333000568 192 WEISER HIGH SCHOOL   Regular School No High 09 12.0 2017   grade_9 96 0 37   2 0     0   1   70 66             74         136 96 0 37   2 0     0   1   70 66         74       136
851051 ID     school 1601110 215   FREMONT COUNTY JOINT DISTRICT 160111000205 99 SOUTH FREMONT HIGH SCHOOL   Regular School No High 09 12 2020   grade_9 95 1 30   0 1     0   2   66 63             59         129 95 1 30   0 1     0   2   66 63         59       129
1821327 ID     school 1601950 21   MARSH VALLEY JOINT DISTRICT 160195000347 19 MARSH VALLEY HIGH SCHOOL   Regular School No 3.0 07 12 2016   grade_9 94 1 4   1 0     0   0   54 46             34         100 94 1 4   1 0     0   0   54 46         34       100
704501 ID     school 1600420 101   BOUNDARY COUNTY DISTRICT 160042000089 57 BONNERS FERRY HIGH SCHOOL   Regular School No High 09 12 2021   grade_9 93 0 7   2 0     0   6   53 55             50         108 93 0 7   2 0     0   6   53 55         50       108
705352 ID     school 1601110 215   FREMONT COUNTY JOINT DISTRICT 160111000205 99 SOUTH FREMONT HIGH SCHOOL   Regular School No High 09 12 2021   grade_9 93 1 20   0 1     0   2   61 56             70         117 93 1 20   0 1     0   2   61 56         70       117
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
1824382 ID     school 1603180 401   TETON COUNTY DISTRICT 160318000543 175 TETON HIGH SCHOOL   Regular School No 3.0 09 12 2016   grade_9 93 0 29   0 0     0   1   53 70             44         123 93 0 29   0 0     0   1   53 70         44       123
1681850 ID     school 1600360 1   BOISE INDEPENDENT DISTRICT 160036000984 675 FRANK CHURCH HIGH SCHOOL   Alternative Education School No 3.0 07 12 2015   grade_9 92 1 23   1 0     0   2   58 61             *         119 92 1 23   1 0     0   2   58 61                 119
1683979 ID     school 1601110 215   FREMONT COUNTY JOINT DISTRICT 160111000205 99 SOUTH FREMONT HIGH SCHOOL   Regular School No 3.0 09 12 2015   grade_9 92 0 27   0 0     0   0   69 50             65         119 92 0 27   0 0     0   0   69 50         65       119
1727230 ID     school 1600420 101   BOUNDARY COUNTY DISTRICT 160042000089 57 BONNERS FERRY HIGH SCHOOL   Regular School No High 09 12.0 2017   grade_9 92 1 3   5 3     0   0   53 51             49         104 92 1 3   5 3     0   0   53 51         49       104
1685220 ID     school 1601140 373   FRUITLAND DISTRICT 160114000212 166 FRUITLAND HIGH SCHOOL   Regular School No 3.0 09 12 2015   grade_9 90 0 29   0 1     0   4   64 60             *         124 90 0 29   0 1     0   4   64 60                 124
704174 ID     school 1600002 84   LAKE PEND OREILLE SCHOOL DISTRICT 160000200691 1045 LAKE PEND OREILLE HIGH SCHOOL   Alternative School No High 09 12 2021   grade_9 9 0 0   0 0     0   1   3 7             *         10 9 0 0   0 0     0   1   3 7                 10
704832 ID     school 1602130 134   MIDDLETON DISTRICT 160213000777 1168 MIDDLETON ACADEMY   Alternative School No High 07 12 2021   grade_9 9 0 2   0 0     0   0   9 2             6         11 9 0 2   0 0     0   0   9 2         6       11
704978 ID     school 1602430 149   NORTH GEM DISTRICT 160243000428 77 NORTH GEM HIGH SCHOOL   Regular School No High 07 12 2021   grade_9 9 0 0   0 0     0   0   3 6             *         9 9 0 0   0 0     0   0   3 6                 9
706682 ID     school 1602820 382   ROCKLAND DISTRICT 160282000501 169 ROCKLAND PUBLIC SCHOOL   Regular School No Other PK 12 2021   grade_9 9 0 0   1 0     0   0   9 1             *         10 9 0 0   1 0     0   0   9 1                 10
707098 ID     school 1602160 433   MIDVALE DISTRICT 160216000857 286 MIDVALE SCHOOL   Regular School No Other PK 12 2021   grade_9 9 0 0   0 0     0   0   6 3             *         9 9 0 0   0 0     0   0   6 3                 9
849910 ID     school 1600002 84   LAKE PEND OREILLE SCHOOL DISTRICT 160000200691 1045 LAKE PEND OREILLE HIGH SCHOOL   Alternative School No High 09 12 2020   grade_9 9 0 3   0 0     0   0   11 1             *         12 9 0 3   0 0     0   0   11 1                 12
851507 ID     school 1600780 271   COEUR D'ALENE DISTRICT 160078000704 1038 CDA JUVENILE DETENTION CENTER   Alternative School No Other 04 12 2020   grade_9 9 0 1   1 0     0   0   6 5             *         11 9 0 1   1 0     0   0   6 5                 11
852727 ID     school 1600570 432   CAMBRIDGE JOINT DISTRICT 160057000113 193 CAMBRIDGE MIDDLE/HIGH SCHOOL   Regular School No High 06 12 2020   grade_9 9 0 1   0 0     0   0   9 1             *         10 9 0 1   0 0     0   0   9 1                 10
852812 ID     school 1600005 453   IDAHO VIRTUAL HIGH SCHOOL, INC. 160000501108 1399 RICHARD MCKENNA CHARTER SCHOOL - ONSITE   Regular School Yes High 09 12 2020   grade_9 9 0 3   0 0     0   0   6 6             *         12 9 0 3   0 0     0   0   6 6                 12
1276380 ID     school 1600360 1   BOISE INDEPENDENT DISTRICT 160036000823 573 TREASURE VALLEY MATH/SCIENCE   Regular School No Other 04 12.0 2018   grade_9 9 0 1   0 2     0   1   10 3             *         13 9 0 1   0 2     0   1   10 3                 13
1278085 ID     school 1602130 134   MIDDLETON DISTRICT 160213000777 1168 MIDDLETON ACADEMY   Alternative School No High 07 12.0 2018   grade_9 9 0 1   0 0     0   0   7 3             *         10 9 0 1   0 0     0   0   7 3                 10
1278668 ID     school 1601020 221   EMMETT INDEPENDENT DISTRICT 160102000095 1265 BLACK CANYON JR/SR HIGH SCHOOL   Alternative School No High 09 12.0 2018   grade_9 9 0 1   0 0     0   1   9 2             *         11 9 0 1   0 0     0   1   9 2                 11
1278727 ID     school 1600330 234   BLISS JOINT DISTRICT 160033000040 714 BLISS SCHOOL   Regular School No Other PK 12.0 2018   grade_9 9 0 2   0 0     0   0   4 7             *         11 9 0 2   0 0     0   0   4 7                 11
1279111 ID     school 1601800 272   LAKELAND DISTRICT 160180000437 1104 MOUNTAINVIEW ALTERNATIVE HIGH SCHOOL   Alternative School No High 07 12.0 2018   grade_9 9 0 0   0 0     0   0   6 3             *         9 9 0 0   0 0     0   0   6 3                 9
1309185 ID     school 1600004 452   IDAHO VIRTUAL ACADEMY, INC. 160000401035 1302 INSIGHT SCHOOL OF IDAHO   Alternative School Yes High 08 12.0 2019   grade_9 9 0 1   0 0     0   0   4 6             *         10 9 0 1   0 0     0   0   4 6                 10
1681567 ID     school 1600360 1   BOISE INDEPENDENT DISTRICT 160036000045 8 BORAH SENIOR HIGH SCHOOL   Regular School No 3.0 09 12 2015   grade_9 9 4 1   1 7     0   0   7 15             *         22 9 4 1   1 7     0   0   7 15                 22
1682816 ID     school 1600002 84   LAKE PEND OREILLE SCHOOL DISTRICT 160000200082 49 CLARK FORK JR/SR HIGH SCHOOL   Regular School No 3.0 07 12 2015   grade_9 9 0 0   0 0     0   1   10 0             *         10 9 0 0   0 0     0   1   10 0                 10
1683464 ID     school 1603480 133   WILDER DISTRICT 160348000530 233 WILDER HIGH SCHOOL   Regular School No 4.0 06 12 2015   grade_9 9 0 21   0 0     0   0   17 13             *         30 9 0 21   0 0     0   0   17 13                 30
1684163 ID     school 1600138 243   SALMON RIVER JOINT SCHOOL DISTRICT 160013800944 1281 SALMON RIVER JR/SR HIGH SCHOOL   Regular School No 4.0 06 12 2015   grade_9 9 0 1   0 0     0   0   6 4             *         10 9 0 1   0 0     0   0   6 4                 10
1684742 ID     school 1602400 302   NEZPERCE JOINT DISTRICT 160240000848 272 NEZPERCE SCHOOL   Regular School No 4.0 PK 12 2015   grade_9 9 0 0   0 0     0   0   3 6             *         9 9 0 0   0 0     0   0   3 6                 9
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
1728131 ID     school 1601020 221   EMMETT INDEPENDENT DISTRICT 160102000095 1265 BLACK CANYON JR/SR HIGH SCHOOL   Alternative School No High 09 12.0 2017   grade_9 9 0 2   1 0     1   0   11 2             *         13 9 0 2   1 0     1   0   11 2                 13
1728882 ID     school 1602760 316   RICHFIELD DISTRICT 160276000497 144 RICHFIELD SCHOOL   Regular School No Other PK 12.0 2017   grade_9 9 0 4   0 0     0   0   8 5             *         13 9 0 4   0 0     0   0   8 5                 13
1729381 ID     school 1602280 392   MULLAN DISTRICT 160228000405 172 MULLAN SCHOOLS   Regular School No High 07 12.0 2017   grade_9 9 0 0   1 0     0   1   4 7             5         11 9 0 0   1 0     0   1   4 7         5       11
1729736 ID     school 1602160 433   MIDVALE DISTRICT 160216000857 286 MIDVALE SCHOOL   Regular School No Other PK 12.0 2017   grade_9 9 0 0   0 0     0   0   4 5             *         9 9 0 0   0 0     0   0   4 5                 9
1821303 ID     school 1602060 11   MEADOWS VALLEY DISTRICT 160206000826 342 MEADOWS VALLEY SCHOOL   Regular School No 4.0 PK 12 2016   grade_9 9 0 1   0 0     0   0   6 4             *         10 9 0 1   0 0     0   0   6 4                 10
1822168 ID     school 1600930 93   BONNEVILLE JOINT DISTRICT 160093000361 1053 LINCOLN HIGH SCHOOL   Alternative Education School No 3.0 09 12 2016   grade_9 9 1 5   0 0     0   0   9 6             *         15 9 1 5   0 0     0   0   9 6                 15
1823788 ID     school 1602400 302   NEZPERCE JOINT DISTRICT 160240000848 272 NEZPERCE SCHOOL   Regular School No 4.0 PK 12 2016   grade_9 9 0 0   0 0     0   0   6 3             *         9 9 0 0   0 0     0   0   6 3                 9
1824178 ID     school 1600450 365   BRUNEAU-GRAND VIEW JOINT SCHOOL DISTRICT 160045000100 158 RIMROCK JR/SR HIGH SCHOOL   Regular School No 4.0 06 12 2016   grade_9 9 0 9   0 0     0   0   10 8             12         18 9 0 9   0 0     0   0   10 8         12       18
1824668 ID     school 1600570 432   CAMBRIDGE JOINT DISTRICT 160057000113 193 CAMBRIDGE MIDDLE/HIGH SCHOOL   Regular School No 3.0 07 12 2016   grade_9 9 0 0   0 0     0   0   5 4             *         9 9 0 0   0 0     0   0   5 4                 9
1825144 ID     school 1600152 555   CANYON-OWYHEE SCHOOL SERVICE AGENCY (COSSA) 160015200304 1291 COSSA ACADEMY   Alternative Education School No 3.0 07 12 2016   grade_9 9 0 11   0 0     0   0   14 6             *         20 9 0 11   0 0     0   0   14 6                 20
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
1729294 ID     school 1601140 373   FRUITLAND DISTRICT 160114000212 166 FRUITLAND HIGH SCHOOL   Regular School No High 09 12.0 2017   grade_9 89 0 36   0 0     0   4   73 56             49         129 89 0 36   0 0     0   4   73 56         49       129
703724 ID     school 1600240 33   BEAR LAKE COUNTY DISTRICT 160024000018 27 BEAR LAKE HIGH SCHOOL   Regular School No High 09 12 2021   grade_9 88 0 2   0 0     0   0   50 40             *         90 88 0 2   0 0     0   0   50 40                 90
1685349 ID     school 1603180 401   TETON COUNTY DISTRICT 160318000543 175 TETON HIGH SCHOOL   Regular School No 3.0 09 12 2015   grade_9 88 1 34   1 0     1   3   69 59             *         128 88 1 34   1 0     1   3   69 59                 128
706635 ID     school 1601140 373   FRUITLAND DISTRICT 160114000212 166 FRUITLAND HIGH SCHOOL   Regular School No High 09 12 2021   grade_9 87 0 40   2 1     0   4   73 61             *         134 87 0 40   2 1     0   4   73 61                 134
1280231 ID     school 1603330 431   WEISER DISTRICT 160333000568 192 WEISER HIGH SCHOOL   Regular School No High 09 12.0 2018   grade_9 87 0 50   1 1     0   2   65 76             72         141 87 0 50   1 1     0   2   65 76         72       141
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
1309579 ID     school 1600173 491   COEUR D'ALENE CHARTER ACADEMY, INC. 160017300765 1370 COEUR D'ALENE CHARTER ACADEMY SCHOOL   Regular School Yes High 06 12.0 2019   grade_9 87 0 14   0 5     0   7   58 55             10         113 87 0 14   0 5     0   7   58 55         10       113
1279813 ID     school 1601140 373   FRUITLAND DISTRICT 160114000212 166 FRUITLAND HIGH SCHOOL   Regular School No High 09 12.0 2018   grade_9 86 1 36   0 1     0   3   61 66             *         127 86 1 36   0 1     0   3   61 66                 127
1685285 ID     school 1601650 391   KELLOGG JOINT DISTRICT 160165000293 171 KELLOGG HIGH SCHOOL   Regular School No 3.0 09 12 2015   grade_9 86 0 2   2 2     0   3   50 45             48         95 86 0 2   2 2     0   3   50 45         48       95
1685621 ID     school 1603330 431   WEISER DISTRICT 160333000568 192 WEISER HIGH SCHOOL   Regular School No 3.0 09 12 2015   grade_9 86 0 33   1 0     0   2   61 61             72         122 86 0 33   1 0     0   2   61 61         72       122
1726815 ID     school 1600001 83   WEST BONNER COUNTY DISTRICT 160000100084 48 PRIEST RIVER LAMANNA HIGH   Regular School No High 09 12.0 2017   grade_9 86 0 1   1 0     0   4   49 43             *         92 86 0 1   1 0     0   4   49 43                 92
1682777 ID     school 1600001 83   WEST BONNER COUNTY DISTRICT 160000100084 48 PRIEST RIVER LAMANNA HIGH   Regular School No 3.0 09 12 2015   grade_9 85 0 7   0 0     0   3   64 31             *         95 85 0 7   0 0     0   3   64 31                 95
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
1685179 ID     school 1602580 371   PAYETTE JOINT DISTRICT 160258000454 162 PAYETTE HIGH SCHOOL   Regular School No 3.0 09 12 2015   grade_9 84 0 38   4 0     0   4   65 65             *         130 84 0 38   4 0     0   4   65 65                 130
1726505 ID     school 1600240 33   BEAR LAKE COUNTY DISTRICT 160024000018 27 BEAR LAKE HIGH SCHOOL   Regular School No High 09 12.0 2017   grade_9 84 0 5   0 0     1   0   54 36             *         90 84 0 5   0 0     1   0   54 36                 90
1279779 ID     school 1602580 371   PAYETTE JOINT DISTRICT 160258000454 162 PAYETTE HIGH SCHOOL   Regular School No High 09 12.0 2018   grade_9 82 1 41   2 0     1   2   70 59             *         129 82 1 41   2 0     1   2   70 59                 129
1279877 ID     school 1601650 391   KELLOGG JOINT DISTRICT 160165000293 171 KELLOGG HIGH SCHOOL   Regular School No High 09 12.0 2018   grade_9 81 0 3   5 0     1   1   46 45             43         91 81 0 3   5 0     1   1   46 45         43       91
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
1729143 ID     school 1602490 351   ONEIDA COUNTY DISTRICT 160249000433 156 MALAD SENIOR HIGH SCHOOL   Regular School No High 09 12.0 2017   grade_9 81 0 0   0 0     0   2   40 43             *         83 81 0 0   0 0     0   2   40 43                 83
1729360 ID     school 1601650 391   KELLOGG JOINT DISTRICT 160165000293 171 KELLOGG HIGH SCHOOL   Regular School No High 09 12.0 2017   grade_9 81 0 3   3 1     0   1   39 50             43         89 81 0 3   3 1     0   1   39 50         43       89
707011 ID     school 1602030 421   MCCALL-DONNELLY JOINT SCHOOL DISTRICT 160203000354 189 MCCALL-DONNELLY HIGH SCHOOL   Regular School No High 09 12 2021   grade_9 80 1 6   0 0     0   2   48 41             *         89 80 1 6   0 0     0   2   48 41                 89
707757 ID     school 1600960 751   S E I TEC CHARTER SCHOOL, INC. 160096001045 1349 SOUTHEAST IDAHO PROFESSIONAL TECHNICAL SCHOOL   Career and Technical School Yes High 09 12 2021   grade_9 80 0 2   1 1     0   0   31 53             *         84 80 0 2   1 1     0   0   31 53                 84
852352 ID     school 1601650 391   KELLOGG JOINT DISTRICT 160165000293 171 KELLOGG HIGH SCHOOL   Regular School No High 09 12 2020   grade_9 80 1 6   1 0     0   3   45 46             36         91 80 1 6   1 0     0   3   45 46         36       91
1277075 ID     school 1603060 41   ST MARIES JOINT DISTRICT 160306000532 29 ST MARIES HIGH SCHOOL   Regular School No High 09 12.0 2018   grade_9 80 0 2   0 0     0   1   42 41             37         83 80 0 2   0 0     0   1   42 41         37       83
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
1824649 ID     school 1603330 431   WEISER DISTRICT 160333000568 192 WEISER HIGH SCHOOL   Regular School No 3.0 09 12 2016   grade_9 80 1 28   0 0     0   0   49 60             62         109 80 1 28   0 0     0   0   49 60         62       109
705997 ID     school 1601740 274   KOOTENAI DISTRICT 160174000303 127 KOOTENAI JR/SR HIGH SCHOOL   Regular School No High 06 12 2021   grade_9 8 0 0   0 0     0   0   4 4             *         8 8 0 0   0 0     0   0   4 4                 8
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
850544 ID     school 1602130 134   MIDDLETON DISTRICT 160213000777 1168 MIDDLETON ACADEMY   Alternative School No High 07 12 2020   grade_9 8 0 0   0 0     0   0   5 3             *         8 8 0 0   0 0     0   0   5 3                 8
851005 ID     school 1602250 193   MOUNTAIN HOME DISTRICT 160225001041 1317 BENNETT MOUNTAIN HIGH SCHOOL   Alternative School No High 07 12 2020   grade_9 8 0 5   0 0     0   1   9 5             *         14 8 0 5   0 0     0   1   9 5                 14
852379 ID     school 1602280 392   MULLAN DISTRICT 160228000405 172 MULLAN SCHOOLS   Regular School No Other PK 12 2020   grade_9 8 0 1   0 0     0   0   5 4             *         9 8 0 1   0 0     0   0   5 4                 9
1278361 ID     school 1600660 151   CASSIA COUNTY JOINT DISTRICT 160066000540 990 CASSIA JR/SR HIGH SCHOOL   Alternative School No High 07 12.0 2018   grade_9 8 0 11   2 0     1   0   13 9             *         22 8 0 11   2 0     1   0   13 9                 22
1279238 ID     school 1601680 283   KENDRICK JOINT DISTRICT 160168000299 132 KENDRICK JR/SR HIGH SCHOOL   Regular School No High 07 12.0 2018   grade_9 8 1 0   0 0     0   2   7 4             6         11 8 1 0   0 0     0   2   7 4         6       11
1279344 ID     school 1602400 302   NEZPERCE JOINT DISTRICT 160240000848 272 NEZPERCE SCHOOL   Regular School No Other PK 12.0 2018   grade_9 8 0 0   0 0     0   1   4 5             *         9 8 0 0   0 0     0   1   4 5                 9
1279547 ID     school 1602190 331   MINIDOKA COUNTY JOINT DISTRICT 160219000158 1046 MT HARRISON JR/SR HIGH   Alternative School No High 06 12.0 2018   grade_9 8 0 11   0 0     0   0   11 8             *         19 8 0 11   0 0     0   0   11 8                 19
1279672 ID     school 1600870 342   CULDESAC JOINT DISTRICT 160087000164 795 CULDESAC SCHOOL   Regular School No Other PK 12.0 2018   grade_9 8 0 1   1 0     0   0   5 5             *         10 8 0 1   1 0     0   0   5 5                 10
1305236 ID     school 1600360 1   BOISE INDEPENDENT DISTRICT 160036000823 573 TREASURE VALLEY MATH/SCIENCE   Regular School No Other 04 12.0 2019   grade_9 8 1 0   0 5     0   0   10 4             *         14 8 1 0   0 5     0   0   10 4                 14
1305592 ID     school 1602100 2   JOINT SCHOOL DISTRICT NO. 2 160210001025 1297 REBOUND SCHOOL OF OPPORTUNITY   Alternative School No High 06 12.0 2019   grade_9 8 1 1   0 0     0   1   2 9             *         11 8 1 1   0 0     0   1   2 9                 11
1306316 ID     school 1600002 84   LAKE PEND OREILLE SCHOOL DISTRICT 160000200691 1045 LAKE PEND OREILLE HIGH SCHOOL   Alternative School No High 09 12.0 2019   grade_9 8 0 1   0 0     0   2   7 4             *         11 8 0 1   0 0     0   2   7 4                 11
1307630 ID     school 1600138 243   SALMON RIVER JOINT SCHOOL DISTRICT 160013800944 1281 SALMON RIVER JR/SR HIGH SCHOOL   Regular School No High 06 12.0 2019   grade_9 8 0 0   0 0     0   0   4 4             *         8 8 0 0   0 0     0   0   4 4                 8
1309010 ID     school 1601410 415   HANSEN DISTRICT 160141000757 620 HANSEN JR/SR HIGH SCHOOL   Regular School No High 07 12.0 2019   grade_9 8 1 4   1 0     0   0   8 6             *         14 8 1 4   1 0     0   0   8 6                 14
1683004 ID     school 1601530 91   IDAHO FALLS DISTRICT 160153000697 1048 EMERSON HIGH SCHOOL   Alternative Education School No 3.0 09 12 2015   grade_9 8 0 5   1 0     0   2   7 9             *         16 8 0 5   1 0     0   2   7 9                 16
1725590 ID     school 1600360 1   BOISE INDEPENDENT DISTRICT 160036000045 8 BORAH SENIOR HIGH SCHOOL   Regular School No High 09 13.0 2017   grade_9 8 19 3   0 5     0   0   19 16             *         35 8 19 3   0 5     0   0   19 16                 35
1726653 ID     school 1600270 55   BLACKFOOT DISTRICT 160027000689 9006 INDEPENDENCE ALTERNATIVE HIGH SCHOOL   Alternative School No High 07 12.0 2017   grade_9 8 0 4   5 0     0   0   10 7             *         17 8 0 4   5 0     0   0   10 7                 17
1727420 ID     school 1602340 131   NAMPA SCHOOL DISTRICT 160234000762 1154 UNION HIGH SCHOOL   Alternative School No High 09 12.0 2017   grade_9 8 1 12   0 0     0   0   6 15             *         21 8 1 12   0 0     0   0   6 15                 21

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