Data source: Big Local News · About: Big Local

4,725 rows where state = "ID" and year = 2017 sorted by ccd_school_low_grade

View and edit SQL

grade

year

  • 2017 · 4,725
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
1726928 ID     school   84   LAKE PEND OREILLE SCHOOL DISTRICT   1391 LPOSD HOME SCHOOL ACADEMY             2017   grade_4 2 0 0   0 0     0   0   2 0             *         2 2 0 0   0 0     0   0   2 0                 2
1726929 ID     school   84   LAKE PEND OREILLE SCHOOL DISTRICT   1391 LPOSD HOME SCHOOL ACADEMY             2017   k_12_total 2 0 0   0 0     0   0   2 0             *         2 2 0 0   0 0     0   0   2 0                 2
1727070 ID     school   92   SWAN VALLEY ELEMENTARY DISTRICT   1014 BORDER DISTRICT - STAR VALLEY ELEMENTARY SCHOOL             2017   grade_7 1 0 0   0 0     0   0   0 1             *         1 1 0 0   0 0     0   0   0 1                 1
1727071 ID     school   92   SWAN VALLEY ELEMENTARY DISTRICT   1014 BORDER DISTRICT - STAR VALLEY ELEMENTARY SCHOOL             2017   k_12_total 1 0 0   0 0     0   0   0 1             *         1 1 0 0   0 0     0   0   0 1                 1
1727072 ID     school   92   SWAN VALLEY ELEMENTARY DISTRICT   1015 BORDER DISTRICT - STAR VALLEY JR-SR HIGH SCHOOL             2017   grade_11 1 0 0   0 0     0   0   0 1             *         1 1 0 0   0 0     0   0   0 1                 1
1727073 ID     school   92   SWAN VALLEY ELEMENTARY DISTRICT   1015 BORDER DISTRICT - STAR VALLEY JR-SR HIGH SCHOOL             2017   grade_9 2 0 0   0 0     0   0   1 1             *         2 2 0 0   0 0     0   0   1 1                 2
1727074 ID     school   92   SWAN VALLEY ELEMENTARY DISTRICT   1015 BORDER DISTRICT - STAR VALLEY JR-SR HIGH SCHOOL             2017   k_12_total 3 0 0   0 0     0   0   1 2             *         3 3 0 0   0 0     0   0   1 2                 3
1727718 ID     school   150   SODA SPRINGS JOINT DISTRICT   1025 BORDER DISTRICT - FREEDOM ELEMENTARY             2017   grade_1 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
1727720 ID     school   150   SODA SPRINGS JOINT DISTRICT   1025 BORDER DISTRICT - FREEDOM ELEMENTARY             2017   grade_3 0 0 1   0 0     0   0   0 1             *         1 0 0 1   0 0     0   0   0 1                 1
1727721 ID     school   150   SODA SPRINGS JOINT DISTRICT   1025 BORDER DISTRICT - FREEDOM ELEMENTARY             2017   grade_5 1 0 0   0 0     0   0   1 0             *         1 1 0 0   0 0     0   0   1 0                 1
1727722 ID     school   150   SODA SPRINGS JOINT DISTRICT   1025 BORDER DISTRICT - FREEDOM ELEMENTARY             2017   grade_6 1 0 1   0 0     0   0   1 1             *         2 1 0 1   0 0     0   0   1 1                 2
1727723 ID     school   150   SODA SPRINGS JOINT DISTRICT   1025 BORDER DISTRICT - FREEDOM ELEMENTARY             2017   k_12_total 4 0 2   0 0     0   0   3 3             *         6 4 0 2   0 0     0   0   3 3                 6
1727724 ID     school   150   SODA SPRINGS JOINT DISTRICT   1026 BORDER DISTRICT FREEDOM - SECONDARY             2017   grade_10 1 0 2   0 0     0   0   2 1             *         3 1 0 2   0 0     0   0   2 1                 3
1727725 ID     school   150   SODA SPRINGS JOINT DISTRICT   1026 BORDER DISTRICT FREEDOM - SECONDARY             2017   grade_12 1 0 0   0 0     0   0   1 0             *         1 1 0 0   0 0     0   0   1 0                 1
1727726 ID     school   150   SODA SPRINGS JOINT DISTRICT   1026 BORDER DISTRICT FREEDOM - SECONDARY             2017   grade_7 0 0 2   0 0     0   0   2 0             *         2 0 0 2   0 0     0   0   2 0                 2
1727727 ID     school   150   SODA SPRINGS JOINT DISTRICT   1026 BORDER DISTRICT FREEDOM - SECONDARY             2017   grade_8 2 0 0   0 0     0   0   2 0             *         2 2 0 0   0 0     0   0   2 0                 2
1727728 ID     school   150   SODA SPRINGS JOINT DISTRICT   1026 BORDER DISTRICT FREEDOM - SECONDARY             2017   grade_9 1 0 0   0 0     0   0   1 0             *         1 1 0 0   0 0     0   0   1 0                 1
1727729 ID     school   150   SODA SPRINGS JOINT DISTRICT   1026 BORDER DISTRICT FREEDOM - SECONDARY             2017   k_12_total 5 0 4   0 0     0   0   8 1             *         9 5 0 4   0 0     0   0   8 1                 9
1729035 ID     school   340   LEWISTON INDEPENDENT DISTRICT   611 NORTHWEST CHILDRENS HOME             2017   grade_10 0 0 0   1 0     0   0   1 0             *         1 0 0 0   1 0     0   0   1 0                 1
1729036 ID     school   340   LEWISTON INDEPENDENT DISTRICT   611 NORTHWEST CHILDRENS HOME             2017   grade_11 1 0 0   0 0     1   0   2 0             *         2 1 0 0   0 0     1   0   2 0                 2
1729037 ID     school   340   LEWISTON INDEPENDENT DISTRICT   611 NORTHWEST CHILDRENS HOME             2017   grade_12 1 0 0   0 0     0   0   1 0             *         1 1 0 0   0 0     0   0   1 0                 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
1729039 ID     school   340   LEWISTON INDEPENDENT DISTRICT   611 NORTHWEST CHILDRENS HOME             2017   grade_3 2 0 0   0 0     0   0   2 0             *         2 2 0 0   0 0     0   0   2 0                 2
1729040 ID     school   340   LEWISTON INDEPENDENT DISTRICT   611 NORTHWEST CHILDRENS HOME             2017   grade_5 1 0 0   0 0     0   1   1 1             *         2 1 0 0   0 0     0   1   1 1                 2
1729041 ID     school   340   LEWISTON INDEPENDENT DISTRICT   611 NORTHWEST CHILDRENS HOME             2017   grade_6 2 0 0   0 0     0   0   2 0             *         2 2 0 0   0 0     0   0   2 0                 2
1729042 ID     school   340   LEWISTON INDEPENDENT DISTRICT   611 NORTHWEST CHILDRENS HOME             2017   grade_7 1 0 0   0 0     0   0   1 0             *         1 1 0 0   0 0     0   0   1 0                 1
1729043 ID     school   340   LEWISTON INDEPENDENT DISTRICT   611 NORTHWEST CHILDRENS HOME             2017   grade_8 1 0 0   0 0     0   0   1 0             *         1 1 0 0   0 0     0   0   1 0                 1
1729044 ID     school   340   LEWISTON INDEPENDENT DISTRICT   611 NORTHWEST CHILDRENS HOME             2017   grade_9 2 0 0   1 0     0   0   2 1             *         3 2 0 0   1 0     0   0   2 1                 3
1729045 ID     school   340   LEWISTON INDEPENDENT DISTRICT   611 NORTHWEST CHILDRENS HOME             2017   k_12_total 12 0 0   3 0     1   1   15 2             *         17 12 0 0   3 0     1   1   15 2                 17
1729199 ID     school   364   PLEASANT VALLEY ELEMENTARY DISTRICT   1056 BORDER DISTRICT - JORDAN VALLEY SECONDARY             2017   grade_10 2 0 0   0 0     0   0   0 2             *         2 2 0 0   0 0     0   0   0 2                 2
1729200 ID     school   364   PLEASANT VALLEY ELEMENTARY DISTRICT   1056 BORDER DISTRICT - JORDAN VALLEY SECONDARY             2017   grade_9 1 0 0   0 0     0   0   1 0             *         1 1 0 0   0 0     0   0   1 0                 1
1729201 ID     school   364   PLEASANT VALLEY ELEMENTARY DISTRICT   1056 BORDER DISTRICT - JORDAN VALLEY SECONDARY             2017   k_12_total 3 0 0   0 0     0   0   1 2             *         3 3 0 0   0 0     0   0   1 2                 3
1726494 ID     school 1602640 25   POCATELLO DISTRICT 160264000186 9034 POCATELLO JUVENILE DETENTION   Alternative School No Other 01 12.0 2017   grade_10 2 0 0   0 0     0   0   2 0             *         2 2 0 0   0 0     0   0   2 0                 2
1726495 ID     school 1602640 25   POCATELLO DISTRICT 160264000186 9034 POCATELLO JUVENILE DETENTION   Alternative School No Other 01 12.0 2017   grade_12 1 0 0   0 0     0   0   1 0             *         1 1 0 0   0 0     0   0   1 0                 1
1726496 ID     school 1602640 25   POCATELLO DISTRICT 160264000186 9034 POCATELLO JUVENILE DETENTION   Alternative School No Other 01 12.0 2017   grade_7 1 0 0   0 0     0   0   0 1             *         1 1 0 0   0 0     0   0   0 1                 1
1726497 ID     school 1602640 25   POCATELLO DISTRICT 160264000186 9034 POCATELLO JUVENILE DETENTION   Alternative School No Other 01 12.0 2017   k_12_total 4 0 0   0 0     0   0   3 1             *         4 4 0 0   0 0     0   0   3 1                 4
1727484 ID     school 1600510 132   CALDWELL DISTRICT 160051000043 1087 SOUTHWEST IDAHO JUVENILE DETENTION   Alternative School No Other 01 12.0 2017   grade_10 7 0 2   0 0     0   0   5 4             *         9 7 0 2   0 0     0   0   5 4                 9
1727485 ID     school 1600510 132   CALDWELL DISTRICT 160051000043 1087 SOUTHWEST IDAHO JUVENILE DETENTION   Alternative School No Other 01 12.0 2017   grade_11 5 0 5   0 0     0   2   11 1             *         12 5 0 5   0 0     0   2   11 1                 12
1727486 ID     school 1600510 132   CALDWELL DISTRICT 160051000043 1087 SOUTHWEST IDAHO JUVENILE DETENTION   Alternative School No Other 01 12.0 2017   grade_12 2 0 8   0 0     0   0   9 1             *         10 2 0 8   0 0     0   0   9 1                 10
1727487 ID     school 1600510 132   CALDWELL DISTRICT 160051000043 1087 SOUTHWEST IDAHO JUVENILE DETENTION   Alternative School No Other 01 12.0 2017   grade_7 0 0 1   0 0     0   0   1 0             *         1 0 0 1   0 0     0   0   1 0                 1
1727488 ID     school 1600510 132   CALDWELL DISTRICT 160051000043 1087 SOUTHWEST IDAHO JUVENILE DETENTION   Alternative School No Other 01 12.0 2017   grade_9 1 0 6   1 0     0   1   4 5             *         9 1 0 6   1 0     0   1   4 5                 9
1727489 ID     school 1600510 132   CALDWELL DISTRICT 160051000043 1087 SOUTHWEST IDAHO JUVENILE DETENTION   Alternative School No Other 01 12.0 2017   k_12_total 15 0 22   1 0     0   3   30 11             7         41 15 0 22   1 0     0   3   30 11         7       41
1727673 ID     school 1601290 148   GRACE JOINT DISTRICT 160129000228 462 THATCHER ELEMENTARY SCHOOL   Regular School No Elementary 01 5.0 2017   grade_1 25 0 0   0 0     0   0   10 15             16         25 25 0 0   0 0     0   0   10 15         16       25
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
1727675 ID     school 1601290 148   GRACE JOINT DISTRICT 160129000228 462 THATCHER ELEMENTARY SCHOOL   Regular School No Elementary 01 5.0 2017   grade_3 25 0 0   0 0     0   0   12 13             10         25 25 0 0   0 0     0   0   12 13         10       25
1727676 ID     school 1601290 148   GRACE JOINT DISTRICT 160129000228 462 THATCHER ELEMENTARY SCHOOL   Regular School No Elementary 01 5.0 2017   grade_4 19 0 3   0 0     0   0   14 8             15         22 19 0 3   0 0     0   0   14 8         15       22
1727677 ID     school 1601290 148   GRACE JOINT DISTRICT 160129000228 462 THATCHER ELEMENTARY SCHOOL   Regular School No Elementary 01 5.0 2017   grade_5 17 0 0   1 0     0   1   9 10             6         19 17 0 0   1 0     0   1   9 10         6       19
1727678 ID     school 1601290 148   GRACE JOINT DISTRICT 160129000228 462 THATCHER ELEMENTARY SCHOOL   Regular School No Elementary 01 5.0 2017   k_12_total 101 0 3   1 0     0   1   55 51             54         106 101 0 3   1 0     0   1   55 51         54       106
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
1728359 ID     school 1601590 261   JEROME JOINT DISTRICT 160159000289 297 JEROME ACADEMY   Special Education School No Other 01 12.0 2017   grade_3 0 0 1   0 0     0   0   1 0             *         1 0 0 1   0 0     0   0   1 0                 1
1728360 ID     school 1601590 261   JEROME JOINT DISTRICT 160159000289 297 JEROME ACADEMY   Special Education School No Other 01 12.0 2017   grade_4 0 0 1   0 0     0   1   2 0             *         2 0 0 1   0 0     0   1   2 0                 2
1728361 ID     school 1601590 261   JEROME JOINT DISTRICT 160159000289 297 JEROME ACADEMY   Special Education School No Other 01 12.0 2017   grade_5 1 0 0   0 0     0   0   1 0             *         1 1 0 0   0 0     0   0   1 0                 1
1728362 ID     school 1601590 261   JEROME JOINT DISTRICT 160159000289 297 JEROME ACADEMY   Special Education School No Other 01 12.0 2017   k_12_total 1 0 3   0 0     0   1   5 0             *         5 1 0 3   0 0     0   1   5 0                 5
1728591 ID     school 1602670 273   POST FALLS DISTRICT 160267000209 736 PRAIRIE VIEW ELEMENTARY   Regular School No Elementary 01 5.0 2017   grade_1 77 1 7   0 0     1   3   45 44             35         89 77 1 7   0 0     1   3   45 44         35       89
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
1728593 ID     school 1602670 273   POST FALLS DISTRICT 160267000209 736 PRAIRIE VIEW ELEMENTARY   Regular School No Elementary 01 5.0 2017   grade_3 77 1 5   1 0     0   3   38 49             39         87 77 1 5   1 0     0   3   38 49         39       87
1728594 ID     school 1602670 273   POST FALLS DISTRICT 160267000209 736 PRAIRIE VIEW ELEMENTARY   Regular School No Elementary 01 5.0 2017   grade_4 80 0 12   0 1     0   5   44 54             47         98 80 0 12   0 1     0   5   44 54         47       98
1728595 ID     school 1602670 273   POST FALLS DISTRICT 160267000209 736 PRAIRIE VIEW ELEMENTARY   Regular School No Elementary 01 5.0 2017   grade_5 73 0 7   0 0     0   2   43 39             40         82 73 0 7   0 0     0   2   43 39         40       82
1728596 ID     school 1602670 273   POST FALLS DISTRICT 160267000209 736 PRAIRIE VIEW ELEMENTARY   Regular School No Elementary 01 5.0 2017   k_12_total 386 2 39   1 2     1   16   210 237             213         447 386 2 39   1 2     1   16   210 237         213       447
1728597 ID     school 1602670 273   POST FALLS DISTRICT 160267000487 748 PONDEROSA ELEMENTARY SCHOOL   Regular School No Elementary 01 5.0 2017   grade_1 79 0 3   0 1     0   3   35 51             53         86 79 0 3   0 1     0   3   35 51         53       86
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
1728599 ID     school 1602670 273   POST FALLS DISTRICT 160267000487 748 PONDEROSA ELEMENTARY SCHOOL   Regular School No Elementary 01 5.0 2017   grade_3 84 1 3   1 0     0   1   52 38             44         90 84 1 3   1 0     0   1   52 38         44       90
1728600 ID     school 1602670 273   POST FALLS DISTRICT 160267000487 748 PONDEROSA ELEMENTARY SCHOOL   Regular School No Elementary 01 5.0 2017   grade_4 75 1 6   1 0     0   4   53 34             44         87 75 1 6   1 0     0   4   53 34         44       87
1728601 ID     school 1602670 273   POST FALLS DISTRICT 160267000487 748 PONDEROSA ELEMENTARY SCHOOL   Regular School No Elementary 01 5.0 2017   grade_5 82 2 3   0 0     0   3   53 37             45         90 82 2 3   0 0     0   3   53 37         45       90
1728602 ID     school 1602670 273   POST FALLS DISTRICT 160267000487 748 PONDEROSA ELEMENTARY SCHOOL   Regular School No Elementary 01 5.0 2017   k_12_total 401 4 21   2 2     0   16   236 210             241         446 401 4 21   2 2     0   16   236 210         241       446
1728603 ID     school 1602670 273   POST FALLS DISTRICT 160267000490 749 SELTICE ELEMENTARY SCHOOL   Regular School No Elementary 01 5.0 2017   grade_1 61 0 1   0 1     0   4   26 41             35         67 61 0 1   0 1     0   4   26 41         35       67
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
1728605 ID     school 1602670 273   POST FALLS DISTRICT 160267000490 749 SELTICE ELEMENTARY SCHOOL   Regular School No Elementary 01 5.0 2017   grade_3 56 2 4   0 0     0   0   26 36             *         62 56 2 4   0 0     0   0   26 36                 62
1728606 ID     school 1602670 273   POST FALLS DISTRICT 160267000490 749 SELTICE ELEMENTARY SCHOOL   Regular School No Elementary 01 5.0 2017   grade_4 64 0 3   0 1     1   2   33 38             39         71 64 0 3   0 1     1   2   33 38         39       71
1728607 ID     school 1602670 273   POST FALLS DISTRICT 160267000490 749 SELTICE ELEMENTARY SCHOOL   Regular School No Elementary 01 5.0 2017   grade_5 60 0 2   2 1     0   0   41 24             36         65 60 0 2   2 1     0   0   41 24         36       65
1728608 ID     school 1602670 273   POST FALLS DISTRICT 160267000490 749 SELTICE ELEMENTARY SCHOOL   Regular School No Elementary 01 5.0 2017   k_12_total 303 2 11   2 4     1   9   162 170             168         332 303 2 11   2 4     1   9   162 170         168       332
1728616 ID     school 1602670 273   POST FALLS DISTRICT 160267001085 1388 GREENSFERRY ELEMENTARY SCHOOL   Regular School No Elementary 01 5.0 2017   grade_1 63 0 1   1 0     0   5   31 39             35         70 63 0 1   1 0     0   5   31 39         35       70
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
1728618 ID     school 1602670 273   POST FALLS DISTRICT 160267001085 1388 GREENSFERRY ELEMENTARY SCHOOL   Regular School No Elementary 01 5.0 2017   grade_3 56 0 1   0 0     0   1   24 34             *         58 56 0 1   0 0     0   1   24 34                 58
1728619 ID     school 1602670 273   POST FALLS DISTRICT 160267001085 1388 GREENSFERRY ELEMENTARY SCHOOL   Regular School No Elementary 01 5.0 2017   grade_4 76 0 4   1 0     0   3   51 33             28         84 76 0 4   1 0     0   3   51 33         28       84
1728620 ID     school 1602670 273   POST FALLS DISTRICT 160267001085 1388 GREENSFERRY ELEMENTARY SCHOOL   Regular School No Elementary 01 5.0 2017   grade_5 54 0 6   1 0     0   3   36 28             *         64 54 0 6   1 0     0   3   36 28                 64
1728621 ID     school 1602670 273   POST FALLS DISTRICT 160267001085 1388 GREENSFERRY ELEMENTARY SCHOOL   Regular School No Elementary 01 5.0 2017   k_12_total 307 0 19   4 0     0   17   177 170             147         347 307 0 19   4 0     0   17   177 170         147       347
1728622 ID     school 1602670 273   POST FALLS DISTRICT 160267000970 2517 WEST RIDGE ELEMENTARY SCHOOL   Regular School No Elementary 01 5.0 2017   grade_1 72 0 2   0 0     0   3   39 38             40         77 72 0 2   0 0     0   3   39 38         40       77
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
1728624 ID     school 1602670 273   POST FALLS DISTRICT 160267000970 2517 WEST RIDGE ELEMENTARY SCHOOL   Regular School No Elementary 01 5.0 2017   grade_3 69 0 3   0 2     0   4   40 38             36         78 69 0 3   0 2     0   4   40 38         36       78
1728625 ID     school 1602670 273   POST FALLS DISTRICT 160267000970 2517 WEST RIDGE ELEMENTARY SCHOOL   Regular School No Elementary 01 5.0 2017   grade_4 87 2 6   0 1     0   2   47 51             52         98 87 2 6   0 1     0   2   47 51         52       98
1728626 ID     school 1602670 273   POST FALLS DISTRICT 160267000970 2517 WEST RIDGE ELEMENTARY SCHOOL   Regular School No Elementary 01 5.0 2017   grade_5 62 0 8   0 0     0   3   33 40             31         73 62 0 8   0 0     0   3   33 40         31       73
1728627 ID     school 1602670 273   POST FALLS DISTRICT 160267000970 2517 WEST RIDGE ELEMENTARY SCHOOL   Regular School No Elementary 01 5.0 2017   k_12_total 353 4 27   1 4     0   20   202 207             193         409 353 4 27   1 4     0   20   202 207         193       409
1729520 ID     school 1603240 411   TWIN FALLS DISTRICT 160324000739 1260 SNAKE RIVER JUVENILE DETENTION   Alternative School No Other 01 12.0 2017   grade_10 1 0 0   0 0     0   1   2 0             *         2 1 0 0   0 0     0   1   2 0                 2
1729521 ID     school 1603240 411   TWIN FALLS DISTRICT 160324000739 1260 SNAKE RIVER JUVENILE DETENTION   Alternative School No Other 01 12.0 2017   grade_12 0 0 1   0 0     0   0   0 1             *         1 0 0 1   0 0     0   0   0 1                 1
1729522 ID     school 1603240 411   TWIN FALLS DISTRICT 160324000739 1260 SNAKE RIVER JUVENILE DETENTION   Alternative School No Other 01 12.0 2017   grade_6 1 0 0   0 0     0   0   1 0             *         1 1 0 0   0 0     0   0   1 0                 1
1729523 ID     school 1603240 411   TWIN FALLS DISTRICT 160324000739 1260 SNAKE RIVER JUVENILE DETENTION   Alternative School No Other 01 12.0 2017   grade_9 1 0 0   0 0     0   0   1 0             *         1 1 0 0   0 0     0   0   1 0                 1
1729524 ID     school 1603240 411   TWIN FALLS DISTRICT 160324000739 1260 SNAKE RIVER JUVENILE DETENTION   Alternative School No Other 01 12.0 2017   k_12_total 3 0 1   0 0     0   1   4 1             *         5 3 0 1   0 0     0   1   4 1                 5
1726268 ID     school 1601770 3   KUNA JOINT DISTRICT 160177000805 850 FREMONT H TEED MIDDLE SCHOOL   Regular School No Elementary 02 6.0 2017   grade_3 85 2 9   0 0     0   8   57 47             63         104 85 2 9   0 0     0   8   57 47         63       104
1726269 ID     school 1601770 3   KUNA JOINT DISTRICT 160177000805 850 FREMONT H TEED MIDDLE SCHOOL   Regular School No Elementary 02 6.0 2017   grade_4 100 0 11   1 0     2   5   66 53             58         119 100 0 11   1 0     2   5   66 53         58       119
1726270 ID     school 1601770 3   KUNA JOINT DISTRICT 160177000805 850 FREMONT H TEED MIDDLE SCHOOL   Regular School No Elementary 02 6.0 2017   grade_5 91 1 8   0 0     0   3   57 46             48         103 91 1 8   0 0     0   3   57 46         48       103
1726271 ID     school 1601770 3   KUNA JOINT DISTRICT 160177000805 850 FREMONT H TEED MIDDLE SCHOOL   Regular School No Elementary 02 6.0 2017   grade_6 91 0 8   0 0     1   6   58 48             50         106 91 0 8   0 0     1   6   58 48         50       106
1726272 ID     school 1601770 3   KUNA JOINT DISTRICT 160177000805 850 FREMONT H TEED MIDDLE SCHOOL   Regular School No Elementary 02 6.0 2017   k_12_total 367 3 36   1 0     3   22   238 194             219         432 367 3 36   1 0     3   22   238 194         219       432
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
1726586 ID     school 1602970 52   SNAKE RIVER DISTRICT 160297000518 376 RIVERSIDE ELEMENTARY SCHOOL   Regular School No Elementary 02 3.0 2017   grade_3 104 1 30   2 0     0   3   76 64             70         140 104 1 30   2 0     0   3   76 64         70       140
1726587 ID     school 1602970 52   SNAKE RIVER DISTRICT 160297000518 376 RIVERSIDE ELEMENTARY SCHOOL   Regular School No Elementary 02 3.0 2017   k_12_total 202 2 51   2 0     0   5   142 120             127         262 202 2 51   2 0     0   5   142 120         127       262
1726264 ID     school 1601770 3   KUNA JOINT DISTRICT 160177000915 635 ROSS ELEMENTARY SCHOOL   Regular School No Elementary 03 6.0 2017   grade_4 70 0 5   0 0     0   4   40 39             45         79 70 0 5   0 0     0   4   40 39         45       79
1726265 ID     school 1601770 3   KUNA JOINT DISTRICT 160177000915 635 ROSS ELEMENTARY SCHOOL   Regular School No Elementary 03 6.0 2017   grade_5 53 0 4   0 2     1   1   34 27             28         61 53 0 4   0 2     1   1   34 27         28       61
1726266 ID     school 1601770 3   KUNA JOINT DISTRICT 160177000915 635 ROSS ELEMENTARY SCHOOL   Regular School No Elementary 03 6.0 2017   grade_6 59 1 6   0 0     1   1   36 32             31         68 59 1 6   0 0     1   1   36 32         31       68

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