Data source: Big Local News · About: Big Local

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

View and edit SQL

year

grade

  • grade_7 · 1,522
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 ▼
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
1822803 ID     school 1600660 151   CASSIA COUNTY JOINT DISTRICT 160066000540 990 CASSIA JR/SR HIGH SCHOOL   Alternative Education School No 3.0 07 12 2016   grade_7 0 0 1   0 0     0   0   0 1             *         1 0 0 1   0 0     0   0   0 1                 1
1822889 ID     school 1600720 181   CHALLIS JOINT DISTRICT 160072000143 486 STANLEY ELEM/JR HIGH SCHOOL   Regular School No 1.0 KG 08 2016   grade_7 0 0 1   0 0     0   0   0 1             *         1 0 0 1   0 0     0   0   0 1                 1
1822922 ID     school 1602730 191   PRAIRIE ELEMENTARY DISTRICT 160273000496 491 PRAIRIE ELEM/JR HIGH SCHOOL   Regular School No 1.0 KG 08 2016   grade_7 0 0 1   0 0     0   0   1 0             *         1 0 0 1   0 0     0   0   1 0                 1
1823997 ID     school 1602190 331   MINIDOKA COUNTY JOINT DISTRICT 160219000166 1100 MINI-CASSIA JUVENILE DETENTION CENTER   Alternative Education School No 4.0 03 12 2016   grade_7 0 0 1   0 0     0   0   1 0             *         1 0 0 1   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
1825142 ID     school 1600152 555   CANYON-OWYHEE SCHOOL SERVICE AGENCY (COSSA) 160015200304 1291 COSSA ACADEMY   Alternative Education School No 3.0 07 12 2016   grade_7 0 0 1   0 0     0   0   0 1             *         1 0 0 1   0 0     0   0   0 1                 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
705242 ID     school 1602730 191   PRAIRIE ELEMENTARY DISTRICT 160273000496 491 PRAIRIE ELEM/JR HIGH SCHOOL   Regular School No Elementary KG 08 2021   grade_7 2 0 0   0 0     0   0   1 1             *         2 2 0 0   0 0     0   0   1 1                 2
706397 ID     school   340   LEWISTON INDEPENDENT DISTRICT   611 NORTHWEST CHILDRENS HOME             2021   grade_7 2 0 0   0 0     0   0   2 0             *         2 2 0 0   0 0     0   0   2 0                 2
848863 ID     school 1600360 1   BOISE INDEPENDENT DISTRICT 160036000984 675 FRANK CHURCH HIGH SCHOOL   Alternative School No High 06 12 2020   grade_7 2 0 0   0 0     0   0   2 0             *         2 2 0 0   0 0     0   0   2 0                 2
849181 ID     school 1602100 2   JOINT SCHOOL DISTRICT NO. 2 160210001025 1297 REBOUND SCHOOL OF OPPORTUNITY   Alternative School No High 06 12 2020   grade_7 2 0 0   0 0     0   0   2 0             *         2 2 0 0   0 0     0   0   2 0                 2
850490 ID     school 1600510 132   CALDWELL DISTRICT 160051000041 1090 CANYON SPRINGS HIGH SCHOOL   Alternative School No High 06 12 2020   grade_7 0 0 2   0 0     0   0   1 1             *         2 0 0 2   0 0     0   0   1 1                 2
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
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
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
1279033 ID     school 1600780 271   COEUR D'ALENE DISTRICT 160078000704 1038 CDA JUVENILE DETENTION CENTER   Alternative School No Other 04 12.0 2018   grade_7 2 0 0   0 0     0   0   2 0             *         2 2 0 0   0 0     0   0   2 0                 2
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
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
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
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
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
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
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
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
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
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
1727654 ID     school 1600600 139   VALLIVUE SCHOOL DISTRICT 160060001011 1296 VALLIVUE VIRTUAL ACADEMY   Regular School No Other PK 12.0 2017   grade_7 0 0 2   0 0     0   0   1 1             *         2 0 0 2   0 0     0   0   1 1                 2
1727726 ID     school   150   SODA SPRINGS JOINT DISTRICT   1026 BORDER DISTRICT FREEDOM - SECONDARY             2017   grade_7 0 0 2   0 0     0   0   2 0             *         2 0 0 2   0 0     0   0   2 0                 2
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
1728377 ID     school 1601590 261   JEROME JOINT DISTRICT 160159000097 1272 FALLS CITY ACADEMY   Alternative School No Other 06 12.0 2017   grade_7 0 0 2   0 0     0   0   2 0             *         2 0 0 2   0 0     0   0   2 0                 2
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
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
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
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
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
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
706660 ID     school 1600060 381   AMERICAN FALLS JOINT DISTRICT 160006000768 261 AMERICAN FALLS ACADEMY   Alternative School No High 06 12 2021   grade_7 0 1 2   0 0     0   0   2 1             *         3 0 1 2   0 0     0   0   2 1                 3
851135 ID     school 1601020 221   EMMETT INDEPENDENT DISTRICT 160102000923 1111 THE PATRIOT CENTER   Alternative School No High 06 12 2020   grade_7 2 0 0   1 0     0   0   3 0             *         3 2 0 0   1 0     0   0   3 0                 3
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
852403 ID     school 1600150 394   AVERY SCHOOL DISTRICT 160015001010 820 CALDER SCHOOL   Regular School No Elementary KG 08 2020   grade_7 3 0 0   0 0     0   0   3 0             *         3 3 0 0   0 0     0   0   3 0                 3
852753 ID     school 1602160 433   MIDVALE DISTRICT 160216000939 1113 MIDVALE ALTERNATIVE SCHOOL   Alternative School No High 07 12 2020   grade_7 3 0 0   0 0     0   0   2 1             *         3 3 0 0   0 0     0   0   2 1                 3
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
1278083 ID     school 1602130 134   MIDDLETON DISTRICT 160213000777 1168 MIDDLETON ACADEMY   Alternative School No High 07 12.0 2018   grade_7 2 0 1   0 0     0   0   2 1             *         3 2 0 1   0 0     0   0   2 1                 3
1278359 ID     school 1600660 151   CASSIA COUNTY JOINT DISTRICT 160066000540 990 CASSIA JR/SR HIGH SCHOOL   Alternative School No High 07 12.0 2018   grade_7 2 0 1   0 0     0   0   1 2             *         3 2 0 1   0 0     0   0   1 2                 3
1278911 ID     school 1601590 261   JEROME JOINT DISTRICT 160159000097 1272 FALLS CITY ACADEMY   Alternative School No High 06 12.0 2018   grade_7 2 0 1   0 0     0   0   3 0             *         3 2 0 1   0 0     0   0   3 0                 3
1280500 ID     school 1600148 469   IDAHO VIRTUAL EDUCATION PARTNERS, INC. 160014801023 1303 IDAHO CONNECTS ONLINE ALTERNATIVE SCHOOL   Alternative School Yes High 06 12.0 2018   grade_7 2 0 0   0 0     0   1   1 2             *         3 2 0 0   0 0     0   1   1 2                 3
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
1307225 ID     school 1600660 151   CASSIA COUNTY JOINT DISTRICT 160066000540 990 CASSIA JR/SR HIGH SCHOOL   Alternative School No High 07 12.0 2019   grade_7 3 0 0   0 0     0   0   0 3             *         3 3 0 0   0 0     0   0   0 3                 3
1308709 ID     school 1600060 381   AMERICAN FALLS JOINT DISTRICT 160006000768 261 AMERICAN FALLS ACADEMY   Alternative School No High 06 12.0 2019   grade_7 0 0 3   0 0     0   0   3 0             *         3 0 0 3   0 0     0   0   3 0                 3
1309519 ID     school 1600163 483   CHIEF TAHGEE ELEMENTARY ACADEMY, INC. 160016301040 1347 CHIEF TAHGEE ELEMENTARY ACADEMY   Regular School Yes Elementary KG 7.0 2019   grade_7 0 0 0   3 0     0   0   2 1             *         3 0 0 0   3 0     0   0   2 1                 3
1681848 ID     school 1600360 1   BOISE INDEPENDENT DISTRICT 160036000984 675 FRANK CHURCH HIGH SCHOOL   Alternative Education School No 3.0 07 12 2015   grade_7 2 0 0   0 0     0   1   3 0             *         3 2 0 0   0 0     0   1   3 0                 3
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
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
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
1728936 ID     school 1601920 321   MADISON DISTRICT 160192000296 9015 CENTRAL HIGH SCHOOL   Alternative School No Other 06 12.0 2017   grade_7 2 0 1   0 0     0   0   2 1             *         3 2 0 1   0 0     0   0   2 1                 3
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
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
1825169 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 2016   grade_7 2 0 1   0 0     0   0   2 1             *         3 2 0 1   0 0     0   0   2 1                 3
706481 ID     school 1600870 342   CULDESAC JOINT DISTRICT 160087000164 795 CULDESAC SCHOOL   Regular School No Other PK 12 2021   grade_7 2 0 0   2 0     0   0   2 2             *         4 2 0 0   2 0     0   0   2 2                 4
852988 ID     school 1600148 469   IDAHO VIRTUAL EDUCATION PARTNERS, INC. 160014801023 1303 IDAHO CONNECTS ONLINE ALTERNATIVE SCHOOL   Alternative School Yes High 06 12 2020   grade_7 3 0 1   0 0     0   0   3 1             *         4 3 0 1   0 0     0   0   3 1                 4
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
1279578 ID     school 1601860 340   LEWISTON INDEPENDENT DISTRICT 160186000929 611 NORTHWEST CHILDRENS HOME   Special Education School No Other PK 12.0 2018   grade_7 3 0 1   0 0     0   0   4 0             *         4 3 0 1   0 0     0   0   4 0                 4
1280067 ID     school 1603240 411   TWIN FALLS DISTRICT 160324001105 1402 TWIN FALLS VIRTUAL SCHOOLHOUSE   Regular School No Elementary PK 8.0 2018   grade_7 4 0 0   0 0     0   0   1 3             *         4 4 0 0   0 0     0   0   1 3                 4
1306451 ID     school 1603120 92   SWAN VALLEY ELEMENTARY DISTRICT 160312000541 424 SWAN VALLEY ELEMENTARY SCHOOL   Regular School No Elementary PK 8.0 2019   grade_7 4 0 0   0 0     0   0   3 1             *         4 4 0 0   0 0     0   0   3 1                 4
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
1686098 ID     school 1600152 555   CANYON-OWYHEE SCHOOL SERVICE AGENCY (COSSA) 160015200304 1291 COSSA ACADEMY   Alternative Education School No 3.0 07 12 2015   grade_7 3 0 1   0 0     0   0   4 0             *         4 3 0 1   0 0     0   0   4 0                 4
1730233 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 2017   grade_7 2 0 2   0 0     0   0   2 2             *         4 2 0 2   0 0     0   0   2 2                 4
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
703704 ID     school 1602640 25   POCATELLO DISTRICT 160264000686 1002 KINPORT MIDDLE SCHOOL   Alternative School No Middle 06 08 2021   grade_7 5 0 0   0 0     0   0   4 1             *         5 5 0 0   0 0     0   0   4 1                 5
705504 ID     school 1601380 233   HAGERMAN JOINT DISTRICT 160138001143 1456 HAGERMAN VIRTUAL SCHOOL   Regular School No Elementary KG 08 2021   grade_7 5 0 0   0 0     0   0   3 2             *         5 5 0 0   0 0     0   0   3 2                 5
705548 ID     school 1600138 243   SALMON RIVER JOINT SCHOOL DISTRICT 160013800944 1281 SALMON RIVER JR/SR HIGH SCHOOL   Regular School No High 06 12 2021   grade_7 5 0 0   0 0     0   0   2 3             *         5 5 0 0   0 0     0   0   2 3                 5
706749 ID     school 1600150 394   AVERY SCHOOL DISTRICT 160015001010 820 CALDER SCHOOL   Regular School No Elementary KG 08 2021   grade_7 5 0 0   0 0     0   0   2 3             *         5 5 0 0   0 0     0   0   2 3                 5
850050 ID     school 1603120 92   SWAN VALLEY ELEMENTARY DISTRICT 160312000541 424 SWAN VALLEY ELEMENTARY SCHOOL   Regular School No Elementary PK 08 2020   grade_7 5 0 0   0 0     0   0   2 3             *         5 5 0 0   0 0     0   0   2 3                 5
851230 ID     school 1600138 243   SALMON RIVER JOINT SCHOOL DISTRICT 160013800944 1281 SALMON RIVER JR/SR HIGH SCHOOL   Regular School No High 06 12 2020   grade_7 5 0 0   0 0     0   0   3 2             *         5 5 0 0   0 0     0   0   3 2                 5
853129 ID     school 1600163 483   CHIEF TAHGEE ELEMENTARY ACADEMY, INC. 160016301040 1347 CHIEF TAHGEE ELEMENTARY ACADEMY   Regular School Yes Elementary KG 07 2020   grade_7 0 0 1   4 0     0   0   3 2             *         5 0 0 1   4 0     0   0   3 2                 5
1308539 ID     school 1600870 342   CULDESAC JOINT DISTRICT 160087000164 795 CULDESAC SCHOOL   Regular School No Other PK 12.0 2019   grade_7 4 0 0   0 0     0   1   3 2             *         5 4 0 0   0 0     0   1   3 2                 5
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
1685245 ID     school 1600060 381   AMERICAN FALLS JOINT DISTRICT 160006000768 261 AMERICAN FALLS ACADEMY   Alternative Education School No 3.0 07 12 2015   grade_7 3 0 2   0 0     0   0   5 0             *         5 3 0 2   0 0     0   0   5 0                 5
1726486 ID     school 1602640 25   POCATELLO DISTRICT 160264000686 1002 KINPORT MIDDLE SCHOOL   Alternative School No Middle 06 8.0 2017   grade_7 4 0 1   0 0     0   0   4 1             *         5 4 0 1   0 0     0   0   4 1                 5
1823114 ID     school 1601020 221   EMMETT INDEPENDENT DISTRICT 160102000923 1111 THE PATRIOT CENTER   Alternative Education School No 3.0 07 12 2016   grade_7 3 1 1   0 0     0   0   5 0             *         5 3 1 1   0 0     0   0   5 0                 5
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
706368 ID     school 1602190 331   MINIDOKA COUNTY JOINT DISTRICT 160219000158 1046 MT HARRISON JR/SR HIGH   Alternative School No High 06 12 2021   grade_7 4 0 1   0 0     0   1   5 1             *         6 4 0 1   0 0     0   1   5 1                 6
707719 ID     school 1600152 555   CANYON-OWYHEE SCHOOL SERVICE AGENCY (COSSA) 160015200304 1291 COSSA ACADEMY   Alternative School No High 07 12 2021   grade_7 5 0 1   0 0     0   0   4 2             *         6 5 0 1   0 0     0   0   4 2                 6
1277598 ID     school 1603120 92   SWAN VALLEY ELEMENTARY DISTRICT 160312000541 424 SWAN VALLEY ELEMENTARY SCHOOL   Regular School No Elementary PK 8.0 2018   grade_7 4 1 1   0 0     0   0   3 3             *         6 4 1 1   0 0     0   0   3 3                 6
1279173 ID     school 1601740 274   KOOTENAI DISTRICT 160174000303 127 KOOTENAI JR/SR HIGH SCHOOL   Regular School No High 06 12.0 2018   grade_7 6 0 0   0 0     0   0   2 4             *         6 6 0 0   0 0     0   0   2 4                 6
1279321 ID     school 1603030 292   SOUTH LEMHI DISTRICT 160303000528 137 LEADORE SCHOOL   Regular School No Other PK 12.0 2018   grade_7 5 0 0   0 1     0   0   2 4             *         6 5 0 0   0 1     0   0   2 4                 6
1279475 ID     school 1601920 321   MADISON DISTRICT 160192000296 9015 CENTRAL HIGH SCHOOL   Alternative School No High 06 12.0 2018   grade_7 4 0 2   0 0     0   0   4 2             *         6 4 0 2   0 0     0   0   4 2                 6
1279839 ID     school 1600060 381   AMERICAN FALLS JOINT DISTRICT 160006000768 261 AMERICAN FALLS ACADEMY   Alternative School No High 06 12.0 2018   grade_7 4 0 2   0 0     0   0   4 2             *         6 4 0 2   0 0     0   0   4 2                 6
1280268 ID     school 1602160 433   MIDVALE DISTRICT 160216000857 286 MIDVALE SCHOOL   Regular School No Other PK 12.0 2018   grade_7 5 0 1   0 0     0   0   0 6             *         6 5 0 1   0 0     0   0   0 6                 6
1305882 ID     school 1602640 25   POCATELLO DISTRICT 160264000686 1002 KINPORT MIDDLE SCHOOL   Alternative School No Middle 06 8.0 2019   grade_7 2 0 2   2 0     0   0   6 0             *         6 2 0 2   2 0     0   0   6 0                 6
1306560 ID     school 1600930 93   BONNEVILLE JOINT DISTRICT 160093000999 1238 BONNEVILLE ONLINE ELEMENTARY   Regular School No Elementary PK 8.0 2019   grade_7 5 0 0   0 0     0   1   2 4             *         6 5 0 0   0 0     0   1   2 4                 6
1306888 ID     school 1600510 132   CALDWELL DISTRICT 160051000041 1090 CANYON SPRINGS HIGH SCHOOL   Alternative School No High 06 12.0 2019   grade_7 2 0 4   0 0     0   0   4 2             *         6 2 0 4   0 0     0   0   4 2                 6
1309368 ID     school 1600148 469   IDAHO VIRTUAL EDUCATION PARTNERS, INC. 160014800993 1221 IDAHO CONNECTS ONLINE SCHOOL   Regular School Yes High 06 12.0 2019   grade_7 3 0 2   0 0     0   1   3 3             *         6 3 0 2   0 0     0   1   3 3                 6

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