Data source: Big Local News · About: Big Local

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

View and edit SQL

grade

year

  • 2016 · 4,643
Link rowid state county county_state_id admin_level district_nces_id ▲ district_state_id district_state_type district school_nces_id school_state_id school school_state_type ccd_school_type ccd_charter_school ccd_school_lvl ccd_school_low_grade ccd_school_high_grade year term grade white black hispanic native_american native_american_alaskan_native asian native_hawaiian asian_pacific_islander native_hawaiian_pacific_islander pacific_islander multiracial unknown_race male female non_binary unknown_gender ell ell_percent homeless homeless_percent low_income free_and_reduced free_and_reduced_percent disability section_504 total white_int black_int hispanic_int native_american_int native_american_alaskan_native_int asian_int native_hawaiian_int asian_pacific_islander_int native_hawaiian_pacific_islander_int pacific_islander_int multiracial_int unknown_race_int male_int female_int non_binary_int unknown_gender_int ell_int homeless_int low_income_int free_and_reduced_int disability_int section_504_int total_int
1822067 ID     school   92   SWAN VALLEY ELEMENTARY DISTRICT   1014 BORDER DISTRICT - STAR VALLEY ELEMENTARY SCHOOL             2016   grade_6 1 0 0   0 0     0   0   0 1             *         1 1 0 0   0 0     0   0   0 1                 1
1822068 ID     school   92   SWAN VALLEY ELEMENTARY DISTRICT   1014 BORDER DISTRICT - STAR VALLEY ELEMENTARY SCHOOL             2016   k_12_total 1 0 0   0 0     0   0   0 1             *         1 1 0 0   0 0     0   0   0 1                 1
1822069 ID     school   92   SWAN VALLEY ELEMENTARY DISTRICT   1015 BORDER DISTRICT - STAR VALLEY JR-SR HIGH SCHOOL             2016   grade_10 1 0 0   0 0     0   0   0 1             *         1 1 0 0   0 0     0   0   0 1                 1
1822070 ID     school   92   SWAN VALLEY ELEMENTARY DISTRICT   1015 BORDER DISTRICT - STAR VALLEY JR-SR HIGH SCHOOL             2016   grade_12 1 0 0   0 0     0   0   1 0             *         1 1 0 0   0 0     0   0   1 0                 1
1822071 ID     school   92   SWAN VALLEY ELEMENTARY DISTRICT   1015 BORDER DISTRICT - STAR VALLEY JR-SR HIGH SCHOOL             2016   grade_8 2 0 0   0 0     0   0   1 1             *         2 2 0 0   0 0     0   0   1 1                 2
1822072 ID     school   92   SWAN VALLEY ELEMENTARY DISTRICT   1015 BORDER DISTRICT - STAR VALLEY JR-SR HIGH SCHOOL             2016   k_12_total 4 0 0   0 0     0   0   2 2             *         4 4 0 0   0 0     0   0   2 2                 4
1822155 ID     school   93   BONNEVILLE JOINT DISTRICT   630 LINCOLN HIGH SCHOOL (SUMMER)             2016   grade_12 1 0 0   0 0     0   0   1 0             *         1 1 0 0   0 0     0   0   1 0                 1
1822156 ID     school   93   BONNEVILLE JOINT DISTRICT   630 LINCOLN HIGH SCHOOL (SUMMER)             2016   k_12_total 1 0 0   0 0     0   0   1 0             *         1 1 0 0   0 0     0   0   1 0                 1
1824019 ID     school   340   LEWISTON INDEPENDENT DISTRICT   611 NORTHWEST CHILDRENS HOME             2016   grade_10 3 0 0   0 0     0   0   3 0             *         3 3 0 0   0 0     0   0   3 0                 3
1824020 ID     school   340   LEWISTON INDEPENDENT DISTRICT   611 NORTHWEST CHILDRENS HOME             2016   grade_11 2 0 0   0 0     0   0   1 1             *         2 2 0 0   0 0     0   0   1 1                 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
1824022 ID     school   340   LEWISTON INDEPENDENT DISTRICT   611 NORTHWEST CHILDRENS HOME             2016   grade_4 0 0 0   0 0     0   1   0 1             *         1 0 0 0   0 0     0   1   0 1                 1
1824023 ID     school   340   LEWISTON INDEPENDENT DISTRICT   611 NORTHWEST CHILDRENS HOME             2016   grade_5 1 0 0   0 0     0   0   1 0             *         1 1 0 0   0 0     0   0   1 0                 1
1824024 ID     school   340   LEWISTON INDEPENDENT DISTRICT   611 NORTHWEST CHILDRENS HOME             2016   grade_6 1 0 0   0 0     0   0   1 0             *         1 1 0 0   0 0     0   0   1 0                 1
1824025 ID     school   340   LEWISTON INDEPENDENT DISTRICT   611 NORTHWEST CHILDRENS HOME             2016   grade_8 2 0 0   2 0     0   0   3 1             *         4 2 0 0   2 0     0   0   3 1                 4
1824026 ID     school   340   LEWISTON INDEPENDENT DISTRICT   611 NORTHWEST CHILDRENS HOME             2016   grade_9 0 0 0   1 0     0   0   1 0             *         1 0 0 0   1 0     0   0   1 0                 1
1824027 ID     school   340   LEWISTON INDEPENDENT DISTRICT   611 NORTHWEST CHILDRENS HOME             2016   k_12_total 10 0 0   3 0     0   1   11 3             *         14 10 0 0   3 0     0   1   11 3                 14
1824168 ID     school   364   PLEASANT VALLEY ELEMENTARY DISTRICT   1056 BORDER DISTRICT - JORDAN VALLEY SECONDARY             2016   grade_11 1 0 0   0 0     0   0   1 0             *         1 1 0 0   0 0     0   0   1 0                 1
1824169 ID     school   364   PLEASANT VALLEY ELEMENTARY DISTRICT   1056 BORDER DISTRICT - JORDAN VALLEY SECONDARY             2016   grade_12 2 0 0   0 0     0   0   1 1             *         2 2 0 0   0 0     0   0   1 1                 2
1824170 ID     school   364   PLEASANT VALLEY ELEMENTARY DISTRICT   1056 BORDER DISTRICT - JORDAN VALLEY SECONDARY             2016   grade_9 2 0 0   0 0     0   0   0 2             *         2 2 0 0   0 0     0   0   0 2                 2
1824171 ID     school   364   PLEASANT VALLEY ELEMENTARY DISTRICT   1056 BORDER DISTRICT - JORDAN VALLEY SECONDARY             2016   k_12_total 5 0 0   0 0     0   0   2 3             *         5 5 0 0   0 0     0   0   2 3                 5
1825160 ID     school 1603511 596   IDAHO BUREAU OF EDUCATIONAL SERVICES FOR THE DEAF AND THE BLIND 160351100685 948 IDAHO SCHOOL FOR THE DEAF AND THE BLIND   Special Education School No 4.0 PK 12 2016   grade_1 2 0 0   0 0     0   0   1 1             *         2 2 0 0   0 0     0   0   1 1                 2
1825161 ID     school 1603511 596   IDAHO BUREAU OF EDUCATIONAL SERVICES FOR THE DEAF AND THE BLIND 160351100685 948 IDAHO SCHOOL FOR THE DEAF AND THE BLIND   Special Education School No 4.0 PK 12 2016   grade_10 3 0 0   0 0     0   0   3 0             *         3 3 0 0   0 0     0   0   3 0                 3
1825162 ID     school 1603511 596   IDAHO BUREAU OF EDUCATIONAL SERVICES FOR THE DEAF AND THE BLIND 160351100685 948 IDAHO SCHOOL FOR THE DEAF AND THE BLIND   Special Education School No 4.0 PK 12 2016   grade_11 10 1 2   1 1     0   0   11 4             6         15 10 1 2   1 1     0   0   11 4         6       15
1825163 ID     school 1603511 596   IDAHO BUREAU OF EDUCATIONAL SERVICES FOR THE DEAF AND THE BLIND 160351100685 948 IDAHO SCHOOL FOR THE DEAF AND THE BLIND   Special Education School No 4.0 PK 12 2016   grade_12 9 0 5   1 0     0   0   5 10             8         15 9 0 5   1 0     0   0   5 10         8       15
1825164 ID     school 1603511 596   IDAHO BUREAU OF EDUCATIONAL SERVICES FOR THE DEAF AND THE BLIND 160351100685 948 IDAHO SCHOOL FOR THE DEAF AND THE BLIND   Special Education School No 4.0 PK 12 2016   grade_2 3 0 2   0 0     0   0   2 3             *         5 3 0 2   0 0     0   0   2 3                 5
1825165 ID     school 1603511 596   IDAHO BUREAU OF EDUCATIONAL SERVICES FOR THE DEAF AND THE BLIND 160351100685 948 IDAHO SCHOOL FOR THE DEAF AND THE BLIND   Special Education School No 4.0 PK 12 2016   grade_3 8 0 1   0 0     0   0   4 5             *         9 8 0 1   0 0     0   0   4 5                 9
1825166 ID     school 1603511 596   IDAHO BUREAU OF EDUCATIONAL SERVICES FOR THE DEAF AND THE BLIND 160351100685 948 IDAHO SCHOOL FOR THE DEAF AND THE BLIND   Special Education School No 4.0 PK 12 2016   grade_4 6 0 1   1 0     0   0   5 3             *         8 6 0 1   1 0     0   0   5 3                 8
1825167 ID     school 1603511 596   IDAHO BUREAU OF EDUCATIONAL SERVICES FOR THE DEAF AND THE BLIND 160351100685 948 IDAHO SCHOOL FOR THE DEAF AND THE BLIND   Special Education School No 4.0 PK 12 2016   grade_5 2 0 1   0 0     0   0   1 2             *         3 2 0 1   0 0     0   0   1 2                 3
1825168 ID     school 1603511 596   IDAHO BUREAU OF EDUCATIONAL SERVICES FOR THE DEAF AND THE BLIND 160351100685 948 IDAHO SCHOOL FOR THE DEAF AND THE BLIND   Special Education School No 4.0 PK 12 2016   grade_6 2 0 4   0 1     0   0   3 4             *         7 2 0 4   0 1     0   0   3 4                 7
1825169 ID     school 1603511 596   IDAHO BUREAU OF EDUCATIONAL SERVICES FOR THE DEAF AND THE BLIND 160351100685 948 IDAHO SCHOOL FOR THE DEAF AND THE BLIND   Special Education School No 4.0 PK 12 2016   grade_7 2 0 1   0 0     0   0   2 1             *         3 2 0 1   0 0     0   0   2 1                 3
1825170 ID     school 1603511 596   IDAHO BUREAU OF EDUCATIONAL SERVICES FOR THE DEAF AND THE BLIND 160351100685 948 IDAHO SCHOOL FOR THE DEAF AND THE BLIND   Special Education School No 4.0 PK 12 2016   grade_8 2 0 0   0 0     0   0   1 1             *         2 2 0 0   0 0     0   0   1 1                 2
1825171 ID     school 1603511 596   IDAHO BUREAU OF EDUCATIONAL SERVICES FOR THE DEAF AND THE BLIND 160351100685 948 IDAHO SCHOOL FOR THE DEAF AND THE BLIND   Special Education School No 4.0 PK 12 2016   grade_9 5 1 0   0 0     0   0   2 4             *         6 5 1 0   0 0     0   0   2 4                 6
1825172 ID     school 1603511 596   IDAHO BUREAU OF EDUCATIONAL SERVICES FOR THE DEAF AND THE BLIND 160351100685 948 IDAHO SCHOOL FOR THE DEAF AND THE BLIND   Special Education School No 4.0 PK 12 2016   k_12_total 62 2 17   3 2     0   0   43 43             51         86 62 2 17   3 2     0   0   43 43         51       86
1825173 ID     school 1603511 596   IDAHO BUREAU OF EDUCATIONAL SERVICES FOR THE DEAF AND THE BLIND 160351100685 948 IDAHO SCHOOL FOR THE DEAF AND THE BLIND   Special Education School No 4.0 PK 12 2016   kindergarten 8 0 0   0 0     0   0   3 5             *         8 8 0 0   0 0     0   0   3 5                 8
1822501 ID     school 1603480 133   WILDER DISTRICT 160348000530 233 WILDER HIGH SCHOOL   Regular School No 4.0 06 12 2016   grade_10 10 0 20   0 0     0   0   15 15             *         30 10 0 20   0 0     0   0   15 15                 30
1822502 ID     school 1603480 133   WILDER DISTRICT 160348000530 233 WILDER HIGH SCHOOL   Regular School No 4.0 06 12 2016   grade_11 7 0 19   0 0     0   0   16 10             *         26 7 0 19   0 0     0   0   16 10                 26
1822503 ID     school 1603480 133   WILDER DISTRICT 160348000530 233 WILDER HIGH SCHOOL   Regular School No 4.0 06 12 2016   grade_12 5 0 15   0 0     0   0   10 10             *         20 5 0 15   0 0     0   0   10 10                 20
1822504 ID     school 1603480 133   WILDER DISTRICT 160348000530 233 WILDER HIGH SCHOOL   Regular School No 4.0 06 12 2016   grade_6 14 0 27   0 0     0   0   15 26             *         41 14 0 27   0 0     0   0   15 26                 41
1822505 ID     school 1603480 133   WILDER DISTRICT 160348000530 233 WILDER HIGH SCHOOL   Regular School No 4.0 06 12 2016   grade_7 5 0 28   0 0     0   0   15 18             *         33 5 0 28   0 0     0   0   15 18                 33
1822506 ID     school 1603480 133   WILDER DISTRICT 160348000530 233 WILDER HIGH SCHOOL   Regular School No 4.0 06 12 2016   grade_8 4 0 16   0 0     0   0   12 8             *         20 4 0 16   0 0     0   0   12 8                 20
1822507 ID     school 1603480 133   WILDER DISTRICT 160348000530 233 WILDER HIGH SCHOOL   Regular School No 4.0 06 12 2016   grade_9 8 0 21   0 0     0   0   16 13             *         29 8 0 21   0 0     0   0   16 13                 29
1822508 ID     school 1603480 133   WILDER DISTRICT 160348000530 233 WILDER HIGH SCHOOL   Regular School No 4.0 06 12 2016   k_12_total 53 0 146   0 0     0   0   99 100             *         199 53 0 146   0 0     0   0   99 100                 199
1822509 ID     school 1603480 133   WILDER DISTRICT 160348000585 452 WILDER ELEMENTARY SCHOOL   Regular School No 1.0 PK 05 2016   grade_1 13 0 33   1 0     0   0   27 20             *         47 13 0 33   1 0     0   0   27 20                 47
1822510 ID     school 1603480 133   WILDER DISTRICT 160348000585 452 WILDER ELEMENTARY SCHOOL   Regular School No 1.0 PK 05 2016   grade_2 11 0 29   0 0     0   0   16 24             *         40 11 0 29   0 0     0   0   16 24                 40
1822511 ID     school 1603480 133   WILDER DISTRICT 160348000585 452 WILDER ELEMENTARY SCHOOL   Regular School No 1.0 PK 05 2016   grade_3 9 0 23   0 0     0   1   19 14             *         33 9 0 23   0 0     0   1   19 14                 33
1822512 ID     school 1603480 133   WILDER DISTRICT 160348000585 452 WILDER ELEMENTARY SCHOOL   Regular School No 1.0 PK 05 2016   grade_4 14 1 33   0 0     0   0   17 31             *         48 14 1 33   0 0     0   0   17 31                 48
1822513 ID     school 1603480 133   WILDER DISTRICT 160348000585 452 WILDER ELEMENTARY SCHOOL   Regular School No 1.0 PK 05 2016   grade_5 8 0 30   0 0     1   0   23 16             *         39 8 0 30   0 0     1   0   23 16                 39
1822514 ID     school 1603480 133   WILDER DISTRICT 160348000585 452 WILDER ELEMENTARY SCHOOL   Regular School No 1.0 PK 05 2016   k_12_total 72 1 174   1 0     1   1   125 125             *         250 72 1 174   1 0     1   1   125 125                 250
1822515 ID     school 1603480 133   WILDER DISTRICT 160348000585 452 WILDER ELEMENTARY SCHOOL   Regular School No 1.0 PK 05 2016   kindergarten 17 0 26   0 0     0   0   23 20             *         43 17 0 26   0 0     0   0   23 20                 43
1822516 ID     school 1603480 133   WILDER DISTRICT 160348000682 1022 COSSA - WILDER   Special Education School No 4.0 PK 12 2016   grade_2 1 0 0   0 0     0   0   0 1             *         1 1 0 0   0 0     0   0   0 1                 1
1822517 ID     school 1603480 133   WILDER DISTRICT 160348000682 1022 COSSA - WILDER   Special Education School No 4.0 PK 12 2016   k_12_total 1 0 0   0 0     0   0   0 1             *         1 1 0 0   0 0     0   0   0 1                 1
1823005 ID     school 1603420 202   WEST SIDE JOINT DISTRICT 160342000412 223 BEUTLER MIDDLE SCHOOL   Regular School No 2.0 06 08 2016   grade_6 56 0 7   0 0     0   0   39 24             33         63 56 0 7   0 0     0   0   39 24         33       63
1823006 ID     school 1603420 202   WEST SIDE JOINT DISTRICT 160342000412 223 BEUTLER MIDDLE SCHOOL   Regular School No 2.0 06 08 2016   grade_7 51 0 3   0 0     0   0   24 30             31         54 51 0 3   0 0     0   0   24 30         31       54
1823007 ID     school 1603420 202   WEST SIDE JOINT DISTRICT 160342000412 223 BEUTLER MIDDLE SCHOOL   Regular School No 2.0 06 08 2016   grade_8 45 0 3   0 0     0   0   30 18             22         48 45 0 3   0 0     0   0   30 18         22       48
1823008 ID     school 1603420 202   WEST SIDE JOINT DISTRICT 160342000412 223 BEUTLER MIDDLE SCHOOL   Regular School No 2.0 06 08 2016   k_12_total 152 0 13   0 0     0   0   93 72             86         165 152 0 13   0 0     0   0   93 72         86       165
1823009 ID     school 1603420 202   WEST SIDE JOINT DISTRICT 160342000388 227 WEST SIDE SENIOR HIGH SCHOOL   Regular School No 3.0 09 12 2016   grade_10 41 0 2   1 0     0   0   17 27             24         44 41 0 2   1 0     0   0   17 27         24       44
1823010 ID     school 1603420 202   WEST SIDE JOINT DISTRICT 160342000388 227 WEST SIDE SENIOR HIGH SCHOOL   Regular School No 3.0 09 12 2016   grade_11 48 0 2   0 0     0   0   22 28             10         50 48 0 2   0 0     0   0   22 28         10       50
1823011 ID     school 1603420 202   WEST SIDE JOINT DISTRICT 160342000388 227 WEST SIDE SENIOR HIGH SCHOOL   Regular School No 3.0 09 12 2016   grade_12 43 0 5   0 1     0   0   22 27             23         49 43 0 5   0 1     0   0   22 27         23       49
1823012 ID     school 1603420 202   WEST SIDE JOINT DISTRICT 160342000388 227 WEST SIDE SENIOR HIGH SCHOOL   Regular School No 3.0 09 12 2016   grade_9 44 0 0   0 0     1   0   26 19             16         45 44 0 0   0 0     1   0   26 19         16       45
1823013 ID     school 1603420 202   WEST SIDE JOINT DISTRICT 160342000388 227 WEST SIDE SENIOR HIGH SCHOOL   Regular School No 3.0 09 12 2016   k_12_total 176 0 9   1 1     1   0   87 101             73         188 176 0 9   1 1     1   0   87 101         73       188
1823014 ID     school 1603420 202   WEST SIDE JOINT DISTRICT 160342000563 987 HAROLD B LEE ELEMENTARY SCHOOL   Regular School No 1.0 PK 05 2016   grade_1 46 0 4   0 1     0   0   27 24             27         51 46 0 4   0 1     0   0   27 24         27       51
1823015 ID     school 1603420 202   WEST SIDE JOINT DISTRICT 160342000563 987 HAROLD B LEE ELEMENTARY SCHOOL   Regular School No 1.0 PK 05 2016   grade_2 56 0 0   0 0     0   0   27 29             25         56 56 0 0   0 0     0   0   27 29         25       56
1823016 ID     school 1603420 202   WEST SIDE JOINT DISTRICT 160342000563 987 HAROLD B LEE ELEMENTARY SCHOOL   Regular School No 1.0 PK 05 2016   grade_3 42 0 3   0 0     0   0   27 18             24         45 42 0 3   0 0     0   0   27 18         24       45
1823017 ID     school 1603420 202   WEST SIDE JOINT DISTRICT 160342000563 987 HAROLD B LEE ELEMENTARY SCHOOL   Regular School No 1.0 PK 05 2016   grade_4 59 0 1   0 0     0   0   32 28             30         60 59 0 1   0 0     0   0   32 28         30       60
1823018 ID     school 1603420 202   WEST SIDE JOINT DISTRICT 160342000563 987 HAROLD B LEE ELEMENTARY SCHOOL   Regular School No 1.0 PK 05 2016   grade_5 58 0 1   0 2     0   0   31 30             25         61 58 0 1   0 2     0   0   31 30         25       61
1823019 ID     school 1603420 202   WEST SIDE JOINT DISTRICT 160342000563 987 HAROLD B LEE ELEMENTARY SCHOOL   Regular School No 1.0 PK 05 2016   k_12_total 312 0 11   0 3     0   0   171 155             159         326 312 0 11   0 3     0   0   171 155         159       326
1823020 ID     school 1603420 202   WEST SIDE JOINT DISTRICT 160342000563 987 HAROLD B LEE ELEMENTARY SCHOOL   Regular School No 1.0 PK 05 2016   kindergarten 51 0 2   0 0     0   0   27 26             28         53 51 0 2   0 0     0   0   27 26         28       53
1823320 ID     school 1603400 253   WEST JEFFERSON DISTRICT 160340000281 115 WEST JEFFERSON HIGH SCHOOL   Regular School No 3.0 09 12 2016   grade_10 31 0 19   0 0     0   0   27 23             27         50 31 0 19   0 0     0   0   27 23         27       50
1823321 ID     school 1603400 253   WEST JEFFERSON DISTRICT 160340000281 115 WEST JEFFERSON HIGH SCHOOL   Regular School No 3.0 09 12 2016   grade_11 36 0 13   0 0     0   0   28 21             20         49 36 0 13   0 0     0   0   28 21         20       49
1823322 ID     school 1603400 253   WEST JEFFERSON DISTRICT 160340000281 115 WEST JEFFERSON HIGH SCHOOL   Regular School No 3.0 09 12 2016   grade_12 37 0 18   0 0     0   1   25 31             28         56 37 0 18   0 0     0   1   25 31         28       56
1823323 ID     school 1603400 253   WEST JEFFERSON DISTRICT 160340000281 115 WEST JEFFERSON HIGH SCHOOL   Regular School No 3.0 09 12 2016   grade_9 43 0 14   1 0     0   0   28 30             28         58 43 0 14   1 0     0   0   28 30         28       58
1823324 ID     school 1603400 253   WEST JEFFERSON DISTRICT 160340000281 115 WEST JEFFERSON HIGH SCHOOL   Regular School No 3.0 09 12 2016   k_12_total 147 0 64   1 0     0   1   108 105             103         213 147 0 64   1 0     0   1   108 105         103       213
1823325 ID     school 1603400 253   WEST JEFFERSON DISTRICT 160340000280 728 TERRETON ELEMENTARY SCHOOL   Regular School No 1.0 PK 06 2016   grade_1 12 0 8   0 0     0   0   8 12             *         20 12 0 8   0 0     0   0   8 12                 20
1823326 ID     school 1603400 253   WEST JEFFERSON DISTRICT 160340000280 728 TERRETON ELEMENTARY SCHOOL   Regular School No 1.0 PK 06 2016   grade_2 29 0 17   0 0     0   0   17 29             28         46 29 0 17   0 0     0   0   17 29         28       46
1823327 ID     school 1603400 253   WEST JEFFERSON DISTRICT 160340000280 728 TERRETON ELEMENTARY SCHOOL   Regular School No 1.0 PK 06 2016   grade_3 24 0 7   0 0     0   0   15 16             *         31 24 0 7   0 0     0   0   15 16                 31
1823328 ID     school 1603400 253   WEST JEFFERSON DISTRICT 160340000280 728 TERRETON ELEMENTARY SCHOOL   Regular School No 1.0 PK 06 2016   grade_4 22 0 12   0 0     0   0   20 14             *         34 22 0 12   0 0     0   0   20 14                 34
1823329 ID     school 1603400 253   WEST JEFFERSON DISTRICT 160340000280 728 TERRETON ELEMENTARY SCHOOL   Regular School No 1.0 PK 06 2016   grade_5 25 1 15   1 0     1   1   17 27             25         44 25 1 15   1 0     1   1   17 27         25       44
1823330 ID     school 1603400 253   WEST JEFFERSON DISTRICT 160340000280 728 TERRETON ELEMENTARY SCHOOL   Regular School No 1.0 PK 06 2016   grade_6 37 2 9   0 0     0   1   25 24             26         49 37 2 9   0 0     0   1   25 24         26       49
1823331 ID     school 1603400 253   WEST JEFFERSON DISTRICT 160340000280 728 TERRETON ELEMENTARY SCHOOL   Regular School No 1.0 PK 06 2016   k_12_total 171 3 73   1 0     1   3   116 136             148         252 171 3 73   1 0     1   3   116 136         148       252
1823332 ID     school 1603400 253   WEST JEFFERSON DISTRICT 160340000280 728 TERRETON ELEMENTARY SCHOOL   Regular School No 1.0 PK 06 2016   kindergarten 22 0 5   0 0     0   1   14 14             *         28 22 0 5   0 0     0   1   14 14                 28
1823333 ID     school 1603400 253   WEST JEFFERSON DISTRICT 160340000273 729 HAMER ELEMENTARY SCHOOL   Regular School No 1.0 KG 04 2016   grade_1 4 0 2   0 0     0   1   4 3             *         7 4 0 2   0 0     0   1   4 3                 7
1823334 ID     school 1603400 253   WEST JEFFERSON DISTRICT 160340000273 729 HAMER ELEMENTARY SCHOOL   Regular School No 1.0 KG 04 2016   grade_2 5 0 4   0 0     0   1   8 2             5         10 5 0 4   0 0     0   1   8 2         5       10
1823335 ID     school 1603400 253   WEST JEFFERSON DISTRICT 160340000273 729 HAMER ELEMENTARY SCHOOL   Regular School No 1.0 KG 04 2016   grade_3 5 0 2   0 0     0   1   4 4             *         8 5 0 2   0 0     0   1   4 4                 8
1823336 ID     school 1603400 253   WEST JEFFERSON DISTRICT 160340000273 729 HAMER ELEMENTARY SCHOOL   Regular School No 1.0 KG 04 2016   grade_4 10 0 3   0 0     0   0   6 7             *         13 10 0 3   0 0     0   0   6 7                 13
1823337 ID     school 1603400 253   WEST JEFFERSON DISTRICT 160340000273 729 HAMER ELEMENTARY SCHOOL   Regular School No 1.0 KG 04 2016   k_12_total 30 0 13   0 0     0   3   27 19             20         46 30 0 13   0 0     0   3   27 19         20       46
1823338 ID     school 1603400 253   WEST JEFFERSON DISTRICT 160340000273 729 HAMER ELEMENTARY SCHOOL   Regular School No 1.0 KG 04 2016   kindergarten 6 0 2   0 0     0   0   5 3             *         8 6 0 2   0 0     0   0   5 3                 8
1823339 ID     school 1603400 253   WEST JEFFERSON DISTRICT 160340001053 1315 WEST JEFFERSON MIDDLE SCHOOL   Regular School No 2.0 07 08 2016   grade_7 35 1 14   0 0     0   4   29 25             27         54 35 1 14   0 0     0   4   29 25         27       54
1823340 ID     school 1603400 253   WEST JEFFERSON DISTRICT 160340001053 1315 WEST JEFFERSON MIDDLE SCHOOL   Regular School No 2.0 07 08 2016   grade_8 35 1 20   0 0     0   1   27 30             30         57 35 1 20   0 0     0   1   27 30         30       57
1823341 ID     school 1603400 253   WEST JEFFERSON DISTRICT 160340001053 1315 WEST JEFFERSON MIDDLE SCHOOL   Regular School No 2.0 07 08 2016   k_12_total 70 2 34   0 0     0   5   56 55             57         111 70 2 34   0 0     0   5   56 55         57       111
1823139 ID     school 1603360 232   WENDELL DISTRICT 160336000571 104 WENDELL MIDDLE SCHOOL   Regular School No 2.0 05 08 2016   grade_5 30 0 58   0 1     0   0   41 48             20         89 30 0 58   0 1     0   0   41 48         20       89
1823140 ID     school 1603360 232   WENDELL DISTRICT 160336000571 104 WENDELL MIDDLE SCHOOL   Regular School No 2.0 05 08 2016   grade_6 35 0 48   0 0     0   0   51 32             18         83 35 0 48   0 0     0   0   51 32         18       83
1823141 ID     school 1603360 232   WENDELL DISTRICT 160336000571 104 WENDELL MIDDLE SCHOOL   Regular School No 2.0 05 08 2016   grade_7 28 0 53   3 0     0   1   40 45             *         85 28 0 53   3 0     0   1   40 45                 85
1823142 ID     school 1603360 232   WENDELL DISTRICT 160336000571 104 WENDELL MIDDLE SCHOOL   Regular School No 2.0 05 08 2016   grade_8 33 0 47   1 0     0   0   40 41             *         81 33 0 47   1 0     0   0   40 41                 81
1823143 ID     school 1603360 232   WENDELL DISTRICT 160336000571 104 WENDELL MIDDLE SCHOOL   Regular School No 2.0 05 08 2016   k_12_total 126 0 206   4 1     0   1   172 166             68         338 126 0 206   4 1     0   1   172 166         68       338
1823144 ID     school 1603360 232   WENDELL DISTRICT 160336000271 209 WENDELL HIGH SCHOOL   Regular School No 3.0 09 12 2016   grade_10 34 0 48   1 0     0   1   53 31             45         84 34 0 48   1 0     0   1   53 31         45       84
1823145 ID     school 1603360 232   WENDELL DISTRICT 160336000271 209 WENDELL HIGH SCHOOL   Regular School No 3.0 09 12 2016   grade_11 32 0 37   0 1     0   1   29 42             *         71 32 0 37   0 1     0   1   29 42                 71
1823146 ID     school 1603360 232   WENDELL DISTRICT 160336000271 209 WENDELL HIGH SCHOOL   Regular School No 3.0 09 12 2016   grade_12 30 0 27   0 2     0   0   33 26             *         59 30 0 27   0 2     0   0   33 26                 59
1823147 ID     school 1603360 232   WENDELL DISTRICT 160336000271 209 WENDELL HIGH SCHOOL   Regular School No 3.0 09 12 2016   grade_9 33 0 50   1 0     0   1   36 49             55         85 33 0 50   1 0     0   1   36 49         55       85
1823148 ID     school 1603360 232   WENDELL DISTRICT 160336000271 209 WENDELL HIGH SCHOOL   Regular School No 3.0 09 12 2016   k_12_total 129 0 162   2 3     0   3   151 148             149         299 129 0 162   2 3     0   3   151 148         149       299

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