Data source: Big Local News · About: Big Local

4,856 rows where state = "ID" and year = 2020 sorted by hispanic_int

View and edit SQL

grade

year

  • 2020 · 4,756
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
849836 ID     school 1600002 84   LAKE PEND OREILLE SCHOOL DISTRICT 160000200082 49 CLARK FORK JR/SR HIGH SCHOOL   Regular School No High 07 12 2020   grade_10 18 0 0   1 0     0   0   12 7             12         19 18 0 0   1 0     0   0   12 7         12       19
849840 ID     school 1600002 84   LAKE PEND OREILLE SCHOOL DISTRICT 160000200082 49 CLARK FORK JR/SR HIGH SCHOOL   Regular School No High 07 12 2020   grade_8 26 0 0   1 0     0   0   16 11             *         27 26 0 0   1 0     0   0   16 11                 27
849856 ID     school 1600002 84   LAKE PEND OREILLE SCHOOL DISTRICT 160000200614 401 HOPE ELEMENTARY SCHOOL   Regular School No Elementary PK 06 2020   grade_1 12 0 0   0 0     1   0   7 6             *         13 12 0 0   0 0     1   0   7 6                 13
849857 ID     school 1600002 84   LAKE PEND OREILLE SCHOOL DISTRICT 160000200614 401 HOPE ELEMENTARY SCHOOL   Regular School No Elementary PK 06 2020   grade_2 14 0 0   0 0     0   0   5 9             *         14 14 0 0   0 0     0   0   5 9                 14
849858 ID     school 1600002 84   LAKE PEND OREILLE SCHOOL DISTRICT 160000200614 401 HOPE ELEMENTARY SCHOOL   Regular School No Elementary PK 06 2020   grade_3 18 0 0   0 0     1   0   13 6             11         19 18 0 0   0 0     1   0   13 6         11       19
849859 ID     school 1600002 84   LAKE PEND OREILLE SCHOOL DISTRICT 160000200614 401 HOPE ELEMENTARY SCHOOL   Regular School No Elementary PK 06 2020   grade_4 8 0 0   0 0     0   1   4 5             *         9 8 0 0   0 0     0   1   4 5                 9
849863 ID     school 1600002 84   LAKE PEND OREILLE SCHOOL DISTRICT 160000200614 401 HOPE ELEMENTARY SCHOOL   Regular School No Elementary PK 06 2020   kindergarten 9 0 0   0 0     0   1   6 4             *         10 9 0 0   0 0     0   1   6 4                 10
849871 ID     school 1600002 84   LAKE PEND OREILLE SCHOOL DISTRICT 160000200618 402 SAGLE ELEMENTARY SCHOOL   Regular School No Elementary PK 06 2020   kindergarten 33 0 0   0 0     0   1   11 23             7         34 33 0 0   0 0     0   1   11 23         7       34
849887 ID     school 1600002 84   LAKE PEND OREILLE SCHOOL DISTRICT 160000200616 405 SOUTHSIDE ELEMENTARY SCHOOL   Regular School No Elementary PK 06 2020   kindergarten 21 2 0   0 0     0   0   14 9             *         23 21 2 0   0 0     0   0   14 9                 23
849895 ID     school 1600002 84   LAKE PEND OREILLE SCHOOL DISTRICT 160000200617 408 WASHINGTON ELEMENTARY SCHOOL   Regular School No Elementary PK 06 2020   kindergarten 26 0 0   0 0     0   0   12 14             7         26 26 0 0   0 0     0   0   12 14         7       26
849896 ID     school 1600002 84   LAKE PEND OREILLE SCHOOL DISTRICT 160000200621 410 NORTHSIDE ELEMENTARY SCHOOL   Regular School No Elementary PK 06 2020   grade_1 17 0 0   0 0     0   1   9 9             *         18 17 0 0   0 0     0   1   9 9                 18
849897 ID     school 1600002 84   LAKE PEND OREILLE SCHOOL DISTRICT 160000200621 410 NORTHSIDE ELEMENTARY SCHOOL   Regular School No Elementary PK 06 2020   grade_2 24 0 0   0 0     0   1   18 7             *         25 24 0 0   0 0     0   1   18 7                 25
849899 ID     school 1600002 84   LAKE PEND OREILLE SCHOOL DISTRICT 160000200621 410 NORTHSIDE ELEMENTARY SCHOOL   Regular School No Elementary PK 06 2020   grade_4 19 0 0   0 0     0   0   12 7             *         19 19 0 0   0 0     0   0   12 7                 19
849901 ID     school 1600002 84   LAKE PEND OREILLE SCHOOL DISTRICT 160000200621 410 NORTHSIDE ELEMENTARY SCHOOL   Regular School No Elementary PK 06 2020   grade_6 31 0 0   0 0     0   1   21 11             12         32 31 0 0   0 0     0   1   21 11         12       32
849903 ID     school 1600002 84   LAKE PEND OREILLE SCHOOL DISTRICT 160000200621 410 NORTHSIDE ELEMENTARY SCHOOL   Regular School No Elementary PK 06 2020   kindergarten 28 0 0   0 0     0   2   14 16             8         30 28 0 0   0 0     0   2   14 16         8       30
849904 ID     school 1600002 84   LAKE PEND OREILLE SCHOOL DISTRICT 160000200604 997 SANDPOINT JUVENILE DETENTION   Alternative School No High 05 12 2020   grade_11 1 0 0   0 0     0   0   1 0             *         1 1 0 0   0 0     0   0   1 0                 1
849905 ID     school 1600002 84   LAKE PEND OREILLE SCHOOL DISTRICT 160000200604 997 SANDPOINT JUVENILE DETENTION   Alternative School No High 05 12 2020   grade_12 2 0 0   0 0     0   0   2 0             *         2 2 0 0   0 0     0   0   2 0                 2
849906 ID     school 1600002 84   LAKE PEND OREILLE SCHOOL DISTRICT 160000200604 997 SANDPOINT JUVENILE DETENTION   Alternative School No High 05 12 2020   k_12_total 3 0 0   0 0     0   0   3 0             *         3 3 0 0   0 0     0   0   3 0                 3
849912 ID     school 1600002 84   LAKE PEND OREILLE SCHOOL DISTRICT 160000201086 1391 LPOSD HOME SCHOOL ACADEMY   Regular School No Elementary KG 08 2020   grade_8 1 0 0   0 0     0   0   1 0             *         1 1 0 0   0 0     0   0   1 0                 1
849913 ID     school 1600002 84   LAKE PEND OREILLE SCHOOL DISTRICT 160000201086 1391 LPOSD HOME SCHOOL ACADEMY   Regular School No Elementary KG 08 2020   k_12_total 1 0 0   0 0     0   0   1 0             *         1 1 0 0   0 0     0   0   1 0                 1
850036 ID     school 1601530 91   IDAHO FALLS DISTRICT 160153000605 1152 3B JUVENILE DETENTION CENTER   Alternative School No Other 04 12 2020   grade_12 2 0 0   0 0     0   0   2 0             *         2 2 0 0   0 0     0   0   2 0                 2
850037 ID     school 1601530 91   IDAHO FALLS DISTRICT 160153000605 1152 3B JUVENILE DETENTION CENTER   Alternative School No Other 04 12 2020   grade_9 3 1 0   0 0     0   0   3 1             *         4 3 1 0   0 0     0   0   3 1                 4
850044 ID     school 1603120 92   SWAN VALLEY ELEMENTARY DISTRICT 160312000541 424 SWAN VALLEY ELEMENTARY SCHOOL   Regular School No Elementary PK 08 2020   grade_1 8 0 0   0 0     0   0   6 2             *         8 8 0 0   0 0     0   0   6 2                 8
850045 ID     school 1603120 92   SWAN VALLEY ELEMENTARY DISTRICT 160312000541 424 SWAN VALLEY ELEMENTARY SCHOOL   Regular School No Elementary PK 08 2020   grade_2 5 0 0   0 0     0   0   3 2             *         5 5 0 0   0 0     0   0   3 2                 5
850046 ID     school 1603120 92   SWAN VALLEY ELEMENTARY DISTRICT 160312000541 424 SWAN VALLEY ELEMENTARY SCHOOL   Regular School No Elementary PK 08 2020   grade_3 6 0 0   0 0     0   0   4 2             *         6 6 0 0   0 0     0   0   4 2                 6
850047 ID     school 1603120 92   SWAN VALLEY ELEMENTARY DISTRICT 160312000541 424 SWAN VALLEY ELEMENTARY SCHOOL   Regular School No Elementary PK 08 2020   grade_4 3 0 0   0 0     0   0   1 2             *         3 3 0 0   0 0     0   0   1 2                 3
850049 ID     school 1603120 92   SWAN VALLEY ELEMENTARY DISTRICT 160312000541 424 SWAN VALLEY ELEMENTARY SCHOOL   Regular School No Elementary PK 08 2020   grade_6 9 0 0   0 0     0   0   5 4             *         9 9 0 0   0 0     0   0   5 4                 9
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
850051 ID     school 1603120 92   SWAN VALLEY ELEMENTARY DISTRICT 160312000541 424 SWAN VALLEY ELEMENTARY SCHOOL   Regular School No Elementary PK 08 2020   grade_8 5 0 0   0 0     0   0   3 2             *         5 5 0 0   0 0     0   0   3 2                 5
850053 ID     school 1603120 92   SWAN VALLEY ELEMENTARY DISTRICT 160312000541 424 SWAN VALLEY ELEMENTARY SCHOOL   Regular School No Elementary PK 08 2020   kindergarten 3 0 0   0 0     0   0   1 2             *         3 3 0 0   0 0     0   0   1 2                 3
850054 ID     school   92   SWAN VALLEY ELEMENTARY DISTRICT   1014 BORDER DISTRICT - STAR VALLEY ELEMENTARY SCHOOL             2020   grade_1 1 0 0   0 0     0   0   0 1             *         1 1 0 0   0 0     0   0   0 1                 1
850055 ID     school   92   SWAN VALLEY ELEMENTARY DISTRICT   1014 BORDER DISTRICT - STAR VALLEY ELEMENTARY SCHOOL             2020   grade_2 1 0 0   0 0     0   0   0 1             *         1 1 0 0   0 0     0   0   0 1                 1
850056 ID     school   92   SWAN VALLEY ELEMENTARY DISTRICT   1014 BORDER DISTRICT - STAR VALLEY ELEMENTARY SCHOOL             2020   grade_3 1 0 0   0 0     0   0   1 0             *         1 1 0 0   0 0     0   0   1 0                 1
850057 ID     school   92   SWAN VALLEY ELEMENTARY DISTRICT   1014 BORDER DISTRICT - STAR VALLEY ELEMENTARY SCHOOL             2020   k_12_total 4 0 0   0 0     0   0   2 2             *         4 4 0 0   0 0     0   0   2 2                 4
850058 ID     school   92   SWAN VALLEY ELEMENTARY DISTRICT   1014 BORDER DISTRICT - STAR VALLEY ELEMENTARY SCHOOL             2020   kindergarten 1 0 0   0 0     0   0   1 0             *         1 1 0 0   0 0     0   0   1 0                 1
850059 ID     school   92   SWAN VALLEY ELEMENTARY DISTRICT   1015 BORDER DISTRICT - STAR VALLEY JR-SR HIGH SCHOOL             2020   grade_10 1 0 0   0 0     0   0   0 1             *         1 1 0 0   0 0     0   0   0 1                 1
850060 ID     school   92   SWAN VALLEY ELEMENTARY DISTRICT   1015 BORDER DISTRICT - STAR VALLEY JR-SR HIGH SCHOOL             2020   grade_12 2 0 0   0 0     0   0   1 1             *         2 2 0 0   0 0     0   0   1 1                 2
850061 ID     school   92   SWAN VALLEY ELEMENTARY DISTRICT   1015 BORDER DISTRICT - STAR VALLEY JR-SR HIGH SCHOOL             2020   k_12_total 3 0 0   0 0     0   0   1 2             *         3 3 0 0   0 0     0   0   1 2                 3
850156 ID     school 1600930 93   BONNEVILLE JOINT DISTRICT 160093000999 1238 BONNEVILLE ONLINE ELEMENTARY   Regular School No Elementary PK 08 2020   grade_1 25 0 0   0 0     0   0   9 16             *         25 25 0 0   0 0     0   0   9 16                 25
850163 ID     school 1600930 93   BONNEVILLE JOINT DISTRICT 160093000999 1238 BONNEVILLE ONLINE ELEMENTARY   Regular School No Elementary PK 08 2020   grade_8 17 0 0   0 0     0   1   13 5             *         18 17 0 0   0 0     0   1   13 5                 18
850165 ID     school 1600930 93   BONNEVILLE JOINT DISTRICT 160093000999 1238 BONNEVILLE ONLINE ELEMENTARY   Regular School No Elementary PK 08 2020   kindergarten 29 0 0   0 0     0   0   12 17             *         29 29 0 0   0 0     0   0   12 17                 29
850174 ID     school 1600930 93   BONNEVILLE JOINT DISTRICT 160093000909 1255 RIMROCK ELEMENTARY   Regular School No Elementary PK 06 2020   grade_1 66 0 0   0 0     0   0   28 38             *         66 66 0 0   0 0     0   0   28 38                 66
850176 ID     school 1600930 93   BONNEVILLE JOINT DISTRICT 160093000909 1255 RIMROCK ELEMENTARY   Regular School No Elementary PK 06 2020   grade_3 57 1 0   0 2     0   2   26 36             *         62 57 1 0   0 2     0   2   26 36                 62
850177 ID     school 1600930 93   BONNEVILLE JOINT DISTRICT 160093000909 1255 RIMROCK ELEMENTARY   Regular School No Elementary PK 06 2020   grade_4 71 0 0   0 0     0   1   35 37             *         72 71 0 0   0 0     0   1   35 37                 72
850185 ID     school 1600930 93   BONNEVILLE JOINT DISTRICT 160093001050 1319 BONNEVILLE ONLINE SCHOOL   Regular School No High 06 12 2020   grade_6 4 0 0   0 0     0   0   2 2             *         4 4 0 0   0 0     0   0   2 2                 4
850186 ID     school 1600930 93   BONNEVILLE JOINT DISTRICT 160093001050 1319 BONNEVILLE ONLINE SCHOOL   Regular School No High 06 12 2020   grade_7 16 0 0   0 0     0   0   8 8             *         16 16 0 0   0 0     0   0   8 8                 16
850241 ID     school 1600420 101   BOUNDARY COUNTY DISTRICT 160042000091 434 MOUNT HALL ELEMENTARY SCHOOL   Regular School No Elementary KG 05 2020   grade_3 22 2 0   0 0     0   1   12 13             16         25 22 2 0   0 0     0   1   12 13         16       25
850255 ID     school 1600490 111   BUTTE COUNTY JOINT DISTRICT 160049000008 59 BUTTE COUNTY MIDDLE/HIGH SCHOOL   Regular School No High 07 12 2020   grade_12 23 0 0   0 0     0   1   19 5             *         24 23 0 0   0 0     0   1   19 5                 24
850257 ID     school 1600490 111   BUTTE COUNTY JOINT DISTRICT 160049000008 59 BUTTE COUNTY MIDDLE/HIGH SCHOOL   Regular School No High 07 12 2020   grade_8 31 0 0   0 0     0   0   14 17             11         31 31 0 0   0 0     0   0   14 17         11       31
850260 ID     school 1600490 111   BUTTE COUNTY JOINT DISTRICT 160049000011 438 HOWE ELEMENTARY SCHOOL   Regular School No Elementary KG 03 2020   grade_1 2 0 0   0 0     0   0   1 1             *         2 2 0 0   0 0     0   0   1 1                 2
850261 ID     school 1600490 111   BUTTE COUNTY JOINT DISTRICT 160049000011 438 HOWE ELEMENTARY SCHOOL   Regular School No Elementary KG 03 2020   grade_2 2 0 0   0 0     0   0   2 0             *         2 2 0 0   0 0     0   0   2 0                 2
850262 ID     school 1600490 111   BUTTE COUNTY JOINT DISTRICT 160049000011 438 HOWE ELEMENTARY SCHOOL   Regular School No Elementary KG 03 2020   grade_3 3 0 0   0 0     0   0   2 1             *         3 3 0 0   0 0     0   0   2 1                 3
850263 ID     school 1600490 111   BUTTE COUNTY JOINT DISTRICT 160049000011 438 HOWE ELEMENTARY SCHOOL   Regular School No Elementary KG 03 2020   k_12_total 8 0 0   0 0     0   0   5 3             *         8 8 0 0   0 0     0   0   5 3                 8
850264 ID     school 1600490 111   BUTTE COUNTY JOINT DISTRICT 160049000011 438 HOWE ELEMENTARY SCHOOL   Regular School No Elementary KG 03 2020   kindergarten 1 0 0   0 0     0   0   0 1             *         1 1 0 0   0 0     0   0   0 1                 1
850267 ID     school 1600490 111   BUTTE COUNTY JOINT DISTRICT 160049000007 439 ARCO ELEMENTARY SCHOOL   Regular School No Elementary PK 06 2020   grade_3 21 0 0   1 0     0   1   13 10             *         23 21 0 0   1 0     0   1   13 10                 23
850275 ID     school 1600540 121   CAMAS COUNTY DISTRICT 160054000111 60 CAMAS COUNTY HIGH SCHOOL   Regular School No High 09 12 2020   grade_12 9 0 0   0 0     0   0   4 5             *         9 9 0 0   0 0     0   0   4 5                 9
850276 ID     school 1600540 121   CAMAS COUNTY DISTRICT 160054000111 60 CAMAS COUNTY HIGH SCHOOL   Regular School No High 09 12 2020   grade_9 11 0 0   0 0     0   0   5 6             5         11 11 0 0   0 0     0   0   5 6         5       11
850278 ID     school 1600540 121   CAMAS COUNTY DISTRICT 160054000110 440 CAMAS COUNTY ELEM/JR HIGH SCHOOL   Regular School No Elementary PK 08 2020   grade_1 11 0 0   0 0     0   0   5 6             6         11 11 0 0   0 0     0   0   5 6         6       11
850279 ID     school 1600540 121   CAMAS COUNTY DISTRICT 160054000110 440 CAMAS COUNTY ELEM/JR HIGH SCHOOL   Regular School No Elementary PK 08 2020   grade_2 16 0 0   0 0     0   0   6 10             8         16 16 0 0   0 0     0   0   6 10         8       16
850280 ID     school 1600540 121   CAMAS COUNTY DISTRICT 160054000110 440 CAMAS COUNTY ELEM/JR HIGH SCHOOL   Regular School No Elementary PK 08 2020   grade_3 18 0 0   0 0     0   0   8 10             12         18 18 0 0   0 0     0   0   8 10         12       18
850281 ID     school 1600540 121   CAMAS COUNTY DISTRICT 160054000110 440 CAMAS COUNTY ELEM/JR HIGH SCHOOL   Regular School No Elementary PK 08 2020   grade_4 8 0 0   0 0     0   0   3 5             *         8 8 0 0   0 0     0   0   3 5                 8
850283 ID     school 1600540 121   CAMAS COUNTY DISTRICT 160054000110 440 CAMAS COUNTY ELEM/JR HIGH SCHOOL   Regular School No Elementary PK 08 2020   grade_6 14 0 0   0 0     0   0   4 10             6         14 14 0 0   0 0     0   0   4 10         6       14
850284 ID     school 1600540 121   CAMAS COUNTY DISTRICT 160054000110 440 CAMAS COUNTY ELEM/JR HIGH SCHOOL   Regular School No Elementary PK 08 2020   grade_7 19 0 0   0 0     0   0   7 12             8         19 19 0 0   0 0     0   0   7 12         8       19
850287 ID     school 1600540 121   CAMAS COUNTY DISTRICT 160054000110 440 CAMAS COUNTY ELEM/JR HIGH SCHOOL   Regular School No Elementary PK 08 2020   kindergarten 6 0 0   0 0     0   0   4 2             *         6 6 0 0   0 0     0   0   4 2                 6
850543 ID     school 1602130 134   MIDDLETON DISTRICT 160213000777 1168 MIDDLETON ACADEMY   Alternative School No High 07 12 2020   grade_8 1 0 0   0 0     0   0   1 0             *         1 1 0 0   0 0     0   0   1 0                 1
850544 ID     school 1602130 134   MIDDLETON DISTRICT 160213000777 1168 MIDDLETON ACADEMY   Alternative School No High 07 12 2020   grade_9 8 0 0   0 0     0   0   5 3             *         8 8 0 0   0 0     0   0   5 3                 8
850665 ID     school 1600600 139   VALLIVUE SCHOOL DISTRICT 160060000914 9017 VALLIVUE ACADEMY   Alternative School No High 09 12 2020   grade_9 1 0 0   0 0     0   0   0 1             *         1 1 0 0   0 0     0   0   0 1                 1
850671 ID     school 1601290 148   GRACE JOINT DISTRICT 160129000742 245 GRACE JR/SR HIGH SCHOOL   Regular School No High 07 12 2020   grade_8 38 0 0   2 0     0   1   21 20             18         41 38 0 0   2 0     0   1   21 20         18       41
850674 ID     school 1601290 148   GRACE JOINT DISTRICT 160129000228 462 THATCHER ELEMENTARY SCHOOL   Regular School No Elementary 01 05 2020   grade_1 19 0 0   0 0     0   0   8 11             14         19 19 0 0   0 0     0   0   8 11         14       19
850675 ID     school 1601290 148   GRACE JOINT DISTRICT 160129000228 462 THATCHER ELEMENTARY SCHOOL   Regular School No Elementary 01 05 2020   grade_2 17 0 0   0 0     0   0   9 8             12         17 17 0 0   0 0     0   0   9 8         12       17
850677 ID     school 1601290 148   GRACE JOINT DISTRICT 160129000228 462 THATCHER ELEMENTARY SCHOOL   Regular School No Elementary 01 05 2020   grade_4 25 0 0   0 0     0   0   10 15             14         25 25 0 0   0 0     0   0   10 15         14       25
850680 ID     school 1601290 148   GRACE JOINT DISTRICT 160129000225 463 GRACE ELEMENTARY SCHOOL   Regular School No Elementary PK 06 2020   grade_1 21 0 0   0 0     0   1   11 11             9         22 21 0 0   0 0     0   1   11 11         9       22
850683 ID     school 1601290 148   GRACE JOINT DISTRICT 160129000225 463 GRACE ELEMENTARY SCHOOL   Regular School No Elementary PK 06 2020   grade_4 22 0 0   0 0     0   0   10 12             12         22 22 0 0   0 0     0   0   10 12         12       22
850688 ID     school 1602430 149   NORTH GEM DISTRICT 160243000428 77 NORTH GEM HIGH SCHOOL   Regular School No High 07 12 2020   grade_10 14 0 0   0 0     0   0   9 5             *         14 14 0 0   0 0     0   0   9 5                 14
850689 ID     school 1602430 149   NORTH GEM DISTRICT 160243000428 77 NORTH GEM HIGH SCHOOL   Regular School No High 07 12 2020   grade_11 14 0 0   0 0     0   0   10 4             5         14 14 0 0   0 0     0   0   10 4         5       14
850690 ID     school 1602430 149   NORTH GEM DISTRICT 160243000428 77 NORTH GEM HIGH SCHOOL   Regular School No High 07 12 2020   grade_12 15 0 0   0 0     0   0   7 8             *         15 15 0 0   0 0     0   0   7 8                 15
850691 ID     school 1602430 149   NORTH GEM DISTRICT 160243000428 77 NORTH GEM HIGH SCHOOL   Regular School No High 07 12 2020   grade_9 10 0 0   0 0     1   0   5 6             6         11 10 0 0   0 0     1   0   5 6         6       11
850692 ID     school 1602430 149   NORTH GEM DISTRICT 160243000428 77 NORTH GEM HIGH SCHOOL   Regular School No High 07 12 2020   k_12_total 53 0 0   0 0     1   0   31 23             20         54 53 0 0   0 0     1   0   31 23         20       54
850694 ID     school 1602430 149   NORTH GEM DISTRICT 160243000427 464 NORTH GEM ELEMENTARY   Regular School No Elementary PK 06 2020   grade_2 8 0 0   0 0     2   0   7 3             *         10 8 0 0   0 0     2   0   7 3                 10
850695 ID     school 1602430 149   NORTH GEM DISTRICT 160243000427 464 NORTH GEM ELEMENTARY   Regular School No Elementary PK 06 2020   grade_3 6 0 0   0 0     0   0   4 2             *         6 6 0 0   0 0     0   0   4 2                 6
850697 ID     school 1602430 149   NORTH GEM DISTRICT 160243000427 464 NORTH GEM ELEMENTARY   Regular School No Elementary PK 06 2020   grade_5 8 0 0   0 0     0   0   4 4             *         8 8 0 0   0 0     0   0   4 4                 8
850699 ID     school 1602430 149   NORTH GEM DISTRICT 160243000427 464 NORTH GEM ELEMENTARY   Regular School No Elementary PK 06 2020   kindergarten 12 0 0   0 0     0   0   7 5             6         12 12 0 0   0 0     0   0   7 5         6       12
850700 ID     school 1602430 149   NORTH GEM DISTRICT 160243001099 1401 NORTH GEM MIDDLE SCHOOL   Regular School No Middle 06 08 2020   grade_6 14 0 0   0 0     0   0   7 7             *         14 14 0 0   0 0     0   0   7 7                 14
850701 ID     school 1602430 149   NORTH GEM DISTRICT 160243001099 1401 NORTH GEM MIDDLE SCHOOL   Regular School No Middle 06 08 2020   grade_7 13 0 0   0 0     1   0   8 6             6         14 13 0 0   0 0     1   0   8 6         6       14
850702 ID     school 1602430 149   NORTH GEM DISTRICT 160243001099 1401 NORTH GEM MIDDLE SCHOOL   Regular School No Middle 06 08 2020   grade_8 10 0 0   0 0     0   0   4 6             *         10 10 0 0   0 0     0   0   4 6                 10
850703 ID     school 1602430 149   NORTH GEM DISTRICT 160243001099 1401 NORTH GEM MIDDLE SCHOOL   Regular School No Middle 06 08 2020   k_12_total 37 0 0   0 0     1   0   19 19             14         38 37 0 0   0 0     1   0   19 19         14       38
850720 ID     school   150   SODA SPRINGS JOINT DISTRICT   1025 BORDER DISTRICT - FREEDOM ELEMENTARY             2020   grade_1 1 0 0   0 0     0   0   1 0             *         1 1 0 0   0 0     0   0   1 0                 1
850721 ID     school   150   SODA SPRINGS JOINT DISTRICT   1025 BORDER DISTRICT - FREEDOM ELEMENTARY             2020   grade_2 6 0 0   0 0     0   0   1 5             *         6 6 0 0   0 0     0   0   1 5                 6
850722 ID     school   150   SODA SPRINGS JOINT DISTRICT   1025 BORDER DISTRICT - FREEDOM ELEMENTARY             2020   grade_3 3 0 0   0 0     0   0   0 3             *         3 3 0 0   0 0     0   0   0 3                 3
850723 ID     school   150   SODA SPRINGS JOINT DISTRICT   1025 BORDER DISTRICT - FREEDOM ELEMENTARY             2020   grade_4 1 0 0   0 0     0   0   1 0             *         1 1 0 0   0 0     0   0   1 0                 1
850724 ID     school   150   SODA SPRINGS JOINT DISTRICT   1025 BORDER DISTRICT - FREEDOM ELEMENTARY             2020   grade_5 2 0 0   0 0     0   0   0 2             *         2 2 0 0   0 0     0   0   0 2                 2
850727 ID     school   150   SODA SPRINGS JOINT DISTRICT   1025 BORDER DISTRICT - FREEDOM ELEMENTARY             2020   kindergarten 2 0 0   0 0     0   0   2 0             *         2 2 0 0   0 0     0   0   2 0                 2
850730 ID     school   150   SODA SPRINGS JOINT DISTRICT   1026 BORDER DISTRICT FREEDOM - SECONDARY             2020   grade_12 1 0 0   0 0     0   0   1 0             *         1 1 0 0   0 0     0   0   1 0                 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
850732 ID     school   150   SODA SPRINGS JOINT DISTRICT   1026 BORDER DISTRICT FREEDOM - SECONDARY             2020   grade_8 3 0 0   0 0     0   0   2 1             *         3 3 0 0   0 0     0   0   2 1                 3
850774 ID     school 1600660 151   CASSIA COUNTY JOINT DISTRICT 160066000123 468 ALMO ELEMENTARY SCHOOL   Regular School No Elementary PK 06 2020   grade_1 3 0 0   0 0     0   0   2 1             *         3 3 0 0   0 0     0   0   2 1                 3
850775 ID     school 1600660 151   CASSIA COUNTY JOINT DISTRICT 160066000123 468 ALMO ELEMENTARY SCHOOL   Regular School No Elementary PK 06 2020   grade_2 2 0 0   0 0     0   0   1 1             *         2 2 0 0   0 0     0   0   1 1                 2
850776 ID     school 1600660 151   CASSIA COUNTY JOINT DISTRICT 160066000123 468 ALMO ELEMENTARY SCHOOL   Regular School No Elementary PK 06 2020   grade_3 3 0 0   0 0     0   0   3 0             *         3 3 0 0   0 0     0   0   3 0                 3
850777 ID     school 1600660 151   CASSIA COUNTY JOINT DISTRICT 160066000123 468 ALMO ELEMENTARY SCHOOL   Regular School No Elementary PK 06 2020   k_12_total 10 0 0   0 0     0   0   8 2             *         10 10 0 0   0 0     0   0   8 2                 10
850778 ID     school 1600660 151   CASSIA COUNTY JOINT DISTRICT 160066000123 468 ALMO ELEMENTARY SCHOOL   Regular School No Elementary PK 06 2020   kindergarten 2 0 0   0 0     0   0   2 0             *         2 2 0 0   0 0     0   0   2 0                 2

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