Data source: Big Local News · About: Big Local

1,582 rows where grade = "grade_7" and state = "ID" sorted by hispanic

View and edit SQL

year

grade

  • grade_7 · 1,438
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
1682880 ID     school 1600002 84   LAKE PEND OREILLE SCHOOL DISTRICT 160000200604 997 SANDPOINT JUVENILE DETENTION   Alternative Education School No 4.0 05 12 2015   grade_7 1 0 0   0 0     0   0   1 0             *         1 1 0 0   0 0     0   0   1 0                 1
1683024 ID     school 1603120 92   SWAN VALLEY ELEMENTARY DISTRICT 160312000541 424 SWAN VALLEY ELEMENTARY SCHOOL   Regular School No 1.0 PK 08 2015   grade_7 2 0 0   0 0     0   0   1 1             *         2 2 0 0   0 0     0   0   1 1                 2
1683214 ID     school 1600490 111   BUTTE COUNTY JOINT DISTRICT 160049000662 58 BUTTE COUNTY MIDDLE SCHOOL   Regular School No 2.0 06 08 2015   grade_7 24 0 0   0 0     0   1   18 7             10         25 24 0 0   0 0     0   1   18 7         10       25
1683247 ID     school 1600540 121   CAMAS COUNTY DISTRICT 160054000110 440 CAMAS COUNTY ELEM/JR HIGH SCHOOL   Regular School No 1.0 PK 08 2015   grade_7 11 0 0   0 0     0   0   7 4             *         11 11 0 0   0 0     0   0   7 4                 11
1683506 ID     school 1602130 134   MIDDLETON DISTRICT 160213000777 1168 MIDDLETON ACADEMY   Alternative Education School No 3.0 07 12 2015   grade_7 20 0 0   0 0     0   1   11 10             16         21 20 0 0   0 0     0   1   11 10         16       21
1683830 ID     school 1600720 181   CHALLIS JOINT DISTRICT 160072000140 89 CHALLIS JR/SR HIGH SCHOOL   Regular School No 3.0 07 12 2015   grade_7 26 0 0   0 0     1   0   11 16             *         27 26 0 0   0 0     1   0   11 16                 27
1684064 ID     school 1601020 221   EMMETT INDEPENDENT DISTRICT 160102000923 1111 THE PATRIOT CENTER   Alternative Education School No 3.0 07 12 2015   grade_7 2 0 0   0 0     0   0   2 0             *         2 2 0 0   0 0     0   0   2 0                 2
1684138 ID     school 1600810 242   COTTONWOOD JOINT DISTRICT 160081000161 111 PRAIRIE JR/SR HIGH SCHOOL   Regular School No 3.0 07 12 2015   grade_7 21 0 0   1 0     0   0   12 10             9         22 21 0 0   1 0     0   0   12 10         9       22
1684199 ID     school 1600139 244   MOUNTAIN VIEW SCHOOL DISTRICT 160013900933 1287 ELK CITY SCHOOL   Regular School No 1.0 PK 08 2015   grade_7 1 0 0   0 0     0   0   1 0             *         1 1 0 0   0 0     0   0   1 0                 1
1684440 ID     school 1600780 271   COEUR D'ALENE DISTRICT 160078000704 1038 CDA JUVENILE DETENTION CENTER   Alternative Education School No 4.0 04 12 2015   grade_7 1 0 0   0 0     0   0   1 0             *         1 1 0 0   0 0     0   0   1 0                 1
1684622 ID     school 1601200 282   GENESEE JOINT DISTRICT 160120000845 269 GENESEE SCHOOL   Regular School No 4.0 PK 12 2015   grade_7 23 0 0   2 0     1   0   11 15             7         26 23 0 0   2 0     1   0   11 15         7       26
1684645 ID     school 1602700 285   POTLATCH DISTRICT 160270000495 135 POTLATCH JR/SR HIGH SCHOOL   Regular School No 3.0 07 12 2015   grade_7 51 0 0   0 0     0   3   24 30             27         54 51 0 0   0 0     0   3   24 30         27       54
1684668 ID     school 1600009 287   TROY SCHOOL DISTRICT 160000900582 772 TROY JR/SR HIGH SCHOOL   Regular School No 3.0 07 12 2015   grade_7 22 0 0   0 0     0   0   15 7             6         22 22 0 0   0 0     0   0   15 7         6       22
1684718 ID     school 1603030 292   SOUTH LEMHI DISTRICT 160303000528 137 LEADORE SCHOOL   Regular School No 4.0 PK 12 2015   grade_7 3 0 0   0 0     0   0   2 1             *         3 3 0 0   0 0     0   0   2 1                 3
1684740 ID     school 1602400 302   NEZPERCE JOINT DISTRICT 160240000848 272 NEZPERCE SCHOOL   Regular School No 4.0 PK 12 2015   grade_7 8 0 0   0 0     0   0   5 3             *         8 8 0 0   0 0     0   0   5 3                 8
1684770 ID     school 1601440 305   HIGHLAND JOINT DISTRICT 160144000849 285 HIGHLAND SCHOOL   Regular School No 4.0 PK 12 2015   grade_7 18 0 0   1 0     0   0   5 14             8         19 18 0 0   1 0     0   0   5 14         8       19
1684874 ID     school 1601920 321   MADISON DISTRICT 160192000296 9015 CENTRAL HIGH SCHOOL   Alternative Education School No 3.0 07 12 2015   grade_7 5 0 0   0 0     0   0   3 2             *         5 5 0 0   0 0     0   0   3 2                 5
1684978 ID     school   340   LEWISTON INDEPENDENT DISTRICT   611 NORTHWEST CHILDRENS HOME             2015   grade_7 3 0 0   1 0     0   0   3 1             *         4 3 0 0   1 0     0   0   3 1                 4
1685044 ID     school 1601860 340   LEWISTON INDEPENDENT DISTRICT 160186000170 1266 REGION 2 JUVENILE DETENTION CENTER   Alternative Education School No 4.0 03 12 2015   grade_7 0 0 0   1 0     0   0   1 0             *         1 0 0 0   1 0     0   0   1 0                 1
1685065 ID     school   341   LAPWAI DISTRICT   1050 NORTHWEST CHILDREN'S HOME             2015   grade_7 0 0 0   1 0     0   0   1 0             *         1 0 0 0   1 0     0   0   1 0                 1
1685079 ID     school 1600870 342   CULDESAC JOINT DISTRICT 160087000164 795 CULDESAC SCHOOL   Regular School No 4.0 PK 12 2015   grade_7 6 0 0   0 0     0   1   5 2             *         7 6 0 0   0 0     0   1   5 2                 7
1685094 ID     school 1602490 351   ONEIDA COUNTY DISTRICT 160249000629 618 MALAD MIDDLE SCHOOL   Regular School No 2.0 06 08 2015   grade_7 73 2 0   0 0     0   2   36 41             35         77 73 2 0   0 0     0   2   36 41         35       77
1685311 ID     school 1602280 392   MULLAN DISTRICT 160228000405 172 MULLAN SCHOOLS   Regular School No 3.0 07 12 2015   grade_7 7 0 0   1 0     0   1   4 5             *         9 7 0 0   1 0     0   1   4 5                 9
1685342 ID     school 1600150 394   AVERY SCHOOL DISTRICT 160015001010 820 CALDER SCHOOL   Regular School No 1.0 KG 08 2015   grade_7 2 0 0   0 0     0   0   2 0             *         2 2 0 0   0 0     0   0   2 0                 2
1685638 ID     school 1600570 432   CAMBRIDGE JOINT DISTRICT 160057000113 193 CAMBRIDGE MIDDLE/HIGH SCHOOL   Regular School No 3.0 07 12 2015   grade_7 8 0 0   0 0     0   3   6 5             *         11 8 0 0   0 0     0   3   6 5                 11
1685659 ID     school 1602160 433   MIDVALE DISTRICT 160216000857 286 MIDVALE SCHOOL   Regular School No 4.0 PK 12 2015   grade_7 9 0 0   0 0     0   0   4 5             *         9 9 0 0   0 0     0   0   4 5                 9
1685873 ID     school 1600148 469   IDAHO VIRTUAL EDUCATION PARTNERS, INC. 160014801023 1303 IDAHO CONNECTS ONLINE ALTERNATIVE SCHOOL   Alternative Education School Yes 3.0 07 12 2015   grade_7 7 1 0   0 0     0   0   2 6             *         8 7 1 0   0 0     0   0   2 6                 8
1685888 ID     school 1600151 472   PALOUSE PRAIRIE EDUCATIONAL ORGANIZATION, INC. 160015100994 1234 PALOUSE PRAIRIE CHARTER SCHOOL   Regular School Yes 1.0 PK 08 2015   grade_7 16 1 0   0 0     0   0   7 10             6         17 16 1 0   0 0     0   0   7 10         6       17
1685991 ID     school 1600162 482   AMERICAN HERITAGE CHARTER SCHOOL, INC. 160016201044 1346 AMERICAN HERITAGE CHARTER SCHOOL   Regular School Yes 4.0 PK 09 2015   grade_7 27 0 0   0 0     0   1   9 19             13         28 27 0 0   0 0     0   1   9 19         13       28
1686013 ID     school 1600170 486   UPPER CARMEN PUBLIC CHARTER SCHOOL, INC. 160017000847 1366 UPPER CARMEN PUBLIC CHARTER SCHOOL   Regular School Yes 1.0 PK 08 2015   grade_7 6 0 0   0 0     0   0   4 2             *         6 6 0 0   0 0     0   0   4 2                 6
1686021 ID     school 1600165 487   SANDPOINT CHARTER SCHOOL, INC. 160016500772 1365 FORREST M BIRD CHARTER SCHOOL   Regular School Yes 4.0 06 12 2015   grade_7 53 0 0   1 2     0   1   36 21             *         57 53 0 0   1 2     0   1   36 21                 57
1686091 ID     school 1602640 494   THE POCATELLO COMMUNITY CHARTER SCHOOL, INC. 160264000760 623 POCATELLO COMMUNITY CHARTER   Regular School Yes 1.0 PK 08 2015   grade_7 38 1 0   0 1     0   1   23 18             17         41 38 1 0   0 1     0   1   23 18         17       41
1686125 ID     school 1603511 596   IDAHO BUREAU OF EDUCATIONAL SERVICES FOR THE DEAF AND THE BLIND 160351100685 948 IDAHO SCHOOL FOR THE DEAF AND THE BLIND   Special Education School No 4.0 PK 12 2015   grade_7 2 0 0   0 0     0   0   1 1             *         2 2 0 0   0 0     0   0   1 1                 2
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
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
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
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
1726311 ID     school 1600840 13   COUNCIL DISTRICT 160084000163 17 COUNCIL JR/SR HIGH SCHOOL   Regular School No High 07 12.0 2017   grade_7 13 0 0   0 0     0   3   7 9             10         16 13 0 0   0 0     0   3   7 9         10       16
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
1726770 ID     school 1601170 71   GARDEN VALLEY DISTRICT 160117000830 274 GARDEN VALLEY SCHOOL   Regular School No Other PK 13.0 2017   grade_7 14 1 0   0 0     0   0   7 8             10         15 14 1 0   0 0     0   0   7 8         10       15
1726852 ID     school 1600002 84   LAKE PEND OREILLE SCHOOL DISTRICT 160000200082 49 CLARK FORK JR/SR HIGH SCHOOL   Regular School No High 07 12.0 2017   grade_7 24 0 0   0 0     0   0   11 13             *         24 24 0 0   0 0     0   0   11 13                 24
1727066 ID     school 1603120 92   SWAN VALLEY ELEMENTARY DISTRICT 160312000541 424 SWAN VALLEY ELEMENTARY SCHOOL   Regular School No Elementary PK 8.0 2017   grade_7 6 0 0   0 0     0   0   5 1             *         6 6 0 0   0 0     0   0   5 1                 6
1727070 ID     school   92   SWAN VALLEY ELEMENTARY DISTRICT   1014 BORDER DISTRICT - STAR VALLEY ELEMENTARY SCHOOL             2017   grade_7 1 0 0   0 0     0   0   0 1             *         1 1 0 0   0 0     0   0   0 1                 1
1727690 ID     school 1602430 149   NORTH GEM DISTRICT 160243000428 77 NORTH GEM HIGH SCHOOL   Regular School No High 07 12.0 2017   grade_7 14 0 0   0 0     0   0   9 5             5         14 14 0 0   0 0     0   0   9 5         5       14
1727897 ID     school 1600720 181   CHALLIS JOINT DISTRICT 160072000143 486 STANLEY ELEM/JR HIGH SCHOOL   Regular School No Elementary KG 8.0 2017   grade_7 2 0 0   0 0     0   0   2 0             *         2 2 0 0   0 0     0   0   2 0                 2
1727930 ID     school 1602730 191   PRAIRIE ELEMENTARY DISTRICT 160273000496 491 PRAIRIE ELEM/JR HIGH SCHOOL   Regular School No Elementary KG 8.0 2017   grade_7 2 0 0   0 0     0   0   1 1             *         2 2 0 0   0 0     0   0   1 1                 2
1728124 ID     school 1601020 221   EMMETT INDEPENDENT DISTRICT 160102000923 1111 THE PATRIOT CENTER   Alternative School No Other 06 12.0 2017   grade_7 3 0 0   0 0     0   0   3 0             *         3 3 0 0   0 0     0   0   3 0                 3
1728221 ID     school 1600138 243   SALMON RIVER JOINT SCHOOL DISTRICT 160013800944 1281 SALMON RIVER JR/SR HIGH SCHOOL   Regular School No Other 06 12.0 2017   grade_7 8 0 0   0 0     0   0   6 2             *         8 8 0 0   0 0     0   0   6 2                 8
1728259 ID     school 1600139 244   MOUNTAIN VIEW SCHOOL DISTRICT 160013900933 1287 ELK CITY SCHOOL   Regular School No Elementary PK 8.0 2017   grade_7 1 0 0   0 0     0   0   1 0             *         1 1 0 0   0 0     0   0   1 0                 1
1728710 ID     school 1602700 285   POTLATCH DISTRICT 160270000495 135 POTLATCH JR/SR HIGH SCHOOL   Regular School No High 07 12.0 2017   grade_7 30 0 0   0 0     0   0   19 11             11         30 30 0 0   0 0     0   0   19 11         11       30
1728733 ID     school 1600009 287   TROY SCHOOL DISTRICT 160000900582 772 TROY JR/SR HIGH SCHOOL   Regular School No High 07 12.0 2017   grade_7 18 0 0   0 0     0   1   11 8             5         19 18 0 0   0 0     0   1   11 8         5       19
1728779 ID     school 1603030 292   SOUTH LEMHI DISTRICT 160303000528 137 LEADORE SCHOOL   Regular School No Other PK 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
1728801 ID     school 1602400 302   NEZPERCE JOINT DISTRICT 160240000848 272 NEZPERCE SCHOOL   Regular School No Other PK 12.0 2017   grade_7 9 0 0   0 0     0   1   5 5             *         10 9 0 0   0 0     0   1   5 5                 10
1729042 ID     school   340   LEWISTON INDEPENDENT DISTRICT   611 NORTHWEST CHILDRENS HOME             2017   grade_7 1 0 0   0 0     0   0   1 0             *         1 1 0 0   0 0     0   0   1 0                 1
1729115 ID     school 1601830 341   LAPWAI DISTRICT 160183000854 583 LAPWAI MIDDLE/HIGH SCHOOL   Regular School No Other 06 12.0 2017   grade_7 4 0 0   36 0     0   3   29 14             *         43 4 0 0   36 0     0   3   29 14                 43
1729135 ID     school 1600870 342   CULDESAC JOINT DISTRICT 160087000164 795 CULDESAC SCHOOL   Regular School No Other PK 12.0 2017   grade_7 9 0 0   2 0     0   0   9 2             *         11 9 0 0   2 0     0   0   9 2                 11
1729268 ID     school 1602580 371   PAYETTE JOINT DISTRICT 160258001051 1318 PAYETTE ALTERNATIVE CENTER   Special Education School No Other PK 12.0 2017   grade_7 0 0 0   1 0     0   0   1 0             *         1 0 0 0   1 0     0   0   1 0                 1
1729320 ID     school 1600060 381   AMERICAN FALLS JOINT DISTRICT 160006000768 261 AMERICAN FALLS ACADEMY   Alternative School No Other 06 12.0 2017   grade_7 3 0 0   0 0     0   0   2 1             *         3 3 0 0   0 0     0   0   2 1                 3
1729340 ID     school 1602820 382   ROCKLAND DISTRICT 160282000501 169 ROCKLAND PUBLIC SCHOOL   Regular School No Other PK 12.0 2017   grade_7 14 0 0   0 0     0   0   8 6             7         14 14 0 0   0 0     0   0   8 6         7       14
1729410 ID     school 1600150 394   AVERY SCHOOL DISTRICT 160015001010 820 CALDER SCHOOL   Regular School No Other KG 12.0 2017   grade_7 0 0 0   0 0     0   1   0 1             *         1 0 0 0   0 0     0   1   0 1                 1
1729734 ID     school 1602160 433   MIDVALE DISTRICT 160216000857 286 MIDVALE SCHOOL   Regular School No Other PK 12.0 2017   grade_7 9 0 0   0 0     0   0   3 6             *         9 9 0 0   0 0     0   0   3 6                 9
1729742 ID     school 1602160 433   MIDVALE DISTRICT 160216000939 1113 MIDVALE ALTERNATIVE SCHOOL   Alternative School No High 07 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
1729946 ID     school 1600148 469   IDAHO VIRTUAL EDUCATION PARTNERS, INC. 160014800993 1221 IDAHO CONNECTS ONLINE SCHOOL   Regular School Yes Other 06 12.0 2017   grade_7 2 0 0   0 0     0   0   0 2             *         2 2 0 0   0 0     0   0   0 2                 2
1729954 ID     school 1600148 469   IDAHO VIRTUAL EDUCATION PARTNERS, INC. 160014801023 1303 IDAHO CONNECTS ONLINE ALTERNATIVE SCHOOL   Alternative School Yes Other 06 12.0 2017   grade_7 9 0 0   0 0     0   0   5 4             *         9 9 0 0   0 0     0   0   5 4                 9
1729979 ID     school 1600157 473   THE VILLAGE CHARTER SCHOOL, INC. 160015701018 1339 THE VILLAGE CHARTER SCHOOL   Regular School Yes Elementary PK 8.0 2017   grade_7 22 0 0   0 0     0   0   15 7             *         22 22 0 0   0 0     0   0   15 7                 22
1730057 ID     school 1600160 480   NORTH IDAHO STEM CHARTER ACADEMY, INC. 160016001020 1342 NORTH IDAHO STEM CHARTER ACADEMY   Regular School Yes Other KG 11.0 2017   grade_7 29 0 0   0 1     0   1   17 14             8         31 29 0 0   0 1     0   1   17 14         8       31
1730104 ID     school 1600170 486   UPPER CARMEN PUBLIC CHARTER SCHOOL, INC. 160017000847 1366 UPPER CARMEN PUBLIC CHARTER SCHOOL   Regular School Yes Elementary PK 8.0 2017   grade_7 8 0 0   0 0     0   0   3 5             *         8 8 0 0   0 0     0   0   3 5                 8
1820901 ID     school 1600360 1   BOISE INDEPENDENT DISTRICT 160036000708 9002 ADA COUNTY JUVENILE CENTER   Alternative Education School No 4.0 05 12 2016   grade_7 1 1 0   0 0     0   0   2 0             *         2 1 1 0   0 0     0   0   2 0                 2
1821194 ID     school 1602100 2   JOINT SCHOOL DISTRICT NO. 2 160210001025 1297 REBOUND SCHOOL OF OPPORTUNITY   Alternative Education School No 3.0 07 12 2016   grade_7 1 0 0   0 0     0   0   1 0             *         1 1 0 0   0 0     0   0   1 0                 1
1821211 ID     school 1602100 2   JOINT SCHOOL DISTRICT NO. 2 160210001070 1374 VIRTUAL SCHOOL HOUSE   Regular School No 1.0 PK 08 2016   grade_7 20 0 0   0 0     0   1   9 12             *         21 20 0 0   0 0     0   1   9 12                 21
1821483 ID     school 1602640 25   POCATELLO DISTRICT 160264000686 1002 KINPORT MIDDLE SCHOOL   Alternative Education School No 2.0 07 08 2016   grade_7 6 0 0   0 0     0   0   6 0             *         6 6 0 0   0 0     0   0   6 0                 6
1821857 ID     school 1600002 84   LAKE PEND OREILLE SCHOOL DISTRICT 160000200087 202 SANDPOINT HIGH SCHOOL   Regular School No 3.0 07 12 2016   grade_7 1 0 0   0 0     0   0   0 1             *         1 1 0 0   0 0     0   0   0 1                 1
1822041 ID     school 1601530 91   IDAHO FALLS DISTRICT 160153000697 1048 EMERSON HIGH SCHOOL   Alternative Education School No 3.0 07 12 2016   grade_7 1 0 0   0 0     0   0   1 0             *         1 1 0 0   0 0     0   0   1 0                 1
1822170 ID     school 1600930 93   BONNEVILLE JOINT DISTRICT 160093000649 1159 TELFORD ACADEMY (ALT)   Alternative Education School No 2.0 07 09 2016   grade_7 3 0 0   0 0     0   0   3 0             *         3 3 0 0   0 0     0   0   3 0                 3
1822692 ID     school 1602430 149   NORTH GEM DISTRICT 160243000428 77 NORTH GEM HIGH SCHOOL   Regular School No 3.0 07 12 2016   grade_7 16 0 0   0 0     0   0   8 8             7         16 16 0 0   0 0     0   0   8 8         7       16
1822908 ID     school 1601900 182   MACKAY JOINT DISTRICT 160190000332 90 MACKAY JR/SR HIGH SCHOOL   Regular School No 3.0 07 12 2016   grade_7 17 0 0   1 0     0   0   9 9             7         18 17 0 0   1 0     0   0   9 9         7       18
1823212 ID     school 1600138 243   SALMON RIVER JOINT SCHOOL DISTRICT 160013800944 1281 SALMON RIVER JR/SR HIGH SCHOOL   Regular School No 4.0 06 12 2016   grade_7 11 0 0   0 0     0   0   4 7             6         11 11 0 0   0 0     0   0   4 7         6       11
1823250 ID     school 1600139 244   MOUNTAIN VIEW SCHOOL DISTRICT 160013900933 1287 ELK CITY SCHOOL   Regular School No 1.0 PK 08 2016   grade_7 2 0 0   0 0     0   0   2 0             *         2 2 0 0   0 0     0   0   2 0                 2
1823671 ID     school 1601200 282   GENESEE JOINT DISTRICT 160120000845 269 GENESEE SCHOOL   Regular School No 4.0 PK 12 2016   grade_7 23 0 0   0 0     0   0   11 12             5         23 23 0 0   0 0     0   0   11 12         5       23
1823764 ID     school 1603030 292   SOUTH LEMHI DISTRICT 160303000528 137 LEADORE SCHOOL   Regular School No 4.0 PK 12 2016   grade_7 7 0 0   0 0     0   0   4 3             *         7 7 0 0   0 0     0   0   4 3                 7
1823920 ID     school 1601920 321   MADISON DISTRICT 160192000296 9015 CENTRAL HIGH SCHOOL   Alternative Education School No 3.0 07 12 2016   grade_7 3 0 0   1 0     0   0   3 1             *         4 3 0 0   1 0     0   0   3 1                 4
1824116 ID     school 1600870 342   CULDESAC JOINT DISTRICT 160087000164 795 CULDESAC SCHOOL   Regular School No 4.0 PK 12 2016   grade_7 4 0 0   0 0     0   0   1 3             *         4 4 0 0   0 0     0   0   1 3                 4
1824237 ID     school 1602580 371   PAYETTE JOINT DISTRICT 160258001051 1318 PAYETTE ALTERNATIVE CENTER   Special Education School No 4.0 PK 12 2016   grade_7 1 0 0   0 0     0   0   0 1             *         1 1 0 0   0 0     0   0   0 1                 1
1824289 ID     school 1600060 381   AMERICAN FALLS JOINT DISTRICT 160006000768 261 AMERICAN FALLS ACADEMY   Alternative Education School No 3.0 07 12 2016   grade_7 1 0 0   0 0     0   1   2 0             *         2 1 0 0   0 0     0   1   2 0                 2
1824347 ID     school 1602280 392   MULLAN DISTRICT 160228000405 172 MULLAN SCHOOLS   Regular School No 3.0 07 12 2016   grade_7 5 0 0   0 0     0   0   3 2             *         5 5 0 0   0 0     0   0   3 2                 5
1824666 ID     school 1600570 432   CAMBRIDGE JOINT DISTRICT 160057000113 193 CAMBRIDGE MIDDLE/HIGH SCHOOL   Regular School No 3.0 07 12 2016   grade_7 13 0 0   0 0     0   0   9 4             7         13 13 0 0   0 0     0   0   9 4         7       13
1824687 ID     school 1602160 433   MIDVALE DISTRICT 160216000857 286 MIDVALE SCHOOL   Regular School No 4.0 PK 12 2016   grade_7 6 0 0   0 0     0   0   0 6             *         6 6 0 0   0 0     0   0   0 6                 6
1824695 ID     school 1602160 433   MIDVALE DISTRICT 160216000939 1113 MIDVALE ALTERNATIVE SCHOOL   Alternative Education School No 3.0 07 12 2016   grade_7 2 0 0   0 0     0   0   1 1             *         2 2 0 0   0 0     0   0   1 1                 2
1824747 ID     school 1600006 454   ROLLING HILLS PUBLIC CHARTER SCHOOL, INC. 160000600863 574 ROLLING HILLS PUBLIC CHARTER   Regular School Yes 1.0 PK 08 2016   grade_7 22 0 0   0 0     0   3   14 11             *         25 22 0 0   0 0     0   3   14 11                 25
1824927 ID     school 1600157 473   THE VILLAGE CHARTER SCHOOL, INC. 160015701018 1339 THE VILLAGE CHARTER SCHOOL   Regular School Yes 1.0 PK 08 2016   grade_7 21 0 0   0 0     0   0   12 9             *         21 21 0 0   0 0     0   0   12 9                 21
1825026 ID     school 1600162 482   AMERICAN HERITAGE CHARTER SCHOOL, INC. 160016201044 1346 AMERICAN HERITAGE CHARTER SCHOOL   Regular School Yes 4.0 PK 10 2016   grade_7 30 0 0   0 0     0   0   17 13             11         30 30 0 0   0 0     0   0   17 13         11       30
1825049 ID     school 1600170 486   UPPER CARMEN PUBLIC CHARTER SCHOOL, INC. 160017000847 1366 UPPER CARMEN PUBLIC CHARTER SCHOOL   Regular School Yes 1.0 PK 08 2016   grade_7 9 0 0   0 0     0   0   4 5             *         9 9 0 0   0 0     0   0   4 5                 9
703072 ID     school 1600360 1   BOISE INDEPENDENT DISTRICT 160036000984 675 FRANK CHURCH HIGH SCHOOL   Alternative School No High 06 12 2021   grade_7 2 0 1   0 0     0   0   3 0             *         3 2 0 1   0 0     0   0   3 0                 3
703530 ID     school 1600840 13   COUNCIL DISTRICT 160084000163 17 COUNCIL JR/SR HIGH SCHOOL   Regular School No High 07 12 2021   grade_7 27 0 1   0 0     0   0   14 14             10         28 27 0 1   0 0     0   0   14 14         10       28
703763 ID     school 1603060 41   ST MARIES JOINT DISTRICT 160306000534 28 ST MARIES MIDDLE SCHOOL   Regular School No Middle 06 08 2021   grade_7 69 0 1   1 1     0   6   43 35             34         78 69 0 1   1 1     0   6   43 35         34       78
703795 ID     school 1600815 44   PLUMMER-WORLEY JOINT DISTRICT 160081500647 128 LAKESIDE JR HIGH SCHOOL   Regular School No Middle 07 08 2021   grade_7 5 0 1   13 0     0   5   10 14             15         24 5 0 1   13 0     0   5   10 14         15       24
704061 ID     school 1601500 73   HORSESHOE BEND SCHOOL DISTRICT 160150000831 278 HORSESHOE BEND MIDDLE/SR HIGH   Regular School No High 06 12 2021   grade_7 13 0 1   0 1     0   2   7 10             10         17 13 0 1   0 1     0   2   7 10         10       17
704531 ID     school 1600490 111   BUTTE COUNTY JOINT DISTRICT 160049000008 59 BUTTE COUNTY MIDDLE/HIGH SCHOOL   Regular School No High 07 12 2021   grade_7 37 0 1   1 0     0   0   16 23             16         39 37 0 1   1 0     0   0   16 23         16       39
705018 ID     school   150   SODA SPRINGS JOINT DISTRICT   1026 BORDER DISTRICT FREEDOM - SECONDARY             2021   grade_7 1 0 1   0 0     0   0   0 2             *         2 1 0 1   0 0     0   0   0 2                 2
705161 ID     school 1602520 171   OROFINO JOINT DISTRICT 160252000440 88 OROFINO HIGH SCHOOL   Regular School No High 07 12 2021   grade_7 66 0 1   4 0     0   1   37 35             24         72 66 0 1   4 0     0   1   37 35         24       72

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