Data source: Big Local News · About: Big Local

33,441 rows where state = "ID" sorted by district_nces_id

View and edit SQL

grade

year

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
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
1821807 ID     school 1600001 83   WEST BONNER COUNTY DISTRICT 160000100085 44 PRIEST RIVER JR HIGH SCHOOL   Regular School No 2.0 07 08 2016   grade_7 75 0 1   0 0     0   1   35 42             39         77 75 0 1   0 0     0   1   35 42         39       77
1821808 ID     school 1600001 83   WEST BONNER COUNTY DISTRICT 160000100085 44 PRIEST RIVER JR HIGH SCHOOL   Regular School No 2.0 07 08 2016   grade_8 80 0 1   1 0     0   4   50 36             43         86 80 0 1   1 0     0   4   50 36         43       86
1821809 ID     school 1600001 83   WEST BONNER COUNTY DISTRICT 160000100085 44 PRIEST RIVER JR HIGH SCHOOL   Regular School No 2.0 07 08 2016   k_12_total 155 0 2   1 0     0   5   85 78             82         163 155 0 2   1 0     0   5   85 78         82       163
1821810 ID     school 1600001 83   WEST BONNER COUNTY DISTRICT 160000100084 48 PRIEST RIVER LAMANNA HIGH   Regular School No 3.0 09 12 2016   grade_10 77 0 7   0 0     0   2   57 29             *         86 77 0 7   0 0     0   2   57 29                 86
1821811 ID     school 1600001 83   WEST BONNER COUNTY DISTRICT 160000100084 48 PRIEST RIVER LAMANNA HIGH   Regular School No 3.0 09 12 2016   grade_11 82 0 4   1 1     0   2   55 35             *         90 82 0 4   1 1     0   2   55 35                 90
1821812 ID     school 1600001 83   WEST BONNER COUNTY DISTRICT 160000100084 48 PRIEST RIVER LAMANNA HIGH   Regular School No 3.0 09 12 2016   grade_12 63 0 1   0 0     0   1   37 28             *         65 63 0 1   0 0     0   1   37 28                 65
1821813 ID     school 1600001 83   WEST BONNER COUNTY DISTRICT 160000100084 48 PRIEST RIVER LAMANNA HIGH   Regular School No 3.0 09 12 2016   grade_9 99 1 2   0 0     0   4   52 54             *         106 99 1 2   0 0     0   4   52 54                 106
1821814 ID     school 1600001 83   WEST BONNER COUNTY DISTRICT 160000100084 48 PRIEST RIVER LAMANNA HIGH   Regular School No 3.0 09 12 2016   k_12_total 321 1 14   1 1     0   9   201 146             172         347 321 1 14   1 1     0   9   201 146         172       347
1821815 ID     school 1600001 83   WEST BONNER COUNTY DISTRICT 160000100620 406 PRIEST LAKE ELEMENTARY SCHOOL   Regular School No 1.0 PK 06 2016   grade_1 6 0 0   0 0     0   0   3 3             *         6 6 0 0   0 0     0   0   3 3                 6
1821816 ID     school 1600001 83   WEST BONNER COUNTY DISTRICT 160000100620 406 PRIEST LAKE ELEMENTARY SCHOOL   Regular School No 1.0 PK 06 2016   grade_2 4 0 0   0 0     0   0   3 1             *         4 4 0 0   0 0     0   0   3 1                 4
1821817 ID     school 1600001 83   WEST BONNER COUNTY DISTRICT 160000100620 406 PRIEST LAKE ELEMENTARY SCHOOL   Regular School No 1.0 PK 06 2016   grade_3 4 0 0   0 0     0   0   2 2             *         4 4 0 0   0 0     0   0   2 2                 4
1821818 ID     school 1600001 83   WEST BONNER COUNTY DISTRICT 160000100620 406 PRIEST LAKE ELEMENTARY SCHOOL   Regular School No 1.0 PK 06 2016   grade_4 4 0 0   0 0     0   0   3 1             *         4 4 0 0   0 0     0   0   3 1                 4
1821819 ID     school 1600001 83   WEST BONNER COUNTY DISTRICT 160000100620 406 PRIEST LAKE ELEMENTARY SCHOOL   Regular School No 1.0 PK 06 2016   grade_5 2 0 0   0 0     0   0   1 1             *         2 2 0 0   0 0     0   0   1 1                 2
1821820 ID     school 1600001 83   WEST BONNER COUNTY DISTRICT 160000100620 406 PRIEST LAKE ELEMENTARY SCHOOL   Regular School No 1.0 PK 06 2016   grade_6 4 0 0   0 0     0   0   1 3             *         4 4 0 0   0 0     0   0   1 3                 4
1821821 ID     school 1600001 83   WEST BONNER COUNTY DISTRICT 160000100620 406 PRIEST LAKE ELEMENTARY SCHOOL   Regular School No 1.0 PK 06 2016   k_12_total 34 0 0   0 0     0   0   18 16             18         34 34 0 0   0 0     0   0   18 16         18       34
1821822 ID     school 1600001 83   WEST BONNER COUNTY DISTRICT 160000100620 406 PRIEST LAKE ELEMENTARY SCHOOL   Regular School No 1.0 PK 06 2016   kindergarten 10 0 0   0 0     0   0   5 5             *         10 10 0 0   0 0     0   0   5 5                 10
1821823 ID     school 1600001 83   WEST BONNER COUNTY DISTRICT 160000100619 407 PRIEST RIVER ELEMENTARY SCHOOL   Regular School No 1.0 PK 06 2016   grade_1 54 0 2   0 0     0   3   27 32             37         59 54 0 2   0 0     0   3   27 32         37       59
1821824 ID     school 1600001 83   WEST BONNER COUNTY DISTRICT 160000100619 407 PRIEST RIVER ELEMENTARY SCHOOL   Regular School No 1.0 PK 06 2016   grade_2 45 0 4   0 0     1   2   28 24             26         52 45 0 4   0 0     1   2   28 24         26       52
1821825 ID     school 1600001 83   WEST BONNER COUNTY DISTRICT 160000100619 407 PRIEST RIVER ELEMENTARY SCHOOL   Regular School No 1.0 PK 06 2016   grade_3 46 0 1   0 0     0   4   30 21             34         51 46 0 1   0 0     0   4   30 21         34       51
1821826 ID     school 1600001 83   WEST BONNER COUNTY DISTRICT 160000100619 407 PRIEST RIVER ELEMENTARY SCHOOL   Regular School No 1.0 PK 06 2016   grade_4 50 0 1   0 0     1   6   28 30             35         58 50 0 1   0 0     1   6   28 30         35       58
1821827 ID     school 1600001 83   WEST BONNER COUNTY DISTRICT 160000100619 407 PRIEST RIVER ELEMENTARY SCHOOL   Regular School No 1.0 PK 06 2016   grade_5 51 0 0   0 1     0   1   28 25             32         53 51 0 0   0 1     0   1   28 25         32       53
1821828 ID     school 1600001 83   WEST BONNER COUNTY DISTRICT 160000100619 407 PRIEST RIVER ELEMENTARY SCHOOL   Regular School No 1.0 PK 06 2016   grade_6 64 0 1   1 0     0   1   46 21             46         67 64 0 1   1 0     0   1   46 21         46       67
1821829 ID     school 1600001 83   WEST BONNER COUNTY DISTRICT 160000100619 407 PRIEST RIVER ELEMENTARY SCHOOL   Regular School No 1.0 PK 06 2016   k_12_total 345 0 13   1 1     2   18   208 172             236         380 345 0 13   1 1     2   18   208 172         236       380
1821830 ID     school 1600001 83   WEST BONNER COUNTY DISTRICT 160000100619 407 PRIEST RIVER ELEMENTARY SCHOOL   Regular School No 1.0 PK 06 2016   kindergarten 35 0 4   0 0     0   1   21 19             26         40 35 0 4   0 0     0   1   21 19         26       40
1821831 ID     school 1600001 83   WEST BONNER COUNTY DISTRICT 160000100613 411 IDAHO HILL ELEMENTARY SCHOOL   Regular School No 1.0 PK 06 2016   grade_1 19 0 0   0 0     0   1   6 14             *         20 19 0 0   0 0     0   1   6 14                 20
1821832 ID     school 1600001 83   WEST BONNER COUNTY DISTRICT 160000100613 411 IDAHO HILL ELEMENTARY SCHOOL   Regular School No 1.0 PK 06 2016   grade_2 17 0 0   0 0     0   0   7 10             *         17 17 0 0   0 0     0   0   7 10                 17
1821833 ID     school 1600001 83   WEST BONNER COUNTY DISTRICT 160000100613 411 IDAHO HILL ELEMENTARY SCHOOL   Regular School No 1.0 PK 06 2016   grade_3 18 0 1   0 0     0   3   11 11             *         22 18 0 1   0 0     0   3   11 11                 22
1821834 ID     school 1600001 83   WEST BONNER COUNTY DISTRICT 160000100613 411 IDAHO HILL ELEMENTARY SCHOOL   Regular School No 1.0 PK 06 2016   grade_4 15 0 0   1 0     0   1   7 10             *         17 15 0 0   1 0     0   1   7 10                 17
1821835 ID     school 1600001 83   WEST BONNER COUNTY DISTRICT 160000100613 411 IDAHO HILL ELEMENTARY SCHOOL   Regular School No 1.0 PK 06 2016   grade_5 13 0 2   0 1     0   0   8 8             *         16 13 0 2   0 1     0   0   8 8                 16
1821836 ID     school 1600001 83   WEST BONNER COUNTY DISTRICT 160000100613 411 IDAHO HILL ELEMENTARY SCHOOL   Regular School No 1.0 PK 06 2016   grade_6 17 0 2   0 0     0   2   12 9             *         21 17 0 2   0 0     0   2   12 9                 21
1821837 ID     school 1600001 83   WEST BONNER COUNTY DISTRICT 160000100613 411 IDAHO HILL ELEMENTARY SCHOOL   Regular School No 1.0 PK 06 2016   k_12_total 114 0 6   1 1     0   8   58 72             84         130 114 0 6   1 1     0   8   58 72         84       130
1821838 ID     school 1600001 83   WEST BONNER COUNTY DISTRICT 160000100613 411 IDAHO HILL ELEMENTARY SCHOOL   Regular School No 1.0 PK 06 2016   kindergarten 15 0 1   0 0     0   1   7 10             *         17 15 0 1   0 0     0   1   7 10                 17
1821839 ID     school 1600001 83   WEST BONNER COUNTY DISTRICT 160000100771 1172 PRIEST RIVER EDUCATIONAL PROGRAM (PREP)   Alternative Education School No 3.0 09 12 2016   grade_10 1 0 0   0 0     0   0   1 0             *         1 1 0 0   0 0     0   0   1 0                 1
1821840 ID     school 1600001 83   WEST BONNER COUNTY DISTRICT 160000100771 1172 PRIEST RIVER EDUCATIONAL PROGRAM (PREP)   Alternative Education School No 3.0 09 12 2016   grade_11 7 0 0   0 0     0   0   5 2             *         7 7 0 0   0 0     0   0   5 2                 7
1821841 ID     school 1600001 83   WEST BONNER COUNTY DISTRICT 160000100771 1172 PRIEST RIVER EDUCATIONAL PROGRAM (PREP)   Alternative Education School No 3.0 09 12 2016   grade_12 7 0 0   0 0     0   1   4 4             *         8 7 0 0   0 0     0   1   4 4                 8
1821842 ID     school 1600001 83   WEST BONNER COUNTY DISTRICT 160000100771 1172 PRIEST RIVER EDUCATIONAL PROGRAM (PREP)   Alternative Education School No 3.0 09 12 2016   grade_9 1 0 0   0 0     0   1   2 0             *         2 1 0 0   0 0     0   1   2 0                 2
1821843 ID     school 1600001 83   WEST BONNER COUNTY DISTRICT 160000100771 1172 PRIEST RIVER EDUCATIONAL PROGRAM (PREP)   Alternative Education School No 3.0 09 12 2016   k_12_total 16 0 0   0 0     0   2   12 6             11         18 16 0 0   0 0     0   2   12 6         11       18
704097 ID     school 1600002 84   LAKE PEND OREILLE SCHOOL DISTRICT 160000200724 47 SANDPOINT MIDDLE SCHOOL   Regular School No Middle 07 08 2021   grade_7 211 0 8   2 6     2   16   124 121             *         245 211 0 8   2 6     2   16   124 121                 245
704098 ID     school 1600002 84   LAKE PEND OREILLE SCHOOL DISTRICT 160000200724 47 SANDPOINT MIDDLE SCHOOL   Regular School No Middle 07 08 2021   grade_8 216 2 11   1 2     1   6   134 105             *         239 216 2 11   1 2     1   6   134 105                 239
704099 ID     school 1600002 84   LAKE PEND OREILLE SCHOOL DISTRICT 160000200724 47 SANDPOINT MIDDLE SCHOOL   Regular School No Middle 07 08 2021   k_12_total 427 2 19   3 8     3   22   258 226             141         484 427 2 19   3 8     3   22   258 226         141       484
704100 ID     school 1600002 84   LAKE PEND OREILLE SCHOOL DISTRICT 160000200082 49 CLARK FORK JR/SR HIGH SCHOOL   Regular School No High 07 12 2021   grade_10 13 0 2   0 0     1   1   10 7             *         17 13 0 2   0 0     1   1   10 7                 17
704101 ID     school 1600002 84   LAKE PEND OREILLE SCHOOL DISTRICT 160000200082 49 CLARK FORK JR/SR HIGH SCHOOL   Regular School No High 07 12 2021   grade_11 22 0 0   1 0     0   0   11 12             *         23 22 0 0   1 0     0   0   11 12                 23
704102 ID     school 1600002 84   LAKE PEND OREILLE SCHOOL DISTRICT 160000200082 49 CLARK FORK JR/SR HIGH SCHOOL   Regular School No High 07 12 2021   grade_12 21 0 1   0 0     0   0   13 9             *         22 21 0 1   0 0     0   0   13 9                 22
704103 ID     school 1600002 84   LAKE PEND OREILLE SCHOOL DISTRICT 160000200082 49 CLARK FORK JR/SR HIGH SCHOOL   Regular School No High 07 12 2021   grade_7 16 0 0   0 0     0   0   5 11             *         16 16 0 0   0 0     0   0   5 11                 16
704104 ID     school 1600002 84   LAKE PEND OREILLE SCHOOL DISTRICT 160000200082 49 CLARK FORK JR/SR HIGH SCHOOL   Regular School No High 07 12 2021   grade_8 22 0 0   0 0     0   0   12 10             *         22 22 0 0   0 0     0   0   12 10                 22
704105 ID     school 1600002 84   LAKE PEND OREILLE SCHOOL DISTRICT 160000200082 49 CLARK FORK JR/SR HIGH SCHOOL   Regular School No High 07 12 2021   grade_9 26 0 0   2 0     0   0   16 12             *         28 26 0 0   2 0     0   0   16 12                 28
704106 ID     school 1600002 84   LAKE PEND OREILLE SCHOOL DISTRICT 160000200082 49 CLARK FORK JR/SR HIGH SCHOOL   Regular School No High 07 12 2021   k_12_total 120 0 3   3 0     1   1   67 61             41         128 120 0 3   3 0     1   1   67 61         41       128
704107 ID     school 1600002 84   LAKE PEND OREILLE SCHOOL DISTRICT 160000200087 202 SANDPOINT HIGH SCHOOL   Regular School No High 07 12 2021   grade_10 215 1 15   2 1     0   16   127 123             49         250 215 1 15   2 1     0   16   127 123         49       250
704108 ID     school 1600002 84   LAKE PEND OREILLE SCHOOL DISTRICT 160000200087 202 SANDPOINT HIGH SCHOOL   Regular School No High 07 12 2021   grade_11 188 1 3   2 1     0   9   115 89             25         204 188 1 3   2 1     0   9   115 89         25       204
704109 ID     school 1600002 84   LAKE PEND OREILLE SCHOOL DISTRICT 160000200087 202 SANDPOINT HIGH SCHOOL   Regular School No High 07 12 2021   grade_12 201 1 11   0 2     0   7   118 104             28         222 201 1 11   0 2     0   7   118 104         28       222
704110 ID     school 1600002 84   LAKE PEND OREILLE SCHOOL DISTRICT 160000200087 202 SANDPOINT HIGH SCHOOL   Regular School No High 07 12 2021   grade_9 221 0 10   2 2     0   10   127 118             50         245 221 0 10   2 2     0   10   127 118         50       245
704111 ID     school 1600002 84   LAKE PEND OREILLE SCHOOL DISTRICT 160000200087 202 SANDPOINT HIGH SCHOOL   Regular School No High 07 12 2021   k_12_total 825 3 39   6 6     0   42   487 434             152         921 825 3 39   6 6     0   42   487 434         152       921
704112 ID     school 1600002 84   LAKE PEND OREILLE SCHOOL DISTRICT 160000200603 293 KOOTENAI ELEMENTARY SCHOOL   Regular School No Elementary KG 06 2021   grade_1 49 1 4   1 0     0   1   28 28             21         56 49 1 4   1 0     0   1   28 28         21       56
704113 ID     school 1600002 84   LAKE PEND OREILLE SCHOOL DISTRICT 160000200603 293 KOOTENAI ELEMENTARY SCHOOL   Regular School No Elementary KG 06 2021   grade_2 48 0 3   0 0     0   2   24 29             21         53 48 0 3   0 0     0   2   24 29         21       53
704114 ID     school 1600002 84   LAKE PEND OREILLE SCHOOL DISTRICT 160000200603 293 KOOTENAI ELEMENTARY SCHOOL   Regular School No Elementary KG 06 2021   grade_3 42 0 8   1 0     0   1   24 28             18         52 42 0 8   1 0     0   1   24 28         18       52
704115 ID     school 1600002 84   LAKE PEND OREILLE SCHOOL DISTRICT 160000200603 293 KOOTENAI ELEMENTARY SCHOOL   Regular School No Elementary KG 06 2021   grade_4 36 0 2   1 0     0   4   23 20             22         43 36 0 2   1 0     0   4   23 20         22       43
704116 ID     school 1600002 84   LAKE PEND OREILLE SCHOOL DISTRICT 160000200603 293 KOOTENAI ELEMENTARY SCHOOL   Regular School No Elementary KG 06 2021   grade_5 58 0 2   0 0     0   2   28 34             29         62 58 0 2   0 0     0   2   28 34         29       62
704117 ID     school 1600002 84   LAKE PEND OREILLE SCHOOL DISTRICT 160000200603 293 KOOTENAI ELEMENTARY SCHOOL   Regular School No Elementary KG 06 2021   grade_6 47 0 5   0 0     0   3   33 22             24         55 47 0 5   0 0     0   3   33 22         24       55
704118 ID     school 1600002 84   LAKE PEND OREILLE SCHOOL DISTRICT 160000200603 293 KOOTENAI ELEMENTARY SCHOOL   Regular School No Elementary KG 06 2021   k_12_total 317 1 26   4 0     0   13   178 183             149         361 317 1 26   4 0     0   13   178 183         149       361
704119 ID     school 1600002 84   LAKE PEND OREILLE SCHOOL DISTRICT 160000200603 293 KOOTENAI ELEMENTARY SCHOOL   Regular School No Elementary KG 06 2021   kindergarten 37 0 2   1 0     0   0   18 22             14         40 37 0 2   1 0     0   0   18 22         14       40
704120 ID     school 1600002 84   LAKE PEND OREILLE SCHOOL DISTRICT 160000200614 401 HOPE ELEMENTARY SCHOOL   Regular School No Elementary PK 06 2021   grade_1 9 0 0   0 0     0   1   6 4             5         10 9 0 0   0 0     0   1   6 4         5       10
704121 ID     school 1600002 84   LAKE PEND OREILLE SCHOOL DISTRICT 160000200614 401 HOPE ELEMENTARY SCHOOL   Regular School No Elementary PK 06 2021   grade_2 13 0 0   0 0     1   0   10 4             *         14 13 0 0   0 0     1   0   10 4                 14
704122 ID     school 1600002 84   LAKE PEND OREILLE SCHOOL DISTRICT 160000200614 401 HOPE ELEMENTARY SCHOOL   Regular School No Elementary PK 06 2021   grade_3 15 0 0   0 0     0   0   6 9             7         15 15 0 0   0 0     0   0   6 9         7       15
704123 ID     school 1600002 84   LAKE PEND OREILLE SCHOOL DISTRICT 160000200614 401 HOPE ELEMENTARY SCHOOL   Regular School No Elementary PK 06 2021   grade_4 16 0 0   0 0     1   0   12 5             5         17 16 0 0   0 0     1   0   12 5         5       17
704124 ID     school 1600002 84   LAKE PEND OREILLE SCHOOL DISTRICT 160000200614 401 HOPE ELEMENTARY SCHOOL   Regular School No Elementary PK 06 2021   grade_5 10 0 0   0 0     0   1   6 5             *         11 10 0 0   0 0     0   1   6 5                 11
704125 ID     school 1600002 84   LAKE PEND OREILLE SCHOOL DISTRICT 160000200614 401 HOPE ELEMENTARY SCHOOL   Regular School No Elementary PK 06 2021   grade_6 16 0 2   0 0     0   0   12 6             7         18 16 0 2   0 0     0   0   12 6         7       18
704126 ID     school 1600002 84   LAKE PEND OREILLE SCHOOL DISTRICT 160000200614 401 HOPE ELEMENTARY SCHOOL   Regular School No Elementary PK 06 2021   k_12_total 94 0 3   0 0     2   2   61 40             45         101 94 0 3   0 0     2   2   61 40         45       101
704127 ID     school 1600002 84   LAKE PEND OREILLE SCHOOL DISTRICT 160000200614 401 HOPE ELEMENTARY SCHOOL   Regular School No Elementary PK 06 2021   kindergarten 15 0 1   0 0     0   0   9 7             7         16 15 0 1   0 0     0   0   9 7         7       16
704128 ID     school 1600002 84   LAKE PEND OREILLE SCHOOL DISTRICT 160000200618 402 SAGLE ELEMENTARY SCHOOL   Regular School No Elementary PK 06 2021   grade_1 31 0 0   0 0     0   1   13 19             11         32 31 0 0   0 0     0   1   13 19         11       32
704129 ID     school 1600002 84   LAKE PEND OREILLE SCHOOL DISTRICT 160000200618 402 SAGLE ELEMENTARY SCHOOL   Regular School No Elementary PK 06 2021   grade_2 40 0 0   0 0     0   2   22 20             12         42 40 0 0   0 0     0   2   22 20         12       42
704130 ID     school 1600002 84   LAKE PEND OREILLE SCHOOL DISTRICT 160000200618 402 SAGLE ELEMENTARY SCHOOL   Regular School No Elementary PK 06 2021   grade_3 21 0 1   0 0     0   2   11 13             7         24 21 0 1   0 0     0   2   11 13         7       24
704131 ID     school 1600002 84   LAKE PEND OREILLE SCHOOL DISTRICT 160000200618 402 SAGLE ELEMENTARY SCHOOL   Regular School No Elementary PK 06 2021   grade_4 29 0 3   0 2     0   1   25 10             13         35 29 0 3   0 2     0   1   25 10         13       35
704132 ID     school 1600002 84   LAKE PEND OREILLE SCHOOL DISTRICT 160000200618 402 SAGLE ELEMENTARY SCHOOL   Regular School No Elementary PK 06 2021   grade_5 29 0 2   0 0     0   1   19 13             10         32 29 0 2   0 0     0   1   19 13         10       32
704133 ID     school 1600002 84   LAKE PEND OREILLE SCHOOL DISTRICT 160000200618 402 SAGLE ELEMENTARY SCHOOL   Regular School No Elementary PK 06 2021   grade_6 35 0 2   0 0     0   2   19 20             16         39 35 0 2   0 0     0   2   19 20         16       39
704134 ID     school 1600002 84   LAKE PEND OREILLE SCHOOL DISTRICT 160000200618 402 SAGLE ELEMENTARY SCHOOL   Regular School No Elementary PK 06 2021   k_12_total 218 0 10   0 3     0   10   127 114             75         241 218 0 10   0 3     0   10   127 114         75       241
704135 ID     school 1600002 84   LAKE PEND OREILLE SCHOOL DISTRICT 160000200618 402 SAGLE ELEMENTARY SCHOOL   Regular School No Elementary PK 06 2021   kindergarten 33 0 2   0 1     0   1   18 19             6         37 33 0 2   0 1     0   1   18 19         6       37
704136 ID     school 1600002 84   LAKE PEND OREILLE SCHOOL DISTRICT 160000200615 403 FARMIN STIDWELL ELEMENTARY SCHOOL   Regular School No Elementary PK 06 2021   grade_1 53 1 3   0 1     0   2   34 26             28         60 53 1 3   0 1     0   2   34 26         28       60
704137 ID     school 1600002 84   LAKE PEND OREILLE SCHOOL DISTRICT 160000200615 403 FARMIN STIDWELL ELEMENTARY SCHOOL   Regular School No Elementary PK 06 2021   grade_2 53 1 3   0 0     0   2   31 28             28         59 53 1 3   0 0     0   2   31 28         28       59
704138 ID     school 1600002 84   LAKE PEND OREILLE SCHOOL DISTRICT 160000200615 403 FARMIN STIDWELL ELEMENTARY SCHOOL   Regular School No Elementary PK 06 2021   grade_3 51 0 7   0 1     0   6   36 29             32         65 51 0 7   0 1     0   6   36 29         32       65
704139 ID     school 1600002 84   LAKE PEND OREILLE SCHOOL DISTRICT 160000200615 403 FARMIN STIDWELL ELEMENTARY SCHOOL   Regular School No Elementary PK 06 2021   grade_4 55 1 7   0 0     0   4   33 34             31         67 55 1 7   0 0     0   4   33 34         31       67
704140 ID     school 1600002 84   LAKE PEND OREILLE SCHOOL DISTRICT 160000200615 403 FARMIN STIDWELL ELEMENTARY SCHOOL   Regular School No Elementary PK 06 2021   grade_5 62 1 6   0 1     0   7   39 38             38         77 62 1 6   0 1     0   7   39 38         38       77
704141 ID     school 1600002 84   LAKE PEND OREILLE SCHOOL DISTRICT 160000200615 403 FARMIN STIDWELL ELEMENTARY SCHOOL   Regular School No Elementary PK 06 2021   grade_6 51 0 4   0 1     0   4   34 26             24         60 51 0 4   0 1     0   4   34 26         24       60
704142 ID     school 1600002 84   LAKE PEND OREILLE SCHOOL DISTRICT 160000200615 403 FARMIN STIDWELL ELEMENTARY SCHOOL   Regular School No Elementary PK 06 2021   k_12_total 355 4 35   1 4     0   27   233 193             200         426 355 4 35   1 4     0   27   233 193         200       426
704143 ID     school 1600002 84   LAKE PEND OREILLE SCHOOL DISTRICT 160000200615 403 FARMIN STIDWELL ELEMENTARY SCHOOL   Regular School No Elementary PK 06 2021   kindergarten 30 0 5   1 0     0   2   26 12             19         38 30 0 5   1 0     0   2   26 12         19       38
704144 ID     school 1600002 84   LAKE PEND OREILLE SCHOOL DISTRICT 160000200616 405 SOUTHSIDE ELEMENTARY SCHOOL   Regular School No Elementary PK 06 2021   grade_1 19 0 0   0 0     0   0   9 10             9         19 19 0 0   0 0     0   0   9 10         9       19
704145 ID     school 1600002 84   LAKE PEND OREILLE SCHOOL DISTRICT 160000200616 405 SOUTHSIDE ELEMENTARY SCHOOL   Regular School No Elementary PK 06 2021   grade_2 15 1 1   0 0     0   4   11 10             14         21 15 1 1   0 0     0   4   11 10         14       21
704146 ID     school 1600002 84   LAKE PEND OREILLE SCHOOL DISTRICT 160000200616 405 SOUTHSIDE ELEMENTARY SCHOOL   Regular School No Elementary PK 06 2021   grade_3 16 0 0   1 0     0   2   12 7             12         19 16 0 0   1 0     0   2   12 7         12       19
704147 ID     school 1600002 84   LAKE PEND OREILLE SCHOOL DISTRICT 160000200616 405 SOUTHSIDE ELEMENTARY SCHOOL   Regular School No Elementary PK 06 2021   grade_4 24 0 1   0 0     0   0   14 11             10         25 24 0 1   0 0     0   0   14 11         10       25
704148 ID     school 1600002 84   LAKE PEND OREILLE SCHOOL DISTRICT 160000200616 405 SOUTHSIDE ELEMENTARY SCHOOL   Regular School No Elementary PK 06 2021   grade_5 14 0 0   0 0     0   0   5 9             *         14 14 0 0   0 0     0   0   5 9                 14

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