Data source: Big Local News · About: Big Local

4,796 rows where state = "ID" and year = 2019 sorted by school_nces_id descending

View and edit SQL

grade

year

  • 2019 · 4,796
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
1306455 ID     school   92   SWAN VALLEY ELEMENTARY DISTRICT   1014 BORDER DISTRICT - STAR VALLEY ELEMENTARY SCHOOL             2019   grade_1 1 0 0   0 0     0   0   1 0             *         1 1 0 0   0 0     0   0   1 0                 1
1306456 ID     school   92   SWAN VALLEY ELEMENTARY DISTRICT   1014 BORDER DISTRICT - STAR VALLEY ELEMENTARY SCHOOL             2019   k_12_total 3 0 0   0 0     0   0   1 2             *         3 3 0 0   0 0     0   0   1 2                 3
1306457 ID     school   92   SWAN VALLEY ELEMENTARY DISTRICT   1014 BORDER DISTRICT - STAR VALLEY ELEMENTARY SCHOOL             2019   kindergarten 2 0 0   0 0     0   0   0 2             *         2 2 0 0   0 0     0   0   0 2                 2
1306458 ID     school   92   SWAN VALLEY ELEMENTARY DISTRICT   1015 BORDER DISTRICT - STAR VALLEY JR-SR HIGH SCHOOL             2019   grade_11 2 0 0   0 0     0   0   1 1             *         2 2 0 0   0 0     0   0   1 1                 2
1306459 ID     school   92   SWAN VALLEY ELEMENTARY DISTRICT   1015 BORDER DISTRICT - STAR VALLEY JR-SR HIGH SCHOOL             2019   grade_9 1 0 0   0 0     0   0   0 1             *         1 1 0 0   0 0     0   0   0 1                 1
1306460 ID     school   92   SWAN VALLEY ELEMENTARY DISTRICT   1015 BORDER DISTRICT - STAR VALLEY JR-SR HIGH SCHOOL             2019   k_12_total 3 0 0   0 0     0   0   1 2             *         3 3 0 0   0 0     0   0   1 2                 3
1307118 ID     school   150   SODA SPRINGS JOINT DISTRICT   1025 BORDER DISTRICT - FREEDOM ELEMENTARY             2019   grade_1 3 0 0   0 0     0   0   0 3             *         3 3 0 0   0 0     0   0   0 3                 3
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
1307120 ID     school   150   SODA SPRINGS JOINT DISTRICT   1025 BORDER DISTRICT - FREEDOM ELEMENTARY             2019   grade_3 3 0 0   0 0     0   0   2 1             *         3 3 0 0   0 0     0   0   2 1                 3
1307121 ID     school   150   SODA SPRINGS JOINT DISTRICT   1025 BORDER DISTRICT - FREEDOM ELEMENTARY             2019   grade_5 3 0 1   0 0     0   0   2 2             *         4 3 0 1   0 0     0   0   2 2                 4
1307122 ID     school   150   SODA SPRINGS JOINT DISTRICT   1025 BORDER DISTRICT - FREEDOM ELEMENTARY             2019   grade_6 2 0 0   0 0     0   0   2 0             *         2 2 0 0   0 0     0   0   2 0                 2
1307123 ID     school   150   SODA SPRINGS JOINT DISTRICT   1025 BORDER DISTRICT - FREEDOM ELEMENTARY             2019   k_12_total 15 0 1   0 0     0   0   8 8             *         16 15 0 1   0 0     0   0   8 8                 16
1307124 ID     school   150   SODA SPRINGS JOINT DISTRICT   1025 BORDER DISTRICT - FREEDOM ELEMENTARY             2019   kindergarten 2 0 0   0 0     0   0   2 0             *         2 2 0 0   0 0     0   0   2 0                 2
1307125 ID     school   150   SODA SPRINGS JOINT DISTRICT   1026 BORDER DISTRICT FREEDOM - SECONDARY             2019   grade_10 1 0 1   0 0     0   0   2 0             *         2 1 0 1   0 0     0   0   2 0                 2
1307126 ID     school   150   SODA SPRINGS JOINT DISTRICT   1026 BORDER DISTRICT FREEDOM - SECONDARY             2019   grade_11 1 0 1   0 0     0   0   2 0             *         2 1 0 1   0 0     0   0   2 0                 2
1307127 ID     school   150   SODA SPRINGS JOINT DISTRICT   1026 BORDER DISTRICT FREEDOM - SECONDARY             2019   grade_12 0 0 1   0 0     0   0   0 1             *         1 0 0 1   0 0     0   0   0 1                 1
1307128 ID     school   150   SODA SPRINGS JOINT DISTRICT   1026 BORDER DISTRICT FREEDOM - SECONDARY             2019   grade_7 1 0 1   0 0     0   0   1 1             *         2 1 0 1   0 0     0   0   1 1                 2
1307129 ID     school   150   SODA SPRINGS JOINT DISTRICT   1026 BORDER DISTRICT FREEDOM - SECONDARY             2019   grade_8 2 0 1   0 0     0   0   2 1             *         3 2 0 1   0 0     0   0   2 1                 3
1307130 ID     school   150   SODA SPRINGS JOINT DISTRICT   1026 BORDER DISTRICT FREEDOM - SECONDARY             2019   grade_9 1 0 1   0 0     0   0   2 0             *         2 1 0 1   0 0     0   0   2 0                 2
1307131 ID     school   150   SODA SPRINGS JOINT DISTRICT   1026 BORDER DISTRICT FREEDOM - SECONDARY             2019   k_12_total 6 0 6   0 0     0   0   9 3             *         12 6 0 6   0 0     0   0   9 3                 12
1308439 ID     school   340   LEWISTON INDEPENDENT DISTRICT   611 NORTHWEST CHILDRENS HOME             2019   grade_1 1 0 0   0 0     0   0   1 0             *         1 1 0 0   0 0     0   0   1 0                 1
1308440 ID     school   340   LEWISTON INDEPENDENT DISTRICT   611 NORTHWEST CHILDRENS HOME             2019   grade_10 2 0 0   0 0     0   0   2 0             *         2 2 0 0   0 0     0   0   2 0                 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
1308442 ID     school   340   LEWISTON INDEPENDENT DISTRICT   611 NORTHWEST CHILDRENS HOME             2019   grade_3 3 0 0   0 0     0   0   2 1             *         3 3 0 0   0 0     0   0   2 1                 3
1308443 ID     school   340   LEWISTON INDEPENDENT DISTRICT   611 NORTHWEST CHILDRENS HOME             2019   grade_4 1 0 0   0 0     0   0   1 0             *         1 1 0 0   0 0     0   0   1 0                 1
1308444 ID     school   340   LEWISTON INDEPENDENT DISTRICT   611 NORTHWEST CHILDRENS HOME             2019   grade_5 1 0 0   0 0     0   0   1 0             *         1 1 0 0   0 0     0   0   1 0                 1
1308445 ID     school   340   LEWISTON INDEPENDENT DISTRICT   611 NORTHWEST CHILDRENS HOME             2019   grade_6 1 0 0   0 0     0   0   1 0             *         1 1 0 0   0 0     0   0   1 0                 1
1308446 ID     school   340   LEWISTON INDEPENDENT DISTRICT   611 NORTHWEST CHILDRENS HOME             2019   grade_7 1 0 0   0 0     0   0   1 0             *         1 1 0 0   0 0     0   0   1 0                 1
1308447 ID     school   340   LEWISTON INDEPENDENT DISTRICT   611 NORTHWEST CHILDRENS HOME             2019   grade_8 2 0 1   0 0     0   0   3 0             *         3 2 0 1   0 0     0   0   3 0                 3
1308448 ID     school   340   LEWISTON INDEPENDENT DISTRICT   611 NORTHWEST CHILDRENS HOME             2019   grade_9 2 0 0   0 0     0   0   2 0             *         2 2 0 0   0 0     0   0   2 0                 2
1308449 ID     school   340   LEWISTON INDEPENDENT DISTRICT   611 NORTHWEST CHILDRENS HOME             2019   k_12_total 15 0 1   0 0     0   0   15 1             *         16 15 0 1   0 0     0   0   15 1                 16
1308528 ID     school   341   LAPWAI DISTRICT   1050 NORTHWEST CHILDREN'S HOME             2019   grade_9 1 0 0   0 0     0   0   1 0             *         1 1 0 0   0 0     0   0   1 0                 1
1308529 ID     school   341   LAPWAI DISTRICT   1050 NORTHWEST CHILDREN'S HOME             2019   k_12_total 1 0 0   0 0     0   0   1 0             *         1 1 0 0   0 0     0   0   1 0                 1
1308544 ID     school   342   CULDESAC JOINT DISTRICT   1373 NORTHWEST CHILDREN'S HOME             2019   grade_4 0 0 0   1 0     0   0   1 0             *         1 0 0 0   1 0     0   0   1 0                 1
1308545 ID     school   342   CULDESAC JOINT DISTRICT   1373 NORTHWEST CHILDREN'S HOME             2019   k_12_total 0 0 0   1 0     0   0   1 0             *         1 0 0 0   1 0     0   0   1 0                 1
1308601 ID     school   364   PLEASANT VALLEY ELEMENTARY DISTRICT   1056 BORDER DISTRICT - JORDAN VALLEY SECONDARY             2019   grade_12 1 0 0   0 0     0   0   0 1             *         1 1 0 0   0 0     0   0   0 1                 1
1308602 ID     school   364   PLEASANT VALLEY ELEMENTARY DISTRICT   1056 BORDER DISTRICT - JORDAN VALLEY SECONDARY             2019   grade_9 2 0 0   0 0     0   0   0 2             *         2 2 0 0   0 0     0   0   0 2                 2
1308603 ID     school   364   PLEASANT VALLEY ELEMENTARY DISTRICT   1056 BORDER DISTRICT - JORDAN VALLEY SECONDARY             2019   k_12_total 3 0 0   0 0     0   0   0 3             *         3 3 0 0   0 0     0   0   0 3                 3
1309385 ID     school   470   THE KOOTENAI BRIDGE ACADEMY, INC.   2523 KOOTENAI BRIDGE ACADEMY (SUMMER)             2019   grade_12 3 0 1   0 0     0   0   2 2             *         4 3 0 1   0 0     0   0   2 2                 4
1309386 ID     school   470   THE KOOTENAI BRIDGE ACADEMY, INC.   2523 KOOTENAI BRIDGE ACADEMY (SUMMER)             2019   k_12_total 3 0 1   0 0     0   0   2 2             *         4 3 0 1   0 0     0   0   2 2                 4
1309695 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 Other PK 12.0 2019   grade_1 2 0 1   0 0     0   1   1 3             *         4 2 0 1   0 0     0   1   1 3                 4
1309696 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 Other PK 12.0 2019   grade_10 1 0 1   0 0     1   0   0 3             *         3 1 0 1   0 0     1   0   0 3                 3
1309697 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 Other PK 12.0 2019   grade_11 3 0 1   0 0     0   0   3 1             *         4 3 0 1   0 0     0   0   3 1                 4
1309698 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 Other PK 12.0 2019   grade_12 8 1 2   0 0     0   0   5 6             5         11 8 1 2   0 0     0   0   5 6         5       11
1309699 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 Other PK 12.0 2019   grade_2 5 2 2   0 0     0   0   5 4             *         9 5 2 2   0 0     0   0   5 4                 9
1309700 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 Other PK 12.0 2019   grade_3 5 0 0   0 0     0   1   1 5             *         6 5 0 0   0 0     0   1   1 5                 6
1309701 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 Other PK 12.0 2019   grade_4 4 0 2   1 0     1   0   5 3             *         8 4 0 2   1 0     1   0   5 3                 8
1309702 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 Other PK 12.0 2019   grade_5 3 0 2   0 0     0   0   2 3             *         5 3 0 2   0 0     0   0   2 3                 5
1309703 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 Other PK 12.0 2019   grade_6 4 0 2   0 0     0   0   2 4             *         6 4 0 2   0 0     0   0   2 4                 6
1309704 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 Other PK 12.0 2019   grade_7 10 1 1   1 0     0   0   6 7             8         13 10 1 1   1 0     0   0   6 7         8       13
1309705 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 Other PK 12.0 2019   grade_8 1 0 1   0 1     0   0   1 2             *         3 1 0 1   0 1     0   0   1 2                 3
1309706 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 Other PK 12.0 2019   grade_9 3 1 1   0 0     0   0   3 2             *         5 3 1 1   0 0     0   0   3 2                 5
1309707 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 Other PK 12.0 2019   k_12_total 53 7 17   2 1     2   2   37 47             51         84 53 7 17   2 1     2   2   37 47         51       84
1309708 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 Other PK 12.0 2019   kindergarten 4 2 1   0 0     0   0   3 4             *         7 4 2 1   0 0     0   0   3 4                 7
1306905 ID     school 1603480 133   WILDER DISTRICT 160348001091 1389 WILDER MIDDLE SCHOOL   Regular School No Middle 07 8.0 2019   grade_7 14 1 34   0 0     0   0   19 30             *         49 14 1 34   0 0     0   0   19 30                 49
1306906 ID     school 1603480 133   WILDER DISTRICT 160348001091 1389 WILDER MIDDLE SCHOOL   Regular School No Middle 07 8.0 2019   grade_8 7 0 39   0 0     1   0   26 21             *         47 7 0 39   0 0     1   0   26 21                 47
1306907 ID     school 1603480 133   WILDER DISTRICT 160348001091 1389 WILDER MIDDLE SCHOOL   Regular School No Middle 07 8.0 2019   k_12_total 21 1 73   0 0     1   0   45 51             90         96 21 1 73   0 0     1   0   45 51         90       96
1306897 ID     school 1603480 133   WILDER DISTRICT 160348000585 452 WILDER ELEMENTARY SCHOOL   Regular School No Elementary PK 6.0 2019   grade_1 10 0 26   0 0     0   0   28 8             *         36 10 0 26   0 0     0   0   28 8                 36
1306898 ID     school 1603480 133   WILDER DISTRICT 160348000585 452 WILDER ELEMENTARY SCHOOL   Regular School No Elementary PK 6.0 2019   grade_2 14 0 27   0 0     0   0   19 22             *         41 14 0 27   0 0     0   0   19 22                 41
1306899 ID     school 1603480 133   WILDER DISTRICT 160348000585 452 WILDER ELEMENTARY SCHOOL   Regular School No Elementary PK 6.0 2019   grade_3 17 0 25   0 0     0   0   22 20             *         42 17 0 25   0 0     0   0   22 20                 42
1306900 ID     school 1603480 133   WILDER DISTRICT 160348000585 452 WILDER ELEMENTARY SCHOOL   Regular School No Elementary PK 6.0 2019   grade_4 14 0 34   0 0     0   1   29 20             *         49 14 0 34   0 0     0   1   29 20                 49
1306901 ID     school 1603480 133   WILDER DISTRICT 160348000585 452 WILDER ELEMENTARY SCHOOL   Regular School No Elementary PK 6.0 2019   grade_5 10 0 37   1 0     0   0   21 27             *         48 10 0 37   1 0     0   0   21 27                 48
1306902 ID     school 1603480 133   WILDER DISTRICT 160348000585 452 WILDER ELEMENTARY SCHOOL   Regular School No Elementary PK 6.0 2019   grade_6 14 0 20   0 0     0   0   18 16             *         34 14 0 20   0 0     0   0   18 16                 34
1306903 ID     school 1603480 133   WILDER DISTRICT 160348000585 452 WILDER ELEMENTARY SCHOOL   Regular School No Elementary PK 6.0 2019   k_12_total 97 0 198   1 0     0   4   162 138             *         300 97 0 198   1 0     0   4   162 138                 300
1306904 ID     school 1603480 133   WILDER DISTRICT 160348000585 452 WILDER ELEMENTARY SCHOOL   Regular School No Elementary PK 6.0 2019   kindergarten 18 0 29   0 0     0   3   25 25             *         50 18 0 29   0 0     0   3   25 25                 50
1306892 ID     school 1603480 133   WILDER DISTRICT 160348000530 233 WILDER HIGH SCHOOL   Regular School No High 09 12.0 2019   grade_10 7 0 32   0 0     0   0   19 20             *         39 7 0 32   0 0     0   0   19 20                 39
1306893 ID     school 1603480 133   WILDER DISTRICT 160348000530 233 WILDER HIGH SCHOOL   Regular School No High 09 12.0 2019   grade_11 5 0 14   0 0     0   0   14 5             *         19 5 0 14   0 0     0   0   14 5                 19
1306894 ID     school 1603480 133   WILDER DISTRICT 160348000530 233 WILDER HIGH SCHOOL   Regular School No High 09 12.0 2019   grade_12 7 0 24   0 0     0   0   17 14             *         31 7 0 24   0 0     0   0   17 14                 31
1306895 ID     school 1603480 133   WILDER DISTRICT 160348000530 233 WILDER HIGH SCHOOL   Regular School No High 09 12.0 2019   grade_9 7 0 32   0 0     0   0   15 24             *         39 7 0 32   0 0     0   0   15 24                 39
1306896 ID     school 1603480 133   WILDER DISTRICT 160348000530 233 WILDER HIGH SCHOOL   Regular School No High 09 12.0 2019   k_12_total 26 0 102   0 0     0   0   65 63             *         128 26 0 102   0 0     0   0   65 63                 128
1307435 ID     school 1603420 202   WEST SIDE JOINT DISTRICT 160342000563 987 HAROLD B LEE ELEMENTARY SCHOOL   Regular School No Elementary PK 5.0 2019   grade_1 55 0 5   1 0     0   0   28 33             32         61 55 0 5   1 0     0   0   28 33         32       61
1307436 ID     school 1603420 202   WEST SIDE JOINT DISTRICT 160342000563 987 HAROLD B LEE ELEMENTARY SCHOOL   Regular School No Elementary PK 5.0 2019   grade_2 57 0 3   0 0     0   1   35 26             30         61 57 0 3   0 0     0   1   35 26         30       61
1307437 ID     school 1603420 202   WEST SIDE JOINT DISTRICT 160342000563 987 HAROLD B LEE ELEMENTARY SCHOOL   Regular School No Elementary PK 5.0 2019   grade_3 57 0 4   0 0     0   0   31 30             33         61 57 0 4   0 0     0   0   31 30         33       61
1307438 ID     school 1603420 202   WEST SIDE JOINT DISTRICT 160342000563 987 HAROLD B LEE ELEMENTARY SCHOOL   Regular School No Elementary PK 5.0 2019   grade_4 56 0 2   1 1     0   0   32 28             29         60 56 0 2   1 1     0   0   32 28         29       60
1307439 ID     school 1603420 202   WEST SIDE JOINT DISTRICT 160342000563 987 HAROLD B LEE ELEMENTARY SCHOOL   Regular School No Elementary PK 5.0 2019   grade_5 69 0 4   1 0     0   0   38 36             32         74 69 0 4   1 0     0   0   38 36         32       74
1307440 ID     school 1603420 202   WEST SIDE JOINT DISTRICT 160342000563 987 HAROLD B LEE ELEMENTARY SCHOOL   Regular School No Elementary PK 5.0 2019   k_12_total 348 0 19   3 1     1   3   198 177             186         375 348 0 19   3 1     1   3   198 177         186       375
1307441 ID     school 1603420 202   WEST SIDE JOINT DISTRICT 160342000563 987 HAROLD B LEE ELEMENTARY SCHOOL   Regular School No Elementary PK 5.0 2019   kindergarten 54 0 1   0 0     1   2   34 24             30         58 54 0 1   0 0     1   2   34 24         30       58
1307426 ID     school 1603420 202   WEST SIDE JOINT DISTRICT 160342000412 223 BEUTLER MIDDLE SCHOOL   Regular School No Middle 06 8.0 2019   grade_6 52 0 1   1 0     0   0   34 20             28         54 52 0 1   1 0     0   0   34 20         28       54
1307427 ID     school 1603420 202   WEST SIDE JOINT DISTRICT 160342000412 223 BEUTLER MIDDLE SCHOOL   Regular School No Middle 06 8.0 2019   grade_7 70 0 3   0 0     0   0   36 37             34         73 70 0 3   0 0     0   0   36 37         34       73
1307428 ID     school 1603420 202   WEST SIDE JOINT DISTRICT 160342000412 223 BEUTLER MIDDLE SCHOOL   Regular School No Middle 06 8.0 2019   grade_8 62 0 4   0 1     0   0   36 31             26         67 62 0 4   0 1     0   0   36 31         26       67
1307429 ID     school 1603420 202   WEST SIDE JOINT DISTRICT 160342000412 223 BEUTLER MIDDLE SCHOOL   Regular School No Middle 06 8.0 2019   k_12_total 184 0 8   1 1     0   0   106 88             88         194 184 0 8   1 1     0   0   106 88         88       194
1307430 ID     school 1603420 202   WEST SIDE JOINT DISTRICT 160342000388 227 WEST SIDE SENIOR HIGH SCHOOL   Regular School No High 09 12.0 2019   grade_10 57 1 3   0 0     0   0   27 34             25         61 57 1 3   0 0     0   0   27 34         25       61
1307431 ID     school 1603420 202   WEST SIDE JOINT DISTRICT 160342000388 227 WEST SIDE SENIOR HIGH SCHOOL   Regular School No High 09 12.0 2019   grade_11 43 1 1   0 0     0   0   27 18             20         45 43 1 1   0 0     0   0   27 18         20       45
1307432 ID     school 1603420 202   WEST SIDE JOINT DISTRICT 160342000388 227 WEST SIDE SENIOR HIGH SCHOOL   Regular School No High 09 12.0 2019   grade_12 46 0 1   0 1     1   1   30 20             13         50 46 0 1   0 1     1   1   30 20         13       50
1307433 ID     school 1603420 202   WEST SIDE JOINT DISTRICT 160342000388 227 WEST SIDE SENIOR HIGH SCHOOL   Regular School No High 09 12.0 2019   grade_9 59 0 7   0 0     0   0   38 28             29         66 59 0 7   0 0     0   0   38 28         29       66
1307434 ID     school 1603420 202   WEST SIDE JOINT DISTRICT 160342000388 227 WEST SIDE SENIOR HIGH SCHOOL   Regular School No High 09 12.0 2019   k_12_total 205 2 12   0 1     1   1   122 100             87         222 205 2 12   0 1     1   1   122 100         87       222
1307749 ID     school 1603400 253   WEST JEFFERSON DISTRICT 160340001053 1315 WEST JEFFERSON MIDDLE SCHOOL   Regular School No Middle 06 8.0 2019   grade_6 37 0 8   0 0     0   1   20 26             23         46 37 0 8   0 0     0   1   20 26         23       46
1307750 ID     school 1603400 253   WEST JEFFERSON DISTRICT 160340001053 1315 WEST JEFFERSON MIDDLE SCHOOL   Regular School No Middle 06 8.0 2019   grade_7 35 0 18   0 0     0   0   28 25             35         53 35 0 18   0 0     0   0   28 25         35       53
1307751 ID     school 1603400 253   WEST JEFFERSON DISTRICT 160340001053 1315 WEST JEFFERSON MIDDLE SCHOOL   Regular School No Middle 06 8.0 2019   grade_8 31 1 8   0 0     1   1   19 23             17         42 31 1 8   0 0     1   1   19 23         17       42
1307752 ID     school 1603400 253   WEST JEFFERSON DISTRICT 160340001053 1315 WEST JEFFERSON MIDDLE SCHOOL   Regular School No Middle 06 8.0 2019   k_12_total 103 1 34   0 0     1   2   67 74             75         141 103 1 34   0 0     1   2   67 74         75       141
1307732 ID     school 1603400 253   WEST JEFFERSON DISTRICT 160340000281 115 WEST JEFFERSON HIGH SCHOOL   Regular School No High 09 12.0 2019   grade_10 40 0 10   0 0     0   1   30 21             24         51 40 0 10   0 0     0   1   30 21         24       51
1307733 ID     school 1603400 253   WEST JEFFERSON DISTRICT 160340000281 115 WEST JEFFERSON HIGH SCHOOL   Regular School No High 09 12.0 2019   grade_11 37 1 17   0 0     0   1   28 28             25         56 37 1 17   0 0     0   1   28 28         25       56
1307734 ID     school 1603400 253   WEST JEFFERSON DISTRICT 160340000281 115 WEST JEFFERSON HIGH SCHOOL   Regular School No High 09 12.0 2019   grade_12 45 0 11   0 0     0   0   28 28             17         56 45 0 11   0 0     0   0   28 28         17       56
1307735 ID     school 1603400 253   WEST JEFFERSON DISTRICT 160340000281 115 WEST JEFFERSON HIGH SCHOOL   Regular School No High 09 12.0 2019   grade_9 37 1 9   0 0     0   2   24 25             18         49 37 1 9   0 0     0   2   24 25         18       49
1307736 ID     school 1603400 253   WEST JEFFERSON DISTRICT 160340000281 115 WEST JEFFERSON HIGH SCHOOL   Regular School No High 09 12.0 2019   k_12_total 159 2 47   0 0     0   4   110 102             84         212 159 2 47   0 0     0   4   110 102         84       212
1307737 ID     school 1603400 253   WEST JEFFERSON DISTRICT 160340000280 728 TERRETON ELEMENTARY SCHOOL   Regular School No Elementary PK 5.0 2019   grade_1 20 0 12   1 0     0   0   22 11             *         33 20 0 12   1 0     0   0   22 11                 33
1307738 ID     school 1603400 253   WEST JEFFERSON DISTRICT 160340000280 728 TERRETON ELEMENTARY SCHOOL   Regular School No Elementary PK 5.0 2019   grade_2 16 0 12   0 0     0   0   11 17             *         28 16 0 12   0 0     0   0   11 17                 28
1307739 ID     school 1603400 253   WEST JEFFERSON DISTRICT 160340000280 728 TERRETON ELEMENTARY SCHOOL   Regular School No Elementary PK 5.0 2019   grade_3 28 0 4   0 0     0   1   17 16             *         33 28 0 4   0 0     0   1   17 16                 33
1307740 ID     school 1603400 253   WEST JEFFERSON DISTRICT 160340000280 728 TERRETON ELEMENTARY SCHOOL   Regular School No Elementary PK 5.0 2019   grade_4 24 0 9   0 0     0   0   16 17             18         33 24 0 9   0 0     0   0   16 17         18       33
1307741 ID     school 1603400 253   WEST JEFFERSON DISTRICT 160340000280 728 TERRETON ELEMENTARY SCHOOL   Regular School No Elementary PK 5.0 2019   grade_5 33 0 23   0 0     0   1   26 31             34         57 33 0 23   0 0     0   1   26 31         34       57

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