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
704149 ID     school 1600002 84   LAKE PEND OREILLE SCHOOL DISTRICT 160000200616 405 SOUTHSIDE ELEMENTARY SCHOOL   Regular School No Elementary PK 06 2021   grade_6 22 0 2   0 0     0   0   15 9             9         24 22 0 2   0 0     0   0   15 9         9       24
704150 ID     school 1600002 84   LAKE PEND OREILLE SCHOOL DISTRICT 160000200616 405 SOUTHSIDE ELEMENTARY SCHOOL   Regular School No Elementary PK 06 2021   k_12_total 128 1 4   1 0     0   6   76 64             66         140 128 1 4   1 0     0   6   76 64         66       140
704151 ID     school 1600002 84   LAKE PEND OREILLE SCHOOL DISTRICT 160000200616 405 SOUTHSIDE ELEMENTARY SCHOOL   Regular School No Elementary PK 06 2021   kindergarten 18 0 0   0 0     0   0   10 8             *         18 18 0 0   0 0     0   0   10 8                 18
704152 ID     school 1600002 84   LAKE PEND OREILLE SCHOOL DISTRICT 160000200617 408 WASHINGTON ELEMENTARY SCHOOL   Regular School No Elementary PK 06 2021   grade_1 29 0 2   1 0     0   1   16 17             9         33 29 0 2   1 0     0   1   16 17         9       33
704153 ID     school 1600002 84   LAKE PEND OREILLE SCHOOL DISTRICT 160000200617 408 WASHINGTON ELEMENTARY SCHOOL   Regular School No Elementary PK 06 2021   grade_2 43 0 1   0 0     0   3   27 20             18         47 43 0 1   0 0     0   3   27 20         18       47
704154 ID     school 1600002 84   LAKE PEND OREILLE SCHOOL DISTRICT 160000200617 408 WASHINGTON ELEMENTARY SCHOOL   Regular School No Elementary PK 06 2021   grade_3 33 0 3   0 0     0   2   17 21             12         38 33 0 3   0 0     0   2   17 21         12       38
704155 ID     school 1600002 84   LAKE PEND OREILLE SCHOOL DISTRICT 160000200617 408 WASHINGTON ELEMENTARY SCHOOL   Regular School No Elementary PK 06 2021   grade_4 32 0 2   0 1     0   2   16 21             6         37 32 0 2   0 1     0   2   16 21         6       37
704156 ID     school 1600002 84   LAKE PEND OREILLE SCHOOL DISTRICT 160000200617 408 WASHINGTON ELEMENTARY SCHOOL   Regular School No Elementary PK 06 2021   grade_5 33 0 3   0 0     0   5   22 19             10         41 33 0 3   0 0     0   5   22 19         10       41
704157 ID     school 1600002 84   LAKE PEND OREILLE SCHOOL DISTRICT 160000200617 408 WASHINGTON ELEMENTARY SCHOOL   Regular School No Elementary PK 06 2021   grade_6 32 1 3   1 0     0   5   25 17             15         42 32 1 3   1 0     0   5   25 17         15       42
704158 ID     school 1600002 84   LAKE PEND OREILLE SCHOOL DISTRICT 160000200617 408 WASHINGTON ELEMENTARY SCHOOL   Regular School No Elementary PK 06 2021   k_12_total 228 1 16   2 1     0   18   139 127             81         266 228 1 16   2 1     0   18   139 127         81       266
704159 ID     school 1600002 84   LAKE PEND OREILLE SCHOOL DISTRICT 160000200617 408 WASHINGTON ELEMENTARY SCHOOL   Regular School No Elementary PK 06 2021   kindergarten 26 0 2   0 0     0   0   16 12             11         28 26 0 2   0 0     0   0   16 12         11       28
704160 ID     school 1600002 84   LAKE PEND OREILLE SCHOOL DISTRICT 160000200621 410 NORTHSIDE ELEMENTARY SCHOOL   Regular School No Elementary PK 06 2021   grade_1 27 0 1   0 0     0   1   16 13             6         29 27 0 1   0 0     0   1   16 13         6       29
704161 ID     school 1600002 84   LAKE PEND OREILLE SCHOOL DISTRICT 160000200621 410 NORTHSIDE ELEMENTARY SCHOOL   Regular School No Elementary PK 06 2021   grade_2 13 0 1   0 0     0   0   8 6             *         14 13 0 1   0 0     0   0   8 6                 14
704162 ID     school 1600002 84   LAKE PEND OREILLE SCHOOL DISTRICT 160000200621 410 NORTHSIDE ELEMENTARY SCHOOL   Regular School No Elementary PK 06 2021   grade_3 18 0 1   0 0     0   0   13 6             5         19 18 0 1   0 0     0   0   13 6         5       19
704163 ID     school 1600002 84   LAKE PEND OREILLE SCHOOL DISTRICT 160000200621 410 NORTHSIDE ELEMENTARY SCHOOL   Regular School No Elementary PK 06 2021   grade_4 24 0 1   0 0     0   0   17 8             9         25 24 0 1   0 0     0   0   17 8         9       25
704164 ID     school 1600002 84   LAKE PEND OREILLE SCHOOL DISTRICT 160000200621 410 NORTHSIDE ELEMENTARY SCHOOL   Regular School No Elementary PK 06 2021   grade_5 19 0 1   0 0     0   0   14 6             6         20 19 0 1   0 0     0   0   14 6         6       20
704165 ID     school 1600002 84   LAKE PEND OREILLE SCHOOL DISTRICT 160000200621 410 NORTHSIDE ELEMENTARY SCHOOL   Regular School No Elementary PK 06 2021   grade_6 17 1 2   0 0     0   0   10 10             7         20 17 1 2   0 0     0   0   10 10         7       20
704166 ID     school 1600002 84   LAKE PEND OREILLE SCHOOL DISTRICT 160000200621 410 NORTHSIDE ELEMENTARY SCHOOL   Regular School No Elementary PK 06 2021   k_12_total 135 1 9   0 0     0   1   86 60             *         146 135 1 9   0 0     0   1   86 60                 146
704167 ID     school 1600002 84   LAKE PEND OREILLE SCHOOL DISTRICT 160000200621 410 NORTHSIDE ELEMENTARY SCHOOL   Regular School No Elementary PK 06 2021   kindergarten 17 0 2   0 0     0   0   8 11             *         19 17 0 2   0 0     0   0   8 11                 19
704168 ID     school 1600002 84   LAKE PEND OREILLE SCHOOL DISTRICT 160000200604 997 SANDPOINT JUVENILE DETENTION   Alternative School No High 05 12 2021   grade_10 2 0 0   0 0     0   0   1 1             *         2 2 0 0   0 0     0   0   1 1                 2
704169 ID     school 1600002 84   LAKE PEND OREILLE SCHOOL DISTRICT 160000200604 997 SANDPOINT JUVENILE DETENTION   Alternative School No High 05 12 2021   grade_12 1 0 0   0 0     0   0   1 0             *         1 1 0 0   0 0     0   0   1 0                 1
704170 ID     school 1600002 84   LAKE PEND OREILLE SCHOOL DISTRICT 160000200604 997 SANDPOINT JUVENILE DETENTION   Alternative School No High 05 12 2021   k_12_total 3 0 0   0 0     0   0   2 1             *         3 3 0 0   0 0     0   0   2 1                 3
704171 ID     school 1600002 84   LAKE PEND OREILLE SCHOOL DISTRICT 160000200691 1045 LAKE PEND OREILLE HIGH SCHOOL   Alternative School No High 09 12 2021   grade_10 13 0 4   0 0     0   1   13 5             13         18 13 0 4   0 0     0   1   13 5         13       18
704172 ID     school 1600002 84   LAKE PEND OREILLE SCHOOL DISTRICT 160000200691 1045 LAKE PEND OREILLE HIGH SCHOOL   Alternative School No High 09 12 2021   grade_11 24 0 1   1 0     0   2   12 16             *         28 24 0 1   1 0     0   2   12 16                 28
704173 ID     school 1600002 84   LAKE PEND OREILLE SCHOOL DISTRICT 160000200691 1045 LAKE PEND OREILLE HIGH SCHOOL   Alternative School No High 09 12 2021   grade_12 32 0 1   0 0     0   0   16 17             16         33 32 0 1   0 0     0   0   16 17         16       33
704174 ID     school 1600002 84   LAKE PEND OREILLE SCHOOL DISTRICT 160000200691 1045 LAKE PEND OREILLE HIGH SCHOOL   Alternative School No High 09 12 2021   grade_9 9 0 0   0 0     0   1   3 7             *         10 9 0 0   0 0     0   1   3 7                 10
704175 ID     school 1600002 84   LAKE PEND OREILLE SCHOOL DISTRICT 160000200691 1045 LAKE PEND OREILLE HIGH SCHOOL   Alternative School No High 09 12 2021   k_12_total 78 0 6   1 0     0   4   44 45             47         89 78 0 6   1 0     0   4   44 45         47       89
704176 ID     school 1600002 84   LAKE PEND OREILLE SCHOOL DISTRICT 160000201086 1391 LPOSD HOME SCHOOL ACADEMY   Regular School No Elementary KG 08 2021   k_12_total 1 0 0   1 0     0   0   2 0             *         2 1 0 0   1 0     0   0   2 0                 2
704177 ID     school 1600002 84   LAKE PEND OREILLE SCHOOL DISTRICT 160000201086 1391 LPOSD HOME SCHOOL ACADEMY   Regular School No Elementary KG 08 2021   kindergarten 1 0 0   1 0     0   0   2 0             *         2 1 0 0   1 0     0   0   2 0                 2
849833 ID     school 1600002 84   LAKE PEND OREILLE SCHOOL DISTRICT 160000200724 47 SANDPOINT MIDDLE SCHOOL   Regular School No Middle 07 08 2020   grade_7 222 1 10   2 0     2   5   134 108             88         242 222 1 10   2 0     2   5   134 108         88       242
849834 ID     school 1600002 84   LAKE PEND OREILLE SCHOOL DISTRICT 160000200724 47 SANDPOINT MIDDLE SCHOOL   Regular School No Middle 07 08 2020   grade_8 210 0 11   2 1     0   11   117 118             88         235 210 0 11   2 1     0   11   117 118         88       235
849835 ID     school 1600002 84   LAKE PEND OREILLE SCHOOL DISTRICT 160000200724 47 SANDPOINT MIDDLE SCHOOL   Regular School No Middle 07 08 2020   k_12_total 432 1 21   4 1     2   16   251 226             176         477 432 1 21   4 1     2   16   251 226         176       477
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
849837 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_11 17 0 1   0 0     0   0   10 8             7         18 17 0 1   0 0     0   0   10 8         7       18
849838 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_12 18 0 1   0 0     1   1   11 10             *         21 18 0 1   0 0     1   1   11 10                 21
849839 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_7 20 0 1   1 0     0   0   14 8             13         22 20 0 1   1 0     0   0   14 8         13       22
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
849841 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_9 15 0 1   0 0     1   1   9 9             *         18 15 0 1   0 0     1   1   9 9                 18
849842 ID     school 1600002 84   LAKE PEND OREILLE SCHOOL DISTRICT 160000200082 49 CLARK FORK JR/SR HIGH SCHOOL   Regular School No High 07 12 2020   k_12_total 114 0 4   3 0     2   2   72 53             65         125 114 0 4   3 0     2   2   72 53         65       125
849843 ID     school 1600002 84   LAKE PEND OREILLE SCHOOL DISTRICT 160000200087 202 SANDPOINT HIGH SCHOOL   Regular School No High 07 12 2020   grade_10 223 1 5   1 1     1   8   129 111             48         240 223 1 5   1 1     1   8   129 111         48       240
849844 ID     school 1600002 84   LAKE PEND OREILLE SCHOOL DISTRICT 160000200087 202 SANDPOINT HIGH SCHOOL   Regular School No High 07 12 2020   grade_11 223 1 12   0 2     0   11   130 119             43         249 223 1 12   0 2     0   11   130 119         43       249
849845 ID     school 1600002 84   LAKE PEND OREILLE SCHOOL DISTRICT 160000200087 202 SANDPOINT HIGH SCHOOL   Regular School No High 07 12 2020   grade_12 207 0 15   1 0     2   13   124 114             49         238 207 0 15   1 0     2   13   124 114         49       238
849846 ID     school 1600002 84   LAKE PEND OREILLE SCHOOL DISTRICT 160000200087 202 SANDPOINT HIGH SCHOOL   Regular School No High 07 12 2020   grade_9 226 1 16   4 1     0   17   138 127             63         265 226 1 16   4 1     0   17   138 127         63       265
849847 ID     school 1600002 84   LAKE PEND OREILLE SCHOOL DISTRICT 160000200087 202 SANDPOINT HIGH SCHOOL   Regular School No High 07 12 2020   k_12_total 879 3 48   6 4     3   49   521 471             203         992 879 3 48   6 4     3   49   521 471         203       992
849848 ID     school 1600002 84   LAKE PEND OREILLE SCHOOL DISTRICT 160000200603 293 KOOTENAI ELEMENTARY SCHOOL   Regular School No Elementary KG 06 2020   grade_1 53 0 4   0 0     0   1   32 26             31         58 53 0 4   0 0     0   1   32 26         31       58
849849 ID     school 1600002 84   LAKE PEND OREILLE SCHOOL DISTRICT 160000200603 293 KOOTENAI ELEMENTARY SCHOOL   Regular School No Elementary KG 06 2020   grade_2 46 0 7   1 0     0   2   26 30             28         56 46 0 7   1 0     0   2   26 30         28       56
849850 ID     school 1600002 84   LAKE PEND OREILLE SCHOOL DISTRICT 160000200603 293 KOOTENAI ELEMENTARY SCHOOL   Regular School No Elementary KG 06 2020   grade_3 47 0 1   2 1     0   5   27 29             35         56 47 0 1   2 1     0   5   27 29         35       56
849851 ID     school 1600002 84   LAKE PEND OREILLE SCHOOL DISTRICT 160000200603 293 KOOTENAI ELEMENTARY SCHOOL   Regular School No Elementary KG 06 2020   grade_4 60 0 4   0 0     0   2   31 35             34         66 60 0 4   0 0     0   2   31 35         34       66
849852 ID     school 1600002 84   LAKE PEND OREILLE SCHOOL DISTRICT 160000200603 293 KOOTENAI ELEMENTARY SCHOOL   Regular School No Elementary KG 06 2020   grade_5 63 0 6   0 0     0   3   42 30             38         72 63 0 6   0 0     0   3   42 30         38       72
849853 ID     school 1600002 84   LAKE PEND OREILLE SCHOOL DISTRICT 160000200603 293 KOOTENAI ELEMENTARY SCHOOL   Regular School No Elementary KG 06 2020   grade_6 61 0 4   0 1     0   0   23 43             29         66 61 0 4   0 1     0   0   23 43         29       66
849854 ID     school 1600002 84   LAKE PEND OREILLE SCHOOL DISTRICT 160000200603 293 KOOTENAI ELEMENTARY SCHOOL   Regular School No Elementary KG 06 2020   k_12_total 380 2 28   4 2     0   13   211 218             220         429 380 2 28   4 2     0   13   211 218         220       429
849855 ID     school 1600002 84   LAKE PEND OREILLE SCHOOL DISTRICT 160000200603 293 KOOTENAI ELEMENTARY SCHOOL   Regular School No Elementary KG 06 2020   kindergarten 50 2 2   1 0     0   0   30 25             25         55 50 2 2   1 0     0   0   30 25         25       55
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
849860 ID     school 1600002 84   LAKE PEND OREILLE SCHOOL DISTRICT 160000200614 401 HOPE ELEMENTARY SCHOOL   Regular School No Elementary PK 06 2020   grade_5 13 0 2   0 0     0   0   10 5             9         15 13 0 2   0 0     0   0   10 5         9       15
849861 ID     school 1600002 84   LAKE PEND OREILLE SCHOOL DISTRICT 160000200614 401 HOPE ELEMENTARY SCHOOL   Regular School No Elementary PK 06 2020   grade_6 14 0 1   0 0     0   0   7 8             6         15 14 0 1   0 0     0   0   7 8         6       15
849862 ID     school 1600002 84   LAKE PEND OREILLE SCHOOL DISTRICT 160000200614 401 HOPE ELEMENTARY SCHOOL   Regular School No Elementary PK 06 2020   k_12_total 88 0 3   0 0     2   2   52 43             *         95 88 0 3   0 0     2   2   52 43                 95
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
849864 ID     school 1600002 84   LAKE PEND OREILLE SCHOOL DISTRICT 160000200618 402 SAGLE ELEMENTARY SCHOOL   Regular School No Elementary PK 06 2020   grade_1 38 0 1   0 0     0   2   19 22             17         41 38 0 1   0 0     0   2   19 22         17       41
849865 ID     school 1600002 84   LAKE PEND OREILLE SCHOOL DISTRICT 160000200618 402 SAGLE ELEMENTARY SCHOOL   Regular School No Elementary PK 06 2020   grade_2 31 0 3   0 0     0   0   18 16             14         34 31 0 3   0 0     0   0   18 16         14       34
849866 ID     school 1600002 84   LAKE PEND OREILLE SCHOOL DISTRICT 160000200618 402 SAGLE ELEMENTARY SCHOOL   Regular School No Elementary PK 06 2020   grade_3 30 0 3   0 1     0   0   23 11             14         34 30 0 3   0 1     0   0   23 11         14       34
849867 ID     school 1600002 84   LAKE PEND OREILLE SCHOOL DISTRICT 160000200618 402 SAGLE ELEMENTARY SCHOOL   Regular School No Elementary PK 06 2020   grade_4 37 0 2   0 0     0   1   20 20             16         40 37 0 2   0 0     0   1   20 20         16       40
849868 ID     school 1600002 84   LAKE PEND OREILLE SCHOOL DISTRICT 160000200618 402 SAGLE ELEMENTARY SCHOOL   Regular School No Elementary PK 06 2020   grade_5 39 0 2   0 0     0   2   22 21             18         43 39 0 2   0 0     0   2   22 21         18       43
849869 ID     school 1600002 84   LAKE PEND OREILLE SCHOOL DISTRICT 160000200618 402 SAGLE ELEMENTARY SCHOOL   Regular School No Elementary PK 06 2020   grade_6 38 0 2   0 0     0   4   23 21             13         44 38 0 2   0 0     0   4   23 21         13       44
849870 ID     school 1600002 84   LAKE PEND OREILLE SCHOOL DISTRICT 160000200618 402 SAGLE ELEMENTARY SCHOOL   Regular School No Elementary PK 06 2020   k_12_total 246 0 13   0 1     0   10   136 134             99         270 246 0 13   0 1     0   10   136 134         99       270
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
849872 ID     school 1600002 84   LAKE PEND OREILLE SCHOOL DISTRICT 160000200615 403 FARMIN STIDWELL ELEMENTARY SCHOOL   Regular School No Elementary PK 06 2020   grade_1 64 1 2   0 0     0   3   34 36             28         70 64 1 2   0 0     0   3   34 36         28       70
849873 ID     school 1600002 84   LAKE PEND OREILLE SCHOOL DISTRICT 160000200615 403 FARMIN STIDWELL ELEMENTARY SCHOOL   Regular School No Elementary PK 06 2020   grade_2 58 0 7   0 1     0   7   40 33             37         73 58 0 7   0 1     0   7   40 33         37       73
849874 ID     school 1600002 84   LAKE PEND OREILLE SCHOOL DISTRICT 160000200615 403 FARMIN STIDWELL ELEMENTARY SCHOOL   Regular School No Elementary PK 06 2020   grade_3 70 0 8   0 0     0   3   42 39             37         81 70 0 8   0 0     0   3   42 39         37       81
849875 ID     school 1600002 84   LAKE PEND OREILLE SCHOOL DISTRICT 160000200615 403 FARMIN STIDWELL ELEMENTARY SCHOOL   Regular School No Elementary PK 06 2020   grade_4 66 1 6   0 2     0   7   44 38             44         82 66 1 6   0 2     0   7   44 38         44       82
849876 ID     school 1600002 84   LAKE PEND OREILLE SCHOOL DISTRICT 160000200615 403 FARMIN STIDWELL ELEMENTARY SCHOOL   Regular School No Elementary PK 06 2020   grade_5 68 0 5   0 2     0   4   43 36             39         79 68 0 5   0 2     0   4   43 36         39       79
849877 ID     school 1600002 84   LAKE PEND OREILLE SCHOOL DISTRICT 160000200615 403 FARMIN STIDWELL ELEMENTARY SCHOOL   Regular School No Elementary PK 06 2020   grade_6 41 0 2   0 0     0   5   25 23             26         48 41 0 2   0 0     0   5   25 23         26       48
849878 ID     school 1600002 84   LAKE PEND OREILLE SCHOOL DISTRICT 160000200615 403 FARMIN STIDWELL ELEMENTARY SCHOOL   Regular School No Elementary PK 06 2020   k_12_total 418 3 36   0 6     0   31   261 233             245         494 418 3 36   0 6     0   31   261 233         245       494
849879 ID     school 1600002 84   LAKE PEND OREILLE SCHOOL DISTRICT 160000200615 403 FARMIN STIDWELL ELEMENTARY SCHOOL   Regular School No Elementary PK 06 2020   kindergarten 51 1 6   0 1     0   2   33 28             34         61 51 1 6   0 1     0   2   33 28         34       61
849880 ID     school 1600002 84   LAKE PEND OREILLE SCHOOL DISTRICT 160000200616 405 SOUTHSIDE ELEMENTARY SCHOOL   Regular School No Elementary PK 06 2020   grade_1 20 0 1   0 0     0   3   10 14             13         24 20 0 1   0 0     0   3   10 14         13       24
849881 ID     school 1600002 84   LAKE PEND OREILLE SCHOOL DISTRICT 160000200616 405 SOUTHSIDE ELEMENTARY SCHOOL   Regular School No Elementary PK 06 2020   grade_2 13 0 1   1 0     0   2   8 9             *         17 13 0 1   1 0     0   2   8 9                 17
849882 ID     school 1600002 84   LAKE PEND OREILLE SCHOOL DISTRICT 160000200616 405 SOUTHSIDE ELEMENTARY SCHOOL   Regular School No Elementary PK 06 2020   grade_3 25 0 2   0 0     0   0   15 12             13         27 25 0 2   0 0     0   0   15 12         13       27
849883 ID     school 1600002 84   LAKE PEND OREILLE SCHOOL DISTRICT 160000200616 405 SOUTHSIDE ELEMENTARY SCHOOL   Regular School No Elementary PK 06 2020   grade_4 21 0 1   0 0     0   0   5 17             12         22 21 0 1   0 0     0   0   5 17         12       22
849884 ID     school 1600002 84   LAKE PEND OREILLE SCHOOL DISTRICT 160000200616 405 SOUTHSIDE ELEMENTARY SCHOOL   Regular School No Elementary PK 06 2020   grade_5 22 0 1   0 0     1   0   18 6             11         24 22 0 1   0 0     1   0   18 6         11       24
849885 ID     school 1600002 84   LAKE PEND OREILLE SCHOOL DISTRICT 160000200616 405 SOUTHSIDE ELEMENTARY SCHOOL   Regular School No Elementary PK 06 2020   grade_6 24 0 1   0 1     0   2   11 17             11         28 24 0 1   0 1     0   2   11 17         11       28
849886 ID     school 1600002 84   LAKE PEND OREILLE SCHOOL DISTRICT 160000200616 405 SOUTHSIDE ELEMENTARY SCHOOL   Regular School No Elementary PK 06 2020   k_12_total 146 2 7   1 1     1   7   81 84             78         165 146 2 7   1 1     1   7   81 84         78       165
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
849888 ID     school 1600002 84   LAKE PEND OREILLE SCHOOL DISTRICT 160000200617 408 WASHINGTON ELEMENTARY SCHOOL   Regular School No Elementary PK 06 2020   grade_1 47 0 2   0 0     0   3   27 25             20         52 47 0 2   0 0     0   3   27 25         20       52
849889 ID     school 1600002 84   LAKE PEND OREILLE SCHOOL DISTRICT 160000200617 408 WASHINGTON ELEMENTARY SCHOOL   Regular School No Elementary PK 06 2020   grade_2 37 0 3   0 0     0   1   14 27             16         41 37 0 3   0 0     0   1   14 27         16       41
849890 ID     school 1600002 84   LAKE PEND OREILLE SCHOOL DISTRICT 160000200617 408 WASHINGTON ELEMENTARY SCHOOL   Regular School No Elementary PK 06 2020   grade_3 34 0 1   0 0     0   4   16 23             10         39 34 0 1   0 0     0   4   16 23         10       39
849891 ID     school 1600002 84   LAKE PEND OREILLE SCHOOL DISTRICT 160000200617 408 WASHINGTON ELEMENTARY SCHOOL   Regular School No Elementary PK 06 2020   grade_4 41 0 2   0 0     0   5   21 27             12         48 41 0 2   0 0     0   5   21 27         12       48
849892 ID     school 1600002 84   LAKE PEND OREILLE SCHOOL DISTRICT 160000200617 408 WASHINGTON ELEMENTARY SCHOOL   Regular School No Elementary PK 06 2020   grade_5 41 0 5   1 0     0   3   27 23             26         50 41 0 5   1 0     0   3   27 23         26       50
849893 ID     school 1600002 84   LAKE PEND OREILLE SCHOOL DISTRICT 160000200617 408 WASHINGTON ELEMENTARY SCHOOL   Regular School No Elementary PK 06 2020   grade_6 37 0 1   0 2     0   3   30 13             9         43 37 0 1   0 2     0   3   30 13         9       43
849894 ID     school 1600002 84   LAKE PEND OREILLE SCHOOL DISTRICT 160000200617 408 WASHINGTON ELEMENTARY SCHOOL   Regular School No Elementary PK 06 2020   k_12_total 263 0 14   1 2     0   19   147 152             100         299 263 0 14   1 2     0   19   147 152         100       299
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
849898 ID     school 1600002 84   LAKE PEND OREILLE SCHOOL DISTRICT 160000200621 410 NORTHSIDE ELEMENTARY SCHOOL   Regular School No Elementary PK 06 2020   grade_3 30 0 1   0 0     0   0   23 8             14         31 30 0 1   0 0     0   0   23 8         14       31
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
849900 ID     school 1600002 84   LAKE PEND OREILLE SCHOOL DISTRICT 160000200621 410 NORTHSIDE ELEMENTARY SCHOOL   Regular School No Elementary PK 06 2020   grade_5 23 1 2   0 0     0   0   15 11             10         26 23 1 2   0 0     0   0   15 11         10       26
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
849902 ID     school 1600002 84   LAKE PEND OREILLE SCHOOL DISTRICT 160000200621 410 NORTHSIDE ELEMENTARY SCHOOL   Regular School No Elementary PK 06 2020   k_12_total 172 1 3   0 0     0   5   112 69             64         181 172 1 3   0 0     0   5   112 69         64       181
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

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