Data source: Big Local News · About: Big Local

393 rows where grade = "grade_2", state = "ID" and year = 2018

View and edit SQL

year

  • 2018 · 293

grade

  • grade_2 · 293
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
1277171 ID     school 1600270 55   BLACKFOOT DISTRICT 160027000026 387 FORT HALL ELEMENTARY SCHOOL   Regular School No Elementary PK 5.0 2018   grade_2 0 0 3   27 0     0   1   14 17             *         31 0 0 3   27 0     0   1   14 17                 31
1277178 ID     school 1600270 55   BLACKFOOT DISTRICT 160027000028 388 I T STODDARD ELEMENTARY SCHOOL   Regular School No Elementary PK 5.0 2018   grade_2 33 0 22   7 0     0   1   31 32             *         63 33 0 22   7 0     0   1   31 32                 63
1277196 ID     school 1600030 58   ABERDEEN DISTRICT 160003000828 298 ABERDEEN ELEMENTARY SCHOOL   Regular School No Elementary PK 5.0 2018   grade_2 23 0 34   1 0     0   2   27 33             *         60 23 0 34   1 0     0   2   27 33                 60
1277217 ID     school 1601080 59   FIRTH DISTRICT 160108000196 390 A W JOHNSON ELEMENTARY SCHOOL   Regular School No Elementary PK 4.0 2018   grade_2 67 1 7   0 0     0   0   39 36             32         75 67 1 7   0 0     0   0   39 36         32       75
1277231 ID     school 1602910 60   SHELLEY JOINT DISTRICT 160291000508 391 SUNRISE ELEMENTARY SCHOOL   Regular School No Elementary KG 2.0 2018   grade_2 161 3 22   0 3     0   2   86 105             98         191 161 3 22   0 3     0   2   86 105         98       191
1277249 ID     school 1600300 61   BLAINE COUNTY DISTRICT 160030000034 197 CAREY PUBLIC SCHOOL   Regular School No Other PK 12.0 2018   grade_2 9 0 4   0 0     0   1   7 7             7         14 9 0 4   0 0     0   1   7 7         7       14
1277260 ID     school 1600300 61   BLAINE COUNTY DISTRICT 160030000033 394 BELLEVUE ELEMENTARY SCHOOL   Regular School No Elementary PK 5.0 2018   grade_2 26 0 11   0 0     0   2   21 18             13         39 26 0 11   0 0     0   2   21 18         13       39
1277267 ID     school 1600300 61   BLAINE COUNTY DISTRICT 160030000035 395 ERNEST HEMINGWAY STEAM SCHOOL   Regular School No Elementary PK 7.0 2018   grade_2 33 0 20   0 1     0   1   32 23             20         55 33 0 20   0 1     0   1   32 23         20       55
1277275 ID     school 1600300 61   BLAINE COUNTY DISTRICT 160030000036 396 HAILEY ELEMENTARY SCHOOL   Regular School No Elementary PK 5.0 2018   grade_2 28 0 24   0 1     0   4   28 29             28         57 28 0 24   0 1     0   4   28 29         28       57
1277282 ID     school 1600300 61   BLAINE COUNTY DISTRICT 160030000908 636 ALTURAS ELEMENTARY SCHOOL   Regular School No Elementary PK 5.0 2018   grade_2 18 0 47   0 0     0   0   34 31             31         65 18 0 47   0 0     0   0   34 31         31       65
1277301 ID     school 1601170 71   GARDEN VALLEY DISTRICT 160117000830 274 GARDEN VALLEY SCHOOL   Regular School No Other PK 13.0 2018   grade_2 14 0 2   0 0     0   2   11 7             *         18 14 0 2   0 0     0   2   11 7                 18
1277312 ID     school 1601170 71   GARDEN VALLEY DISTRICT 160117000216 398 LOWMAN ELEMENTARY SCHOOL   Regular School No Elementary PK 6.0 2018   grade_2 1 0 0   0 0     0   0   1 0             *         1 1 0 0   0 0     0   0   1 0                 1
1277317 ID     school 1600180 72   BASIN SCHOOL DISTRICT 160018000334 159 BASIN ELEMENTARY SCHOOL   Regular School No Elementary PK 6.0 2018   grade_2 20 0 1   0 0     0   1   14 8             12         22 20 0 1   0 0     0   1   14 8         12       22
1277332 ID     school 1601500 73   HORSESHOE BEND SCHOOL DISTRICT 160150000506 256 HORSESHOE BEND ELEMENTARY   Regular School No Elementary PK 5.0 2018   grade_2 15 0 2   0 0     0   1   12 6             13         18 15 0 2   0 0     0   1   12 6         13       18
1277355 ID     school 1600001 83   WEST BONNER COUNTY DISTRICT 160000100620 406 PRIEST LAKE ELEMENTARY SCHOOL   Regular School No Elementary PK 6.0 2018   grade_2 11 0 0   0 0     0   0   6 5             *         11 11 0 0   0 0     0   0   6 5                 11
1277363 ID     school 1600001 83   WEST BONNER COUNTY DISTRICT 160000100619 407 PRIEST RIVER ELEMENTARY SCHOOL   Regular School No Elementary PK 6.0 2018   grade_2 48 0 5   0 0     0   1   33 21             33         54 48 0 5   0 0     0   1   33 21         33       54
1277371 ID     school 1600001 83   WEST BONNER COUNTY DISTRICT 160000100613 411 IDAHO HILL ELEMENTARY SCHOOL   Regular School No Elementary PK 6.0 2018   grade_2 12 0 1   0 0     0   2   5 10             *         15 12 0 1   0 0     0   2   5 10                 15
1277399 ID     school 1600002 84   LAKE PEND OREILLE SCHOOL DISTRICT 160000200603 293 KOOTENAI ELEMENTARY SCHOOL   Regular School No Elementary KG 6.0 2018   grade_2 57 0 3   0 0     0   2   27 35             32         62 57 0 3   0 0     0   2   27 35         32       62
1277407 ID     school 1600002 84   LAKE PEND OREILLE SCHOOL DISTRICT 160000200614 401 HOPE ELEMENTARY SCHOOL   Regular School No Elementary PK 6.0 2018   grade_2 10 0 0   0 0     0   1   5 6             *         11 10 0 0   0 0     0   1   5 6                 11
1277415 ID     school 1600002 84   LAKE PEND OREILLE SCHOOL DISTRICT 160000200618 402 SAGLE ELEMENTARY SCHOOL   Regular School No Elementary PK 6.0 2018   grade_2 33 0 1   0 0     0   0   19 15             16         34 33 0 1   0 0     0   0   19 15         16       34
1277423 ID     school 1600002 84   LAKE PEND OREILLE SCHOOL DISTRICT 160000200615 403 FARMIN STIDWELL ELEMENTARY SCHOOL   Regular School No Elementary PK 6.0 2018   grade_2 66 1 4   0 1     0   10   40 42             48         82 66 1 4   0 1     0   10   40 42         48       82
1277431 ID     school 1600002 84   LAKE PEND OREILLE SCHOOL DISTRICT 160000200616 405 SOUTHSIDE ELEMENTARY SCHOOL   Regular School No Elementary PK 6.0 2018   grade_2 16 0 0   0 0     0   0   7 9             11         16 16 0 0   0 0     0   0   7 9         11       16
1277439 ID     school 1600002 84   LAKE PEND OREILLE SCHOOL DISTRICT 160000200617 408 WASHINGTON ELEMENTARY SCHOOL   Regular School No Elementary PK 6.0 2018   grade_2 37 0 2   0 0     0   5   21 23             16         44 37 0 2   0 0     0   5   21 23         16       44
1277447 ID     school 1600002 84   LAKE PEND OREILLE SCHOOL DISTRICT 160000200621 410 NORTHSIDE ELEMENTARY SCHOOL   Regular School No Elementary PK 6.0 2018   grade_2 17 0 0   0 0     0   1   7 11             *         18 17 0 0   0 0     0   1   7 11                 18
1277481 ID     school 1601530 91   IDAHO FALLS DISTRICT 160153000264 412 LONGFELLOW ELEMENTARY SCHOOL   Regular School No Elementary PK 6.0 2018   grade_2 67 0 6   0 0     0   4   44 33             27         77 67 0 6   0 0     0   4   44 33         27       77
1277489 ID     school 1601530 91   IDAHO FALLS DISTRICT 160153000261 413 HAWTHORNE ELEMENTARY SCHOOL   Regular School No Elementary PK 6.0 2018   grade_2 30 0 16   0 0     0   0   24 22             33         46 30 0 16   0 0     0   0   24 22         33       46
1277497 ID     school 1601530 91   IDAHO FALLS DISTRICT 160153000269 414 TEMPLE VIEW ELEMENTARY SCHOOL   Regular School No Elementary PK 6.0 2018   grade_2 38 0 19   1 0     0   1   36 23             29         59 38 0 19   1 0     0   1   36 23         29       59
1277505 ID     school 1601530 91   IDAHO FALLS DISTRICT 160153000252 415 A H BUSH ELEMENTARY SCHOOL   Regular School No Elementary PK 6.0 2018   grade_2 32 0 17   0 1     0   0   30 20             40         50 32 0 17   0 1     0   0   30 20         40       50
1277513 ID     school 1601530 91   IDAHO FALLS DISTRICT 160153000258 416 EDGEMONT GARDENS ELEMENTARY SCHOOL   Regular School No Elementary PK 6.0 2018   grade_2 56 0 19   0 0     0   1   37 39             35         76 56 0 19   0 0     0   1   37 39         35       76
1277521 ID     school 1601530 91   IDAHO FALLS DISTRICT 160153000270 419 THERESA BUNKER ELEMENTARY SCHOOL   Regular School No Elementary PK 6.0 2018   grade_2 26 1 5   0 0     0   1   17 16             *         33 26 1 5   0 0     0   1   17 16                 33
1277529 ID     school 1601530 91   IDAHO FALLS DISTRICT 160153000260 420 ETHEL BOYES ELEMENTARY SCHOOL   Regular School No Elementary PK 6.0 2018   grade_2 33 0 17   0 0     0   1   23 28             38         51 33 0 17   0 0     0   1   23 28         38       51
1277537 ID     school 1601530 91   IDAHO FALLS DISTRICT 160153000633 421 WESTSIDE ELEMENTARY SCHOOL   Regular School No Elementary PK 6.0 2018   grade_2 52 1 9   0 0     0   2   34 30             24         64 52 1 9   0 0     0   2   34 30         24       64
1277545 ID     school 1601530 91   IDAHO FALLS DISTRICT 160153000256 422 DORA ERICKSON ELEMENTARY SCHOOL   Regular School No Elementary PK 6.0 2018   grade_2 39 0 30   0 1     0   0   37 33             56         70 39 0 30   0 1     0   0   37 33         56       70
1277553 ID     school 1601530 91   IDAHO FALLS DISTRICT 160153000263 423 LINDEN PARK ELEMENTARY SCHOOL   Regular School No Elementary PK 6.0 2018   grade_2 47 3 14   0 0     0   6   38 32             48         70 47 3 14   0 0     0   6   38 32         48       70
1277561 ID     school 1601530 91   IDAHO FALLS DISTRICT 160153000726 667 FOX HOLLOW ELEMENTARY SCHOOL   Regular School No Elementary PK 6.0 2018   grade_2 33 1 24   0 0     0   0   36 22             42         58 33 1 24   0 0     0   0   36 22         42       58
1277569 ID     school 1601530 91   IDAHO FALLS DISTRICT 160153000725 668 SUNNYSIDE ELEMENTARY SCHOOL   Regular School No Elementary PK 6.0 2018   grade_2 73 1 6   0 3     0   3   50 36             *         86 73 1 6   0 3     0   3   50 36                 86
1277593 ID     school 1603120 92   SWAN VALLEY ELEMENTARY DISTRICT 160312000541 424 SWAN VALLEY ELEMENTARY SCHOOL   Regular School No Elementary PK 8.0 2018   grade_2 1 0 0   0 0     0   0   0 1             *         1 1 0 0   0 0     0   0   0 1                 1
1277624 ID     school 1600930 93   BONNEVILLE JOINT DISTRICT 160093000173 425 FALLS VALLEY ELEMENTARY SCHOOL   Regular School No Elementary PK 6.0 2018   grade_2 41 3 21   0 0     0   2   36 31             *         67 41 3 21   0 0     0   2   36 31                 67
1277632 ID     school 1600930 93   BONNEVILLE JOINT DISTRICT 160093000167 426 AMMON ELEMENTARY SCHOOL   Regular School No Elementary PK 6.0 2018   grade_2 43 1 6   0 0     0   1   25 26             26         51 43 1 6   0 0     0   1   25 26         26       51
1277640 ID     school 1600930 93   BONNEVILLE JOINT DISTRICT 160093000176 427 IONA ELEMENTARY SCHOOL   Regular School No Elementary PK 6.0 2018   grade_2 66 1 11   0 0     0   1   35 44             28         79 66 1 11   0 0     0   1   35 44         28       79
1277648 ID     school 1600930 93   BONNEVILLE JOINT DISTRICT 160093000175 428 HILLVIEW ELEMENTARY SCHOOL   Regular School No Elementary PK 6.0 2018   grade_2 48 0 10   0 0     0   1   32 27             27         59 48 0 10   0 0     0   1   32 27         27       59
1277656 ID     school 1600930 93   BONNEVILLE JOINT DISTRICT 160093000178 429 UCON ELEMENTARY SCHOOL   Regular School No Elementary PK 6.0 2018   grade_2 55 0 3   0 0     0   0   32 26             22         58 55 0 3   0 0     0   0   32 26         22       58
1277664 ID     school 1600930 93   BONNEVILLE JOINT DISTRICT 160093000630 431 CLOVERDALE ELEMENTARY SCHOOL   Regular School No Elementary PK 6.0 2018   grade_2 65 1 14   2 0     1   1   41 43             44         84 65 1 14   2 0     1   1   41 43         44       84
1277672 ID     school 1600930 93   BONNEVILLE JOINT DISTRICT 160093000172 432 FAIRVIEW ELEMENTARY SCHOOL   Regular School No Elementary PK 6.0 2018   grade_2 54 0 4   0 0     0   2   28 32             27         60 54 0 4   0 0     0   2   28 32         27       60
1277680 ID     school 1600930 93   BONNEVILLE JOINT DISTRICT 160093000670 501 TIEBREAKER ELEMENTARY SCHOOL   Regular School No Elementary PK 6.0 2018   grade_2 34 0 10   0 0     0   0   27 17             21         44 34 0 10   0 0     0   0   27 17         21       44
1277688 ID     school 1600930 93   BONNEVILLE JOINT DISTRICT 160093000910 637 WOODLAND HILLS ELEMENTARY   Regular School No Elementary PK 6.0 2018   grade_2 63 3 4   0 0     1   0   33 38             10         71 63 3 4   0 0     1   0   33 38         10       71
1277701 ID     school 1600930 93   BONNEVILLE JOINT DISTRICT 160093000999 1238 BONNEVILLE ONLINE ELEMENTARY   Regular School No Elementary PK 8.0 2018   grade_2 18 0 0   0 0     0   0   10 8             *         18 18 0 0   0 0     0   0   10 8                 18
1277711 ID     school 1600930 93   BONNEVILLE JOINT DISTRICT 160093001015 1250 MOUNTAIN VALLEY ELEMENTARY SCHOOL   Regular School No Elementary PK 6.0 2018   grade_2 60 0 8   0 0     0   1   36 33             32         69 60 0 8   0 0     0   1   36 33         32       69
1277719 ID     school 1600930 93   BONNEVILLE JOINT DISTRICT 160093000909 1255 RIMROCK ELEMENTARY   Regular School No Elementary PK 6.0 2018   grade_2 62 1 0   0 0     0   1   34 30             *         64 62 1 0   0 0     0   1   34 30                 64
1277740 ID     school 1600930 93   BONNEVILLE JOINT DISTRICT 160093001062 1360 SUMMIT HILLS ELEMENTARY SCHOOL   Regular School No Elementary KG 6.0 2018   grade_2 56 0 20   0 0     0   1   39 38             33         77 56 0 20   0 0     0   1   39 38         33       77
1277748 ID     school 1600930 93   BONNEVILLE JOINT DISTRICT 160093000975 2518 BRIDGEWATER ELEMENTARY SCHOOL   Regular School No Elementary PK 6.0 2018   grade_2 41 0 17   0 0     0   3   28 33             27         61 41 0 17   0 0     0   3   28 33         27       61
1277756 ID     school 1600930 93   BONNEVILLE JOINT DISTRICT 160093000971 2519 DISCOVERY ELEMENTARY SCHOOL   Regular School No Elementary PK 6.0 2018   grade_2 69 0 11   0 0     0   3   42 41             39         83 69 0 11   0 0     0   3   42 41         39       83
1277773 ID     school 1600420 101   BOUNDARY COUNTY DISTRICT 160042000092 433 NAPLES ELEMENTARY SCHOOL   Regular School No Elementary KG 5.0 2018   grade_2 19 0 1   0 1     1   0   9 13             *         22 19 0 1   0 1     1   0   9 13                 22
1277780 ID     school 1600420 101   BOUNDARY COUNTY DISTRICT 160042000091 434 MOUNT HALL ELEMENTARY SCHOOL   Regular School No Elementary KG 5.0 2018   grade_2 22 0 3   0 0     0   1   18 8             *         26 22 0 3   0 0     0   1   18 8                 26
1277787 ID     school 1600420 101   BOUNDARY COUNTY DISTRICT 160042000094 437 VALLEY VIEW ELEMENTARY SCHOOL   Regular School No Elementary PK 5.0 2018   grade_2 43 0 10   2 0     0   4   29 30             43         59 43 0 10   2 0     0   4   29 30         43       59
1277803 ID     school 1600490 111   BUTTE COUNTY JOINT DISTRICT 160049000011 438 HOWE ELEMENTARY SCHOOL   Regular School No Elementary PK 5.0 2018   grade_2 3 0 0   0 0     0   0   1 2             *         3 3 0 0   0 0     0   0   1 2                 3
1277809 ID     school 1600490 111   BUTTE COUNTY JOINT DISTRICT 160049000007 439 ARCO ELEMENTARY SCHOOL   Regular School No Elementary PK 5.0 2018   grade_2 28 0 2   0 0     0   5   14 21             *         35 28 0 2   0 0     0   5   14 21                 35
1277821 ID     school 1600540 121   CAMAS COUNTY DISTRICT 160054000110 440 CAMAS COUNTY ELEM/JR HIGH SCHOOL   Regular School No Elementary PK 8.0 2018   grade_2 7 0 0   0 0     0   0   2 5             *         7 7 0 0   0 0     0   0   2 5                 7
1277839 ID     school 1602340 131   NAMPA SCHOOL DISTRICT 160234000375 213 IOWA ELEMENTARY   Regular School No Elementary PK 5.0 2018   grade_2 43 0 26   0 0     2   5   40 36             *         76 43 0 26   0 0     2   5   40 36                 76
1277846 ID     school 1602340 131   NAMPA SCHOOL DISTRICT 160234000379 214 SHERMAN ELEMENTARY   Regular School No Elementary PK 5.0 2018   grade_2 42 1 37   1 1     1   1   38 46             *         84 42 1 37   1 1     1   1   38 46                 84
1277853 ID     school 1602340 131   NAMPA SCHOOL DISTRICT 160234000383 215 PARK RIDGE ELEMENTARY   Regular School No Elementary PK 5.0 2018   grade_2 32 0 16   0 0     0   1   27 22             *         49 32 0 16   0 0     0   1   27 22                 49
1277860 ID     school 1602340 131   NAMPA SCHOOL DISTRICT 160234000409 444 CENTENNIAL ELEMENTARY SCHOOL   Regular School No Elementary PK 5.0 2018   grade_2 52 1 29   0 0     0   1   46 37             *         83 52 1 29   0 0     0   1   46 37                 83
1277867 ID     school 1602340 131   NAMPA SCHOOL DISTRICT 160234000410 447 CENTRAL ELEMENTARY   Regular School No Elementary PK 5.0 2018   grade_2 37 0 26   0 0     0   3   39 27             *         66 37 0 26   0 0     0   3   39 27                 66
1277874 ID     school 1602340 131   NAMPA SCHOOL DISTRICT 160234000677 450 GREENHURST ELEMENTARY SCHOOL   Regular School No Elementary PK 5.0 2018   grade_2 35 0 13   2 0     0   0   25 25             *         50 35 0 13   2 0     0   0   25 25                 50
1277881 ID     school 1602340 131   NAMPA SCHOOL DISTRICT 160234000774 527 OWYHEE ELEMENTARY SCHOOL   Regular School No Elementary PK 5.0 2018   grade_2 44 0 11   0 0     0   0   32 23             18         55 44 0 11   0 0     0   0   32 23         18       55
1277888 ID     school 1602340 131   NAMPA SCHOOL DISTRICT 160234000775 528 REAGAN ELEMENTARY SCHOOL   Regular School No Elementary PK 5.0 2018   grade_2 46 1 16   0 0     0   3   31 35             33         66 46 1 16   0 0     0   3   31 35         33       66
1277895 ID     school 1602340 131   NAMPA SCHOOL DISTRICT 160234000773 529 ROOSEVELT ELEMENTARY SCHOOL   Regular School No Elementary PK 5.0 2018   grade_2 43 1 21   0 2     0   5   34 38             39         72 43 1 21   0 2     0   5   34 38         39       72
1277902 ID     school 1602340 131   NAMPA SCHOOL DISTRICT 160234000833 581 WILLOW CREEK ELEMENTARY   Regular School No Elementary PK 5.0 2018   grade_2 61 1 39   0 0     1   0   55 47             75         102 61 1 39   0 0     1   0   55 47         75       102
1277914 ID     school 1602340 131   NAMPA SCHOOL DISTRICT 160234000986 647 LAKE RIDGE ELEMENTARY   Regular School No Elementary PK 5.0 2018   grade_2 67 0 27   0 0     0   2   39 57             40         96 67 0 27   0 0     0   2   39 57         40       96
1277925 ID     school 1602340 131   NAMPA SCHOOL DISTRICT 160234000947 890 ENDEAVOR ELEMENTARY SCHOOL   Regular School No Elementary PK 5.0 2018   grade_2 25 0 55   0 0     1   1   41 41             *         82 25 0 55   0 0     1   1   41 41                 82
1277937 ID     school 1602340 131   NAMPA SCHOOL DISTRICT 160234000507 996 SNAKE RIVER ELEMENTARY   Regular School No Elementary PK 5.0 2018   grade_2 34 0 31   1 0     0   3   33 36             *         69 34 0 31   1 0     0   3   33 36                 69
1277960 ID     school 1602340 131   NAMPA SCHOOL DISTRICT 160234000941 2889 NEW HORIZON MAGNET SCHOOL   Regular School No Elementary PK 5.0 2018   grade_2 17 0 56   0 0     0   2   40 35             49         75 17 0 56   0 0     0   2   40 35         49       75
1277976 ID     school 1600510 132   CALDWELL DISTRICT 160051000835 76 LEWIS AND CLARK ELEMENTARY   Regular School No Elementary PK 5.0 2018   grade_2 23 1 38   0 1     0   0   36 27             *         63 23 1 38   0 1     0   0   36 27                 63
1277987 ID     school 1600510 132   CALDWELL DISTRICT 160051000609 289 WILSON ELEMENTARY SCHOOL   Regular School No Elementary PK 5.0 2018   grade_2 44 0 51   0 1     0   5   46 55             *         101 44 0 51   0 1     0   5   46 55                 101
1277994 ID     school 1600510 132   CALDWELL DISTRICT 160051000108 448 WASHINGTON ELEMENTARY SCHOOL   Regular School No Elementary PK 5.0 2018   grade_2 32 0 53   0 0     1   2   46 42             *         88 32 0 53   0 0     1   2   46 42                 88
1278001 ID     school 1600510 132   CALDWELL DISTRICT 160051000106 449 LINCOLN ELEMENTARY SCHOOL   Regular School No Elementary PK 5.0 2018   grade_2 30 0 37   0 0     0   4   32 39             *         71 30 0 37   0 0     0   4   32 39                 71
1278008 ID     school 1600510 132   CALDWELL DISTRICT 160051000107 451 VAN BUREN ELEMENTARY SCHOOL   Regular School No Elementary KG 5.0 2018   grade_2 42 1 86   1 0     0   3   75 58             *         133 42 1 86   1 0     0   3   75 58                 133
1278015 ID     school 1600510 132   CALDWELL DISTRICT 160051000731 457 SACAJAWEA ELEMENTARY SCHOOL   Regular School No Elementary PK 5.0 2018   grade_2 24 1 45   0 0     0   3   33 40             *         73 24 1 45   0 0     0   3   33 40                 73
1278040 ID     school 1603480 133   WILDER DISTRICT 160348000585 452 WILDER ELEMENTARY SCHOOL   Regular School No Elementary PK 5.0 2018   grade_2 15 0 26   1 0     0   0   21 21             *         42 15 0 26   1 0     0   0   21 21                 42
1278060 ID     school 1602130 134   MIDDLETON DISTRICT 160213000376 453 MIDDLETON MILL CREEK ELEMENTARY   Regular School No Elementary PK 5.0 2018   grade_2 95 1 13   3 0     0   3   56 59             47         115 95 1 13   3 0     0   3   56 59         47       115
1278067 ID     school 1602130 134   MIDDLETON DISTRICT 160213000675 500 MIDDLETON HEIGHTS ELEMENTARY   Regular School No Elementary PK 5.0 2018   grade_2 73 1 10   1 0     0   4   36 53             52         89 73 1 10   1 0     0   4   36 53         52       89
1278074 ID     school 1602130 134   MIDDLETON DISTRICT 160213000812 546 PURPLE SAGE ELEMENTARY   Regular School No Elementary PK 5.0 2018   grade_2 60 0 17   0 0     0   0   46 31             26         77 60 0 17   0 0     0   0   46 31         26       77
1278095 ID     school 1602460 135   NOTUS DISTRICT 160246000430 520 NOTUS ELEMENTARY SCHOOL   Regular School No Elementary PK 6.0 2018   grade_2 13 0 5   0 0     0   0   5 13             11         18 13 0 5   0 0     0   0   5 13         11       18
1278110 ID     school 1602070 136   MELBA JOINT DISTRICT 160207000359 455 MELBA ELEMENTARY SCHOOL   Regular School No Elementary PK 6.0 2018   grade_2 34 0 15   0 0     0   2   33 18             31         51 34 0 15   0 0     0   2   33 18         31       51
1278128 ID     school 1602550 137   PARMA DISTRICT 160255000449 456 MAXINE JOHNSON ELEMENTARY   Regular School No Elementary PK 4.0 2018   grade_2 51 0 23   0 0     0   4   44 34             44         78 51 0 23   0 0     0   4   44 34         44       78
1278139 ID     school 1600600 139   VALLIVUE SCHOOL DISTRICT 160060000115 460 EAST CANYON ELEMENTARY SCHOOL   Regular School No Elementary PK 5.0 2018   grade_2 36 0 39   0 0     0   2   39 38             53         77 36 0 39   0 0     0   2   39 38         53       77
1278146 ID     school 1600600 139   VALLIVUE SCHOOL DISTRICT 160060000119 461 WEST CANYON ELEMENTARY SCHOOL   Regular School No Elementary PK 5.0 2018   grade_2 57 0 28   3 0     0   1   58 31             45         89 57 0 28   3 0     0   1   58 31         45       89
1278153 ID     school 1600600 139   VALLIVUE SCHOOL DISTRICT 160060000083 505 CENTRAL CANYON ELEMENTARY SCHOOL   Regular School No Elementary PK 5.0 2018   grade_2 48 0 40   0 0     0   3   40 51             61         91 48 0 40   0 0     0   3   40 51         61       91
1278160 ID     school 1600600 139   VALLIVUE SCHOOL DISTRICT 160060000778 519 BIRCH ELEMENTARY SCHOOL   Regular School No Elementary PK 5.0 2018   grade_2 72 0 24   0 1     1   5   54 49             62         103 72 0 24   0 1     1   5   54 49         62       103
1278171 ID     school 1600600 139   VALLIVUE SCHOOL DISTRICT 160060000976 646 LAKEVUE ELEMENTARY SCHOOL   Regular School No Elementary PK 5.0 2018   grade_2 77 0 37   0 0     2   2   62 56             70         118 77 0 37   0 0     2   2   62 56         70       118
1278178 ID     school 1600600 139   VALLIVUE SCHOOL DISTRICT 160060000935 892 DESERT SPRINGS ELEMENTARY SCHOOL   Regular School No Elementary PK 5.0 2018   grade_2 56 0 42   0 0     0   2   60 40             61         100 56 0 42   0 0     0   2   60 40         61       100
1278200 ID     school 1600600 139   VALLIVUE SCHOOL DISTRICT 160060001092 1397 SKYWAY ELEMENTARY   Regular School No Elementary KG 5.0 2018   grade_2 45 0 38   0 0     0   1   46 38             64         84 45 0 38   0 0     0   1   46 38         64       84
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
1278225 ID     school 1601290 148   GRACE JOINT DISTRICT 160129000225 463 GRACE ELEMENTARY SCHOOL   Regular School No Elementary PK 6.0 2018   grade_2 20 0 0   0 0     0   0   8 12             11         20 20 0 0   0 0     0   0   8 12         11       20
1278238 ID     school 1602430 149   NORTH GEM DISTRICT 160243000427 464 NORTH GEM ELEMENTARY   Regular School No Elementary PK 6.0 2018   grade_2 12 0 1   0 0     0   1   7 7             7         14 12 0 1   0 0     0   1   7 7         7       14
1278259 ID     school 1603000 150   SODA SPRINGS JOINT DISTRICT 160300000525 466 HOWARD E THIRKILL PRIMARY SCHOOL   Regular School No Elementary PK 4.0 2018   grade_2 56 0 6   0 1     0   1   40 24             *         64 56 0 6   0 1     0   1   40 24                 64
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
1278312 ID     school 1600660 151   CASSIA COUNTY JOINT DISTRICT 160066000123 468 ALMO ELEMENTARY SCHOOL   Regular School No Elementary PK 6.0 2018   grade_2 3 0 0   0 0     0   0   0 3             *         3 3 0 0   0 0     0   0   0 3                 3
1278317 ID     school 1600660 151   CASSIA COUNTY JOINT DISTRICT 160066000126 469 DECLO ELEMENTARY SCHOOL   Regular School No Elementary PK 5.0 2018   grade_2 58 0 22   0 0     0   0   36 44             41         80 58 0 22   0 0     0   0   36 44         41       80
1278324 ID     school 1600660 151   CASSIA COUNTY JOINT DISTRICT 160066000130 470 MOUNTAIN VIEW ELEMENTARY   Regular School No Elementary PK 3.0 2018   grade_2 80 0 50   0 0     0   1   65 66             75         131 80 0 50   0 0     0   1   65 66         75       131

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