Data source: Big Local News · About: Big Local

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

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
850037 ID     school 1601530 91   IDAHO FALLS DISTRICT 160153000605 1152 3B JUVENILE DETENTION CENTER   Alternative School No Other 04 12 2020   grade_9 3 1 0   0 0     0   0   3 1             *         4 3 1 0   0 0     0   0   3 1                 4
1277585 ID     school 1601530 91   IDAHO FALLS DISTRICT 160153000605 1152 3B JUVENILE DETENTION CENTER   Alternative School No Other 04 12.0 2018   grade_9 3 0 1   1 0     0   0   5 0             *         5 3 0 1   1 0     0   0   5 0                 5
1306438 ID     school 1601530 91   IDAHO FALLS DISTRICT 160153000605 1152 3B JUVENILE DETENTION CENTER   Alternative School No Other 04 12.0 2019   grade_9 0 0 3   0 0     0   0   3 0             *         3 0 0 3   0 0     0   0   3 0                 3
1683011 ID     school 1601530 91   IDAHO FALLS DISTRICT 160153000605 1152 3B JUVENILE DETENTION CENTER   Alternative Education School No 4.0 05 12 2015   grade_9 2 0 1   0 0     0   0   3 0             *         3 2 0 1   0 0     0   0   3 0                 3
1727053 ID     school 1601530 91   IDAHO FALLS DISTRICT 160153000605 1152 3B JUVENILE DETENTION CENTER   Alternative School No Other 04 12.0 2017   grade_9 0 0 0   1 0     0   1   2 0             *         2 0 0 0   1 0     0   1   2 0                 2
1822050 ID     school 1601530 91   IDAHO FALLS DISTRICT 160153000605 1152 3B JUVENILE DETENTION CENTER   Alternative Education School No 4.0 04 12 2016   grade_9 0 0 1   1 0     0   1   3 0             *         3 0 0 1   1 0     0   1   3 0                 3
703908 ID     school 1600030 58   ABERDEEN DISTRICT 160003000002 36 ABERDEEN HIGH SCHOOL   Regular School No High 09 12 2021   grade_9 20 0 44   1 1     0   1   29 38             *         67 20 0 44   1 1     0   1   29 38                 67
849645 ID     school 1600030 58   ABERDEEN DISTRICT 160003000002 36 ABERDEEN HIGH SCHOOL   Regular School No High 09 12 2020   grade_9 24 3 30   1 0     0   0   30 28             29         58 24 3 30   1 0     0   0   30 28         29       58
1277193 ID     school 1600030 58   ABERDEEN DISTRICT 160003000002 36 ABERDEEN HIGH SCHOOL   Regular School No High 09 12.0 2018   grade_9 16 0 36   0 0     0   0   28 24             *         52 16 0 36   0 0     0   0   28 24                 52
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
1682620 ID     school 1600030 58   ABERDEEN DISTRICT 160003000002 36 ABERDEEN HIGH SCHOOL   Regular School No 3.0 09 12 2015   grade_9 19 0 35   0 0     0   0   22 32             30         54 19 0 35   0 0     0   0   22 32         30       54
1726658 ID     school 1600030 58   ABERDEEN DISTRICT 160003000002 36 ABERDEEN HIGH SCHOOL   Regular School No High 09 12.0 2017   grade_9 19 0 34   1 0     0   1   35 20             40         55 19 0 34   1 0     0   1   35 20         40       55
1821656 ID     school 1600030 58   ABERDEEN DISTRICT 160003000002 36 ABERDEEN HIGH SCHOOL   Regular School No 3.0 09 12 2016   grade_9 21 0 28   2 0     0   1   25 27             34         52 21 0 28   2 0     0   1   25 27         34       52
703095 ID     school 1600360 1   BOISE INDEPENDENT DISTRICT 160036000708 9002 ADA COUNTY JUVENILE CENTER   Alternative School No High 05 12 2021   grade_9 1 1 1   0 0     0   0   2 1             *         3 1 1 1   0 0     0   0   2 1                 3
848888 ID     school 1600360 1   BOISE INDEPENDENT DISTRICT 160036000708 9002 ADA COUNTY JUVENILE CENTER   Alternative School No High 05 12 2020   grade_9 7 0 0   0 0     0   0   6 1             *         7 7 0 0   0 0     0   0   6 1                 7
1276442 ID     school 1600360 1   BOISE INDEPENDENT DISTRICT 160036000708 9002 ADA COUNTY JUVENILE CENTER   Alternative School No High 05 12.0 2018   grade_9 4 0 2   0 0     0   1   5 2             *         7 4 0 2   0 0     0   1   5 2                 7
1305298 ID     school 1600360 1   BOISE INDEPENDENT DISTRICT 160036000708 9002 ADA COUNTY JUVENILE CENTER   Alternative School No High 05 12.0 2019   grade_9 5 0 0   0 0     0   0   3 2             *         5 5 0 0   0 0     0   0   3 2                 5
1681873 ID     school 1600360 1   BOISE INDEPENDENT DISTRICT 160036000708 9002 ADA COUNTY JUVENILE CENTER   Alternative Education School No 4.0 05 12 2015   grade_9 5 0 1   0 0     0   0   3 3             *         6 5 0 1   0 0     0   0   3 3                 6
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
1820903 ID     school 1600360 1   BOISE INDEPENDENT DISTRICT 160036000708 9002 ADA COUNTY JUVENILE CENTER   Alternative Education School No 4.0 05 12 2016   grade_9 1 0 4   1 0     0   0   4 2             *         6 1 0 4   1 0     0   0   4 2                 6
706655 ID     school 1600060 381   AMERICAN FALLS JOINT DISTRICT 160006000003 168 AMERICAN FALLS HIGH SCHOOL   Regular School No High 09 12 2021   grade_9 62 0 67   2 0     0   0   73 58             74         131 62 0 67   2 0     0   0   73 58         74       131
852309 ID     school 1600060 381   AMERICAN FALLS JOINT DISTRICT 160006000003 168 AMERICAN FALLS HIGH SCHOOL   Regular School No High 09 12 2020   grade_9 63 0 64   5 0     0   0   73 59             92         132 63 0 64   5 0     0   0   73 59         92       132
1279833 ID     school 1600060 381   AMERICAN FALLS JOINT DISTRICT 160006000003 168 AMERICAN FALLS HIGH SCHOOL   Regular School No High 09 12.0 2018   grade_9 47 1 53   2 2     0   0   53 52             71         105 47 1 53   2 2     0   0   53 52         71       105
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
1685240 ID     school 1600060 381   AMERICAN FALLS JOINT DISTRICT 160006000003 168 AMERICAN FALLS HIGH SCHOOL   Regular School No 3.0 09 12 2015   grade_9 55 0 48   4 0     1   0   56 52             69         108 55 0 48   4 0     1   0   56 52         69       108
1729314 ID     school 1600060 381   AMERICAN FALLS JOINT DISTRICT 160006000003 168 AMERICAN FALLS HIGH SCHOOL   Regular School No High 09 12.0 2017   grade_9 52 0 58   1 1     0   0   63 49             82         112 52 0 58   1 1     0   0   63 49         82       112
1824284 ID     school 1600060 381   AMERICAN FALLS JOINT DISTRICT 160006000003 168 AMERICAN FALLS HIGH SCHOOL   Regular School No 3.0 09 12 2016   grade_9 54 1 51   3 0     0   1   54 56             74         110 54 1 51   3 0     0   1   54 56         74       110
707473 ID     school 1600162 482   AMERICAN HERITAGE CHARTER SCHOOL, INC. 160016201044 1346 AMERICAN HERITAGE CHARTER SCHOOL   Regular School Yes Other KG 12 2021   grade_9 19 0 2   0 0     0   1   8 14             5         22 19 0 2   0 0     0   1   8 14         5       22
853120 ID     school 1600162 482   AMERICAN HERITAGE CHARTER SCHOOL, INC. 160016201044 1346 AMERICAN HERITAGE CHARTER SCHOOL   Regular School Yes Other KG 12 2020   grade_9 18 0 1   0 0     0   0   12 7             7         19 18 0 1   0 0     0   0   12 7         7       19
1280632 ID     school 1600162 482   AMERICAN HERITAGE CHARTER SCHOOL, INC. 160016201044 1346 AMERICAN HERITAGE CHARTER SCHOOL   Regular School Yes Other KG 12.0 2018   grade_9 26 0 1   0 0     0   0   15 12             6         27 26 0 1   0 0     0   0   15 12         6       27
1309510 ID     school 1600162 482   AMERICAN HERITAGE CHARTER SCHOOL, INC. 160016201044 1346 AMERICAN HERITAGE CHARTER SCHOOL   Regular School Yes Other KG 12.0 2019   grade_9 16 1 0   1 1     0   0   12 7             8         19 16 1 0   1 1     0   0   12 7         8       19
1685993 ID     school 1600162 482   AMERICAN HERITAGE CHARTER SCHOOL, INC. 160016201044 1346 AMERICAN HERITAGE CHARTER SCHOOL   Regular School Yes 4.0 PK 09 2015   grade_9 7 0 0   1 0     0   1   4 5             *         9 7 0 0   1 0     0   1   4 5                 9
1730082 ID     school 1600162 482   AMERICAN HERITAGE CHARTER SCHOOL, INC. 160016201044 1346 AMERICAN HERITAGE CHARTER SCHOOL   Regular School Yes Other PK 11.0 2017   grade_9 15 0 0   0 0     0   1   8 8             *         16 15 0 0   0 0     0   1   8 8                 16
1825028 ID     school 1600162 482   AMERICAN HERITAGE CHARTER SCHOOL, INC. 160016201044 1346 AMERICAN HERITAGE CHARTER SCHOOL   Regular School Yes 4.0 PK 10 2016   grade_9 8 0 3   0 1     0   0   7 5             *         12 8 0 3   0 1     0   0   7 5                 12
707405 ID     school 1600155 476   ANOTHER CHOICE VIRTUAL CHARTER SCHOOL, INC. 160015501008 1247 ANOTHER CHOICE VIRTUAL CHARTER   Regular School Yes Other PK 12 2021   grade_9 43 0 15   0 0     0   0   35 23             34         58 43 0 15   0 0     0   0   35 23         34       58
853052 ID     school 1600155 476   ANOTHER CHOICE VIRTUAL CHARTER SCHOOL, INC. 160015501008 1247 ANOTHER CHOICE VIRTUAL CHARTER   Regular School Yes Other PK 12 2020   grade_9 42 0 18   1 0     0   0   35 26             23         61 42 0 18   1 0     0   0   35 26         23       61
1280564 ID     school 1600155 476   ANOTHER CHOICE VIRTUAL CHARTER SCHOOL, INC. 160015501008 1247 ANOTHER CHOICE VIRTUAL CHARTER   Regular School Yes Other PK 12.0 2018   grade_9 48 0 19   0 1     0   4   36 36             41         72 48 0 19   0 1     0   4   36 36         41       72
1309442 ID     school 1600155 476   ANOTHER CHOICE VIRTUAL CHARTER SCHOOL, INC. 160015501008 1247 ANOTHER CHOICE VIRTUAL CHARTER   Regular School Yes Other PK 12.0 2019   grade_9 47 0 21   0 0     0   1   29 40             30         69 47 0 21   0 0     0   1   29 40         30       69
1685934 ID     school 1600155 476   ANOTHER CHOICE VIRTUAL CHARTER SCHOOL, INC. 160015501008 1247 ANOTHER CHOICE VIRTUAL CHARTER   Regular School Yes 4.0 PK 12 2015   grade_9 47 0 16   1 0     0   4   34 34             51         68 47 0 16   1 0     0   4   34 34         51       68
1730016 ID     school 1600155 476   ANOTHER CHOICE VIRTUAL CHARTER SCHOOL, INC. 160015501008 1247 ANOTHER CHOICE VIRTUAL CHARTER   Regular School Yes Other PK 12.0 2017   grade_9 56 3 22   0 0     0   2   46 37             24         83 56 3 22   0 0     0   2   46 37         24       83
1824964 ID     school 1600155 476   ANOTHER CHOICE VIRTUAL CHARTER SCHOOL, INC. 160015501008 1247 ANOTHER CHOICE VIRTUAL CHARTER   Regular School Yes 4.0 PK 12 2016   grade_9 53 0 14   2 0     0   2   38 33             40         71 53 0 14   2 0     0   2   38 33         40       71
707642 ID     school 1602190 518   ADVANCED REGIONAL TECHNICAL EDUCATION INDUSTRIAL, INC. 160219001117 1414 ARTE I RPTCS (Regional Professional Technical Charter School)   Career and Technical School Yes High 09 12 2021   grade_9 29 0 7   0 0     0   1   29 8             *         37 29 0 7   0 0     0   1   29 8                 37
853272 ID     school 1602190 518   ADVANCED REGIONAL TECHNICAL EDUCATION INDUSTRIAL, INC. 160219001117 1414 ARTE I RPTCS (Regional Professional Technical Charter School)   Career and Technical School Yes High 09 12 2020   grade_9 13 0 5   0 0     0   0   16 2             *         18 13 0 5   0 0     0   0   16 2                 18
1309672 ID     school 1600185 518   ADVANCED REGIONAL TECHNICAL EDUCATION INDUSTRIAL, INC. 160018501095 1414 ARTE I RPTCS (Regional Professional Technical Charter School)   Career and Technical School Yes High 09 12.0 2019   grade_9 21 0 8   1 0     0   1   27 4             *         31 21 0 8   1 0     0   1   27 4                 31
707772 ID     school 1602190 790   ADVANCED REGIONAL TECHNICAL EDUCATION, INC. 160219000883 639 ARTEC CHARTER SCHOOL   Career and Technical School Yes High 09 12 2021   grade_9 11 0 2   0 0     0   0   8 5             *         13 11 0 2   0 0     0   0   8 5                 13
853374 ID     school 1602190 790   ADVANCED REGIONAL TECHNICAL EDUCATION, INC. 160219000883 639 ARTEC CHARTER SCHOOL   Career and Technical School Yes High 09 12 2020   grade_9 25 0 7   0 0     0   1   16 17             *         33 25 0 7   0 0     0   1   16 17                 33
1280814 ID     school 1602190 790   ADVANCED REGIONAL TECHNICAL EDUCATION, INC. 160219000883 639 ARTEC CHARTER SCHOOL   Career and Technical School Yes High 09 12.0 2018   grade_9 27 0 4   0 0     0   1   22 10             *         32 27 0 4   0 0     0   1   22 10                 32
1309729 ID     school 1602190 790   ADVANCED REGIONAL TECHNICAL EDUCATION, INC. 160219000883 639 ARTEC CHARTER SCHOOL   Career and Technical School Yes High 09 12.0 2019   grade_9 13 1 7   0 0     0   0   9 12             *         21 13 1 7   0 0     0   0   9 12                 21
1686147 ID     school 1602190 790   ADVANCED REGIONAL TECHNICAL EDUCATION, INC. 160219000883 639 ARTEC CHARTER SCHOOL   Vocational Education School Yes 3.0 09 12 2015   grade_9 1 0 0   0 0     0   0   1 0             *         1 1 0 0   0 0     0   0   1 0                 1
1730255 ID     school 1602190 790   ADVANCED REGIONAL TECHNICAL EDUCATION, INC. 160219000883 639 ARTEC CHARTER SCHOOL   Career and Technical School Yes High 09 12.0 2017   grade_9 11 0 4   0 0     0   0   12 3             *         15 11 0 4   0 0     0   0   12 3                 15
1825191 ID     school 1602190 790   ADVANCED REGIONAL TECHNICAL EDUCATION, INC. 160219000883 639 ARTEC CHARTER SCHOOL   Vocational Education School Yes 3.0 09 12 2016   grade_9 4 0 0   0 0     0   0   4 0             *         4 4 0 0   0 0     0   0   4 0                 4
1685373 ID     school 1603180 401   TETON COUNTY DISTRICT 160318000884 875 BASIN ALTERNATIVE HIGH SCHOOL   Alternative Education School No 3.0 09 12 2015   grade_9 1 0 0   0 0     0   0   0 1             *         1 1 0 0   0 0     0   0   0 1                 1
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
849493 ID     school 1600240 33   BEAR LAKE COUNTY DISTRICT 160024000018 27 BEAR LAKE HIGH SCHOOL   Regular School No High 09 12 2020   grade_9 73 0 3   1 0     1   1   39 40             38         79 73 0 3   1 0     1   1   39 40         38       79
1277040 ID     school 1600240 33   BEAR LAKE COUNTY DISTRICT 160024000018 27 BEAR LAKE HIGH SCHOOL   Regular School No High 09 12.0 2018   grade_9 72 0 1   0 0     0   0   31 42             *         73 72 0 1   0 0     0   0   31 42                 73
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
1682466 ID     school 1600240 33   BEAR LAKE COUNTY DISTRICT 160024000018 27 BEAR LAKE HIGH SCHOOL   Regular School No 3.0 09 12 2015   grade_9 78 1 2   1 1     1   0   42 42             *         84 78 1 2   1 1     1   0   42 42                 84
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
1821501 ID     school 1600240 33   BEAR LAKE COUNTY DISTRICT 160024000018 27 BEAR LAKE HIGH SCHOOL   Regular School No 3.0 09 12 2016   grade_9 69 0 4   1 1     0   0   38 37             *         75 69 0 4   1 1     0   0   38 37                 75
705306 ID     school 1602250 193   MOUNTAIN HOME DISTRICT 160225001041 1317 BENNETT MOUNTAIN HIGH SCHOOL   Alternative School No High 07 12 2021   grade_9 5 0 3   0 0     0   0   5 3             *         8 5 0 3   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
1278530 ID     school 1602250 193   MOUNTAIN HOME DISTRICT 160225001041 1317 BENNETT MOUNTAIN HIGH SCHOOL   Alternative School No High 07 12.0 2018   grade_9 11 0 0   0 0     0   1   8 4             *         12 11 0 0   0 0     0   1   8 4                 12
1307403 ID     school 1602250 193   MOUNTAIN HOME DISTRICT 160225001041 1317 BENNETT MOUNTAIN HIGH SCHOOL   Alternative School No High 07 12.0 2019   grade_9 5 0 1   0 0     0   0   3 3             *         6 5 0 1   0 0     0   0   3 3                 6
1683932 ID     school 1602250 193   MOUNTAIN HOME DISTRICT 160225001041 1317 BENNETT MOUNTAIN HIGH SCHOOL   Alternative Education School No 3.0 09 12 2015   grade_9 6 0 4   1 0     0   1   8 4             *         12 6 0 4   1 0     0   1   8 4                 12
1727993 ID     school 1602250 193   MOUNTAIN HOME DISTRICT 160225001041 1317 BENNETT MOUNTAIN HIGH SCHOOL   Alternative School No High 07 12.0 2017   grade_9 10 0 0   0 0     0   1   4 7             6         11 10 0 0   0 0     0   1   4 7         6       11
1822982 ID     school 1602250 193   MOUNTAIN HOME DISTRICT 160225001041 1317 BENNETT MOUNTAIN HIGH SCHOOL   Alternative Education School No 3.0 09 12 2016   grade_9 8 0 3   0 0     0   0   4 7             *         11 8 0 3   0 0     0   0   4 7                 11
707488 ID     school 1600169 485   IDAHO STEM ACADEMY, INC. 160016901067 1364 BINGHAM ACADEMY   Regular School Yes High 09 12 2021   grade_9 28 0 11   2 2     0   1   26 18             28         44 28 0 11   2 2     0   1   26 18         28       44
853135 ID     school 1600169 485   IDAHO STEM ACADEMY, INC. 160016901067 1364 BINGHAM ACADEMY   Regular School Yes High 09 12 2020   grade_9 24 0 2   3 2     0   0   10 21             15         31 24 0 2   3 2     0   0   10 21         15       31
1280646 ID     school 1600169 485   IDAHO STEM ACADEMY, INC. 160016901067 1364 BINGHAM ACADEMY   Regular School Yes High 09 12.0 2018   grade_9 26 0 2   3 0     1   0   20 12             *         32 26 0 2   3 0     1   0   20 12                 32
1309525 ID     school 1600169 485   IDAHO STEM ACADEMY, INC. 160016901067 1364 BINGHAM ACADEMY   Regular School Yes High 09 12.0 2019   grade_9 24 0 6   1 0     0   2   25 8             18         33 24 0 6   1 0     0   2   25 8         18       33
1686005 ID     school 1600169 485   IDAHO STEM ACADEMY, INC. 160016901067 1364 BINGHAM ACADEMY   Regular School Yes 3.0 09 12 2015   grade_9 28 0 8   2 1     0   1   26 14             21         40 28 0 8   2 1     0   1   26 14         21       40
1730096 ID     school 1600169 485   IDAHO STEM ACADEMY, INC. 160016901067 1364 BINGHAM ACADEMY   Regular School Yes High 09 12.0 2017   grade_9 14 0 5   0 1     1   0   15 6             *         21 14 0 5   0 1     1   0   15 6                 21
1825041 ID     school 1600169 485   IDAHO STEM ACADEMY, INC. 160016901067 1364 BINGHAM ACADEMY   Regular School Yes 4.0 09 11 2016   grade_9 23 0 3   0 0     0   1   15 12             *         27 23 0 3   0 0     0   1   15 12                 27
705450 ID     school 1601020 221   EMMETT INDEPENDENT DISTRICT 160102000095 1265 BLACK CANYON JR/SR HIGH SCHOOL   Alternative School No High 07 12 2021   grade_9 11 0 0   0 0     0   1   10 2             *         12 11 0 0   0 0     0   1   10 2                 12
851142 ID     school 1601020 221   EMMETT INDEPENDENT DISTRICT 160102000095 1265 BLACK CANYON JR/SR HIGH SCHOOL   Alternative School No High 09 12 2020   grade_9 19 1 3   0 0     0   0   11 12             *         23 19 1 3   0 0     0   0   11 12                 23
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
1307540 ID     school 1601020 221   EMMETT INDEPENDENT DISTRICT 160102000095 1265 BLACK CANYON JR/SR HIGH SCHOOL   Alternative School No High 09 12.0 2019   grade_9 14 0 4   0 0     1   1   14 6             *         20 14 0 4   0 0     1   1   14 6                 20
1684071 ID     school 1601020 221   EMMETT INDEPENDENT DISTRICT 160102000095 1265 BLACK CANYON JR/SR HIGH SCHOOL   Alternative Education School No 3.0 09 12 2015   grade_9 12 0 4   0 0     0   0   9 7             *         16 12 0 4   0 0     0   0   9 7                 16
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
1823121 ID     school 1601020 221   EMMETT INDEPENDENT DISTRICT 160102000095 1265 BLACK CANYON JR/SR HIGH SCHOOL   Alternative Education School No 3.0 09 12 2016   grade_9 4 0 2   0 0     0   0   5 1             *         6 4 0 2   0 0     0   0   5 1                 6
703842 ID     school 1600270 55   BLACKFOOT DISTRICT 160027000022 34 BLACKFOOT HIGH SCHOOL   Regular School No High 09 12 2021   grade_9 225 0 75   26 0     0   7   167 166             *         333 225 0 75   26 0     0   7   167 166                 333
849590 ID     school 1600270 55   BLACKFOOT DISTRICT 160027000022 34 BLACKFOOT HIGH SCHOOL   Regular School No High 09 12 2020   grade_9 209 2 93   30 2     0   14   171 179             *         350 209 2 93   30 2     0   14   171 179                 350
1277138 ID     school 1600270 55   BLACKFOOT DISTRICT 160027000022 34 BLACKFOOT HIGH SCHOOL   Regular School No High 09 12.0 2018   grade_9 198 1 66   32 0     1   7   160 145             *         305 198 1 66   32 0     1   7   160 145                 305
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
1682562 ID     school 1600270 55   BLACKFOOT DISTRICT 160027000022 34 BLACKFOOT HIGH SCHOOL   Regular School No 3.0 09 12 2015   grade_9 187 1 80   21 1     1   10   162 139             *         301 187 1 80   21 1     1   10   162 139                 301
1726603 ID     school 1600270 55   BLACKFOOT DISTRICT 160027000022 34 BLACKFOOT HIGH SCHOOL   Regular School No High 09 12.0 2017   grade_9 206 2 58   31 2     0   10   155 154             *         309 206 2 58   31 2     0   10   155 154                 309
1821598 ID     school 1600270 55   BLACKFOOT DISTRICT 160027000022 34 BLACKFOOT HIGH SCHOOL   Regular School No 3.0 09 12 2016   grade_9 186 3 74   29 2     0   7   168 133             *         301 186 3 74   29 2     0   7   168 133                 301
705519 ID     school 1600330 234   BLISS JOINT DISTRICT 160033000040 714 BLISS SCHOOL   Regular School No Other PK 12 2021   grade_9 3 0 4   0 0     0   0   3 4             *         7 3 0 4   0 0     0   0   3 4                 7
851201 ID     school 1600330 234   BLISS JOINT DISTRICT 160033000040 714 BLISS SCHOOL   Regular School No Other PK 12 2020   grade_9 7 0 6   0 0     0   1   5 9             *         14 7 0 6   0 0     0   1   5 9                 14
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
1307599 ID     school 1600330 234   BLISS JOINT DISTRICT 160033000040 714 BLISS SCHOOL   Regular School No Other PK 12.0 2019   grade_9 2 0 7   0 0     0   0   4 5             *         9 2 0 7   0 0     0   0   4 5                 9
1684132 ID     school 1600330 234   BLISS JOINT DISTRICT 160033000040 714 BLISS SCHOOL   Regular School No 4.0 PK 12 2015   grade_9 4 0 1   0 0     0   0   4 1             *         5 4 0 1   0 0     0   0   4 1                 5
1728192 ID     school 1600330 234   BLISS JOINT DISTRICT 160033000040 714 BLISS SCHOOL   Regular School No Other PK 12.0 2017   grade_9 6 0 1   0 0     0   0   3 4             *         7 6 0 1   0 0     0   0   3 4                 7
1823183 ID     school 1600330 234   BLISS JOINT DISTRICT 160033000040 714 BLISS SCHOOL   Regular School No 4.0 PK 12 2016   grade_9 5 0 5   0 0     0   0   5 5             *         10 5 0 5   0 0     0   0   5 5                 10
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
850226 ID     school 1600420 101   BOUNDARY COUNTY DISTRICT 160042000089 57 BONNERS FERRY HIGH SCHOOL   Regular School No High 09 12 2020   grade_9 110 0 5   4 2     0   6   65 62             54         127 110 0 5   4 2     0   6   65 62         54       127
1277766 ID     school 1600420 101   BOUNDARY COUNTY DISTRICT 160042000089 57 BONNERS FERRY HIGH SCHOOL   Regular School No High 09 12.0 2018   grade_9 115 0 11   2 1     0   5   56 78             69         134 115 0 11   2 1     0   5   56 78         69       134
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
1683186 ID     school 1600420 101   BOUNDARY COUNTY DISTRICT 160042000089 57 BONNERS FERRY HIGH SCHOOL   Regular School No 3.0 09 12 2015   grade_9 100 0 9   8 2     0   2   61 60             55         121 100 0 9   8 2     0   2   61 60         55       121
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

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