Data source: Big Local News · About: Big Local

4,725 rows where state = "ID" and year = 2017 sorted by district_nces_id

View and edit SQL

grade

year

  • 2017 · 4,725
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
1726809 ID     school 1600001 83   WEST BONNER COUNTY DISTRICT 160000100085 44 PRIEST RIVER JR HIGH SCHOOL   Regular School No Middle 07 8.0 2017   grade_7 86 0 3   1 0     0   1   58 33             57         91 86 0 3   1 0     0   1   58 33         57       91
1726810 ID     school 1600001 83   WEST BONNER COUNTY DISTRICT 160000100085 44 PRIEST RIVER JR HIGH SCHOOL   Regular School No Middle 07 8.0 2017   grade_8 65 0 0   0 0     0   0   29 36             31         65 65 0 0   0 0     0   0   29 36         31       65
1726811 ID     school 1600001 83   WEST BONNER COUNTY DISTRICT 160000100085 44 PRIEST RIVER JR HIGH SCHOOL   Regular School No Middle 07 8.0 2017   k_12_total 151 0 3   1 0     0   1   87 69             88         156 151 0 3   1 0     0   1   87 69         88       156
1726812 ID     school 1600001 83   WEST BONNER COUNTY DISTRICT 160000100084 48 PRIEST RIVER LAMANNA HIGH   Regular School No High 09 12.0 2017   grade_10 84 1 4   0 0     0   3   49 43             *         92 84 1 4   0 0     0   3   49 43                 92
1726813 ID     school 1600001 83   WEST BONNER COUNTY DISTRICT 160000100084 48 PRIEST RIVER LAMANNA HIGH   Regular School No High 09 12.0 2017   grade_11 72 0 7   0 0     0   3   48 34             *         82 72 0 7   0 0     0   3   48 34                 82
1726814 ID     school 1600001 83   WEST BONNER COUNTY DISTRICT 160000100084 48 PRIEST RIVER LAMANNA HIGH   Regular School No High 09 12.0 2017   grade_12 75 0 3   1 0     0   1   48 32             *         80 75 0 3   1 0     0   1   48 32                 80
1726815 ID     school 1600001 83   WEST BONNER COUNTY DISTRICT 160000100084 48 PRIEST RIVER LAMANNA HIGH   Regular School No High 09 12.0 2017   grade_9 86 0 1   1 0     0   4   49 43             *         92 86 0 1   1 0     0   4   49 43                 92
1726816 ID     school 1600001 83   WEST BONNER COUNTY DISTRICT 160000100084 48 PRIEST RIVER LAMANNA HIGH   Regular School No High 09 12.0 2017   k_12_total 317 1 15   2 0     0   11   194 152             161         346 317 1 15   2 0     0   11   194 152         161       346
1726817 ID     school 1600001 83   WEST BONNER COUNTY DISTRICT 160000100620 406 PRIEST LAKE ELEMENTARY SCHOOL   Regular School No Elementary PK 6.0 2017   grade_1 11 0 0   0 0     0   0   6 5             5         11 11 0 0   0 0     0   0   6 5         5       11
1726818 ID     school 1600001 83   WEST BONNER COUNTY DISTRICT 160000100620 406 PRIEST LAKE ELEMENTARY SCHOOL   Regular School No Elementary PK 6.0 2017   grade_2 7 0 0   0 0     0   0   3 4             *         7 7 0 0   0 0     0   0   3 4                 7
1726819 ID     school 1600001 83   WEST BONNER COUNTY DISTRICT 160000100620 406 PRIEST LAKE ELEMENTARY SCHOOL   Regular School No Elementary PK 6.0 2017   grade_3 5 0 0   0 0     0   0   3 2             *         5 5 0 0   0 0     0   0   3 2                 5
1726820 ID     school 1600001 83   WEST BONNER COUNTY DISTRICT 160000100620 406 PRIEST LAKE ELEMENTARY SCHOOL   Regular School No Elementary PK 6.0 2017   grade_4 3 0 0   0 0     0   0   2 1             *         3 3 0 0   0 0     0   0   2 1                 3
1726821 ID     school 1600001 83   WEST BONNER COUNTY DISTRICT 160000100620 406 PRIEST LAKE ELEMENTARY SCHOOL   Regular School No Elementary PK 6.0 2017   grade_5 6 0 0   0 0     0   0   5 1             *         6 6 0 0   0 0     0   0   5 1                 6
1726822 ID     school 1600001 83   WEST BONNER COUNTY DISTRICT 160000100620 406 PRIEST LAKE ELEMENTARY SCHOOL   Regular School No Elementary PK 6.0 2017   grade_6 4 0 0   0 0     0   0   2 2             *         4 4 0 0   0 0     0   0   2 2                 4
1726823 ID     school 1600001 83   WEST BONNER COUNTY DISTRICT 160000100620 406 PRIEST LAKE ELEMENTARY SCHOOL   Regular School No Elementary PK 6.0 2017   k_12_total 44 0 0   0 0     0   0   25 19             24         44 44 0 0   0 0     0   0   25 19         24       44
1726824 ID     school 1600001 83   WEST BONNER COUNTY DISTRICT 160000100620 406 PRIEST LAKE ELEMENTARY SCHOOL   Regular School No Elementary PK 6.0 2017   kindergarten 8 0 0   0 0     0   0   4 4             *         8 8 0 0   0 0     0   0   4 4                 8
1726825 ID     school 1600001 83   WEST BONNER COUNTY DISTRICT 160000100619 407 PRIEST RIVER ELEMENTARY SCHOOL   Regular School No Elementary PK 6.0 2017   grade_1 48 0 5   0 0     0   1   32 22             34         54 48 0 5   0 0     0   1   32 22         34       54
1726826 ID     school 1600001 83   WEST BONNER COUNTY DISTRICT 160000100619 407 PRIEST RIVER ELEMENTARY SCHOOL   Regular School No Elementary PK 6.0 2017   grade_2 61 0 3   0 0     0   1   34 31             38         65 61 0 3   0 0     0   1   34 31         38       65
1726827 ID     school 1600001 83   WEST BONNER COUNTY DISTRICT 160000100619 407 PRIEST RIVER ELEMENTARY SCHOOL   Regular School No Elementary PK 6.0 2017   grade_3 45 0 3   0 0     1   1   31 19             26         50 45 0 3   0 0     1   1   31 19         26       50
1726828 ID     school 1600001 83   WEST BONNER COUNTY DISTRICT 160000100619 407 PRIEST RIVER ELEMENTARY SCHOOL   Regular School No Elementary PK 6.0 2017   grade_4 54 0 2   0 0     0   4   37 23             38         60 54 0 2   0 0     0   4   37 23         38       60
1726829 ID     school 1600001 83   WEST BONNER COUNTY DISTRICT 160000100619 407 PRIEST RIVER ELEMENTARY SCHOOL   Regular School No Elementary PK 6.0 2017   grade_5 59 0 1   0 0     1   7   33 35             47         68 59 0 1   0 0     1   7   33 35         47       68
1726830 ID     school 1600001 83   WEST BONNER COUNTY DISTRICT 160000100619 407 PRIEST RIVER ELEMENTARY SCHOOL   Regular School No Elementary PK 6.0 2017   grade_6 53 0 0   0 1     0   1   26 29             30         55 53 0 0   0 1     0   1   26 29         30       55
1726831 ID     school 1600001 83   WEST BONNER COUNTY DISTRICT 160000100619 407 PRIEST RIVER ELEMENTARY SCHOOL   Regular School No Elementary PK 6.0 2017   k_12_total 379 0 16   0 1     2   18   231 185             255         416 379 0 16   0 1     2   18   231 185         255       416
1726832 ID     school 1600001 83   WEST BONNER COUNTY DISTRICT 160000100619 407 PRIEST RIVER ELEMENTARY SCHOOL   Regular School No Elementary PK 6.0 2017   kindergarten 59 0 2   0 0     0   3   38 26             42         64 59 0 2   0 0     0   3   38 26         42       64
1726833 ID     school 1600001 83   WEST BONNER COUNTY DISTRICT 160000100613 411 IDAHO HILL ELEMENTARY SCHOOL   Regular School No Elementary PK 6.0 2017   grade_1 12 0 1   0 0     0   2   5 10             10         15 12 0 1   0 0     0   2   5 10         10       15
1726834 ID     school 1600001 83   WEST BONNER COUNTY DISTRICT 160000100613 411 IDAHO HILL ELEMENTARY SCHOOL   Regular School No Elementary PK 6.0 2017   grade_2 18 0 1   0 0     0   2   6 15             *         21 18 0 1   0 0     0   2   6 15                 21
1726835 ID     school 1600001 83   WEST BONNER COUNTY DISTRICT 160000100613 411 IDAHO HILL ELEMENTARY SCHOOL   Regular School No Elementary PK 6.0 2017   grade_3 19 0 0   0 0     0   0   9 10             *         19 19 0 0   0 0     0   0   9 10                 19
1726836 ID     school 1600001 83   WEST BONNER COUNTY DISTRICT 160000100613 411 IDAHO HILL ELEMENTARY SCHOOL   Regular School No Elementary PK 6.0 2017   grade_4 19 0 1   0 0     0   2   9 13             *         22 19 0 1   0 0     0   2   9 13                 22
1726837 ID     school 1600001 83   WEST BONNER COUNTY DISTRICT 160000100613 411 IDAHO HILL ELEMENTARY SCHOOL   Regular School No Elementary PK 6.0 2017   grade_5 12 0 1   1 0     0   0   8 6             *         14 12 0 1   1 0     0   0   8 6                 14
1726838 ID     school 1600001 83   WEST BONNER COUNTY DISTRICT 160000100613 411 IDAHO HILL ELEMENTARY SCHOOL   Regular School No Elementary PK 6.0 2017   grade_6 15 0 1   0 1     0   0   10 7             *         17 15 0 1   0 1     0   0   10 7                 17
1726839 ID     school 1600001 83   WEST BONNER COUNTY DISTRICT 160000100613 411 IDAHO HILL ELEMENTARY SCHOOL   Regular School No Elementary PK 6.0 2017   k_12_total 107 0 6   1 1     0   6   54 67             70         121 107 0 6   1 1     0   6   54 67         70       121
1726840 ID     school 1600001 83   WEST BONNER COUNTY DISTRICT 160000100613 411 IDAHO HILL ELEMENTARY SCHOOL   Regular School No Elementary PK 6.0 2017   kindergarten 12 0 1   0 0     0   0   7 6             *         13 12 0 1   0 0     0   0   7 6                 13
1726841 ID     school 1600001 83   WEST BONNER COUNTY DISTRICT 160000100771 1172 PRIEST RIVER EDUCATIONAL PROGRAM (PREP)   Alternative School No High 09 12.0 2017   grade_10 5 0 0   0 0     0   0   3 2             *         5 5 0 0   0 0     0   0   3 2                 5
1726842 ID     school 1600001 83   WEST BONNER COUNTY DISTRICT 160000100771 1172 PRIEST RIVER EDUCATIONAL PROGRAM (PREP)   Alternative School No High 09 12.0 2017   grade_11 6 0 0   0 0     0   0   4 2             *         6 6 0 0   0 0     0   0   4 2                 6
1726843 ID     school 1600001 83   WEST BONNER COUNTY DISTRICT 160000100771 1172 PRIEST RIVER EDUCATIONAL PROGRAM (PREP)   Alternative School No High 09 12.0 2017   grade_12 10 0 0   0 0     0   3   7 6             *         13 10 0 0   0 0     0   3   7 6                 13
1726844 ID     school 1600001 83   WEST BONNER COUNTY DISTRICT 160000100771 1172 PRIEST RIVER EDUCATIONAL PROGRAM (PREP)   Alternative School No High 09 12.0 2017   grade_9 1 0 0   0 0     0   0   0 1             *         1 1 0 0   0 0     0   0   0 1                 1
1726845 ID     school 1600001 83   WEST BONNER COUNTY DISTRICT 160000100771 1172 PRIEST RIVER EDUCATIONAL PROGRAM (PREP)   Alternative School No High 09 12.0 2017   k_12_total 22 0 0   0 0     0   3   14 11             17         25 22 0 0   0 0     0   3   14 11         17       25
1726846 ID     school 1600002 84   LAKE PEND OREILLE SCHOOL DISTRICT 160000200724 47 SANDPOINT MIDDLE SCHOOL   Regular School No Middle 07 8.0 2017   grade_7 204 0 8   2 0     1   9   116 108             *         224 204 0 8   2 0     1   9   116 108                 224
1726847 ID     school 1600002 84   LAKE PEND OREILLE SCHOOL DISTRICT 160000200724 47 SANDPOINT MIDDLE SCHOOL   Regular School No Middle 07 8.0 2017   grade_8 227 1 13   0 1     0   10   136 116             *         252 227 1 13   0 1     0   10   136 116                 252
1726848 ID     school 1600002 84   LAKE PEND OREILLE SCHOOL DISTRICT 160000200724 47 SANDPOINT MIDDLE SCHOOL   Regular School No Middle 07 8.0 2017   k_12_total 431 1 21   2 1     1   19   252 224             186         476 431 1 21   2 1     1   19   252 224         186       476
1726849 ID     school 1600002 84   LAKE PEND OREILLE SCHOOL DISTRICT 160000200082 49 CLARK FORK JR/SR HIGH SCHOOL   Regular School No High 07 12.0 2017   grade_10 22 0 1   1 1     0   0   12 13             8         25 22 0 1   1 1     0   0   12 13         8       25
1726850 ID     school 1600002 84   LAKE PEND OREILLE SCHOOL DISTRICT 160000200082 49 CLARK FORK JR/SR HIGH SCHOOL   Regular School No High 07 12.0 2017   grade_11 11 0 0   0 0     0   0   8 3             *         11 11 0 0   0 0     0   0   8 3                 11
1726851 ID     school 1600002 84   LAKE PEND OREILLE SCHOOL DISTRICT 160000200082 49 CLARK FORK JR/SR HIGH SCHOOL   Regular School No High 07 12.0 2017   grade_12 14 0 0   0 1     0   1   6 10             *         16 14 0 0   0 1     0   1   6 10                 16
1726852 ID     school 1600002 84   LAKE PEND OREILLE SCHOOL DISTRICT 160000200082 49 CLARK FORK JR/SR HIGH SCHOOL   Regular School No High 07 12.0 2017   grade_7 24 0 0   0 0     0   0   11 13             *         24 24 0 0   0 0     0   0   11 13                 24
1726853 ID     school 1600002 84   LAKE PEND OREILLE SCHOOL DISTRICT 160000200082 49 CLARK FORK JR/SR HIGH SCHOOL   Regular School No High 07 12.0 2017   grade_8 17 0 1   0 0     0   0   7 11             *         18 17 0 1   0 0     0   0   7 11                 18
1726854 ID     school 1600002 84   LAKE PEND OREILLE SCHOOL DISTRICT 160000200082 49 CLARK FORK JR/SR HIGH SCHOOL   Regular School No High 07 12.0 2017   grade_9 20 0 0   0 0     0   1   9 12             6         21 20 0 0   0 0     0   1   9 12         6       21
1726855 ID     school 1600002 84   LAKE PEND OREILLE SCHOOL DISTRICT 160000200082 49 CLARK FORK JR/SR HIGH SCHOOL   Regular School No High 07 12.0 2017   k_12_total 108 0 2   1 2     0   2   53 62             *         115 108 0 2   1 2     0   2   53 62                 115
1726856 ID     school 1600002 84   LAKE PEND OREILLE SCHOOL DISTRICT 160000200087 202 SANDPOINT HIGH SCHOOL   Regular School No High 07 12.0 2017   grade_10 209 0 14   1 5     0   16   112 133             80         245 209 0 14   1 5     0   16   112 133         80       245
1726857 ID     school 1600002 84   LAKE PEND OREILLE SCHOOL DISTRICT 160000200087 202 SANDPOINT HIGH SCHOOL   Regular School No High 07 12.0 2017   grade_11 222 2 11   2 1     0   13   121 130             73         251 222 2 11   2 1     0   13   121 130         73       251
1726858 ID     school 1600002 84   LAKE PEND OREILLE SCHOOL DISTRICT 160000200087 202 SANDPOINT HIGH SCHOOL   Regular School No High 07 12.0 2017   grade_12 193 0 9   1 1     1   8   104 109             53         213 193 0 9   1 1     1   8   104 109         53       213
1726859 ID     school 1600002 84   LAKE PEND OREILLE SCHOOL DISTRICT 160000200087 202 SANDPOINT HIGH SCHOOL   Regular School No High 07 12.0 2017   grade_9 245 0 12   0 0     1   15   139 134             90         273 245 0 12   0 0     1   15   139 134         90       273
1726860 ID     school 1600002 84   LAKE PEND OREILLE SCHOOL DISTRICT 160000200087 202 SANDPOINT HIGH SCHOOL   Regular School No High 07 12.0 2017   k_12_total 869 2 46   4 7     2   52   476 506             296         982 869 2 46   4 7     2   52   476 506         296       982
1726861 ID     school 1600002 84   LAKE PEND OREILLE SCHOOL DISTRICT 160000200603 293 KOOTENAI ELEMENTARY SCHOOL   Regular School No Elementary KG 6.0 2017   grade_1 53 0 2   0 0     0   0   28 27             26         55 53 0 2   0 0     0   0   28 27         26       55
1726862 ID     school 1600002 84   LAKE PEND OREILLE SCHOOL DISTRICT 160000200603 293 KOOTENAI ELEMENTARY SCHOOL   Regular School No Elementary KG 6.0 2017   grade_2 58 1 5   0 0     0   1   42 23             35         65 58 1 5   0 0     0   1   42 23         35       65
1726863 ID     school 1600002 84   LAKE PEND OREILLE SCHOOL DISTRICT 160000200603 293 KOOTENAI ELEMENTARY SCHOOL   Regular School No Elementary KG 6.0 2017   grade_3 67 1 0   0 0     1   1   21 49             37         70 67 1 0   0 0     1   1   21 49         37       70
1726864 ID     school 1600002 84   LAKE PEND OREILLE SCHOOL DISTRICT 160000200603 293 KOOTENAI ELEMENTARY SCHOOL   Regular School No Elementary KG 6.0 2017   grade_4 46 1 2   0 1     0   0   25 25             27         50 46 1 2   0 1     0   0   25 25         27       50
1726865 ID     school 1600002 84   LAKE PEND OREILLE SCHOOL DISTRICT 160000200603 293 KOOTENAI ELEMENTARY SCHOOL   Regular School No Elementary KG 6.0 2017   grade_5 50 0 3   0 4     0   2   33 26             32         59 50 0 3   0 4     0   2   33 26         32       59
1726866 ID     school 1600002 84   LAKE PEND OREILLE SCHOOL DISTRICT 160000200603 293 KOOTENAI ELEMENTARY SCHOOL   Regular School No Elementary KG 6.0 2017   grade_6 44 0 3   0 0     0   4   25 26             29         51 44 0 3   0 0     0   4   25 26         29       51
1726867 ID     school 1600002 84   LAKE PEND OREILLE SCHOOL DISTRICT 160000200603 293 KOOTENAI ELEMENTARY SCHOOL   Regular School No Elementary KG 6.0 2017   k_12_total 356 3 16   1 5     1   11   198 195             209         393 356 3 16   1 5     1   11   198 195         209       393
1726868 ID     school 1600002 84   LAKE PEND OREILLE SCHOOL DISTRICT 160000200603 293 KOOTENAI ELEMENTARY SCHOOL   Regular School No Elementary KG 6.0 2017   kindergarten 38 0 1   1 0     0   3   24 19             23         43 38 0 1   1 0     0   3   24 19         23       43
1726869 ID     school 1600002 84   LAKE PEND OREILLE SCHOOL DISTRICT 160000200614 401 HOPE ELEMENTARY SCHOOL   Regular School No Elementary PK 6.0 2017   grade_1 11 0 0   0 0     0   1   7 5             *         12 11 0 0   0 0     0   1   7 5                 12
1726870 ID     school 1600002 84   LAKE PEND OREILLE SCHOOL DISTRICT 160000200614 401 HOPE ELEMENTARY SCHOOL   Regular School No Elementary PK 6.0 2017   grade_2 13 0 2   0 0     0   0   12 3             10         15 13 0 2   0 0     0   0   12 3         10       15
1726871 ID     school 1600002 84   LAKE PEND OREILLE SCHOOL DISTRICT 160000200614 401 HOPE ELEMENTARY SCHOOL   Regular School No Elementary PK 6.0 2017   grade_3 16 0 0   0 1     0   0   5 12             8         17 16 0 0   0 1     0   0   5 12         8       17
1726872 ID     school 1600002 84   LAKE PEND OREILLE SCHOOL DISTRICT 160000200614 401 HOPE ELEMENTARY SCHOOL   Regular School No Elementary PK 6.0 2017   grade_4 15 0 0   0 0     0   0   5 10             *         15 15 0 0   0 0     0   0   5 10                 15
1726873 ID     school 1600002 84   LAKE PEND OREILLE SCHOOL DISTRICT 160000200614 401 HOPE ELEMENTARY SCHOOL   Regular School No Elementary PK 6.0 2017   grade_5 18 0 0   1 0     0   0   9 10             12         19 18 0 0   1 0     0   0   9 10         12       19
1726874 ID     school 1600002 84   LAKE PEND OREILLE SCHOOL DISTRICT 160000200614 401 HOPE ELEMENTARY SCHOOL   Regular School No Elementary PK 6.0 2017   grade_6 11 0 1   0 0     0   2   5 9             *         14 11 0 1   0 0     0   2   5 9                 14
1726875 ID     school 1600002 84   LAKE PEND OREILLE SCHOOL DISTRICT 160000200614 401 HOPE ELEMENTARY SCHOOL   Regular School No Elementary PK 6.0 2017   k_12_total 100 0 4   1 1     0   3   54 55             63         109 100 0 4   1 1     0   3   54 55         63       109
1726876 ID     school 1600002 84   LAKE PEND OREILLE SCHOOL DISTRICT 160000200614 401 HOPE ELEMENTARY SCHOOL   Regular School No Elementary PK 6.0 2017   kindergarten 16 0 1   0 0     0   0   11 6             8         17 16 0 1   0 0     0   0   11 6         8       17
1726877 ID     school 1600002 84   LAKE PEND OREILLE SCHOOL DISTRICT 160000200618 402 SAGLE ELEMENTARY SCHOOL   Regular School No Elementary PK 6.0 2017   grade_1 29 0 1   0 0     0   1   16 15             17         31 29 0 1   0 0     0   1   16 15         17       31
1726878 ID     school 1600002 84   LAKE PEND OREILLE SCHOOL DISTRICT 160000200618 402 SAGLE ELEMENTARY SCHOOL   Regular School No Elementary PK 6.0 2017   grade_2 35 0 1   0 0     0   3   20 19             23         39 35 0 1   0 0     0   3   20 19         23       39
1726879 ID     school 1600002 84   LAKE PEND OREILLE SCHOOL DISTRICT 160000200618 402 SAGLE ELEMENTARY SCHOOL   Regular School No Elementary PK 6.0 2017   grade_3 39 0 3   1 0     0   2   21 24             18         45 39 0 3   1 0     0   2   21 24         18       45
1726880 ID     school 1600002 84   LAKE PEND OREILLE SCHOOL DISTRICT 160000200618 402 SAGLE ELEMENTARY SCHOOL   Regular School No Elementary PK 6.0 2017   grade_4 47 0 4   0 0     0   2   27 26             22         53 47 0 4   0 0     0   2   27 26         22       53
1726881 ID     school 1600002 84   LAKE PEND OREILLE SCHOOL DISTRICT 160000200618 402 SAGLE ELEMENTARY SCHOOL   Regular School No Elementary PK 6.0 2017   grade_5 33 0 4   0 0     0   4   18 23             15         41 33 0 4   0 0     0   4   18 23         15       41
1726882 ID     school 1600002 84   LAKE PEND OREILLE SCHOOL DISTRICT 160000200618 402 SAGLE ELEMENTARY SCHOOL   Regular School No Elementary PK 6.0 2017   grade_6 34 0 3   0 0     0   2   23 16             21         39 34 0 3   0 0     0   2   23 16         21       39
1726883 ID     school 1600002 84   LAKE PEND OREILLE SCHOOL DISTRICT 160000200618 402 SAGLE ELEMENTARY SCHOOL   Regular School No Elementary PK 6.0 2017   k_12_total 254 0 16   1 1     0   14   145 141             135         286 254 0 16   1 1     0   14   145 141         135       286
1726884 ID     school 1600002 84   LAKE PEND OREILLE SCHOOL DISTRICT 160000200618 402 SAGLE ELEMENTARY SCHOOL   Regular School No Elementary PK 6.0 2017   kindergarten 37 0 0   0 1     0   0   20 18             19         38 37 0 0   0 1     0   0   20 18         19       38
1726885 ID     school 1600002 84   LAKE PEND OREILLE SCHOOL DISTRICT 160000200615 403 FARMIN STIDWELL ELEMENTARY SCHOOL   Regular School No Elementary PK 6.0 2017   grade_1 62 1 4   0 1     0   8   39 37             40         76 62 1 4   0 1     0   8   39 37         40       76
1726886 ID     school 1600002 84   LAKE PEND OREILLE SCHOOL DISTRICT 160000200615 403 FARMIN STIDWELL ELEMENTARY SCHOOL   Regular School No Elementary PK 6.0 2017   grade_2 61 0 8   0 2     0   5   34 42             52         76 61 0 8   0 2     0   5   34 42         52       76
1726887 ID     school 1600002 84   LAKE PEND OREILLE SCHOOL DISTRICT 160000200615 403 FARMIN STIDWELL ELEMENTARY SCHOOL   Regular School No Elementary PK 6.0 2017   grade_3 61 0 4   0 0     0   6   41 30             42         71 61 0 4   0 0     0   6   41 30         42       71
1726888 ID     school 1600002 84   LAKE PEND OREILLE SCHOOL DISTRICT 160000200615 403 FARMIN STIDWELL ELEMENTARY SCHOOL   Regular School No Elementary PK 6.0 2017   grade_4 64 1 6   0 0     0   2   51 22             44         73 64 1 6   0 0     0   2   51 22         44       73
1726889 ID     school 1600002 84   LAKE PEND OREILLE SCHOOL DISTRICT 160000200615 403 FARMIN STIDWELL ELEMENTARY SCHOOL   Regular School No Elementary PK 6.0 2017   grade_5 55 0 4   1 0     0   6   33 33             35         66 55 0 4   1 0     0   6   33 33         35       66
1726890 ID     school 1600002 84   LAKE PEND OREILLE SCHOOL DISTRICT 160000200615 403 FARMIN STIDWELL ELEMENTARY SCHOOL   Regular School No Elementary PK 6.0 2017   grade_6 58 2 7   0 0     0   2   42 27             31         69 58 2 7   0 0     0   2   42 27         31       69
1726891 ID     school 1600002 84   LAKE PEND OREILLE SCHOOL DISTRICT 160000200615 403 FARMIN STIDWELL ELEMENTARY SCHOOL   Regular School No Elementary PK 6.0 2017   k_12_total 417 4 41   1 3     0   33   271 228             288         499 417 4 41   1 3     0   33   271 228         288       499
1726892 ID     school 1600002 84   LAKE PEND OREILLE SCHOOL DISTRICT 160000200615 403 FARMIN STIDWELL ELEMENTARY SCHOOL   Regular School No Elementary PK 6.0 2017   kindergarten 56 0 8   0 0     0   4   31 37             44         68 56 0 8   0 0     0   4   31 37         44       68
1726893 ID     school 1600002 84   LAKE PEND OREILLE SCHOOL DISTRICT 160000200616 405 SOUTHSIDE ELEMENTARY SCHOOL   Regular School No Elementary PK 6.0 2017   grade_1 14 0 0   0 0     0   0   8 6             *         14 14 0 0   0 0     0   0   8 6                 14
1726894 ID     school 1600002 84   LAKE PEND OREILLE SCHOOL DISTRICT 160000200616 405 SOUTHSIDE ELEMENTARY SCHOOL   Regular School No Elementary PK 6.0 2017   grade_2 18 0 0   0 0     0   1   13 6             10         19 18 0 0   0 0     0   1   13 6         10       19
1726895 ID     school 1600002 84   LAKE PEND OREILLE SCHOOL DISTRICT 160000200616 405 SOUTHSIDE ELEMENTARY SCHOOL   Regular School No Elementary PK 6.0 2017   grade_3 20 0 1   1 1     0   1   11 13             10         24 20 0 1   1 1     0   1   11 13         10       24
1726896 ID     school 1600002 84   LAKE PEND OREILLE SCHOOL DISTRICT 160000200616 405 SOUTHSIDE ELEMENTARY SCHOOL   Regular School No Elementary PK 6.0 2017   grade_4 20 0 1   0 0     0   0   8 13             10         21 20 0 1   0 0     0   0   8 13         10       21
1726897 ID     school 1600002 84   LAKE PEND OREILLE SCHOOL DISTRICT 160000200616 405 SOUTHSIDE ELEMENTARY SCHOOL   Regular School No Elementary PK 6.0 2017   grade_5 16 0 1   1 0     0   0   9 9             11         18 16 0 1   1 0     0   0   9 9         11       18
1726898 ID     school 1600002 84   LAKE PEND OREILLE SCHOOL DISTRICT 160000200616 405 SOUTHSIDE ELEMENTARY SCHOOL   Regular School No Elementary PK 6.0 2017   grade_6 12 0 2   0 0     0   2   10 6             *         16 12 0 2   0 0     0   2   10 6                 16
1726899 ID     school 1600002 84   LAKE PEND OREILLE SCHOOL DISTRICT 160000200616 405 SOUTHSIDE ELEMENTARY SCHOOL   Regular School No Elementary PK 6.0 2017   k_12_total 119 0 5   2 1     0   5   71 61             69         132 119 0 5   2 1     0   5   71 61         69       132
1726900 ID     school 1600002 84   LAKE PEND OREILLE SCHOOL DISTRICT 160000200616 405 SOUTHSIDE ELEMENTARY SCHOOL   Regular School No Elementary PK 6.0 2017   kindergarten 19 0 0   0 0     0   1   12 8             10         20 19 0 0   0 0     0   1   12 8         10       20
1726901 ID     school 1600002 84   LAKE PEND OREILLE SCHOOL DISTRICT 160000200617 408 WASHINGTON ELEMENTARY SCHOOL   Regular School No Elementary PK 6.0 2017   grade_1 40 0 1   1 0     0   4   23 23             15         46 40 0 1   1 0     0   4   23 23         15       46
1726902 ID     school 1600002 84   LAKE PEND OREILLE SCHOOL DISTRICT 160000200617 408 WASHINGTON ELEMENTARY SCHOOL   Regular School No Elementary PK 6.0 2017   grade_2 43 0 4   1 0     0   1   24 25             23         49 43 0 4   1 0     0   1   24 25         23       49
1726903 ID     school 1600002 84   LAKE PEND OREILLE SCHOOL DISTRICT 160000200617 408 WASHINGTON ELEMENTARY SCHOOL   Regular School No Elementary PK 6.0 2017   grade_3 32 0 0   1 2     0   1   26 10             16         36 32 0 0   1 2     0   1   26 10         16       36
1726904 ID     school 1600002 84   LAKE PEND OREILLE SCHOOL DISTRICT 160000200617 408 WASHINGTON ELEMENTARY SCHOOL   Regular School No Elementary PK 6.0 2017   grade_4 42 0 2   1 0     1   2   26 22             14         48 42 0 2   1 0     1   2   26 22         14       48
1726905 ID     school 1600002 84   LAKE PEND OREILLE SCHOOL DISTRICT 160000200617 408 WASHINGTON ELEMENTARY SCHOOL   Regular School No Elementary PK 6.0 2017   grade_5 46 0 2   1 0     0   4   27 26             17         53 46 0 2   1 0     0   4   27 26         17       53
1726906 ID     school 1600002 84   LAKE PEND OREILLE SCHOOL DISTRICT 160000200617 408 WASHINGTON ELEMENTARY SCHOOL   Regular School No Elementary PK 6.0 2017   grade_6 33 0 5   2 0     0   5   23 22             14         45 33 0 5   2 0     0   5   23 22         14       45
1726907 ID     school 1600002 84   LAKE PEND OREILLE SCHOOL DISTRICT 160000200617 408 WASHINGTON ELEMENTARY SCHOOL   Regular School No Elementary PK 6.0 2017   k_12_total 261 0 15   8 2     1   18   160 145             112         305 261 0 15   8 2     1   18   160 145         112       305
1726908 ID     school 1600002 84   LAKE PEND OREILLE SCHOOL DISTRICT 160000200617 408 WASHINGTON ELEMENTARY SCHOOL   Regular School No Elementary PK 6.0 2017   kindergarten 25 0 1   1 0     0   1   11 17             13         28 25 0 1   1 0     0   1   11 17         13       28

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