Data source: Big Local News · About: Big Local

2,772 rows where grade = "grade_2" and state = "ID" sorted by district_nces_id

View and edit SQL

year

grade

  • grade_2 · 2,772
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
704074 ID     school 1600001 83   WEST BONNER COUNTY DISTRICT 160000100620 406 PRIEST LAKE ELEMENTARY SCHOOL   Regular School No Elementary PK 06 2021   grade_2 7 0 0   1 0     0   0   5 3             *         8 7 0 0   1 0     0   0   5 3                 8
704082 ID     school 1600001 83   WEST BONNER COUNTY DISTRICT 160000100619 407 PRIEST RIVER ELEMENTARY SCHOOL   Regular School No Elementary PK 06 2021   grade_2 45 0 0   0 0     0   1   22 24             20         46 45 0 0   0 0     0   1   22 24         20       46
704090 ID     school 1600001 83   WEST BONNER COUNTY DISTRICT 160000100613 411 IDAHO HILL ELEMENTARY SCHOOL   Regular School No Elementary PK 06 2021   grade_2 11 0 0   0 0     0   0   6 5             *         11 11 0 0   0 0     0   0   6 5                 11
849810 ID     school 1600001 83   WEST BONNER COUNTY DISTRICT 160000100620 406 PRIEST LAKE ELEMENTARY SCHOOL   Regular School No Elementary PK 06 2020   grade_2 5 0 1   0 0     0   0   5 1             *         6 5 0 1   0 0     0   0   5 1                 6
849818 ID     school 1600001 83   WEST BONNER COUNTY DISTRICT 160000100619 407 PRIEST RIVER ELEMENTARY SCHOOL   Regular School No Elementary PK 06 2020   grade_2 55 0 0   0 0     0   0   36 19             33         55 55 0 0   0 0     0   0   36 19         33       55
849826 ID     school 1600001 83   WEST BONNER COUNTY DISTRICT 160000100613 411 IDAHO HILL ELEMENTARY SCHOOL   Regular School No Elementary PK 06 2020   grade_2 15 0 2   0 0     0   1   8 10             *         18 15 0 2   0 0     0   1   8 10                 18
1277355 ID     school 1600001 83   WEST BONNER COUNTY DISTRICT 160000100620 406 PRIEST LAKE ELEMENTARY SCHOOL   Regular School No Elementary PK 6.0 2018   grade_2 11 0 0   0 0     0   0   6 5             *         11 11 0 0   0 0     0   0   6 5                 11
1277363 ID     school 1600001 83   WEST BONNER COUNTY DISTRICT 160000100619 407 PRIEST RIVER ELEMENTARY SCHOOL   Regular School No Elementary PK 6.0 2018   grade_2 48 0 5   0 0     0   1   33 21             33         54 48 0 5   0 0     0   1   33 21         33       54
1277371 ID     school 1600001 83   WEST BONNER COUNTY DISTRICT 160000100613 411 IDAHO HILL ELEMENTARY SCHOOL   Regular School No Elementary PK 6.0 2018   grade_2 12 0 1   0 0     0   2   5 10             *         15 12 0 1   0 0     0   2   5 10                 15
1306217 ID     school 1600001 83   WEST BONNER COUNTY DISTRICT 160000100620 406 PRIEST LAKE ELEMENTARY SCHOOL   Regular School No Elementary PK 6.0 2019   grade_2 6 0 0   0 0     0   0   4 2             *         6 6 0 0   0 0     0   0   4 2                 6
1306225 ID     school 1600001 83   WEST BONNER COUNTY DISTRICT 160000100619 407 PRIEST RIVER ELEMENTARY SCHOOL   Regular School No Elementary PK 6.0 2019   grade_2 53 0 1   0 0     0   3   30 27             36         57 53 0 1   0 0     0   3   30 27         36       57
1306233 ID     school 1600001 83   WEST BONNER COUNTY DISTRICT 160000100613 411 IDAHO HILL ELEMENTARY SCHOOL   Regular School No Elementary PK 6.0 2019   grade_2 10 0 1   0 0     0   0   4 7             *         11 10 0 1   0 0     0   0   4 7                 11
1682780 ID     school 1600001 83   WEST BONNER COUNTY DISTRICT 160000100620 406 PRIEST LAKE ELEMENTARY SCHOOL   Regular School No 1.0 PK 06 2015   grade_2 3 0 0   0 0     0   0   1 2             *         3 3 0 0   0 0     0   0   1 2                 3
1682788 ID     school 1600001 83   WEST BONNER COUNTY DISTRICT 160000100619 407 PRIEST RIVER ELEMENTARY SCHOOL   Regular School No 1.0 PK 06 2015   grade_2 44 0 1   0 0     0   3   30 18             33         48 44 0 1   0 0     0   3   30 18         33       48
1682796 ID     school 1600001 83   WEST BONNER COUNTY DISTRICT 160000100613 411 IDAHO HILL ELEMENTARY SCHOOL   Regular School No 1.0 PK 06 2015   grade_2 16 0 1   0 0     0   3   9 11             *         20 16 0 1   0 0     0   3   9 11                 20
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
1277399 ID     school 1600002 84   LAKE PEND OREILLE SCHOOL DISTRICT 160000200603 293 KOOTENAI ELEMENTARY SCHOOL   Regular School No Elementary KG 6.0 2018   grade_2 57 0 3   0 0     0   2   27 35             32         62 57 0 3   0 0     0   2   27 35         32       62
1277407 ID     school 1600002 84   LAKE PEND OREILLE SCHOOL DISTRICT 160000200614 401 HOPE ELEMENTARY SCHOOL   Regular School No Elementary PK 6.0 2018   grade_2 10 0 0   0 0     0   1   5 6             *         11 10 0 0   0 0     0   1   5 6                 11
1277415 ID     school 1600002 84   LAKE PEND OREILLE SCHOOL DISTRICT 160000200618 402 SAGLE ELEMENTARY SCHOOL   Regular School No Elementary PK 6.0 2018   grade_2 33 0 1   0 0     0   0   19 15             16         34 33 0 1   0 0     0   0   19 15         16       34
1277423 ID     school 1600002 84   LAKE PEND OREILLE SCHOOL DISTRICT 160000200615 403 FARMIN STIDWELL ELEMENTARY SCHOOL   Regular School No Elementary PK 6.0 2018   grade_2 66 1 4   0 1     0   10   40 42             48         82 66 1 4   0 1     0   10   40 42         48       82
1277431 ID     school 1600002 84   LAKE PEND OREILLE SCHOOL DISTRICT 160000200616 405 SOUTHSIDE ELEMENTARY SCHOOL   Regular School No Elementary PK 6.0 2018   grade_2 16 0 0   0 0     0   0   7 9             11         16 16 0 0   0 0     0   0   7 9         11       16
1277439 ID     school 1600002 84   LAKE PEND OREILLE SCHOOL DISTRICT 160000200617 408 WASHINGTON ELEMENTARY SCHOOL   Regular School No Elementary PK 6.0 2018   grade_2 37 0 2   0 0     0   5   21 23             16         44 37 0 2   0 0     0   5   21 23         16       44
1277447 ID     school 1600002 84   LAKE PEND OREILLE SCHOOL DISTRICT 160000200621 410 NORTHSIDE ELEMENTARY SCHOOL   Regular School No Elementary PK 6.0 2018   grade_2 17 0 0   0 0     0   1   7 11             *         18 17 0 0   0 0     0   1   7 11                 18
1306256 ID     school 1600002 84   LAKE PEND OREILLE SCHOOL DISTRICT 160000200603 293 KOOTENAI ELEMENTARY SCHOOL   Regular School No Elementary KG 6.0 2019   grade_2 43 0 2   2 1     0   5   25 28             32         53 43 0 2   2 1     0   5   25 28         32       53
1306264 ID     school 1600002 84   LAKE PEND OREILLE SCHOOL DISTRICT 160000200614 401 HOPE ELEMENTARY SCHOOL   Regular School No Elementary PK 6.0 2019   grade_2 16 0 0   0 0     1   0   10 7             *         17 16 0 0   0 0     1   0   10 7                 17
1306272 ID     school 1600002 84   LAKE PEND OREILLE SCHOOL DISTRICT 160000200618 402 SAGLE ELEMENTARY SCHOOL   Regular School No Elementary PK 6.0 2019   grade_2 32 0 1   0 1     0   0   25 9             12         34 32 0 1   0 1     0   0   25 9         12       34
1306280 ID     school 1600002 84   LAKE PEND OREILLE SCHOOL DISTRICT 160000200615 403 FARMIN STIDWELL ELEMENTARY SCHOOL   Regular School No Elementary PK 6.0 2019   grade_2 65 0 8   0 0     0   7   39 41             40         80 65 0 8   0 0     0   7   39 41         40       80
1306288 ID     school 1600002 84   LAKE PEND OREILLE SCHOOL DISTRICT 160000200616 405 SOUTHSIDE ELEMENTARY SCHOOL   Regular School No Elementary PK 6.0 2019   grade_2 21 0 1   0 0     0   0   13 9             *         22 21 0 1   0 0     0   0   13 9                 22
1306296 ID     school 1600002 84   LAKE PEND OREILLE SCHOOL DISTRICT 160000200617 408 WASHINGTON ELEMENTARY SCHOOL   Regular School No Elementary PK 6.0 2019   grade_2 30 0 1   0 0     0   4   15 20             *         35 30 0 1   0 0     0   4   15 20                 35
1306304 ID     school 1600002 84   LAKE PEND OREILLE SCHOOL DISTRICT 160000200621 410 NORTHSIDE ELEMENTARY SCHOOL   Regular School No Elementary PK 6.0 2019   grade_2 31 0 1   0 0     0   0   22 10             14         32 31 0 1   0 0     0   0   22 10         14       32
1682824 ID     school 1600002 84   LAKE PEND OREILLE SCHOOL DISTRICT 160000200603 293 KOOTENAI ELEMENTARY SCHOOL   Regular School No 1.0 KG 06 2015   grade_2 43 0 5   0 0     0   0   23 25             31         48 43 0 5   0 0     0   0   23 25         31       48
1682832 ID     school 1600002 84   LAKE PEND OREILLE SCHOOL DISTRICT 160000200614 401 HOPE ELEMENTARY SCHOOL   Regular School No 1.0 PK 06 2015   grade_2 16 0 0   0 0     0   0   8 8             *         16 16 0 0   0 0     0   0   8 8                 16
1682840 ID     school 1600002 84   LAKE PEND OREILLE SCHOOL DISTRICT 160000200618 402 SAGLE ELEMENTARY SCHOOL   Regular School No 1.0 PK 06 2015   grade_2 39 0 4   0 0     0   0   21 22             22         43 39 0 4   0 0     0   0   21 22         22       43
1682848 ID     school 1600002 84   LAKE PEND OREILLE SCHOOL DISTRICT 160000200615 403 FARMIN STIDWELL ELEMENTARY SCHOOL   Regular School No 1.0 PK 06 2015   grade_2 52 1 3   1 0     0   2   38 21             39         59 52 1 3   1 0     0   2   38 21         39       59
1682856 ID     school 1600002 84   LAKE PEND OREILLE SCHOOL DISTRICT 160000200616 405 SOUTHSIDE ELEMENTARY SCHOOL   Regular School No 1.0 PK 06 2015   grade_2 22 0 1   0 0     0   1   11 13             *         24 22 0 1   0 0     0   1   11 13                 24
1682864 ID     school 1600002 84   LAKE PEND OREILLE SCHOOL DISTRICT 160000200617 408 WASHINGTON ELEMENTARY SCHOOL   Regular School No 1.0 PK 06 2015   grade_2 37 0 2   0 0     1   2   26 16             17         42 37 0 2   0 0     1   2   26 16         17       42
1682872 ID     school 1600002 84   LAKE PEND OREILLE SCHOOL DISTRICT 160000200621 410 NORTHSIDE ELEMENTARY SCHOOL   Regular School No 1.0 PK 06 2015   grade_2 23 0 0   0 0     0   0   15 8             16         23 23 0 0   0 0     0   0   15 8         16       23
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
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
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
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
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
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
1726910 ID     school 1600002 84   LAKE PEND OREILLE SCHOOL DISTRICT 160000200621 410 NORTHSIDE ELEMENTARY SCHOOL   Regular School No Elementary PK 6.0 2017   grade_2 27 1 1   0 0     0   0   15 14             15         29 27 1 1   0 0     0   0   15 14         15       29
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
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
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
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
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
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
1821910 ID     school 1600002 84   LAKE PEND OREILLE SCHOOL DISTRICT 160000200621 410 NORTHSIDE ELEMENTARY SCHOOL   Regular School No 1.0 PK 06 2016   grade_2 24 0 0   0 0     0   1   18 7             10         25 24 0 0   0 0     0   1   18 7         10       25
707110 ID     school 1600003 451   VICTORY CHARTER SCHOOL, INC. 160000300858 868 VICTORY CHARTER SCHOOL   Regular School Yes Other PK 12 2021   grade_2 21 0 4   0 0     0   2   12 15             8         27 21 0 4   0 0     0   2   12 15         8       27
852760 ID     school 1600003 451   VICTORY CHARTER SCHOOL, INC. 160000300858 868 VICTORY CHARTER SCHOOL   Regular School Yes Other PK 12 2020   grade_2 24 0 1   0 1     1   2   16 13             8         29 24 0 1   0 1     1   2   16 13         8       29
1280284 ID     school 1600003 451   VICTORY CHARTER SCHOOL, INC. 160000300858 868 VICTORY CHARTER SCHOOL   Regular School Yes Other PK 12.0 2018   grade_2 25 0 2   0 1     0   2   18 12             15         30 25 0 2   0 1     0   2   18 12         15       30
1309158 ID     school 1600003 451   VICTORY CHARTER SCHOOL, INC. 160000300858 868 VICTORY CHARTER SCHOOL   Regular School Yes Other PK 12.0 2019   grade_2 24 0 3   0 1     0   1   19 10             10         29 24 0 3   0 1     0   1   19 10         10       29
1685674 ID     school 1600003 451   VICTORY CHARTER SCHOOL, INC. 160000300858 868 VICTORY CHARTER SCHOOL   Regular School Yes 4.0 PK 12 2015   grade_2 28 0 2   0 0     0   1   12 19             14         31 28 0 2   0 0     0   1   12 19         14       31
1729750 ID     school 1600003 451   VICTORY CHARTER SCHOOL, INC. 160000300858 868 VICTORY CHARTER SCHOOL   Regular School Yes Other PK 12.0 2017   grade_2 25 1 1   1 0     1   1   14 16             13         30 25 1 1   1 0     1   1   14 16         13       30
1824702 ID     school 1600003 451   VICTORY CHARTER SCHOOL, INC. 160000300858 868 VICTORY CHARTER SCHOOL   Regular School Yes 4.0 PK 12 2016   grade_2 26 1 1   0 0     0   2   18 12             11         30 26 1 1   0 0     0   2   18 12         11       30
707124 ID     school 1600004 452   IDAHO VIRTUAL ACADEMY, INC. 160000400859 869 IDAHO VIRTUAL ACADEMY   Regular School Yes Other KG 12 2021   grade_2 235 2 33   2 1     0   17   149 141             168         290 235 2 33   2 1     0   17   149 141         168       290
852774 ID     school 1600004 452   IDAHO VIRTUAL ACADEMY, INC. 160000400859 869 IDAHO VIRTUAL ACADEMY   Regular School Yes Other KG 12 2020   grade_2 50 0 8   0 1     0   5   28 36             36         64 50 0 8   0 1     0   5   28 36         36       64
1280298 ID     school 1600004 452   IDAHO VIRTUAL ACADEMY, INC. 160000400859 869 IDAHO VIRTUAL ACADEMY   Regular School Yes Other KG 12.0 2018   grade_2 74 1 10   1 0     0   3   50 39             56         89 74 1 10   1 0     0   3   50 39         56       89
1309172 ID     school 1600004 452   IDAHO VIRTUAL ACADEMY, INC. 160000400859 869 IDAHO VIRTUAL ACADEMY   Regular School Yes Other KG 12.0 2019   grade_2 51 0 9   1 1     0   2   32 32             41         64 51 0 9   1 1     0   2   32 32         41       64
1685688 ID     school 1600004 452   IDAHO VIRTUAL ACADEMY, INC. 160000400859 869 IDAHO VIRTUAL ACADEMY   Regular School Yes 4.0 PK 12 2015   grade_2 123 1 11   0 3     0   4   65 77             108         142 123 1 11   0 3     0   4   65 77         108       142
1729764 ID     school 1600004 452   IDAHO VIRTUAL ACADEMY, INC. 160000400859 869 IDAHO VIRTUAL ACADEMY   Regular School Yes Other PK 12.0 2017   grade_2 81 1 9   1 0     1   3   51 45             65         96 81 1 9   1 0     1   3   51 45         65       96
1824716 ID     school 1600004 452   IDAHO VIRTUAL ACADEMY, INC. 160000400859 869 IDAHO VIRTUAL ACADEMY   Regular School Yes 4.0 PK 12 2016   grade_2 108 0 7   0 1     1   3   45 75             69         120 108 0 7   0 1     1   3   45 75         69       120
707153 ID     school 1600005 453   IDAHO VIRTUAL HIGH SCHOOL, INC. 160000501087 1387 RICHARD MCKENNA CHARTER SCHOOL - MONTESSORI   Regular School Yes Elementary KG 08 2021   grade_2 20 0 4   0 0     0   0   16 8             12         24 20 0 4   0 0     0   0   16 8         12       24
852803 ID     school 1600005 453   IDAHO VIRTUAL HIGH SCHOOL, INC. 160000501087 1387 RICHARD MCKENNA CHARTER SCHOOL - MONTESSORI   Regular School Yes Elementary KG 07 2020   grade_2 19 1 4   0 0     0   0   12 12             7         24 19 1 4   0 0     0   0   12 12         7       24
1280324 ID     school 1600005 453   IDAHO VIRTUAL HIGH SCHOOL, INC. 160000501087 1387 RICHARD MCKENNA CHARTER SCHOOL - MONTESSORI   Regular School Yes Elementary KG 3.0 2018   grade_2 21 0 3   0 0     0   0   12 12             *         24 21 0 3   0 0     0   0   12 12                 24
1309198 ID     school 1600005 453   IDAHO VIRTUAL HIGH SCHOOL, INC. 160000501087 1387 RICHARD MCKENNA CHARTER SCHOOL - MONTESSORI   Regular School Yes Elementary KG 3.0 2019   grade_2 22 0 2   0 0     0   0   18 6             5         24 22 0 2   0 0     0   0   18 6         5       24
707167 ID     school 1600006 454   ROLLING HILLS PUBLIC CHARTER SCHOOL, INC. 160000600863 574 ROLLING HILLS PUBLIC CHARTER   Regular School Yes Elementary KG 08 2021   grade_2 20 0 3   0 0     0   3   16 10             6         26 20 0 3   0 0     0   3   16 10         6       26
852815 ID     school 1600006 454   ROLLING HILLS PUBLIC CHARTER SCHOOL, INC. 160000600863 574 ROLLING HILLS PUBLIC CHARTER   Regular School Yes Elementary KG 08 2020   grade_2 24 0 1   0 1     0   2   14 14             11         28 24 0 1   0 1     0   2   14 14         11       28
1280333 ID     school 1600006 454   ROLLING HILLS PUBLIC CHARTER SCHOOL, INC. 160000600863 574 ROLLING HILLS PUBLIC CHARTER   Regular School Yes Elementary KG 8.0 2018   grade_2 23 0 2   0 0     0   4   12 17             14         29 23 0 2   0 0     0   4   12 17         14       29
1309208 ID     school 1600006 454   ROLLING HILLS PUBLIC CHARTER SCHOOL, INC. 160000600863 574 ROLLING HILLS PUBLIC CHARTER   Regular School Yes Elementary KG 8.0 2019   grade_2 21 0 3   0 0     0   1   18 7             11         25 21 0 3   0 0     0   1   18 7         11       25
1685714 ID     school 1600006 454   ROLLING HILLS PUBLIC CHARTER SCHOOL, INC. 160000600863 574 ROLLING HILLS PUBLIC CHARTER   Regular School Yes 1.0 PK 08 2015   grade_2 29 0 0   0 0     0   1   19 11             13         30 29 0 0   0 0     0   1   19 11         13       30
1729793 ID     school 1600006 454   ROLLING HILLS PUBLIC CHARTER SCHOOL, INC. 160000600863 574 ROLLING HILLS PUBLIC CHARTER   Regular School Yes Elementary PK 8.0 2017   grade_2 24 0 1   0 0     0   3   17 11             9         28 24 0 1   0 0     0   3   17 11         9       28
1824742 ID     school 1600006 454   ROLLING HILLS PUBLIC CHARTER SCHOOL, INC. 160000600863 574 ROLLING HILLS PUBLIC CHARTER   Regular School Yes 1.0 PK 08 2016   grade_2 22 0 1   0 0     0   2   11 14             13         25 22 0 1   0 0     0   2   11 14         13       25
707180 ID     school 1600007 455   COMPASS PUBLIC CHARTER SCHOOL, INC. 160000700864 575 COMPASS PUBLIC CHARTER SCHOOL   Regular School Yes Other KG 12 2021   grade_2 89 1 7   0 5     1   1   48 56             16         104 89 1 7   0 5     1   1   48 56         16       104
852828 ID     school 1600007 455   COMPASS PUBLIC CHARTER SCHOOL, INC. 160000700864 575 COMPASS PUBLIC CHARTER SCHOOL   Regular School Yes Other KG 12 2020   grade_2 86 0 14   0 4     0   8   57 55             18         112 86 0 14   0 4     0   8   57 55         18       112
1280346 ID     school 1600007 455   COMPASS PUBLIC CHARTER SCHOOL, INC. 160000700864 575 COMPASS PUBLIC CHARTER SCHOOL   Regular School Yes Other KG 12.0 2018   grade_2 66 2 5   0 2     0   2   34 43             18         77 66 2 5   0 2     0   2   34 43         18       77
1309221 ID     school 1600007 455   COMPASS PUBLIC CHARTER SCHOOL, INC. 160000700864 575 COMPASS PUBLIC CHARTER SCHOOL   Regular School Yes Other KG 12.0 2019   grade_2 70 2 15   0 5     0   3   52 43             13         95 70 2 15   0 5     0   3   52 43         13       95
1685727 ID     school 1600007 455   COMPASS PUBLIC CHARTER SCHOOL, INC. 160000700864 575 COMPASS PUBLIC CHARTER SCHOOL   Regular School Yes 4.0 PK 12 2015   grade_2 41 1 9   0 0     0   1   24 28             14         52 41 1 9   0 0     0   1   24 28         14       52

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