Data source: Big Local News · About: Big Local

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

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
705008 ID     school   150   SODA SPRINGS JOINT DISTRICT   1025 BORDER DISTRICT - FREEDOM ELEMENTARY             2021   grade_2 2 0 0   0 0     0   0   1 1             *         2 2 0 0   0 0     0   0   1 1                 2
850055 ID     school   92   SWAN VALLEY ELEMENTARY DISTRICT   1014 BORDER DISTRICT - STAR VALLEY ELEMENTARY SCHOOL             2020   grade_2 1 0 0   0 0     0   0   0 1             *         1 1 0 0   0 0     0   0   0 1                 1
850721 ID     school   150   SODA SPRINGS JOINT DISTRICT   1025 BORDER DISTRICT - FREEDOM ELEMENTARY             2020   grade_2 6 0 0   0 0     0   0   1 5             *         6 6 0 0   0 0     0   0   1 5                 6
1278264 ID     school   150   SODA SPRINGS JOINT DISTRICT   1025 BORDER DISTRICT - FREEDOM ELEMENTARY             2018   grade_2 1 0 0   0 0     0   0   1 0             *         1 1 0 0   0 0     0   0   1 0                 1
1307119 ID     school   150   SODA SPRINGS JOINT DISTRICT   1025 BORDER DISTRICT - FREEDOM ELEMENTARY             2019   grade_2 2 0 0   0 0     0   0   0 2             *         2 2 0 0   0 0     0   0   0 2                 2
1308441 ID     school   340   LEWISTON INDEPENDENT DISTRICT   611 NORTHWEST CHILDRENS HOME             2019   grade_2 1 0 0   0 0     0   0   1 0             *         1 1 0 0   0 0     0   0   1 0                 1
1727719 ID     school   150   SODA SPRINGS JOINT DISTRICT   1025 BORDER DISTRICT - FREEDOM ELEMENTARY             2017   grade_2 1 0 0   0 0     0   0   0 1             *         1 1 0 0   0 0     0   0   0 1                 1
1729038 ID     school   340   LEWISTON INDEPENDENT DISTRICT   611 NORTHWEST CHILDRENS HOME             2017   grade_2 1 0 0   1 0     0   0   2 0             *         2 1 0 0   1 0     0   0   2 0                 2
1824021 ID     school   340   LEWISTON INDEPENDENT DISTRICT   611 NORTHWEST CHILDRENS HOME             2016   grade_2 1 0 0   0 0     0   0   1 0             *         1 1 0 0   0 0     0   0   1 0                 1
704963 ID     school 1601290 148   GRACE JOINT DISTRICT 160129000228 462 THATCHER ELEMENTARY SCHOOL   Regular School No Elementary 01 05 2021   grade_2 17 0 0   0 0     0   0   8 9             *         17 17 0 0   0 0     0   0   8 9                 17
850675 ID     school 1601290 148   GRACE JOINT DISTRICT 160129000228 462 THATCHER ELEMENTARY SCHOOL   Regular School No Elementary 01 05 2020   grade_2 17 0 0   0 0     0   0   9 8             12         17 17 0 0   0 0     0   0   9 8         12       17
851605 ID     school 1602670 273   POST FALLS DISTRICT 160267000209 736 PRAIRIE VIEW ELEMENTARY   Regular School No Elementary 01 05 2020   grade_2 79 1 3   1 0     0   5   50 39             39         89 79 1 3   1 0     0   5   50 39         39       89
851632 ID     school 1602670 273   POST FALLS DISTRICT 160267001085 1388 GREENSFERRY ELEMENTARY SCHOOL   Regular School No Elementary 01 05 2020   grade_2 69 1 6   1 0     0   1   43 35             32         78 69 1 6   1 0     0   1   43 35         32       78
851638 ID     school 1602670 273   POST FALLS DISTRICT 160267000970 2517 WEST RIDGE ELEMENTARY SCHOOL   Regular School No Elementary 01 05 2020   grade_2 76 0 7   0 0     0   4   46 41             44         87 76 0 7   0 0     0   4   46 41         44       87
1278219 ID     school 1601290 148   GRACE JOINT DISTRICT 160129000228 462 THATCHER ELEMENTARY SCHOOL   Regular School No Elementary 01 5.0 2018   grade_2 24 0 0   0 0     0   0   9 15             14         24 24 0 0   0 0     0   0   9 15         14       24
1279133 ID     school 1602670 273   POST FALLS DISTRICT 160267000209 736 PRAIRIE VIEW ELEMENTARY   Regular School No Elementary 01 5.0 2018   grade_2 82 1 7   0 1     0   4   47 48             38         95 82 1 7   0 1     0   4   47 48         38       95
1279139 ID     school 1602670 273   POST FALLS DISTRICT 160267000487 748 PONDEROSA ELEMENTARY SCHOOL   Regular School No Elementary 01 5.0 2018   grade_2 75 0 4   0 0     0   3   38 44             50         82 75 0 4   0 0     0   3   38 44         50       82
1279145 ID     school 1602670 273   POST FALLS DISTRICT 160267000490 749 SELTICE ELEMENTARY SCHOOL   Regular School No Elementary 01 5.0 2018   grade_2 56 0 5   0 0     1   4   26 40             34         66 56 0 5   0 0     1   4   26 40         34       66
1279158 ID     school 1602670 273   POST FALLS DISTRICT 160267001085 1388 GREENSFERRY ELEMENTARY SCHOOL   Regular School No Elementary 01 5.0 2018   grade_2 65 0 3   1 0     0   2   34 37             26         71 65 0 3   1 0     0   2   34 37         26       71
1279164 ID     school 1602670 273   POST FALLS DISTRICT 160267000970 2517 WEST RIDGE ELEMENTARY SCHOOL   Regular School No Elementary 01 5.0 2018   grade_2 67 0 3   1 0     0   3   39 35             35         74 67 0 3   1 0     0   3   39 35         35       74
1307073 ID     school 1601290 148   GRACE JOINT DISTRICT 160129000228 462 THATCHER ELEMENTARY SCHOOL   Regular School No Elementary 01 5.0 2019   grade_2 16 0 1   0 0     0   0   11 6             *         17 16 0 1   0 0     0   0   11 6                 17
1308002 ID     school 1602670 273   POST FALLS DISTRICT 160267000209 736 PRAIRIE VIEW ELEMENTARY   Regular School No Elementary 01 5.0 2019   grade_2 76 1 5   1 0     0   2   39 46             49         85 76 1 5   1 0     0   2   39 46         49       85
1308008 ID     school 1602670 273   POST FALLS DISTRICT 160267000487 748 PONDEROSA ELEMENTARY SCHOOL   Regular School No Elementary 01 5.0 2019   grade_2 69 0 8   0 0     1   0   48 30             40         78 69 0 8   0 0     1   0   48 30         40       78
1308014 ID     school 1602670 273   POST FALLS DISTRICT 160267000490 749 SELTICE ELEMENTARY SCHOOL   Regular School No Elementary 01 5.0 2019   grade_2 50 0 5   2 0     2   3   35 27             30         62 50 0 5   2 0     2   3   35 27         30       62
1308027 ID     school 1602670 273   POST FALLS DISTRICT 160267001085 1388 GREENSFERRY ELEMENTARY SCHOOL   Regular School No Elementary 01 5.0 2019   grade_2 62 0 7   0 1     0   5   43 32             30         75 62 0 7   0 1     0   5   43 32         30       75
1308033 ID     school 1602670 273   POST FALLS DISTRICT 160267000970 2517 WEST RIDGE ELEMENTARY SCHOOL   Regular School No Elementary 01 5.0 2019   grade_2 67 1 6   0 0     0   7   43 38             44         81 67 1 6   0 0     0   7   43 38         44       81
1682567 ID     school 1600270 55   BLACKFOOT DISTRICT 160027000031 382 DONALD D STALKER ELEMENTARY   Regular School No 1.0 01 05 2015   grade_2 35 0 13   9 0     0   3   33 27             42         60 35 0 13   9 0     0   3   33 27         42       60
1682603 ID     school 1600270 55   BLACKFOOT DISTRICT 160027000028 388 I T STODDARD ELEMENTARY SCHOOL   Regular School No 1.0 01 05 2015   grade_2 42 1 23   6 0     0   2   33 41             51         74 42 1 23   6 0     0   2   33 41         51       74
1683630 ID     school 1601290 148   GRACE JOINT DISTRICT 160129000228 462 THATCHER ELEMENTARY SCHOOL   Regular School No 1.0 01 05 2015   grade_2 15 0 2   0 0     0   0   9 8             9         17 15 0 2   0 0     0   0   9 8         9       17
1684298 ID     school 1601590 261   JEROME JOINT DISTRICT 160159000289 297 JEROME ACADEMY   Special Education School No 4.0 01 12 2015   grade_2 1 0 1   0 0     0   0   2 0             *         2 1 0 1   0 0     0   0   2 0                 2
1684533 ID     school 1602670 273   POST FALLS DISTRICT 160267000209 736 PRAIRIE VIEW ELEMENTARY   Regular School No 1.0 01 05 2015   grade_2 142 0 12   1 1     0   9   90 75             82         165 142 0 12   1 1     0   9   90 75         82       165
1684539 ID     school 1602670 273   POST FALLS DISTRICT 160267000487 748 PONDEROSA ELEMENTARY SCHOOL   Regular School No 1.0 01 05 2015   grade_2 89 1 10   0 0     0   4   54 50             62         104 89 1 10   0 0     0   4   54 50         62       104
1684545 ID     school 1602670 273   POST FALLS DISTRICT 160267000490 749 SELTICE ELEMENTARY SCHOOL   Regular School No 1.0 01 05 2015   grade_2 59 0 4   0 1     0   2   30 36             42         66 59 0 4   0 1     0   2   30 36         42       66
1684558 ID     school 1602670 273   POST FALLS DISTRICT 160267000970 2517 WEST RIDGE ELEMENTARY SCHOOL   Regular School No 1.0 01 05 2015   grade_2 90 0 7   0 1     0   0   46 52             55         98 90 0 7   0 1     0   0   46 52         55       98
1727674 ID     school 1601290 148   GRACE JOINT DISTRICT 160129000228 462 THATCHER ELEMENTARY SCHOOL   Regular School No Elementary 01 5.0 2017   grade_2 15 0 0   0 0     0   0   10 5             7         15 15 0 0   0 0     0   0   10 5         7       15
1728358 ID     school 1601590 261   JEROME JOINT DISTRICT 160159000289 297 JEROME ACADEMY   Special Education School No Other 01 12.0 2017   grade_2 0 0 1   0 0     0   0   1 0             *         1 0 0 1   0 0     0   0   1 0                 1
1728592 ID     school 1602670 273   POST FALLS DISTRICT 160267000209 736 PRAIRIE VIEW ELEMENTARY   Regular School No Elementary 01 5.0 2017   grade_2 79 0 8   0 1     0   3   40 51             52         91 79 0 8   0 1     0   3   40 51         52       91
1728598 ID     school 1602670 273   POST FALLS DISTRICT 160267000487 748 PONDEROSA ELEMENTARY SCHOOL   Regular School No Elementary 01 5.0 2017   grade_2 81 0 6   0 1     0   5   43 50             55         93 81 0 6   0 1     0   5   43 50         55       93
1728604 ID     school 1602670 273   POST FALLS DISTRICT 160267000490 749 SELTICE ELEMENTARY SCHOOL   Regular School No Elementary 01 5.0 2017   grade_2 62 0 1   0 1     0   3   36 31             *         67 62 0 1   0 1     0   3   36 31                 67
1728617 ID     school 1602670 273   POST FALLS DISTRICT 160267001085 1388 GREENSFERRY ELEMENTARY SCHOOL   Regular School No Elementary 01 5.0 2017   grade_2 58 0 7   1 0     0   5   35 36             *         71 58 0 7   1 0     0   5   35 36                 71
1728623 ID     school 1602670 273   POST FALLS DISTRICT 160267000970 2517 WEST RIDGE ELEMENTARY SCHOOL   Regular School No Elementary 01 5.0 2017   grade_2 63 2 8   1 1     0   8   43 40             34         83 63 2 8   1 1     0   8   43 40         34       83
1821639 ID     school 1600270 55   BLACKFOOT DISTRICT 160027000028 388 I T STODDARD ELEMENTARY SCHOOL   Regular School No 1.0 01 05 2016   grade_2 58 0 18   9 0     0   3   40 48             44         88 58 0 18   9 0     0   3   40 48         44       88
1822676 ID     school 1601290 148   GRACE JOINT DISTRICT 160129000228 462 THATCHER ELEMENTARY SCHOOL   Regular School No 1.0 01 05 2016   grade_2 27 0 0   0 0     0   0   14 13             12         27 27 0 0   0 0     0   0   14 13         12       27
1823582 ID     school 1602670 273   POST FALLS DISTRICT 160267000209 736 PRAIRIE VIEW ELEMENTARY   Regular School No 1.0 01 05 2016   grade_2 112 1 8   2 0     0   3   53 73             48         126 112 1 8   2 0     0   3   53 73         48       126
1823588 ID     school 1602670 273   POST FALLS DISTRICT 160267000487 748 PONDEROSA ELEMENTARY SCHOOL   Regular School No 1.0 01 05 2016   grade_2 105 1 5   0 0     0   1   57 55             56         112 105 1 5   0 0     0   1   57 55         56       112
1823594 ID     school 1602670 273   POST FALLS DISTRICT 160267000490 749 SELTICE ELEMENTARY SCHOOL   Regular School No 1.0 01 05 2016   grade_2 61 2 5   0 0     0   0   32 36             *         68 61 2 5   0 0     0   0   32 36                 68
1823607 ID     school 1602670 273   POST FALLS DISTRICT 160267000970 2517 WEST RIDGE ELEMENTARY SCHOOL   Regular School No 1.0 01 05 2016   grade_2 68 0 4   0 2     0   2   40 36             33         76 68 0 4   0 2     0   2   40 36         33       76
703814 ID     school 1602970 52   SNAKE RIVER DISTRICT 160297000518 376 RIVERSIDE ELEMENTARY SCHOOL   Regular School No Elementary 02 03 2021   grade_2 94 0 14   1 1     0   0   57 53             *         110 94 0 14   1 1     0   0   57 53                 110
705727 ID     school 1601590 261   JEROME JOINT DISTRICT 160159000972 2516 SUMMIT ELEMENTARY   Regular School No Elementary 02 05 2021   grade_2 1 0 1   0 0     0   0   2 0             *         2 1 0 1   0 0     0   0   2 0                 2
849572 ID     school 1602970 52   SNAKE RIVER DISTRICT 160297000518 376 RIVERSIDE ELEMENTARY SCHOOL   Regular School No Elementary 02 03 2020   grade_2 109 0 19   0 0     0   2   68 62             59         130 109 0 19   0 0     0   2   68 62         59       130
1277120 ID     school 1602970 52   SNAKE RIVER DISTRICT 160297000518 376 RIVERSIDE ELEMENTARY SCHOOL   Regular School No Elementary 02 3.0 2018   grade_2 114 1 20   2 0     0   1   72 66             62         138 114 1 20   2 0     0   1   72 66         62       138
1305980 ID     school 1602970 52   SNAKE RIVER DISTRICT 160297000518 376 RIVERSIDE ELEMENTARY SCHOOL   Regular School No Elementary 02 3.0 2019   grade_2 97 0 22   2 1     0   2   69 55             53         124 97 0 22   2 1     0   2   69 55         53       124
1682545 ID     school 1602970 52   SNAKE RIVER DISTRICT 160297000518 376 RIVERSIDE ELEMENTARY SCHOOL   Regular School No 1.0 02 03 2015   grade_2 105 0 24   4 0     0   1   73 61             67         134 105 0 24   4 0     0   1   73 61         67       134
1684259 ID     school 1602790 252   RIRIE JOINT DISTRICT 160279000435 229 RIRIE ELEMENTARY SCHOOL   Regular School No 1.0 02 08 2015   grade_2 35 0 3   1 0     0   0   20 19             22         39 35 0 3   1 0     0   0   20 19         22       39
1726585 ID     school 1602970 52   SNAKE RIVER DISTRICT 160297000518 376 RIVERSIDE ELEMENTARY SCHOOL   Regular School No Elementary 02 3.0 2017   grade_2 98 1 21   0 0     0   2   66 56             57         122 98 1 21   0 0     0   2   66 56         57       122
1821580 ID     school 1602970 52   SNAKE RIVER DISTRICT 160297000518 376 RIVERSIDE ELEMENTARY SCHOOL   Regular School No 1.0 02 03 2016   grade_2 100 1 26   2 0     0   3   71 61             67         132 100 1 26   2 0     0   3   71 61         67       132
703243 ID     school 1602100 2   JOINT SCHOOL DISTRICT NO. 2 160210000639 339 BARBARA MORGAN STEM ACADEMY   Regular School No Elementary KG 05 2021   grade_2 44 2 16   1 0     0   1   39 25             14         64 44 2 16   1 0     0   1   39 25         14       64
703609 ID     school 1602640 25   POCATELLO DISTRICT 160264000467 353 EDAHOW ELEMENTARY SCHOOL   Regular School No Elementary KG 05 2021   grade_2 45 0 5   5 1     1   0   24 33             20         57 45 0 5   5 1     1   0   24 33         20       57
703616 ID     school 1602640 25   POCATELLO DISTRICT 160264000470 354 GREENACRES ELEMENTARY SCHOOL   Regular School No Elementary KG 05 2021   grade_2 31 2 9   2 0     2   1   26 21             33         47 31 2 9   2 0     2   1   26 21         33       47
703623 ID     school 1602640 25   POCATELLO DISTRICT 160264000473 355 INDIAN HILLS ELEMENTARY SCHOOL   Regular School No Elementary KG 05 2021   grade_2 67 1 9   2 0     0   2   37 44             32         81 67 1 9   2 0     0   2   37 44         32       81
703637 ID     school 1602640 25   POCATELLO DISTRICT 160264000642 357 GATE CITY ELEMENTARY SCHOOL   Regular School No Elementary KG 05 2021   grade_2 52 1 6   0 1     0   4   31 33             14         64 52 1 6   0 1     0   4   31 33         14       64
703651 ID     school 1602640 25   POCATELLO DISTRICT 160264000484 359 WASHINGTON ELEMENTARY SCHOOL   Regular School No Elementary KG 05 2021   grade_2 30 0 4   1 1     0   2   20 18             27         38 30 0 4   1 1     0   2   20 18         27       38
703672 ID     school 1602640 25   POCATELLO DISTRICT 160264000465 362 CLAUDE A WILCOX ELEMENTARY SCHOOL   Regular School No Elementary KG 05 2021   grade_2 73 1 14   3 1     1   1   56 38             62         94 73 1 14   3 1     1   1   56 38         62       94
703686 ID     school 1602640 25   POCATELLO DISTRICT 160264000482 366 TENDOY ELEMENTARY SCHOOL   Regular School No Elementary KG 05 2021   grade_2 28 0 3   0 0     0   1   11 21             22         32 28 0 3   0 0     0   1   11 21         22       32
703693 ID     school 1602640 25   POCATELLO DISTRICT 160264000476 368 LEWIS & CLARK ELEMENTARY SCHOOL   Regular School No Elementary KG 05 2021   grade_2 66 0 15   4 1     0   3   45 44             59         89 66 0 15   4 1     0   3   45 44         59       89
703753 ID     school 1600240 33   BEAR LAKE COUNTY DISTRICT 160024001136 1455 BEAR LAKE ON-LINE LEARNING   Regular School No Elementary KG 08 2021   grade_2 28 0 1   0 0     0   0   16 13             6         29 28 0 1   0 0     0   0   16 13         6       29
703779 ID     school 1603060 41   ST MARIES JOINT DISTRICT 160306000536 374 UPRIVER ELEMENTARY SCHOOL   Regular School No Elementary KG 06 2021   grade_2 9 0 0   0 0     0   0   2 7             *         9 9 0 0   0 0     0   0   2 7                 9
703826 ID     school 1602970 52   SNAKE RIVER DISTRICT 160297001137 1451 SNAKE RIVER ONLINE   Regular School No Elementary KG 08 2021   grade_2 59 0 5   0 1     0   3   36 32             *         68 59 0 5   0 1     0   3   36 32                 68
703861 ID     school 1600270 55   BLACKFOOT DISTRICT 160027000032 385 WAPELLO ELEMENTARY SCHOOL   Regular School No Elementary KG 05 2021   grade_2 32 0 4   0 0     0   0   22 14             12         36 32 0 4   0 0     0   0   22 14         12       36
703889 ID     school 1600270 55   BLACKFOOT DISTRICT 160027001138 1452 BLACKFOOT ONLINE SCHOOL SOLUTION   Regular School No Elementary KG 08 2021   grade_2 8 0 9   6 0     0   1   13 11             12         24 8 0 9   6 0     0   1   13 11         12       24
703946 ID     school 1602910 60   SHELLEY JOINT DISTRICT 160291000508 391 SUNRISE ELEMENTARY SCHOOL   Regular School No Elementary KG 02 2021   grade_2 142 0 15   1 0     0   2   94 66             52         160 142 0 15   1 0     0   2   94 66         52       160
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
704315 ID     school 1601530 91   IDAHO FALLS DISTRICT 160153001139 1454 D91 ONLINE ACADEMY - ELEMENTARY   Regular School No Elementary KG 06 2021   grade_2 32 0 13   1 3     0   3   30 22             28         52 32 0 13   1 3     0   3   30 22         28       52
704470 ID     school 1600930 93   BONNEVILLE JOINT DISTRICT 160093001062 1360 SUMMIT HILLS ELEMENTARY SCHOOL   Regular School No Elementary KG 06 2021   grade_2 62 1 19   1 0     1   3   48 39             33         87 62 1 19   1 0     1   3   48 39         33       87
704508 ID     school 1600420 101   BOUNDARY COUNTY DISTRICT 160042000092 433 NAPLES ELEMENTARY SCHOOL   Regular School No Elementary KG 05 2021   grade_2 22 0 0   0 0     1   0   13 10             10         23 22 0 0   0 0     1   0   13 10         10       23
704515 ID     school 1600420 101   BOUNDARY COUNTY DISTRICT 160042000091 434 MOUNT HALL ELEMENTARY SCHOOL   Regular School No Elementary KG 05 2021   grade_2 24 0 1   1 0     0   0   18 8             11         26 24 0 1   1 0     0   0   18 8         11       26
704708 ID     school 1602340 131   NAMPA SCHOOL DISTRICT 160234000941 2889 NEW HORIZON MAGNET SCHOOL   Regular School No Elementary KG 07 2021   grade_2 13 0 76   0 0     0   0   44 45             41         89 13 0 76   0 0     0   0   44 45         41       89
704758 ID     school 1600510 132   CALDWELL DISTRICT 160051000107 451 VAN BUREN ELEMENTARY SCHOOL   Regular School No Elementary KG 05 2021   grade_2 29 0 54   2 1     0   2   48 40             51         88 29 0 54   2 1     0   2   48 40         51       88
704789 ID     school 1603480 133   WILDER DISTRICT 160348000585 452 WILDER ELEMENTARY SCHOOL   Regular School No Elementary KG 05 2021   grade_2 9 0 27   0 0     0   2   19 19             *         38 9 0 27   0 0     0   2   19 19                 38
705092 ID     school 1600660 151   CASSIA COUNTY JOINT DISTRICT 160066000128 474 DWORSHAK ELEMENTARY SCHOOL   Regular School No Elementary KG 06 2021   grade_2 22 0 21   0 0     0   0   19 24             22         43 22 0 21   0 0     0   0   19 24         22       43
705114 ID     school 1600660 151   CASSIA COUNTY JOINT DISTRICT 160066001088 1395 JOHN V EVANS ELEMENTARY   Regular School No Elementary KG 06 2021   grade_2 37 0 31   0 0     0   1   43 26             36         69 37 0 31   0 0     0   1   43 26         36       69
705125 ID     school 1600660 151   CASSIA COUNTY JOINT DISTRICT 160066001141 1441 MINI-CASSIA ONLINE LEARNING ACADEMY   Regular School No Other KG 12 2021   grade_2 9 0 4   0 0     0   1   6 8             *         14 9 0 4   0 0     0   1   6 8                 14
705406 ID     school 1601020 221   EMMETT INDEPENDENT DISTRICT 160102000797 230 KENNETH J CARBERRY ELEMENTARY   Regular School No Elementary KG 05 2021   grade_2 80 0 12   1 0     0   11   55 49             49         104 80 0 12   1 0     0   11   55 49         49       104
705413 ID     school 1601020 221   EMMETT INDEPENDENT DISTRICT 160102000798 251 SHADOW BUTTE ELEMENTARY SCHOOL   Regular School No Elementary KG 05 2021   grade_2 71 0 7   0 1     0   4   40 43             *         83 71 0 7   0 1     0   4   40 43                 83
705420 ID     school 1601020 221   EMMETT INDEPENDENT DISTRICT 160102000192 707 SWEET MONTOUR ELEMENTARY SCHOOL   Regular School No Elementary KG 05 2021   grade_2 6 0 0   0 0     0   0   4 2             *         6 6 0 0   0 0     0   0   4 2                 6
705430 ID     school 1601020 221   EMMETT INDEPENDENT DISTRICT 160102000190 710 OLA ELEMENTARY SCHOOL   Regular School No Elementary KG 06 2021   grade_2 3 0 0   0 0     0   0   2 1             *         3 3 0 0   0 0     0   0   2 1                 3
705499 ID     school 1601380 233   HAGERMAN JOINT DISTRICT 160138001143 1456 HAGERMAN VIRTUAL SCHOOL   Regular School No Elementary KG 08 2021   grade_2 13 0 1   0 0     0   0   8 6             *         14 13 0 1   0 0     0   0   8 6                 14
705610 ID     school 1601570 251   JEFFERSON COUNTY JOINT DISTRICT 160157000276 725 JEFFERSON ELEMENTARY SCHOOL   Regular School No Elementary KG 05 2021   grade_2 81 0 7   0 0     0   1   46 43             18         89 81 0 7   0 0     0   1   46 43         18       89
705640 ID     school 1601570 251   JEFFERSON COUNTY JOINT DISTRICT 160157001128 1437 COTTONWOOD ELEMENTARY   Regular School No Elementary KG 05 2021   grade_2 83 0 16   0 1     0   2   56 46             29         102 83 0 16   0 1     0   2   56 46         29       102
705651 ID     school 1601570 251   JEFFERSON COUNTY JOINT DISTRICT 160157001132 1447 RIGBY VIRTUAL ACADEMY   Regular School No Elementary KG 08 2021   grade_2 20 0 5   0 0     0   2   6 21             *         27 20 0 5   0 0     0   2   6 21                 27
705689 ID     school 1603400 253   WEST JEFFERSON DISTRICT 160340000273 729 HAMER ELEMENTARY SCHOOL   Regular School No Elementary KG 04 2021   grade_2 6 0 1   0 0     0   0   4 3             *         7 6 0 1   0 0     0   0   4 3                 7
705717 ID     school 1601590 261   JEROME JOINT DISTRICT 160159000283 731 JEFFERSON ELEMENTARY SCHOOL   Regular School No Elementary KG 03 2021   grade_2 66 0 90   0 0     0   0   76 80             *         156 66 0 90   0 0     0   0   76 80                 156
705783 ID     school 1600780 271   COEUR D'ALENE DISTRICT 160078000208 514 FERNAN STEM ACADEMY   Regular School No Elementary KG 05 2021   grade_2 55 2 3   0 0     0   10   37 33             26         70 55 2 3   0 0     0   10   37 33         26       70
705790 ID     school 1600780 271   COEUR D'ALENE DISTRICT 160078000146 735 BORAH ELEMENTARY SCHOOL   Regular School No Elementary KG 05 2021   grade_2 51 0 8   1 0     0   3   45 18             43         63 51 0 8   1 0     0   3   45 18         43       63
705811 ID     school 1600780 271   COEUR D'ALENE DISTRICT 160078000152 740 ATLAS ELEMENTARY SCHOOL   Regular School No Elementary KG 05 2021   grade_2 65 0 3   1 2     0   4   43 32             18         75 65 0 3   1 2     0   4   43 32         18       75
705945 ID     school 1602670 273   POST FALLS DISTRICT 160267000209 736 PRAIRIE VIEW ELEMENTARY   Regular School No Elementary KG 05 2021   grade_2 62 1 6   1 1     0   0   41 30             19         71 62 1 6   1 1     0   0   41 30         19       71
705978 ID     school 1602670 273   POST FALLS DISTRICT 160267001129 1445 TREATY ROCK ELEMENTARY   Regular School No Elementary KG 05 2021   grade_2 57 0 7   1 1     0   1   26 41             30         67 57 0 7   1 1     0   1   26 41         30       67
706024 ID     school 1602220 281   MOSCOW DISTRICT 160222000392 754 LENA WHITMORE ELEMENTARY SCHOOL   Regular School No Elementary KG 05 2021   grade_2 27 0 3   1 0     0   0   16 15             *         31 27 0 3   1 0     0   0   16 15                 31
706031 ID     school 1602220 281   MOSCOW DISTRICT 160222000395 755 WEST PARK ELEMENTARY SCHOOL   Regular School No Elementary KG 02 2021   grade_2 42 2 4   1 3     0   0   35 17             21         52 42 2 4   1 3     0   0   35 17         21       52
706179 ID     school 1601620 304   KAMIAH JOINT DISTRICT 160162000286 768 KAMIAH ELEMENTARY SCHOOL   Regular School No Elementary KG 03 2021   grade_2 20 0 1   3 0     0   2   14 12             9         26 20 0 1   3 0     0   2   14 12         9       26

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