Data source: Big Local News · About: Big Local

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

View and edit SQL

year

grade

  • grade_7 · 1,548
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
703901 ID     school 1600270 55   BLACKFOOT DISTRICT 160027000689 9006 INDEPENDENCE ALTERNATIVE HIGH SCHOOL   Alternative School No High 07 12 2021   grade_7 1 0 0   0 0     0   0   1 0             *         1 1 0 0   0 0     0   0   1 0                 1
704774 ID     school 1600510 132   CALDWELL DISTRICT 160051000043 1087 SOUTHWEST IDAHO JUVENILE DETENTION   Alternative School No Other 01 12 2021   grade_7 1 0 0   0 0     0   0   1 0             *         1 1 0 0   0 0     0   0   1 0                 1
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
705109 ID     school 1600660 151   CASSIA COUNTY JOINT DISTRICT 160066000540 990 CASSIA JR/SR HIGH SCHOOL   Alternative School No High 07 12 2021   grade_7 1 0 0   0 0     0   0   1 0             *         1 1 0 0   0 0     0   0   1 0                 1
705213 ID     school 1600720 181   CHALLIS JOINT DISTRICT 160072000143 486 STANLEY ELEM/JR HIGH SCHOOL   Regular School No Elementary KG 08 2021   grade_7 1 0 0   0 0     0   0   0 1             *         1 1 0 0   0 0     0   0   0 1                 1
705846 ID     school 1600780 271   COEUR D'ALENE DISTRICT 160078000704 1038 CDA JUVENILE DETENTION CENTER   Alternative School No Other 04 12 2021   grade_7 1 0 0   0 0     0   0   1 0             *         1 1 0 0   0 0     0   0   1 0                 1
706541 ID     school 1602610 364   PLEASANT VALLEY ELEMENTARY DISTRICT 160261000459 800 PLEASANT VALLEY ELEM/JR HIGH   Regular School No Elementary PK 08 2021   grade_7 1 0 0   0 0     0   0   1 0             *         1 1 0 0   0 0     0   0   1 0                 1
706862 ID     school 1603240 411   TWIN FALLS DISTRICT 160324000739 1260 SNAKE RIVER JUVENILE DETENTION   Alternative School No Other 01 12 2021   grade_7 1 0 0   0 0     0   0   1 0             *         1 1 0 0   0 0     0   0   1 0                 1
706978 ID     school 1603210 416   THREE CREEK JOINT ELEMENTARY DISTRICT 160321000546 835 THREE CREEK ELEM/JR HIGH SCHOOL   Regular School No Elementary PK 08 2021   grade_7 1 0 0   0 0     0   0   0 1             *         1 1 0 0   0 0     0   0   0 1                 1
850731 ID     school   150   SODA SPRINGS JOINT DISTRICT   1026 BORDER DISTRICT FREEDOM - SECONDARY             2020   grade_7 1 0 0   0 0     0   0   1 0             *         1 1 0 0   0 0     0   0   1 0                 1
850828 ID     school 1600660 151   CASSIA COUNTY JOINT DISTRICT 160066000540 990 CASSIA JR/SR HIGH SCHOOL   Alternative School No High 07 12 2020   grade_7 1 0 1   0 0     0   0   0 2             *         2 1 0 1   0 0     0   0   0 2                 2
850844 ID     school 1600750 161   CLARK COUNTY DISTRICT 160075000144 85 CLARK COUNTY JR/SR HIGH SCHOOL   Regular School No High 06 12 2020   grade_7 1 0 7   0 0     0   0   1 7             *         8 1 0 7   0 0     0   0   1 7                 8
850916 ID     school 1600720 181   CHALLIS JOINT DISTRICT 160072000143 486 STANLEY ELEM/JR HIGH SCHOOL   Regular School No Elementary KG 08 2020   grade_7 1 0 0   0 0     0   0   1 0             *         1 1 0 0   0 0     0   0   1 0                 1
851385 ID     school 1601590 261   JEROME JOINT DISTRICT 160159000097 1272 FALLS CITY ACADEMY   Alternative School No High 06 12 2020   grade_7 1 0 2   0 0     0   0   2 1             *         3 1 0 2   0 0     0   0   2 1                 3
851506 ID     school 1600780 271   COEUR D'ALENE DISTRICT 160078000704 1038 CDA JUVENILE DETENTION CENTER   Alternative School No Other 04 12 2020   grade_7 1 0 0   0 0     0   0   1 0             *         1 1 0 0   0 0     0   0   1 0                 1
851949 ID     school 1601920 321   MADISON DISTRICT 160192000296 9015 CENTRAL HIGH SCHOOL   Alternative School No High 06 12 2020   grade_7 1 0 1   0 0     0   0   2 0             *         2 1 0 1   0 0     0   0   2 0                 2
852047 ID     school   340   LEWISTON INDEPENDENT DISTRICT   611 NORTHWEST CHILDRENS HOME             2020   grade_7 1 0 0   0 0     0   0   1 0             *         1 1 0 0   0 0     0   0   1 0                 1
852314 ID     school 1600060 381   AMERICAN FALLS JOINT DISTRICT 160006000768 261 AMERICAN FALLS ACADEMY   Alternative School No High 06 12 2020   grade_7 1 0 0   0 0     0   0   0 1             *         1 1 0 0   0 0     0   0   0 1                 1
853318 ID     school 1600152 555   CANYON-OWYHEE SCHOOL SERVICE AGENCY (COSSA) 160015200304 1291 COSSA ACADEMY   Alternative School No High 07 12 2020   grade_7 1 0 2   0 0     0   0   2 1             *         3 1 0 2   0 0     0   0   2 1                 3
1276417 ID     school 1600360 1   BOISE INDEPENDENT DISTRICT 160036000984 675 FRANK CHURCH HIGH SCHOOL   Alternative School No High 06 12.0 2018   grade_7 1 0 0   0 0     0   0   1 0             *         1 1 0 0   0 0     0   0   1 0                 1
1276440 ID     school 1600360 1   BOISE INDEPENDENT DISTRICT 160036000708 9002 ADA COUNTY JUVENILE CENTER   Alternative School No High 05 12.0 2018   grade_7 1 0 1   0 0     0   0   2 0             *         2 1 0 1   0 0     0   0   2 0                 2
1278272 ID     school   150   SODA SPRINGS JOINT DISTRICT   1026 BORDER DISTRICT FREEDOM - SECONDARY             2018   grade_7 1 0 1   0 0     0   0   1 1             *         2 1 0 1   0 0     0   0   1 1                 2
1278440 ID     school 1600720 181   CHALLIS JOINT DISTRICT 160072000143 486 STANLEY ELEM/JR HIGH SCHOOL   Regular School No Elementary KG 8.0 2018   grade_7 1 0 0   0 0     0   0   1 0             *         1 1 0 0   0 0     0   0   1 0                 1
1278528 ID     school 1602250 193   MOUNTAIN HOME DISTRICT 160225001041 1317 BENNETT MOUNTAIN HIGH SCHOOL   Alternative School No High 07 12.0 2018   grade_7 1 0 2   1 0     0   0   2 2             *         4 1 0 2   1 0     0   0   2 2                 4
1278661 ID     school 1601020 221   EMMETT INDEPENDENT DISTRICT 160102000923 1111 THE PATRIOT CENTER   Alternative School No High 06 12.0 2018   grade_7 1 0 3   0 0     0   0   4 0             *         4 1 0 3   0 0     0   0   4 0                 4
1279552 ID     school 1602190 331   MINIDOKA COUNTY JOINT DISTRICT 160219000166 1100 MINI-CASSIA JUVENILE DETENTION CENTER   Alternative School No Other 03 12.0 2018   grade_7 1 0 0   0 0     0   0   1 0             *         1 1 0 0   0 0     0   0   1 0                 1
1279650 ID     school 1601830 341   LAPWAI DISTRICT 160183000854 583 LAPWAI MIDDLE/HIGH SCHOOL   Regular School No High 06 12.0 2018   grade_7 1 0 1   34 0     0   4   23 17             *         40 1 0 1   34 0     0   4   23 17                 40
1280150 ID     school 1603210 416   THREE CREEK JOINT ELEMENTARY DISTRICT 160321000546 835 THREE CREEK ELEM/JR HIGH SCHOOL   Regular School No Elementary PK 8.0 2018   grade_7 1 0 0   0 0     0   0   1 0             *         1 1 0 0   0 0     0   0   1 0                 1
1280276 ID     school 1602160 433   MIDVALE DISTRICT 160216000939 1113 MIDVALE ALTERNATIVE SCHOOL   Alternative School No High 07 12.0 2018   grade_7 1 0 0   0 0     0   0   0 1             *         1 1 0 0   0 0     0   0   0 1                 1
1280765 ID     school 1600152 555   CANYON-OWYHEE SCHOOL SERVICE AGENCY (COSSA) 160015200304 1291 COSSA ACADEMY   Alternative School No High 07 12.0 2018   grade_7 1 0 1   0 0     0   1   3 0             *         3 1 0 1   0 0     0   1   3 0                 3
1280792 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 Other PK 12.0 2018   grade_7 1 0 1   0 1     0   0   1 2             *         3 1 0 1   0 1     0   0   1 2                 3
1305296 ID     school 1600360 1   BOISE INDEPENDENT DISTRICT 160036000708 9002 ADA COUNTY JUVENILE CENTER   Alternative School No High 05 12.0 2019   grade_7 1 0 0   0 0     0   0   1 0             *         1 1 0 0   0 0     0   0   1 0                 1
1306882 ID     school 1600510 132   CALDWELL DISTRICT 160051000043 1087 SOUTHWEST IDAHO JUVENILE DETENTION   Alternative School No Other 01 12.0 2019   grade_7 1 0 0   0 0     0   0   1 0             *         1 1 0 0   0 0     0   0   1 0                 1
1307128 ID     school   150   SODA SPRINGS JOINT DISTRICT   1026 BORDER DISTRICT FREEDOM - SECONDARY             2019   grade_7 1 0 1   0 0     0   0   1 1             *         2 1 0 1   0 0     0   0   1 1                 2
1307315 ID     school 1600720 181   CHALLIS JOINT DISTRICT 160072000143 486 STANLEY ELEM/JR HIGH SCHOOL   Regular School No Elementary KG 8.0 2019   grade_7 1 0 0   0 0     0   0   0 1             *         1 1 0 0   0 0     0   0   0 1                 1
1307664 ID     school 1600139 244   MOUNTAIN VIEW SCHOOL DISTRICT 160013900933 1287 ELK CITY SCHOOL   Regular School No Elementary PK 8.0 2019   grade_7 1 0 0   0 0     0   0   0 1             *         1 1 0 0   0 0     0   0   0 1                 1
1307781 ID     school 1601590 261   JEROME JOINT DISTRICT 160159000097 1272 FALLS CITY ACADEMY   Alternative School No High 06 12.0 2019   grade_7 1 0 0   0 0     0   0   1 0             *         1 1 0 0   0 0     0   0   1 0                 1
1307902 ID     school 1600780 271   COEUR D'ALENE DISTRICT 160078000704 1038 CDA JUVENILE DETENTION CENTER   Alternative School No Other 04 12.0 2019   grade_7 1 1 0   0 0     0   0   2 0             *         2 1 1 0   0 0     0   0   2 0                 2
1308346 ID     school 1601920 321   MADISON DISTRICT 160192000296 9015 CENTRAL HIGH SCHOOL   Alternative School No High 06 12.0 2019   grade_7 1 0 0   0 0     0   0   0 1             *         1 1 0 0   0 0     0   0   0 1                 1
1308446 ID     school   340   LEWISTON INDEPENDENT DISTRICT   611 NORTHWEST CHILDRENS HOME             2019   grade_7 1 0 0   0 0     0   0   1 0             *         1 1 0 0   0 0     0   0   1 0                 1
1308798 ID     school 1600150 394   AVERY SCHOOL DISTRICT 160015001010 820 CALDER SCHOOL   Regular School No Elementary KG 8.0 2019   grade_7 1 0 0   0 0     0   1   2 0             *         2 1 0 0   0 0     0   1   2 0                 2
1309023 ID     school 1603210 416   THREE CREEK JOINT ELEMENTARY DISTRICT 160321000546 835 THREE CREEK ELEM/JR HIGH SCHOOL   Regular School No Elementary PK 8.0 2019   grade_7 1 0 0   0 0     0   0   0 1             *         1 1 0 0   0 0     0   0   0 1                 1
1309677 ID     school 1600152 555   CANYON-OWYHEE SCHOOL SERVICE AGENCY (COSSA) 160015200304 1291 COSSA ACADEMY   Alternative School No High 07 12.0 2019   grade_7 1 0 1   0 0     0   0   2 0             *         2 1 0 1   0 0     0   0   2 0                 2
1681871 ID     school 1600360 1   BOISE INDEPENDENT DISTRICT 160036000708 9002 ADA COUNTY JUVENILE CENTER   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
1682175 ID     school 1602100 2   JOINT SCHOOL DISTRICT NO. 2 160210001070 1374 VIRTUAL SCHOOL HOUSE   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
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
1683840 ID     school 1600720 181   CHALLIS JOINT DISTRICT 160072000143 486 STANLEY ELEM/JR HIGH SCHOOL   Regular School No 1.0 KG 08 2015   grade_7 1 0 1   0 0     0   0   1 1             *         2 1 0 1   0 0     0   0   1 1                 2
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
1684950 ID     school 1602190 331   MINIDOKA COUNTY JOINT DISTRICT 160219000166 1100 MINI-CASSIA JUVENILE DETENTION CENTER   Alternative Education School No 4.0 03 12 2015   grade_7 1 0 1   0 0     0   0   2 0             *         2 1 0 1   0 0     0   0   2 0                 2
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
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
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
1727826 ID     school 1600750 161   CLARK COUNTY DISTRICT 160075000144 85 CLARK COUNTY JR/SR HIGH SCHOOL   Regular School No Other 06 12.0 2017   grade_7 1 0 8   0 0     0   0   3 6             *         9 1 0 8   0 0     0   0   3 6                 9
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
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
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
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
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
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
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
706162 ID     school 1602400 302   NEZPERCE JOINT DISTRICT 160240000848 272 NEZPERCE SCHOOL   Regular School No Other PK 12 2021   grade_7 10 0 0   0 0     0   2   4 8             7         12 10 0 0   0 0     0   2   4 8         7       12
851844 ID     school 1601440 305   HIGHLAND JOINT DISTRICT 160144000849 285 HIGHLAND SCHOOL   Regular School No Other PK 12 2020   grade_7 10 0 2   0 0     0   0   9 3             5         12 10 0 2   0 0     0   0   9 3         5       12
851878 ID     school 1600900 314   DIETRICH DISTRICT 160090000165 143 DIETRICH SCHOOL   Regular School No Other PK 12 2020   grade_7 10 0 6   0 0     0   0   9 7             11         16 10 0 6   0 0     0   0   9 7         11       16
852725 ID     school 1600570 432   CAMBRIDGE JOINT DISTRICT 160057000113 193 CAMBRIDGE MIDDLE/HIGH SCHOOL   Regular School No High 06 12 2020   grade_7 10 0 0   0 0     0   0   4 6             *         10 10 0 0   0 0     0   0   4 6                 10
853003 ID     school 1600151 472   PALOUSE PRAIRIE EDUCATIONAL ORGANIZATION, INC. 160015100994 1234 PALOUSE PRAIRIE CHARTER SCHOOL   Regular School Yes Elementary KG 08 2020   grade_7 10 0 0   1 0     0   3   4 10             *         14 10 0 0   1 0     0   3   4 10                 14
1278047 ID     school 1603480 133   WILDER DISTRICT 160348001091 1389 WILDER MIDDLE SCHOOL   Regular School No Middle 06 8.0 2018   grade_7 10 0 39   0 0     1   1   30 21             26         51 10 0 39   0 0     1   1   30 21         26       51
1278189 ID     school 1600600 139   VALLIVUE SCHOOL DISTRICT 160060001016 1295 RIVERVUE MIDDLE SCHOOL   Alternative School No Middle 06 8.0 2018   grade_7 10 0 12   1 0     0   2   20 5             15         25 10 0 12   1 0     0   2   20 5         15       25
1278725 ID     school 1600330 234   BLISS JOINT DISTRICT 160033000040 714 BLISS SCHOOL   Regular School No Other PK 12.0 2018   grade_7 10 0 6   0 0     0   0   7 9             *         16 10 0 6   0 0     0   0   7 9                 16
1279372 ID     school 1601440 305   HIGHLAND JOINT DISTRICT 160144000849 285 HIGHLAND SCHOOL   Regular School No Other PK 12.0 2018   grade_7 10 0 0   2 0     0   0   6 6             6         12 10 0 0   2 0     0   0   6 6         6       12
1280848 ID     school 1602220 813   MOSCOW CHARTER SCHOOL, INC. 160222000749 813 MOSCOW CHARTER SCHOOL   Regular School Yes Elementary KG 8.0 2018   grade_7 10 1 0   0 1     0   2   5 9             *         14 10 1 0   0 1     0   2   5 9                 14
1309533 ID     school 1600170 486   UPPER CARMEN PUBLIC CHARTER SCHOOL, INC. 160017000847 1366 UPPER CARMEN PUBLIC CHARTER SCHOOL   Regular School Yes Elementary PK 8.0 2019   grade_7 10 0 0   0 0     0   0   4 6             *         10 10 0 0   0 0     0   0   4 6                 10
1309704 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 Other PK 12.0 2019   grade_7 10 1 1   1 0     0   0   6 7             8         13 10 1 1   1 0     0   0   6 7         8       13
1682526 ID     school 1600815 44   PLUMMER-WORLEY JOINT DISTRICT 160081500647 128 LAKESIDE JR HIGH SCHOOL   Regular School No 2.0 07 08 2015   grade_7 10 0 4   14 0     0   4   17 15             *         32 10 0 4   14 0     0   4   17 15                 32
1686174 ID     school 1602220 813   MOSCOW CHARTER SCHOOL, INC. 160222000749 813 MOSCOW CHARTER SCHOOL   Regular School Yes 1.0 PK 08 2015   grade_7 10 0 2   0 1     0   3   5 11             5         16 10 0 2   0 1     0   3   5 11         5       16
1727544 ID     school 1602130 134   MIDDLETON DISTRICT 160213000777 1168 MIDDLETON ACADEMY   Alternative School No High 07 12.0 2017   grade_7 10 0 2   0 0     0   0   5 7             *         12 10 0 2   0 0     0   0   5 7                 12
1729642 ID     school 1602310 418   MURTAUGH JOINT DISTRICT 160231001034 1344 MURTAUGH SCHOOLS   Regular School No Other PK 12.0 2017   grade_7 10 0 17   0 0     0   0   7 20             *         27 10 0 17   0 0     0   0   7 20                 27
1821301 ID     school 1602060 11   MEADOWS VALLEY DISTRICT 160206000826 342 MEADOWS VALLEY SCHOOL   Regular School No 4.0 PK 12 2016   grade_7 10 0 1   0 1     0   1   8 5             6         13 10 0 1   0 1     0   1   8 5         6       13
1822551 ID     school 1602130 134   MIDDLETON DISTRICT 160213000777 1168 MIDDLETON ACADEMY   Alternative Education School No 3.0 07 12 2016   grade_7 10 0 3   0 0     0   1   8 6             9         14 10 0 3   0 0     0   1   8 6         9       14
852283 ID     school 1601140 373   FRUITLAND DISTRICT 160114000213 165 FRUITLAND MIDDLE SCHOOL   Regular School No Middle 05 08 2020   grade_7 100 2 32   0 2     0   1   80 57             40         137 100 2 32   0 2     0   1   80 57         40       137
852663 ID     school 1602030 421   MCCALL-DONNELLY JOINT SCHOOL DISTRICT 160203000584 236 PAYETTE LAKES MIDDLE SCHOOL   Regular School No Middle 06 08 2020   grade_7 101 1 13   0 0     0   3   64 54             30         118 101 1 13   0 0     0   3   64 54         30       118
1277112 ID     school 1602970 52   SNAKE RIVER DISTRICT 160297000520 31 SNAKE RIVER JR HIGH SCHOOL   Regular School No Middle 07 8.0 2018   grade_7 101 0 23   1 0     0   3   57 71             48         128 101 0 23   1 0     0   3   57 71         48       128
1279938 ID     school 1603180 401   TETON COUNTY DISTRICT 160318000544 195 TETON MIDDLE SCHOOL   Regular School No Middle 06 8.0 2018   grade_7 101 0 40   1 0     0   2   83 61             45         144 101 0 40   1 0     0   2   83 61         45       144
1682284 ID     school 1601950 21   MARSH VALLEY JOINT DISTRICT 160195000348 18 MARSH VALLEY MIDDLE SCHOOL   Regular School No 2.0 07 08 2015   grade_7 101 0 3   0 0     0   0   46 58             44         104 101 0 3   0 0     0   0   46 58         44       104
1824385 ID     school 1603180 401   TETON COUNTY DISTRICT 160318000544 195 TETON MIDDLE SCHOOL   Regular School No 2.0 06 08 2016   grade_7 101 0 34   0 0     0   3   80 58             58         138 101 0 34   0 0     0   3   80 58         58       138
706310 ID     school 1603090 322   SUGAR-SALEM JOINT DISTRICT 160309000702 226 SUGAR-SALEM JUNIOR HIGH SCHOOL   Regular School No Middle 07 08 2021   grade_7 102 0 12   0 2     1   0   51 66             41         117 102 0 12   0 2     1   0   51 66         41       117
1685483 ID     school 1601050 413   FILER DISTRICT 160105000631 196 FILER MIDDLE SCHOOL   Regular School No 2.0 07 08 2015   grade_7 102 1 15   1 0     1   2   54 68             64         122 102 1 15   1 0     1   2   54 68         64       122
1729560 ID     school 1601050 413   FILER DISTRICT 160105000631 196 FILER MIDDLE SCHOOL   Regular School No Middle 07 8.0 2017   grade_7 102 1 21   1 0     0   1   72 54             56         126 102 1 21   1 0     0   1   72 54         56       126
705346 ID     school 1601110 215   FREMONT COUNTY JOINT DISTRICT 160111000625 98 SOUTH FREMONT JR HIGH   Regular School No Middle 06 08 2021   grade_7 103 0 23   1 0     0   1   63 65             70         128 103 0 23   1 0     0   1   63 65         70       128
707185 ID     school 1600007 455   COMPASS PUBLIC CHARTER SCHOOL, INC. 160000700864 575 COMPASS PUBLIC CHARTER SCHOOL   Regular School Yes Other KG 12 2021   grade_7 103 1 14   0 2     0   4   58 66             14         124 103 1 14   0 2     0   4   58 66         14       124
707014 ID     school 1602030 421   MCCALL-DONNELLY JOINT SCHOOL DISTRICT 160203000584 236 PAYETTE LAKES MIDDLE SCHOOL   Regular School No Middle 06 08 2021   grade_7 104 0 11   1 0     0   1   62 55             14         117 104 0 11   1 0     0   1   62 55         14       117
851045 ID     school 1601110 215   FREMONT COUNTY JOINT DISTRICT 160111000625 98 SOUTH FREMONT JR HIGH   Regular School No Middle 06 08 2020   grade_7 104 0 31   0 0     1   4   63 77             80         140 104 0 31   0 0     1   4   63 77         80       140
1822436 ID     school 1600510 132   CALDWELL DISTRICT 160051000105 64 JEFFERSON MIDDLE SCHOOL   Regular School No 2.0 06 08 2016   grade_7 104 2 119   1 2     0   7   125 110             *         235 104 2 119   1 2     0   7   125 110                 235
1280058 ID     school 1603240 411   TWIN FALLS DISTRICT 160324001093 1393 SOUTH HILLS MIDDLE SCHOOL   Regular School No Middle 06 8.0 2018   grade_7 107 3 76   0 8     1   3   93 105             99         198 107 3 76   0 8     1   3   93 105         99       198
1305668 ID     school 1601770 3   KUNA JOINT DISTRICT 160177000805 850 FREMONT H TEED MIDDLE SCHOOL   Regular School No Middle 06 8.0 2019   grade_7 107 0 15   0 0     0   5   61 66             55         127 107 0 15   0 0     0   5   61 66         55       127
1686057 ID     school 1600173 491   COEUR D'ALENE CHARTER ACADEMY, INC. 160017300765 1370 COEUR D'ALENE CHARTER ACADEMY SCHOOL   Regular School Yes 4.0 06 12 2015   grade_7 107 0 10   1 5     0   7   56 74             *         130 107 0 10   1 5     0   7   56 74                 130

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