Data source: Big Local News · About: Big Local

5,050 rows where state = "ID" and year = 2021 sorted by ccd_school_low_grade

View and edit SQL

grade

year

  • 2021 · 5,050
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
704332 ID     school   92   SWAN VALLEY ELEMENTARY DISTRICT   1014 BORDER DISTRICT - STAR VALLEY ELEMENTARY SCHOOL             2021   grade_3 2 0 0   0 0     0   0   0 2             *         2 2 0 0   0 0     0   0   0 2                 2
704333 ID     school   92   SWAN VALLEY ELEMENTARY DISTRICT   1014 BORDER DISTRICT - STAR VALLEY ELEMENTARY SCHOOL             2021   grade_4 1 0 0   0 0     0   0   1 0             *         1 1 0 0   0 0     0   0   1 0                 1
704334 ID     school   92   SWAN VALLEY ELEMENTARY DISTRICT   1014 BORDER DISTRICT - STAR VALLEY ELEMENTARY SCHOOL             2021   k_12_total 3 0 0   0 0     0   0   1 2             *         3 3 0 0   0 0     0   0   1 2                 3
704335 ID     school   92   SWAN VALLEY ELEMENTARY DISTRICT   1015 BORDER DISTRICT - STAR VALLEY JR-SR HIGH SCHOOL             2021   grade_11 1 0 0   0 0     0   0   0 1             *         1 1 0 0   0 0     0   0   0 1                 1
704336 ID     school   92   SWAN VALLEY ELEMENTARY DISTRICT   1015 BORDER DISTRICT - STAR VALLEY JR-SR HIGH SCHOOL             2021   k_12_total 1 0 0   0 0     0   0   0 1             *         1 1 0 0   0 0     0   0   0 1                 1
705007 ID     school   150   SODA SPRINGS JOINT DISTRICT   1025 BORDER DISTRICT - FREEDOM ELEMENTARY             2021   grade_1 5 0 0   0 0     0   0   3 2             *         5 5 0 0   0 0     0   0   3 2                 5
705008 ID     school   150   SODA SPRINGS JOINT DISTRICT   1025 BORDER DISTRICT - FREEDOM ELEMENTARY             2021   grade_2 2 0 0   0 0     0   0   1 1             *         2 2 0 0   0 0     0   0   1 1                 2
705009 ID     school   150   SODA SPRINGS JOINT DISTRICT   1025 BORDER DISTRICT - FREEDOM ELEMENTARY             2021   grade_3 5 0 0   0 0     0   0   1 4             *         5 5 0 0   0 0     0   0   1 4                 5
705010 ID     school   150   SODA SPRINGS JOINT DISTRICT   1025 BORDER DISTRICT - FREEDOM ELEMENTARY             2021   grade_4 4 0 0   0 0     0   0   0 4             *         4 4 0 0   0 0     0   0   0 4                 4
705011 ID     school   150   SODA SPRINGS JOINT DISTRICT   1025 BORDER DISTRICT - FREEDOM ELEMENTARY             2021   grade_5 1 0 0   0 0     0   0   1 0             *         1 1 0 0   0 0     0   0   1 0                 1
705012 ID     school   150   SODA SPRINGS JOINT DISTRICT   1025 BORDER DISTRICT - FREEDOM ELEMENTARY             2021   grade_6 1 0 0   0 0     0   0   0 1             *         1 1 0 0   0 0     0   0   0 1                 1
705013 ID     school   150   SODA SPRINGS JOINT DISTRICT   1025 BORDER DISTRICT - FREEDOM ELEMENTARY             2021   k_12_total 19 0 0   0 0     0   0   6 13             *         19 19 0 0   0 0     0   0   6 13                 19
705014 ID     school   150   SODA SPRINGS JOINT DISTRICT   1025 BORDER DISTRICT - FREEDOM ELEMENTARY             2021   kindergarten 1 0 0   0 0     0   0   0 1             *         1 1 0 0   0 0     0   0   0 1                 1
705015 ID     school   150   SODA SPRINGS JOINT DISTRICT   1026 BORDER DISTRICT FREEDOM - SECONDARY             2021   grade_10 3 0 1   0 0     0   0   2 2             *         4 3 0 1   0 0     0   0   2 2                 4
705016 ID     school   150   SODA SPRINGS JOINT DISTRICT   1026 BORDER DISTRICT FREEDOM - SECONDARY             2021   grade_11 0 0 2   0 0     0   0   2 0             *         2 0 0 2   0 0     0   0   2 0                 2
705017 ID     school   150   SODA SPRINGS JOINT DISTRICT   1026 BORDER DISTRICT FREEDOM - SECONDARY             2021   grade_12 3 0 1   0 0     0   0   4 0             *         4 3 0 1   0 0     0   0   4 0                 4
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
705019 ID     school   150   SODA SPRINGS JOINT DISTRICT   1026 BORDER DISTRICT FREEDOM - SECONDARY             2021   grade_9 3 0 0   0 0     0   0   2 1             *         3 3 0 0   0 0     0   0   2 1                 3
705020 ID     school   150   SODA SPRINGS JOINT DISTRICT   1026 BORDER DISTRICT FREEDOM - SECONDARY             2021   k_12_total 10 0 5   0 0     0   0   10 5             *         15 10 0 5   0 0     0   0   10 5                 15
706390 ID     school   340   LEWISTON INDEPENDENT DISTRICT   611 NORTHWEST CHILDRENS HOME             2021   grade_10 2 0 1   0 0     0   0   3 0             *         3 2 0 1   0 0     0   0   3 0                 3
706391 ID     school   340   LEWISTON INDEPENDENT DISTRICT   611 NORTHWEST CHILDRENS HOME             2021   grade_11 1 0 0   0 0     0   0   1 0             *         1 1 0 0   0 0     0   0   1 0                 1
706392 ID     school   340   LEWISTON INDEPENDENT DISTRICT   611 NORTHWEST CHILDRENS HOME             2021   grade_12 1 0 0   0 0     0   0   1 0             *         1 1 0 0   0 0     0   0   1 0                 1
706393 ID     school   340   LEWISTON INDEPENDENT DISTRICT   611 NORTHWEST CHILDRENS HOME             2021   grade_3 1 0 0   0 0     0   0   1 0             *         1 1 0 0   0 0     0   0   1 0                 1
706394 ID     school   340   LEWISTON INDEPENDENT DISTRICT   611 NORTHWEST CHILDRENS HOME             2021   grade_4 1 0 0   0 0     0   0   1 0             *         1 1 0 0   0 0     0   0   1 0                 1
706395 ID     school   340   LEWISTON INDEPENDENT DISTRICT   611 NORTHWEST CHILDRENS HOME             2021   grade_5 6 0 0   0 0     0   0   5 1             *         6 6 0 0   0 0     0   0   5 1                 6
706396 ID     school   340   LEWISTON INDEPENDENT DISTRICT   611 NORTHWEST CHILDRENS HOME             2021   grade_6 2 0 0   0 0     0   0   2 0             *         2 2 0 0   0 0     0   0   2 0                 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
706398 ID     school   340   LEWISTON INDEPENDENT DISTRICT   611 NORTHWEST CHILDRENS HOME             2021   grade_8 1 0 0   0 0     0   0   1 0             *         1 1 0 0   0 0     0   0   1 0                 1
706399 ID     school   340   LEWISTON INDEPENDENT DISTRICT   611 NORTHWEST CHILDRENS HOME             2021   grade_9 2 0 0   0 0     0   0   2 0             *         2 2 0 0   0 0     0   0   2 0                 2
706400 ID     school   340   LEWISTON INDEPENDENT DISTRICT   611 NORTHWEST CHILDRENS HOME             2021   k_12_total 20 0 1   0 0     0   0   20 1             *         21 20 0 1   0 0     0   0   20 1                 21
706401 ID     school   340   LEWISTON INDEPENDENT DISTRICT   611 NORTHWEST CHILDRENS HOME             2021   kindergarten 1 0 0   0 0     0   0   1 0             *         1 1 0 0   0 0     0   0   1 0                 1
706486 ID     school   342   CULDESAC JOINT DISTRICT   1373 NORTHWEST CHILDREN'S HOME             2021   grade_6 0 0 0   1 0     0   0   1 0             *         1 0 0 0   1 0     0   0   1 0                 1
706487 ID     school   342   CULDESAC JOINT DISTRICT   1373 NORTHWEST CHILDREN'S HOME             2021   k_12_total 0 0 0   1 0     0   0   1 0             *         1 0 0 0   1 0     0   0   1 0                 1
706544 ID     school   364   PLEASANT VALLEY ELEMENTARY DISTRICT   1056 BORDER DISTRICT - JORDAN VALLEY SECONDARY             2021   grade_11 2 0 0   0 0     0   0   0 2             *         2 2 0 0   0 0     0   0   0 2                 2
706545 ID     school   364   PLEASANT VALLEY ELEMENTARY DISTRICT   1056 BORDER DISTRICT - JORDAN VALLEY SECONDARY             2021   grade_9 1 0 0   0 0     0   0   0 1             *         1 1 0 0   0 0     0   0   0 1                 1
706546 ID     school   364   PLEASANT VALLEY ELEMENTARY DISTRICT   1056 BORDER DISTRICT - JORDAN VALLEY SECONDARY             2021   k_12_total 3 0 0   0 0     0   0   0 3             *         3 3 0 0   0 0     0   0   0 3                 3
703712 ID     school 1602640 25   POCATELLO DISTRICT 160264000186 9034 POCATELLO JUVENILE DETENTION   Alternative School No Other 01 12 2021   grade_10 3 0 1   1 0     0   0   3 2             *         5 3 0 1   1 0     0   0   3 2                 5
703713 ID     school 1602640 25   POCATELLO DISTRICT 160264000186 9034 POCATELLO JUVENILE DETENTION   Alternative School No Other 01 12 2021   grade_11 1 0 0   0 0     0   0   1 0             *         1 1 0 0   0 0     0   0   1 0                 1
703714 ID     school 1602640 25   POCATELLO DISTRICT 160264000186 9034 POCATELLO JUVENILE DETENTION   Alternative School No Other 01 12 2021   grade_12 1 0 0   0 0     0   0   1 0             *         1 1 0 0   0 0     0   0   1 0                 1
703715 ID     school 1602640 25   POCATELLO DISTRICT 160264000186 9034 POCATELLO JUVENILE DETENTION   Alternative School No Other 01 12 2021   grade_9 1 0 0   0 0     0   0   1 0             *         1 1 0 0   0 0     0   0   1 0                 1
703716 ID     school 1602640 25   POCATELLO DISTRICT 160264000186 9034 POCATELLO JUVENILE DETENTION   Alternative School No Other 01 12 2021   k_12_total 6 0 1   1 0     0   0   6 2             *         8 6 0 1   1 0     0   0   6 2                 8
704771 ID     school 1600510 132   CALDWELL DISTRICT 160051000043 1087 SOUTHWEST IDAHO JUVENILE DETENTION   Alternative School No Other 01 12 2021   grade_10 0 0 4   0 0     0   1   4 1             *         5 0 0 4   0 0     0   1   4 1                 5
704772 ID     school 1600510 132   CALDWELL DISTRICT 160051000043 1087 SOUTHWEST IDAHO JUVENILE DETENTION   Alternative School No Other 01 12 2021   grade_11 5 1 2   0 0     0   0   8 0             *         8 5 1 2   0 0     0   0   8 0                 8
704773 ID     school 1600510 132   CALDWELL DISTRICT 160051000043 1087 SOUTHWEST IDAHO JUVENILE DETENTION   Alternative School No Other 01 12 2021   grade_12 4 0 5   0 0     0   0   8 1             *         9 4 0 5   0 0     0   0   8 1                 9
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
704775 ID     school 1600510 132   CALDWELL DISTRICT 160051000043 1087 SOUTHWEST IDAHO JUVENILE DETENTION   Alternative School No Other 01 12 2021   grade_8 0 0 1   0 0     0   0   1 0             *         1 0 0 1   0 0     0   0   1 0                 1
704776 ID     school 1600510 132   CALDWELL DISTRICT 160051000043 1087 SOUTHWEST IDAHO JUVENILE DETENTION   Alternative School No Other 01 12 2021   grade_9 1 0 2   0 0     0   0   2 1             *         3 1 0 2   0 0     0   0   2 1                 3
704777 ID     school 1600510 132   CALDWELL DISTRICT 160051000043 1087 SOUTHWEST IDAHO JUVENILE DETENTION   Alternative School No Other 01 12 2021   k_12_total 11 1 14   0 0     0   1   24 3             8         27 11 1 14   0 0     0   1   24 3         8       27
704962 ID     school 1601290 148   GRACE JOINT DISTRICT 160129000228 462 THATCHER ELEMENTARY SCHOOL   Regular School No Elementary 01 05 2021   grade_1 19 0 0   0 0     0   0   10 9             7         19 19 0 0   0 0     0   0   10 9         7       19
704963 ID     school 1601290 148   GRACE JOINT DISTRICT 160129000228 462 THATCHER ELEMENTARY SCHOOL   Regular School No Elementary 01 05 2021   grade_2 17 0 0   0 0     0   0   8 9             *         17 17 0 0   0 0     0   0   8 9                 17
704964 ID     school 1601290 148   GRACE JOINT DISTRICT 160129000228 462 THATCHER ELEMENTARY SCHOOL   Regular School No Elementary 01 05 2021   grade_3 17 0 0   0 0     0   0   11 6             11         17 17 0 0   0 0     0   0   11 6         11       17
704965 ID     school 1601290 148   GRACE JOINT DISTRICT 160129000228 462 THATCHER ELEMENTARY SCHOOL   Regular School No Elementary 01 05 2021   grade_4 14 0 0   0 0     0   0   7 7             *         14 14 0 0   0 0     0   0   7 7                 14
704966 ID     school 1601290 148   GRACE JOINT DISTRICT 160129000228 462 THATCHER ELEMENTARY SCHOOL   Regular School No Elementary 01 05 2021   k_12_total 67 0 0   0 0     0   0   36 31             37         67 67 0 0   0 0     0   0   36 31         37       67
706859 ID     school 1603240 411   TWIN FALLS DISTRICT 160324000739 1260 SNAKE RIVER JUVENILE DETENTION   Alternative School No Other 01 12 2021   grade_10 2 0 0   0 0     0   0   1 1             *         2 2 0 0   0 0     0   0   1 1                 2
706860 ID     school 1603240 411   TWIN FALLS DISTRICT 160324000739 1260 SNAKE RIVER JUVENILE DETENTION   Alternative School No Other 01 12 2021   grade_11 1 0 1   0 0     0   0   2 0             *         2 1 0 1   0 0     0   0   2 0                 2
706861 ID     school 1603240 411   TWIN FALLS DISTRICT 160324000739 1260 SNAKE RIVER JUVENILE DETENTION   Alternative School No Other 01 12 2021   grade_12 0 1 0   0 0     0   0   1 0             *         1 0 1 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
706863 ID     school 1603240 411   TWIN FALLS DISTRICT 160324000739 1260 SNAKE RIVER JUVENILE DETENTION   Alternative School No Other 01 12 2021   grade_9 0 0 1   0 0     0   0   1 0             *         1 0 0 1   0 0     0   0   1 0                 1
706864 ID     school 1603240 411   TWIN FALLS DISTRICT 160324000739 1260 SNAKE RIVER JUVENILE DETENTION   Alternative School No Other 01 12 2021   k_12_total 4 1 2   0 0     0   0   6 1             *         7 4 1 2   0 0     0   0   6 1                 7
703814 ID     school 1602970 52   SNAKE RIVER DISTRICT 160297000518 376 RIVERSIDE ELEMENTARY SCHOOL   Regular School No Elementary 02 03 2021   grade_2 94 0 14   1 1     0   0   57 53             *         110 94 0 14   1 1     0   0   57 53                 110
703815 ID     school 1602970 52   SNAKE RIVER DISTRICT 160297000518 376 RIVERSIDE ELEMENTARY SCHOOL   Regular School No Elementary 02 03 2021   grade_3 117 0 16   0 0     0   0   67 66             *         133 117 0 16   0 0     0   0   67 66                 133
703816 ID     school 1602970 52   SNAKE RIVER DISTRICT 160297000518 376 RIVERSIDE ELEMENTARY SCHOOL   Regular School No Elementary 02 03 2021   k_12_total 211 0 30   1 1     0   0   124 119             80         243 211 0 30   1 1     0   0   124 119         80       243
705727 ID     school 1601590 261   JEROME JOINT DISTRICT 160159000972 2516 SUMMIT ELEMENTARY   Regular School No Elementary 02 05 2021   grade_2 1 0 1   0 0     0   0   2 0             *         2 1 0 1   0 0     0   0   2 0                 2
705728 ID     school 1601590 261   JEROME JOINT DISTRICT 160159000972 2516 SUMMIT ELEMENTARY   Regular School No Elementary 02 05 2021   grade_3 0 0 1   1 0     0   0   2 0             *         2 0 0 1   1 0     0   0   2 0                 2
705729 ID     school 1601590 261   JEROME JOINT DISTRICT 160159000972 2516 SUMMIT ELEMENTARY   Regular School No Elementary 02 05 2021   grade_4 122 0 173   0 2     0   3   156 144             *         300 122 0 173   0 2     0   3   156 144                 300
705730 ID     school 1601590 261   JEROME JOINT DISTRICT 160159000972 2516 SUMMIT ELEMENTARY   Regular School No Elementary 02 05 2021   grade_5 130 0 165   1 1     1   2   152 148             *         300 130 0 165   1 1     1   2   152 148                 300
705731 ID     school 1601590 261   JEROME JOINT DISTRICT 160159000972 2516 SUMMIT ELEMENTARY   Regular School No Elementary 02 05 2021   k_12_total 253 0 340   2 3     1   5   312 292             307         604 253 0 340   2 3     1   5   312 292         307       604
703952 ID     school 1602910 60   SHELLEY JOINT DISTRICT 160291001012 1251 RIVERVIEW ELEMENTARY SCHOOL   Regular School No Elementary 03 04 2021   grade_3 157 1 17   0 1     0   0   88 88             64         176 157 1 17   0 1     0   0   88 88         64       176
703953 ID     school 1602910 60   SHELLEY JOINT DISTRICT 160291001012 1251 RIVERVIEW ELEMENTARY SCHOOL   Regular School No Elementary 03 04 2021   grade_4 150 1 21   1 2     0   0   98 77             58         175 150 1 21   1 2     0   0   98 77         58       175
703954 ID     school 1602910 60   SHELLEY JOINT DISTRICT 160291001012 1251 RIVERVIEW ELEMENTARY SCHOOL   Regular School No Elementary 03 04 2021   k_12_total 307 2 38   1 3     0   0   186 165             122         351 307 2 38   1 3     0   0   186 165         122       351
705317 ID     school 1600960 201   PRESTON JOINT DISTRICT 160096000181 497 OAKWOOD ELEMENTARY SCHOOL   Regular School No Elementary 03 05 2021   grade_3 140 1 8   2 0     0   1   80 72             53         152 140 1 8   2 0     0   1   80 72         53       152
705318 ID     school 1600960 201   PRESTON JOINT DISTRICT 160096000181 497 OAKWOOD ELEMENTARY SCHOOL   Regular School No Elementary 03 05 2021   grade_4 146 1 24   2 0     0   2   87 88             61         175 146 1 24   2 0     0   2   87 88         61       175
705319 ID     school 1600960 201   PRESTON JOINT DISTRICT 160096000181 497 OAKWOOD ELEMENTARY SCHOOL   Regular School No Elementary 03 05 2021   grade_5 147 0 21   2 0     0   1   90 81             53         171 147 0 21   2 0     0   1   90 81         53       171
705320 ID     school 1600960 201   PRESTON JOINT DISTRICT 160096000181 497 OAKWOOD ELEMENTARY SCHOOL   Regular School No Elementary 03 05 2021   k_12_total 433 2 53   6 0     0   4   257 241             167         498 433 2 53   6 0     0   4   257 241         167       498
706019 ID     school 1602220 281   MOSCOW DISTRICT 160222000391 753 J RUSSELL ELEMENTARY SCHOOL   Regular School No Elementary 03 05 2021   grade_3 36 0 3   1 2     0   7   20 29             22         49 36 0 3   1 2     0   7   20 29         22       49
706020 ID     school 1602220 281   MOSCOW DISTRICT 160222000391 753 J RUSSELL ELEMENTARY SCHOOL   Regular School No Elementary 03 05 2021   grade_4 40 2 4   0 4     0   1   21 30             27         51 40 2 4   0 4     0   1   21 30         27       51
706021 ID     school 1602220 281   MOSCOW DISTRICT 160222000391 753 J RUSSELL ELEMENTARY SCHOOL   Regular School No Elementary 03 05 2021   grade_5 40 2 3   2 1     0   6   25 29             *         54 40 2 3   2 1     0   6   25 29                 54
706022 ID     school 1602220 281   MOSCOW DISTRICT 160222000391 753 J RUSSELL ELEMENTARY SCHOOL   Regular School No Elementary 03 05 2021   k_12_total 116 4 10   3 7     0   14   66 88             *         154 116 4 10   3 7     0   14   66 88                 154
706372 ID     school 1602190 331   MINIDOKA COUNTY JOINT DISTRICT 160219000166 1100 MINI-CASSIA JUVENILE DETENTION CENTER   Alternative School No Other 03 12 2021   grade_10 1 0 0   0 0     0   0   1 0             *         1 1 0 0   0 0     0   0   1 0                 1
706373 ID     school 1602190 331   MINIDOKA COUNTY JOINT DISTRICT 160219000166 1100 MINI-CASSIA JUVENILE DETENTION CENTER   Alternative School No Other 03 12 2021   grade_11 0 0 2   0 0     0   0   1 1             *         2 0 0 2   0 0     0   0   1 1                 2
706374 ID     school 1602190 331   MINIDOKA COUNTY JOINT DISTRICT 160219000166 1100 MINI-CASSIA JUVENILE DETENTION CENTER   Alternative School No Other 03 12 2021   grade_12 1 0 1   0 0     0   0   0 2             *         2 1 0 1   0 0     0   0   0 2                 2
706375 ID     school 1602190 331   MINIDOKA COUNTY JOINT DISTRICT 160219000166 1100 MINI-CASSIA JUVENILE DETENTION CENTER   Alternative School No Other 03 12 2021   grade_8 0 0 2   0 0     0   0   2 0             *         2 0 0 2   0 0     0   0   2 0                 2
706376 ID     school 1602190 331   MINIDOKA COUNTY JOINT DISTRICT 160219000166 1100 MINI-CASSIA JUVENILE DETENTION CENTER   Alternative School No Other 03 12 2021   k_12_total 2 0 5   0 0     0   0   4 3             *         7 2 0 5   0 0     0   0   4 3                 7
706455 ID     school 1601860 340   LEWISTON INDEPENDENT DISTRICT 160186000170 1266 REGION 2 JUVENILE DETENTION CENTER   Alternative School No Other 03 12 2021   grade_10 1 0 1   0 0     0   0   2 0             *         2 1 0 1   0 0     0   0   2 0                 2
706456 ID     school 1601860 340   LEWISTON INDEPENDENT DISTRICT 160186000170 1266 REGION 2 JUVENILE DETENTION CENTER   Alternative School No Other 03 12 2021   k_12_total 1 0 1   0 0     0   0   2 0             *         2 1 0 1   0 0     0   0   2 0                 2
706667 ID     school 1600060 381   AMERICAN FALLS JOINT DISTRICT 160006000816 849 J.R. SIMPLOT ELEMENTARY SCHOOL   Regular School No Elementary 03 05 2021   grade_3 49 1 59   1 0     0   1   53 58             76         111 49 1 59   1 0     0   1   53 58         76       111
706668 ID     school 1600060 381   AMERICAN FALLS JOINT DISTRICT 160006000816 849 J.R. SIMPLOT ELEMENTARY SCHOOL   Regular School No Elementary 03 05 2021   grade_4 48 0 55   5 0     0   0   51 57             *         108 48 0 55   5 0     0   0   51 57                 108
706669 ID     school 1600060 381   AMERICAN FALLS JOINT DISTRICT 160006000816 849 J.R. SIMPLOT ELEMENTARY SCHOOL   Regular School No Elementary 03 05 2021   grade_5 67 0 52   1 0     0   1   60 61             74         121 67 0 52   1 0     0   1   60 61         74       121
706670 ID     school 1600060 381   AMERICAN FALLS JOINT DISTRICT 160006000816 849 J.R. SIMPLOT ELEMENTARY SCHOOL   Regular School No Elementary 03 05 2021   k_12_total 164 1 166   7 0     0   2   164 176             *         340 164 1 166   7 0     0   2   164 176                 340
703028 ID     school 1600360 1   BOISE INDEPENDENT DISTRICT 160036000823 573 TREASURE VALLEY MATH/SCIENCE   Regular School No Other 04 12 2021   grade_10 5 0 1   0 1     0   0   5 2             *         7 5 0 1   0 1     0   0   5 2                 7
703029 ID     school 1600360 1   BOISE INDEPENDENT DISTRICT 160036000823 573 TREASURE VALLEY MATH/SCIENCE   Regular School No Other 04 12 2021   grade_11 4 0 0   0 0     0   0   3 1             *         4 4 0 0   0 0     0   0   3 1                 4
703030 ID     school 1600360 1   BOISE INDEPENDENT DISTRICT 160036000823 573 TREASURE VALLEY MATH/SCIENCE   Regular School No Other 04 12 2021   grade_12 4 0 0   0 1     0   0   4 1             *         5 4 0 0   0 1     0   0   4 1                 5
703031 ID     school 1600360 1   BOISE INDEPENDENT DISTRICT 160036000823 573 TREASURE VALLEY MATH/SCIENCE   Regular School No Other 04 12 2021   grade_5 2 0 0   0 0     0   0   2 0             *         2 2 0 0   0 0     0   0   2 0                 2
703032 ID     school 1600360 1   BOISE INDEPENDENT DISTRICT 160036000823 573 TREASURE VALLEY MATH/SCIENCE   Regular School No Other 04 12 2021   grade_6 11 0 1   0 0     0   0   10 2             *         12 11 0 1   0 0     0   0   10 2                 12
703033 ID     school 1600360 1   BOISE INDEPENDENT DISTRICT 160036000823 573 TREASURE VALLEY MATH/SCIENCE   Regular School No Other 04 12 2021   grade_7 19 0 0   0 1     0   0   9 11             *         20 19 0 0   0 1     0   0   9 11                 20
703034 ID     school 1600360 1   BOISE INDEPENDENT DISTRICT 160036000823 573 TREASURE VALLEY MATH/SCIENCE   Regular School No Other 04 12 2021   grade_8 10 1 1   0 5     0   1   9 9             *         18 10 1 1   0 5     0   1   9 9                 18
703035 ID     school 1600360 1   BOISE INDEPENDENT DISTRICT 160036000823 573 TREASURE VALLEY MATH/SCIENCE   Regular School No Other 04 12 2021   grade_9 10 0 0   0 0     0   1   7 4             *         11 10 0 0   0 0     0   1   7 4                 11
703036 ID     school 1600360 1   BOISE INDEPENDENT DISTRICT 160036000823 573 TREASURE VALLEY MATH/SCIENCE   Regular School No Other 04 12 2021   k_12_total 65 1 3   0 8     0   2   49 30             *         79 65 1 3   0 8     0   2   49 30                 79
703482 ID     school 1601770 3   KUNA JOINT DISTRICT 160177000915 635 ROSS ELEMENTARY SCHOOL   Regular School No Elementary 04 05 2021   grade_4 109 0 12   0 1     0   2   60 64             36         124 109 0 12   0 1     0   2   60 64         36       124
703483 ID     school 1601770 3   KUNA JOINT DISTRICT 160177000915 635 ROSS ELEMENTARY SCHOOL   Regular School No Elementary 04 05 2021   grade_5 98 1 14   1 1     0   3   74 44             45         118 98 1 14   1 1     0   3   74 44         45       118

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