Data source: Big Local News · About: Big Local

4,643 rows where state = "ID" and year = 2016 sorted by district_nces_id

View and edit SQL

grade

year

  • 2016 · 4,643
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
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
1821844 ID     school 1600002 84   LAKE PEND OREILLE SCHOOL DISTRICT 160000200724 47 SANDPOINT MIDDLE SCHOOL   Regular School No 2.0 07 08 2016   grade_7 225 1 13   0 1     0   10   134 116             101         250 225 1 13   0 1     0   10   134 116         101       250
1821845 ID     school 1600002 84   LAKE PEND OREILLE SCHOOL DISTRICT 160000200724 47 SANDPOINT MIDDLE SCHOOL   Regular School No 2.0 07 08 2016   grade_8 238 0 12   0 0     1   10   131 130             110         261 238 0 12   0 0     1   10   131 130         110       261
1821846 ID     school 1600002 84   LAKE PEND OREILLE SCHOOL DISTRICT 160000200724 47 SANDPOINT MIDDLE SCHOOL   Regular School No 2.0 07 08 2016   k_12_total 463 1 25   0 1     1   20   265 246             211         511 463 1 25   0 1     1   20   265 246         211       511
1821847 ID     school 1600002 84   LAKE PEND OREILLE SCHOOL DISTRICT 160000200082 49 CLARK FORK JR/SR HIGH SCHOOL   Regular School No 3.0 07 12 2016   grade_10 12 0 1   0 0     0   0   8 5             *         13 12 0 1   0 0     0   0   8 5                 13
1821848 ID     school 1600002 84   LAKE PEND OREILLE SCHOOL DISTRICT 160000200082 49 CLARK FORK JR/SR HIGH SCHOOL   Regular School No 3.0 07 12 2016   grade_11 14 0 0   0 2     1   1   6 12             *         18 14 0 0   0 2     1   1   6 12                 18
1821849 ID     school 1600002 84   LAKE PEND OREILLE SCHOOL DISTRICT 160000200082 49 CLARK FORK JR/SR HIGH SCHOOL   Regular School No 3.0 07 12 2016   grade_12 11 0 1   0 0     0   0   7 5             *         12 11 0 1   0 0     0   0   7 5                 12
1821850 ID     school 1600002 84   LAKE PEND OREILLE SCHOOL DISTRICT 160000200082 49 CLARK FORK JR/SR HIGH SCHOOL   Regular School No 3.0 07 12 2016   grade_7 14 1 1   0 0     0   0   6 10             *         16 14 1 1   0 0     0   0   6 10                 16
1821851 ID     school 1600002 84   LAKE PEND OREILLE SCHOOL DISTRICT 160000200082 49 CLARK FORK JR/SR HIGH SCHOOL   Regular School No 3.0 07 12 2016   grade_8 19 0 1   0 0     1   1   13 9             *         22 19 0 1   0 0     1   1   13 9                 22
1821852 ID     school 1600002 84   LAKE PEND OREILLE SCHOOL DISTRICT 160000200082 49 CLARK FORK JR/SR HIGH SCHOOL   Regular School No 3.0 07 12 2016   grade_9 16 0 1   1 0     0   1   9 10             7         19 16 0 1   1 0     0   1   9 10         7       19
1821853 ID     school 1600002 84   LAKE PEND OREILLE SCHOOL DISTRICT 160000200082 49 CLARK FORK JR/SR HIGH SCHOOL   Regular School No 3.0 07 12 2016   k_12_total 86 1 5   1 2     2   3   49 51             *         100 86 1 5   1 2     2   3   49 51                 100
1821854 ID     school 1600002 84   LAKE PEND OREILLE SCHOOL DISTRICT 160000200087 202 SANDPOINT HIGH SCHOOL   Regular School No 3.0 07 12 2016   grade_10 238 2 11   4 1     0   15   135 136             97         271 238 2 11   4 1     0   15   135 136         97       271
1821855 ID     school 1600002 84   LAKE PEND OREILLE SCHOOL DISTRICT 160000200087 202 SANDPOINT HIGH SCHOOL   Regular School No 3.0 07 12 2016   grade_11 203 1 9   3 0     1   7   111 113             *         224 203 1 9   3 0     1   7   111 113                 224
1821856 ID     school 1600002 84   LAKE PEND OREILLE SCHOOL DISTRICT 160000200087 202 SANDPOINT HIGH SCHOOL   Regular School No 3.0 07 12 2016   grade_12 209 3 8   2 0     1   11   120 114             77         234 209 3 8   2 0     1   11   120 114         77       234
1821857 ID     school 1600002 84   LAKE PEND OREILLE SCHOOL DISTRICT 160000200087 202 SANDPOINT HIGH SCHOOL   Regular School No 3.0 07 12 2016   grade_7 1 0 0   0 0     0   0   0 1             *         1 1 0 0   0 0     0   0   0 1                 1
1821858 ID     school 1600002 84   LAKE PEND OREILLE SCHOOL DISTRICT 160000200087 202 SANDPOINT HIGH SCHOOL   Regular School No 3.0 07 12 2016   grade_8 1 0 0   0 0     0   0   0 1             *         1 1 0 0   0 0     0   0   0 1                 1
1821859 ID     school 1600002 84   LAKE PEND OREILLE SCHOOL DISTRICT 160000200087 202 SANDPOINT HIGH SCHOOL   Regular School No 3.0 07 12 2016   grade_9 234 0 11   3 5     1   19   126 147             123         273 234 0 11   3 5     1   19   126 147         123       273
1821860 ID     school 1600002 84   LAKE PEND OREILLE SCHOOL DISTRICT 160000200087 202 SANDPOINT HIGH SCHOOL   Regular School No 3.0 07 12 2016   k_12_total 886 6 39   12 6     3   52   492 512             358         1004 886 6 39   12 6     3   52   492 512         358       1004
1821861 ID     school 1600002 84   LAKE PEND OREILLE SCHOOL DISTRICT 160000200603 293 KOOTENAI ELEMENTARY SCHOOL   Regular School No 1.0 KG 06 2016   grade_1 62 1 5   0 1     0   0   42 27             40         69 62 1 5   0 1     0   0   42 27         40       69
1821862 ID     school 1600002 84   LAKE PEND OREILLE SCHOOL DISTRICT 160000200603 293 KOOTENAI ELEMENTARY SCHOOL   Regular School No 1.0 KG 06 2016   grade_2 66 1 1   0 0     0   2   24 46             44         70 66 1 1   0 0     0   2   24 46         44       70
1821863 ID     school 1600002 84   LAKE PEND OREILLE SCHOOL DISTRICT 160000200603 293 KOOTENAI ELEMENTARY SCHOOL   Regular School No 1.0 KG 06 2016   grade_3 48 0 2   0 0     0   0   27 23             30         50 48 0 2   0 0     0   0   27 23         30       50
1821864 ID     school 1600002 84   LAKE PEND OREILLE SCHOOL DISTRICT 160000200603 293 KOOTENAI ELEMENTARY SCHOOL   Regular School No 1.0 KG 06 2016   grade_4 47 0 5   0 3     0   4   33 26             36         59 47 0 5   0 3     0   4   33 26         36       59
1821865 ID     school 1600002 84   LAKE PEND OREILLE SCHOOL DISTRICT 160000200603 293 KOOTENAI ELEMENTARY SCHOOL   Regular School No 1.0 KG 06 2016   grade_5 43 0 6   0 0     0   5   28 26             34         54 43 0 6   0 0     0   5   28 26         34       54
1821866 ID     school 1600002 84   LAKE PEND OREILLE SCHOOL DISTRICT 160000200603 293 KOOTENAI ELEMENTARY SCHOOL   Regular School No 1.0 KG 06 2016   grade_6 43 0 3   1 0     0   0   28 19             21         47 43 0 3   1 0     0   0   28 19         21       47
1821867 ID     school 1600002 84   LAKE PEND OREILLE SCHOOL DISTRICT 160000200603 293 KOOTENAI ELEMENTARY SCHOOL   Regular School No 1.0 KG 06 2016   k_12_total 358 2 24   1 4     0   12   208 193             233         401 358 2 24   1 4     0   12   208 193         233       401
1821868 ID     school 1600002 84   LAKE PEND OREILLE SCHOOL DISTRICT 160000200603 293 KOOTENAI ELEMENTARY SCHOOL   Regular School No 1.0 KG 06 2016   kindergarten 49 0 2   0 0     0   1   26 26             28         52 49 0 2   0 0     0   1   26 26         28       52
1821869 ID     school 1600002 84   LAKE PEND OREILLE SCHOOL DISTRICT 160000200614 401 HOPE ELEMENTARY SCHOOL   Regular School No 1.0 PK 06 2016   grade_1 9 0 2   0 0     0   0   9 2             5         11 9 0 2   0 0     0   0   9 2         5       11
1821870 ID     school 1600002 84   LAKE PEND OREILLE SCHOOL DISTRICT 160000200614 401 HOPE ELEMENTARY SCHOOL   Regular School No 1.0 PK 06 2016   grade_2 15 0 0   0 0     0   0   8 7             6         15 15 0 0   0 0     0   0   8 7         6       15
1821871 ID     school 1600002 84   LAKE PEND OREILLE SCHOOL DISTRICT 160000200614 401 HOPE ELEMENTARY SCHOOL   Regular School No 1.0 PK 06 2016   grade_3 14 0 0   0 0     0   0   6 8             5         14 14 0 0   0 0     0   0   6 8         5       14
1821872 ID     school 1600002 84   LAKE PEND OREILLE SCHOOL DISTRICT 160000200614 401 HOPE ELEMENTARY SCHOOL   Regular School No 1.0 PK 06 2016   grade_4 15 0 0   1 0     0   0   8 8             9         16 15 0 0   1 0     0   0   8 8         9       16
1821873 ID     school 1600002 84   LAKE PEND OREILLE SCHOOL DISTRICT 160000200614 401 HOPE ELEMENTARY SCHOOL   Regular School No 1.0 PK 06 2016   grade_5 8 0 1   0 0     0   1   4 6             *         10 8 0 1   0 0     0   1   4 6                 10
1821874 ID     school 1600002 84   LAKE PEND OREILLE SCHOOL DISTRICT 160000200614 401 HOPE ELEMENTARY SCHOOL   Regular School No 1.0 PK 06 2016   grade_6 21 0 0   0 0     0   0   10 11             14         21 21 0 0   0 0     0   0   10 11         14       21
1821875 ID     school 1600002 84   LAKE PEND OREILLE SCHOOL DISTRICT 160000200614 401 HOPE ELEMENTARY SCHOOL   Regular School No 1.0 PK 06 2016   k_12_total 92 0 3   1 0     0   2   51 47             47         98 92 0 3   1 0     0   2   51 47         47       98
1821876 ID     school 1600002 84   LAKE PEND OREILLE SCHOOL DISTRICT 160000200614 401 HOPE ELEMENTARY SCHOOL   Regular School No 1.0 PK 06 2016   kindergarten 10 0 0   0 0     0   1   6 5             *         11 10 0 0   0 0     0   1   6 5                 11
1821877 ID     school 1600002 84   LAKE PEND OREILLE SCHOOL DISTRICT 160000200618 402 SAGLE ELEMENTARY SCHOOL   Regular School No 1.0 PK 06 2016   grade_1 36 0 1   0 0     0   1   19 19             23         38 36 0 1   0 0     0   1   19 19         23       38
1821878 ID     school 1600002 84   LAKE PEND OREILLE SCHOOL DISTRICT 160000200618 402 SAGLE ELEMENTARY SCHOOL   Regular School No 1.0 PK 06 2016   grade_2 44 0 3   2 0     1   2   27 25             28         52 44 0 3   2 0     1   2   27 25         28       52
1821879 ID     school 1600002 84   LAKE PEND OREILLE SCHOOL DISTRICT 160000200618 402 SAGLE ELEMENTARY SCHOOL   Regular School No 1.0 PK 06 2016   grade_3 39 0 3   0 0     0   1   21 22             20         43 39 0 3   0 0     0   1   21 22         20       43
1821880 ID     school 1600002 84   LAKE PEND OREILLE SCHOOL DISTRICT 160000200618 402 SAGLE ELEMENTARY SCHOOL   Regular School No 1.0 PK 06 2016   grade_4 34 0 3   0 0     0   5   18 24             23         42 34 0 3   0 0     0   5   18 24         23       42
1821881 ID     school 1600002 84   LAKE PEND OREILLE SCHOOL DISTRICT 160000200618 402 SAGLE ELEMENTARY SCHOOL   Regular School No 1.0 PK 06 2016   grade_5 37 0 3   1 0     0   0   25 16             17         41 37 0 3   1 0     0   0   25 16         17       41
1821882 ID     school 1600002 84   LAKE PEND OREILLE SCHOOL DISTRICT 160000200618 402 SAGLE ELEMENTARY SCHOOL   Regular School No 1.0 PK 06 2016   grade_6 33 0 1   0 0     0   1   18 17             18         35 33 0 1   0 0     0   1   18 17         18       35
1821883 ID     school 1600002 84   LAKE PEND OREILLE SCHOOL DISTRICT 160000200618 402 SAGLE ELEMENTARY SCHOOL   Regular School No 1.0 PK 06 2016   k_12_total 251 0 15   3 0     1   10   141 139             148         280 251 0 15   3 0     1   10   141 139         148       280
1821884 ID     school 1600002 84   LAKE PEND OREILLE SCHOOL DISTRICT 160000200618 402 SAGLE ELEMENTARY SCHOOL   Regular School No 1.0 PK 06 2016   kindergarten 28 0 1   0 0     0   0   13 16             19         29 28 0 1   0 0     0   0   13 16         19       29
1821885 ID     school 1600002 84   LAKE PEND OREILLE SCHOOL DISTRICT 160000200615 403 FARMIN STIDWELL ELEMENTARY SCHOOL   Regular School No 1.0 PK 06 2016   grade_1 56 0 6   0 2     0   5   30 39             45         69 56 0 6   0 2     0   5   30 39         45       69
1821886 ID     school 1600002 84   LAKE PEND OREILLE SCHOOL DISTRICT 160000200615 403 FARMIN STIDWELL ELEMENTARY SCHOOL   Regular School No 1.0 PK 06 2016   grade_2 60 0 3   0 0     0   4   39 28             39         67 60 0 3   0 0     0   4   39 28         39       67
1821887 ID     school 1600002 84   LAKE PEND OREILLE SCHOOL DISTRICT 160000200615 403 FARMIN STIDWELL ELEMENTARY SCHOOL   Regular School No 1.0 PK 06 2016   grade_3 64 1 4   0 0     0   3   47 25             43         72 64 1 4   0 0     0   3   47 25         43       72
1821888 ID     school 1600002 84   LAKE PEND OREILLE SCHOOL DISTRICT 160000200615 403 FARMIN STIDWELL ELEMENTARY SCHOOL   Regular School No 1.0 PK 06 2016   grade_4 59 0 6   0 1     0   5   35 36             36         71 59 0 6   0 1     0   5   35 36         36       71
1821889 ID     school 1600002 84   LAKE PEND OREILLE SCHOOL DISTRICT 160000200615 403 FARMIN STIDWELL ELEMENTARY SCHOOL   Regular School No 1.0 PK 06 2016   grade_5 63 2 6   2 0     0   5   46 32             42         78 63 2 6   2 0     0   5   46 32         42       78
1821890 ID     school 1600002 84   LAKE PEND OREILLE SCHOOL DISTRICT 160000200615 403 FARMIN STIDWELL ELEMENTARY SCHOOL   Regular School No 1.0 PK 06 2016   grade_6 41 0 4   0 0     0   3   21 27             28         48 41 0 4   0 0     0   3   21 27         28       48
1821891 ID     school 1600002 84   LAKE PEND OREILLE SCHOOL DISTRICT 160000200615 403 FARMIN STIDWELL ELEMENTARY SCHOOL   Regular School No 1.0 PK 06 2016   k_12_total 404 3 31   2 3     0   30   253 220             274         473 404 3 31   2 3     0   30   253 220         274       473
1821892 ID     school 1600002 84   LAKE PEND OREILLE SCHOOL DISTRICT 160000200615 403 FARMIN STIDWELL ELEMENTARY SCHOOL   Regular School No 1.0 PK 06 2016   kindergarten 61 0 2   0 0     0   5   35 33             41         68 61 0 2   0 0     0   5   35 33         41       68
1821893 ID     school 1600002 84   LAKE PEND OREILLE SCHOOL DISTRICT 160000200616 405 SOUTHSIDE ELEMENTARY SCHOOL   Regular School No 1.0 PK 06 2016   grade_1 16 0 0   0 0     0   1   11 6             7         17 16 0 0   0 0     0   1   11 6         7       17
1821894 ID     school 1600002 84   LAKE PEND OREILLE SCHOOL DISTRICT 160000200616 405 SOUTHSIDE ELEMENTARY SCHOOL   Regular School No 1.0 PK 06 2016   grade_2 20 0 1   1 1     0   1   9 15             8         24 20 0 1   1 1     0   1   9 15         8       24
1821895 ID     school 1600002 84   LAKE PEND OREILLE SCHOOL DISTRICT 160000200616 405 SOUTHSIDE ELEMENTARY SCHOOL   Regular School No 1.0 PK 06 2016   grade_3 25 0 1   0 0     0   0   11 15             13         26 25 0 1   0 0     0   0   11 15         13       26
1821896 ID     school 1600002 84   LAKE PEND OREILLE SCHOOL DISTRICT 160000200616 405 SOUTHSIDE ELEMENTARY SCHOOL   Regular School No 1.0 PK 06 2016   grade_4 17 0 1   2 0     0   1   10 11             12         21 17 0 1   2 0     0   1   10 11         12       21
1821897 ID     school 1600002 84   LAKE PEND OREILLE SCHOOL DISTRICT 160000200616 405 SOUTHSIDE ELEMENTARY SCHOOL   Regular School No 1.0 PK 06 2016   grade_5 16 0 2   0 0     0   2   10 10             *         20 16 0 2   0 0     0   2   10 10                 20
1821898 ID     school 1600002 84   LAKE PEND OREILLE SCHOOL DISTRICT 160000200616 405 SOUTHSIDE ELEMENTARY SCHOOL   Regular School No 1.0 PK 06 2016   grade_6 11 0 0   1 0     0   2   7 7             *         14 11 0 0   1 0     0   2   7 7                 14
1821899 ID     school 1600002 84   LAKE PEND OREILLE SCHOOL DISTRICT 160000200616 405 SOUTHSIDE ELEMENTARY SCHOOL   Regular School No 1.0 PK 06 2016   k_12_total 114 0 5   4 1     0   8   64 68             62         132 114 0 5   4 1     0   8   64 68         62       132
1821900 ID     school 1600002 84   LAKE PEND OREILLE SCHOOL DISTRICT 160000200616 405 SOUTHSIDE ELEMENTARY SCHOOL   Regular School No 1.0 PK 06 2016   kindergarten 9 0 0   0 0     0   1   6 4             *         10 9 0 0   0 0     0   1   6 4                 10
1821901 ID     school 1600002 84   LAKE PEND OREILLE SCHOOL DISTRICT 160000200617 408 WASHINGTON ELEMENTARY SCHOOL   Regular School No 1.0 PK 06 2016   grade_1 43 0 4   1 0     0   0   23 25             24         48 43 0 4   1 0     0   0   23 25         24       48
1821902 ID     school 1600002 84   LAKE PEND OREILLE SCHOOL DISTRICT 160000200617 408 WASHINGTON ELEMENTARY SCHOOL   Regular School No 1.0 PK 06 2016   grade_2 29 0 0   1 2     0   1   23 10             13         33 29 0 0   1 2     0   1   23 10         13       33
1821903 ID     school 1600002 84   LAKE PEND OREILLE SCHOOL DISTRICT 160000200617 408 WASHINGTON ELEMENTARY SCHOOL   Regular School No 1.0 PK 06 2016   grade_3 38 0 3   1 0     1   1   25 19             13         44 38 0 3   1 0     1   1   25 19         13       44
1821904 ID     school 1600002 84   LAKE PEND OREILLE SCHOOL DISTRICT 160000200617 408 WASHINGTON ELEMENTARY SCHOOL   Regular School No 1.0 PK 06 2016   grade_4 47 0 1   0 0     0   3   25 26             19         51 47 0 1   0 0     0   3   25 26         19       51
1821905 ID     school 1600002 84   LAKE PEND OREILLE SCHOOL DISTRICT 160000200617 408 WASHINGTON ELEMENTARY SCHOOL   Regular School No 1.0 PK 06 2016   grade_5 43 0 4   2 0     0   5   25 29             21         54 43 0 4   2 0     0   5   25 29         21       54
1821906 ID     school 1600002 84   LAKE PEND OREILLE SCHOOL DISTRICT 160000200617 408 WASHINGTON ELEMENTARY SCHOOL   Regular School No 1.0 PK 06 2016   grade_6 42 0 1   0 0     0   3   23 23             11         46 42 0 1   0 0     0   3   23 23         11       46

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