Data source: Big Local News · About: Big Local

391 rows where grade = "grade_2", state = "ID" and year = 2017

View and edit SQL

year

  • 2017 · 291

grade

  • grade_2 · 291
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
1726629 ID     school 1600270 55   BLACKFOOT DISTRICT 160027000027 386 GROVELAND ELEMENTARY SCHOOL   Regular School No Elementary PK 5.0 2017   grade_2 21 0 14   1 0     0   2   23 15             22         38 21 0 14   1 0     0   2   23 15         22       38
1726636 ID     school 1600270 55   BLACKFOOT DISTRICT 160027000026 387 FORT HALL ELEMENTARY SCHOOL   Regular School No Elementary PK 5.0 2017   grade_2 0 0 6   17 0     0   0   9 14             18         23 0 0 6   17 0     0   0   9 14         18       23
1726643 ID     school 1600270 55   BLACKFOOT DISTRICT 160027000028 388 I T STODDARD ELEMENTARY SCHOOL   Regular School No Elementary PK 5.0 2017   grade_2 39 0 19   8 0     2   7   37 38             34         75 39 0 19   8 0     2   7   37 38         34       75
1726661 ID     school 1600030 58   ABERDEEN DISTRICT 160003000828 298 ABERDEEN ELEMENTARY SCHOOL   Regular School No Elementary PK 5.0 2017   grade_2 21 0 36   1 0     0   1   34 25             46         59 21 0 36   1 0     0   1   34 25         46       59
1726682 ID     school 1601080 59   FIRTH DISTRICT 160108000196 390 A W JOHNSON ELEMENTARY SCHOOL   Regular School No Elementary PK 4.0 2017   grade_2 47 1 7   1 0     0   0   26 30             29         56 47 1 7   1 0     0   0   26 30         29       56
1726696 ID     school 1602910 60   SHELLEY JOINT DISTRICT 160291000508 391 SUNRISE ELEMENTARY SCHOOL   Regular School No Elementary KG 2.0 2017   grade_2 156 1 25   0 0     0   0   91 91             93         182 156 1 25   0 0     0   0   91 91         93       182
1726714 ID     school 1600300 61   BLAINE COUNTY DISTRICT 160030000034 197 CAREY PUBLIC SCHOOL   Regular School No Other PK 12.0 2017   grade_2 7 0 3   0 0     0   1   5 6             *         11 7 0 3   0 0     0   1   5 6                 11
1726725 ID     school 1600300 61   BLAINE COUNTY DISTRICT 160030000033 394 BELLEVUE ELEMENTARY SCHOOL   Regular School No Elementary PK 5.0 2017   grade_2 27 0 11   0 0     0   4   20 22             18         42 27 0 11   0 0     0   4   20 22         18       42
1726732 ID     school 1600300 61   BLAINE COUNTY DISTRICT 160030000035 395 ERNEST HEMINGWAY STEAM SCHOOL   Regular School No Elementary PK 5.0 2017   grade_2 40 0 19   0 0     0   1   28 32             *         60 40 0 19   0 0     0   1   28 32                 60
1726739 ID     school 1600300 61   BLAINE COUNTY DISTRICT 160030000036 396 HAILEY ELEMENTARY SCHOOL   Regular School No Elementary PK 5.0 2017   grade_2 33 0 21   0 1     0   3   28 30             30         58 33 0 21   0 1     0   3   28 30         30       58
1726746 ID     school 1600300 61   BLAINE COUNTY DISTRICT 160030000908 636 ALTURAS ELEMENTARY SCHOOL   Regular School No Elementary PK 5.0 2017   grade_2 12 0 61   0 1     0   0   41 33             44         74 12 0 61   0 1     0   0   41 33         44       74
1726765 ID     school 1601170 71   GARDEN VALLEY DISTRICT 160117000830 274 GARDEN VALLEY SCHOOL   Regular School No Other PK 13.0 2017   grade_2 11 0 0   0 0     0   0   5 6             5         11 11 0 0   0 0     0   0   5 6         5       11
1726780 ID     school 1600180 72   BASIN SCHOOL DISTRICT 160018000334 159 BASIN ELEMENTARY SCHOOL   Regular School No Elementary PK 6.0 2017   grade_2 19 0 0   0 0     0   0   11 8             *         19 19 0 0   0 0     0   0   11 8                 19
1726795 ID     school 1601500 73   HORSESHOE BEND SCHOOL DISTRICT 160150000506 256 HORSESHOE BEND ELEMENTARY   Regular School No Elementary PK 5.0 2017   grade_2 10 0 2   0 0     0   0   6 6             *         12 10 0 2   0 0     0   0   6 6                 12
1726818 ID     school 1600001 83   WEST BONNER COUNTY DISTRICT 160000100620 406 PRIEST LAKE ELEMENTARY SCHOOL   Regular School No Elementary PK 6.0 2017   grade_2 7 0 0   0 0     0   0   3 4             *         7 7 0 0   0 0     0   0   3 4                 7
1726826 ID     school 1600001 83   WEST BONNER COUNTY DISTRICT 160000100619 407 PRIEST RIVER ELEMENTARY SCHOOL   Regular School No Elementary PK 6.0 2017   grade_2 61 0 3   0 0     0   1   34 31             38         65 61 0 3   0 0     0   1   34 31         38       65
1726834 ID     school 1600001 83   WEST BONNER COUNTY DISTRICT 160000100613 411 IDAHO HILL ELEMENTARY SCHOOL   Regular School No Elementary PK 6.0 2017   grade_2 18 0 1   0 0     0   2   6 15             *         21 18 0 1   0 0     0   2   6 15                 21
1726862 ID     school 1600002 84   LAKE PEND OREILLE SCHOOL DISTRICT 160000200603 293 KOOTENAI ELEMENTARY SCHOOL   Regular School No Elementary KG 6.0 2017   grade_2 58 1 5   0 0     0   1   42 23             35         65 58 1 5   0 0     0   1   42 23         35       65
1726870 ID     school 1600002 84   LAKE PEND OREILLE SCHOOL DISTRICT 160000200614 401 HOPE ELEMENTARY SCHOOL   Regular School No Elementary PK 6.0 2017   grade_2 13 0 2   0 0     0   0   12 3             10         15 13 0 2   0 0     0   0   12 3         10       15
1726878 ID     school 1600002 84   LAKE PEND OREILLE SCHOOL DISTRICT 160000200618 402 SAGLE ELEMENTARY SCHOOL   Regular School No Elementary PK 6.0 2017   grade_2 35 0 1   0 0     0   3   20 19             23         39 35 0 1   0 0     0   3   20 19         23       39
1726886 ID     school 1600002 84   LAKE PEND OREILLE SCHOOL DISTRICT 160000200615 403 FARMIN STIDWELL ELEMENTARY SCHOOL   Regular School No Elementary PK 6.0 2017   grade_2 61 0 8   0 2     0   5   34 42             52         76 61 0 8   0 2     0   5   34 42         52       76
1726894 ID     school 1600002 84   LAKE PEND OREILLE SCHOOL DISTRICT 160000200616 405 SOUTHSIDE ELEMENTARY SCHOOL   Regular School No Elementary PK 6.0 2017   grade_2 18 0 0   0 0     0   1   13 6             10         19 18 0 0   0 0     0   1   13 6         10       19
1726902 ID     school 1600002 84   LAKE PEND OREILLE SCHOOL DISTRICT 160000200617 408 WASHINGTON ELEMENTARY SCHOOL   Regular School No Elementary PK 6.0 2017   grade_2 43 0 4   1 0     0   1   24 25             23         49 43 0 4   1 0     0   1   24 25         23       49
1726910 ID     school 1600002 84   LAKE PEND OREILLE SCHOOL DISTRICT 160000200621 410 NORTHSIDE ELEMENTARY SCHOOL   Regular School No Elementary PK 6.0 2017   grade_2 27 1 1   0 0     0   0   15 14             15         29 27 1 1   0 0     0   0   15 14         15       29
1726947 ID     school 1601530 91   IDAHO FALLS DISTRICT 160153000264 412 LONGFELLOW ELEMENTARY SCHOOL   Regular School No Elementary PK 6.0 2017   grade_2 56 1 12   0 0     0   3   34 38             21         72 56 1 12   0 0     0   3   34 38         21       72
1726955 ID     school 1601530 91   IDAHO FALLS DISTRICT 160153000261 413 HAWTHORNE ELEMENTARY SCHOOL   Regular School No Elementary PK 6.0 2017   grade_2 38 0 14   0 0     0   0   24 28             35         52 38 0 14   0 0     0   0   24 28         35       52
1726963 ID     school 1601530 91   IDAHO FALLS DISTRICT 160153000269 414 TEMPLE VIEW ELEMENTARY SCHOOL   Regular School No Elementary PK 6.0 2017   grade_2 46 0 18   0 0     0   1   35 30             49         65 46 0 18   0 0     0   1   35 30         49       65
1726971 ID     school 1601530 91   IDAHO FALLS DISTRICT 160153000252 415 A H BUSH ELEMENTARY SCHOOL   Regular School No Elementary PK 6.0 2017   grade_2 33 1 20   1 0     0   0   24 31             47         55 33 1 20   1 0     0   0   24 31         47       55
1726979 ID     school 1601530 91   IDAHO FALLS DISTRICT 160153000258 416 EDGEMONT GARDENS ELEMENTARY SCHOOL   Regular School No Elementary PK 6.0 2017   grade_2 59 0 17   0 1     0   3   42 38             45         80 59 0 17   0 1     0   3   42 38         45       80
1726987 ID     school 1601530 91   IDAHO FALLS DISTRICT 160153000270 419 THERESA BUNKER ELEMENTARY SCHOOL   Regular School No Elementary PK 6.0 2017   grade_2 27 0 5   0 0     0   6   21 17             30         38 27 0 5   0 0     0   6   21 17         30       38
1726995 ID     school 1601530 91   IDAHO FALLS DISTRICT 160153000260 420 ETHEL BOYES ELEMENTARY SCHOOL   Regular School No Elementary PK 6.0 2017   grade_2 29 0 18   0 0     0   1   21 27             35         48 29 0 18   0 0     0   1   21 27         35       48
1727003 ID     school 1601530 91   IDAHO FALLS DISTRICT 160153000633 421 WESTSIDE ELEMENTARY SCHOOL   Regular School No Elementary PK 6.0 2017   grade_2 48 1 11   0 1     0   0   33 28             29         61 48 1 11   0 1     0   0   33 28         29       61
1727011 ID     school 1601530 91   IDAHO FALLS DISTRICT 160153000256 422 DORA ERICKSON ELEMENTARY SCHOOL   Regular School No Elementary PK 6.0 2017   grade_2 37 1 32   0 0     1   1   48 24             65         72 37 1 32   0 0     1   1   48 24         65       72
1727019 ID     school 1601530 91   IDAHO FALLS DISTRICT 160153000263 423 LINDEN PARK ELEMENTARY SCHOOL   Regular School No Elementary PK 6.0 2017   grade_2 48 1 18   0 0     0   3   43 27             53         70 48 1 18   0 0     0   3   43 27         53       70
1727029 ID     school 1601530 91   IDAHO FALLS DISTRICT 160153000726 667 FOX HOLLOW ELEMENTARY SCHOOL   Regular School No Elementary PK 6.0 2017   grade_2 38 0 29   0 0     0   0   29 38             40         67 38 0 29   0 0     0   0   29 38         40       67
1727037 ID     school 1601530 91   IDAHO FALLS DISTRICT 160153000725 668 SUNNYSIDE ELEMENTARY SCHOOL   Regular School No Elementary PK 6.0 2017   grade_2 84 0 3   0 0     0   1   39 49             7         88 84 0 3   0 0     0   1   39 49         7       88
1727061 ID     school 1603120 92   SWAN VALLEY ELEMENTARY DISTRICT 160312000541 424 SWAN VALLEY ELEMENTARY SCHOOL   Regular School No Elementary PK 8.0 2017   grade_2 5 0 1   0 0     0   0   1 5             *         6 5 0 1   0 0     0   0   1 5                 6
1727092 ID     school 1600930 93   BONNEVILLE JOINT DISTRICT 160093000173 425 FALLS VALLEY ELEMENTARY SCHOOL   Regular School No Elementary PK 6.0 2017   grade_2 48 0 14   0 0     0   3   28 37             *         65 48 0 14   0 0     0   3   28 37                 65
1727100 ID     school 1600930 93   BONNEVILLE JOINT DISTRICT 160093000167 426 AMMON ELEMENTARY SCHOOL   Regular School No Elementary PK 6.0 2017   grade_2 38 0 7   0 1     0   1   23 24             24         47 38 0 7   0 1     0   1   23 24         24       47
1727108 ID     school 1600930 93   BONNEVILLE JOINT DISTRICT 160093000176 427 IONA ELEMENTARY SCHOOL   Regular School No Elementary PK 6.0 2017   grade_2 59 0 20   0 0     1   1   47 34             41         81 59 0 20   0 0     1   1   47 34         41       81
1727116 ID     school 1600930 93   BONNEVILLE JOINT DISTRICT 160093000175 428 HILLVIEW ELEMENTARY SCHOOL   Regular School No Elementary PK 6.0 2017   grade_2 50 0 4   1 0     0   3   33 25             27         58 50 0 4   1 0     0   3   33 25         27       58
1727124 ID     school 1600930 93   BONNEVILLE JOINT DISTRICT 160093000178 429 UCON ELEMENTARY SCHOOL   Regular School No Elementary PK 6.0 2017   grade_2 50 0 3   0 0     0   1   29 25             29         54 50 0 3   0 0     0   1   29 25         29       54
1727132 ID     school 1600930 93   BONNEVILLE JOINT DISTRICT 160093000630 431 CLOVERDALE ELEMENTARY SCHOOL   Regular School No Elementary PK 6.0 2017   grade_2 71 1 23   1 0     0   3   49 50             50         99 71 1 23   1 0     0   3   49 50         50       99
1727140 ID     school 1600930 93   BONNEVILLE JOINT DISTRICT 160093000172 432 FAIRVIEW ELEMENTARY SCHOOL   Regular School No Elementary PK 6.0 2017   grade_2 31 1 5   0 0     0   0   21 16             19         37 31 1 5   0 0     0   0   21 16         19       37
1727148 ID     school 1600930 93   BONNEVILLE JOINT DISTRICT 160093000670 501 TIEBREAKER ELEMENTARY SCHOOL   Regular School No Elementary PK 6.0 2017   grade_2 58 0 6   0 1     0   2   35 32             42         67 58 0 6   0 1     0   2   35 32         42       67
1727156 ID     school 1600930 93   BONNEVILLE JOINT DISTRICT 160093000910 637 WOODLAND HILLS ELEMENTARY   Regular School No Elementary PK 6.0 2017   grade_2 88 1 2   0 1     0   0   46 46             12         92 88 1 2   0 1     0   0   46 46         12       92
1727169 ID     school 1600930 93   BONNEVILLE JOINT DISTRICT 160093000999 1238 BONNEVILLE ONLINE ELEMENTARY   Regular School No Elementary PK 8.0 2017   grade_2 10 0 0   0 0     0   0   6 4             *         10 10 0 0   0 0     0   0   6 4                 10
1727179 ID     school 1600930 93   BONNEVILLE JOINT DISTRICT 160093001015 1250 MOUNTAIN VALLEY ELEMENTARY SCHOOL   Regular School No Elementary PK 6.0 2017   grade_2 59 0 5   1 0     0   3   42 26             29         68 59 0 5   1 0     0   3   42 26         29       68
1727187 ID     school 1600930 93   BONNEVILLE JOINT DISTRICT 160093000909 1255 RIMROCK ELEMENTARY   Regular School No Elementary PK 6.0 2017   grade_2 51 0 4   1 0     0   3   27 32             15         59 51 0 4   1 0     0   3   27 32         15       59
1727204 ID     school 1600930 93   BONNEVILLE JOINT DISTRICT 160093001062 1360 SUMMIT HILLS ELEMENTARY SCHOOL   Regular School No Elementary KG 6.0 2017   grade_2 59 0 25   0 1     1   3   44 45             40         89 59 0 25   0 1     1   3   44 45         40       89
1727212 ID     school 1600930 93   BONNEVILLE JOINT DISTRICT 160093000975 2518 BRIDGEWATER ELEMENTARY SCHOOL   Regular School No Elementary PK 6.0 2017   grade_2 43 0 27   0 0     0   2   42 30             43         72 43 0 27   0 0     0   2   42 30         43       72
1727220 ID     school 1600930 93   BONNEVILLE JOINT DISTRICT 160093000971 2519 DISCOVERY ELEMENTARY SCHOOL   Regular School No Elementary PK 6.0 2017   grade_2 104 0 16   1 0     0   1   70 52             53         122 104 0 16   1 0     0   1   70 52         53       122
1727237 ID     school 1600420 101   BOUNDARY COUNTY DISTRICT 160042000092 433 NAPLES ELEMENTARY SCHOOL   Regular School No Elementary KG 5.0 2017   grade_2 19 0 3   1 0     0   0   16 7             15         23 19 0 3   1 0     0   0   16 7         15       23
1727244 ID     school 1600420 101   BOUNDARY COUNTY DISTRICT 160042000091 434 MOUNT HALL ELEMENTARY SCHOOL   Regular School No Elementary KG 5.0 2017   grade_2 18 1 1   0 0     0   0   13 7             9         20 18 1 1   0 0     0   0   13 7         9       20
1727251 ID     school 1600420 101   BOUNDARY COUNTY DISTRICT 160042000094 437 VALLEY VIEW ELEMENTARY SCHOOL   Regular School No Elementary PK 5.0 2017   grade_2 65 0 5   3 0     0   3   41 35             49         76 65 0 5   3 0     0   3   41 35         49       76
1727267 ID     school 1600490 111   BUTTE COUNTY JOINT DISTRICT 160049000011 438 HOWE ELEMENTARY SCHOOL   Regular School No Elementary PK 5.0 2017   grade_2 7 0 2   0 0     0   0   6 3             *         9 7 0 2   0 0     0   0   6 3                 9
1727274 ID     school 1600490 111   BUTTE COUNTY JOINT DISTRICT 160049000007 439 ARCO ELEMENTARY SCHOOL   Regular School No Elementary PK 5.0 2017   grade_2 26 0 3   0 0     1   3   20 13             *         33 26 0 3   0 0     1   3   20 13                 33
1727286 ID     school 1600540 121   CAMAS COUNTY DISTRICT 160054000110 440 CAMAS COUNTY ELEM/JR HIGH SCHOOL   Regular School No Elementary PK 8.0 2017   grade_2 10 0 2   0 0     0   0   6 6             7         12 10 0 2   0 0     0   0   6 6         7       12
1727304 ID     school 1602340 131   NAMPA SCHOOL DISTRICT 160234000375 213 IOWA ELEMENTARY   Regular School No Elementary PK 5.0 2017   grade_2 49 0 29   0 0     0   2   38 42             *         80 49 0 29   0 0     0   2   38 42                 80
1727311 ID     school 1602340 131   NAMPA SCHOOL DISTRICT 160234000379 214 SHERMAN ELEMENTARY   Regular School No Elementary PK 5.0 2017   grade_2 47 0 31   0 1     1   7   46 41             *         87 47 0 31   0 1     1   7   46 41                 87
1727318 ID     school 1602340 131   NAMPA SCHOOL DISTRICT 160234000383 215 PARK RIDGE ELEMENTARY   Regular School No Elementary PK 5.0 2017   grade_2 32 0 22   0 0     0   0   30 24             *         54 32 0 22   0 0     0   0   30 24                 54
1727325 ID     school 1602340 131   NAMPA SCHOOL DISTRICT 160234000409 444 CENTENNIAL ELEMENTARY SCHOOL   Regular School No Elementary PK 5.0 2017   grade_2 50 0 26   0 0     1   1   43 35             *         78 50 0 26   0 0     1   1   43 35                 78
1727332 ID     school 1602340 131   NAMPA SCHOOL DISTRICT 160234000410 447 CENTRAL ELEMENTARY   Regular School No Elementary PK 5.0 2017   grade_2 27 0 25   0 0     0   3   32 23             *         55 27 0 25   0 0     0   3   32 23                 55
1727339 ID     school 1602340 131   NAMPA SCHOOL DISTRICT 160234000677 450 GREENHURST ELEMENTARY SCHOOL   Regular School No Elementary PK 5.0 2017   grade_2 33 0 15   0 0     0   1   30 19             *         49 33 0 15   0 0     0   1   30 19                 49
1727346 ID     school 1602340 131   NAMPA SCHOOL DISTRICT 160234000774 527 OWYHEE ELEMENTARY SCHOOL   Regular School No Elementary PK 5.0 2017   grade_2 61 0 11   0 1     1   0   37 37             *         74 61 0 11   0 1     1   0   37 37                 74
1727353 ID     school 1602340 131   NAMPA SCHOOL DISTRICT 160234000775 528 REAGAN ELEMENTARY SCHOOL   Regular School No Elementary PK 5.0 2017   grade_2 55 0 10   0 0     1   1   41 26             *         67 55 0 10   0 0     1   1   41 26                 67
1727360 ID     school 1602340 131   NAMPA SCHOOL DISTRICT 160234000773 529 ROOSEVELT ELEMENTARY SCHOOL   Regular School No Elementary PK 5.0 2017   grade_2 58 0 26   0 0     0   2   53 33             *         86 58 0 26   0 0     0   2   53 33                 86
1727367 ID     school 1602340 131   NAMPA SCHOOL DISTRICT 160234000833 581 WILLOW CREEK ELEMENTARY   Regular School No Elementary PK 5.0 2017   grade_2 64 0 38   0 0     0   3   52 53             *         105 64 0 38   0 0     0   3   52 53                 105
1727379 ID     school 1602340 131   NAMPA SCHOOL DISTRICT 160234000986 647 LAKE RIDGE ELEMENTARY   Regular School No Elementary PK 5.0 2017   grade_2 88 4 19   0 0     0   0   70 41             *         111 88 4 19   0 0     0   0   70 41                 111
1727390 ID     school 1602340 131   NAMPA SCHOOL DISTRICT 160234000947 890 ENDEAVOR ELEMENTARY SCHOOL   Regular School No Elementary PK 5.0 2017   grade_2 34 1 42   0 0     0   1   43 35             *         78 34 1 42   0 0     0   1   43 35                 78
1727402 ID     school 1602340 131   NAMPA SCHOOL DISTRICT 160234000507 996 SNAKE RIVER ELEMENTARY   Regular School No Elementary PK 5.0 2017   grade_2 40 0 39   0 1     1   3   38 46             *         84 40 0 39   0 1     1   3   38 46                 84
1727423 ID     school 1602340 131   NAMPA SCHOOL DISTRICT 160234000941 2889 NEW HORIZON MAGNET SCHOOL   Regular School No Elementary PK 5.0 2017   grade_2 13 1 57   0 0     0   0   37 34             *         71 13 1 57   0 0     0   0   37 34                 71
1727439 ID     school 1600510 132   CALDWELL DISTRICT 160051000835 76 LEWIS AND CLARK ELEMENTARY   Regular School No Elementary PK 5.0 2017   grade_2 21 2 42   0 0     0   1   38 28             *         66 21 2 42   0 0     0   1   38 28                 66
1727450 ID     school 1600510 132   CALDWELL DISTRICT 160051000609 289 WILSON ELEMENTARY SCHOOL   Regular School No Elementary PK 5.0 2017   grade_2 47 0 27   0 0     0   3   35 42             *         77 47 0 27   0 0     0   3   35 42                 77
1727457 ID     school 1600510 132   CALDWELL DISTRICT 160051000108 448 WASHINGTON ELEMENTARY SCHOOL   Regular School No Elementary PK 5.0 2017   grade_2 19 0 60   0 0     0   2   49 32             *         81 19 0 60   0 0     0   2   49 32                 81
1727464 ID     school 1600510 132   CALDWELL DISTRICT 160051000106 449 LINCOLN ELEMENTARY SCHOOL   Regular School No Elementary PK 5.0 2017   grade_2 28 0 32   1 0     0   1   32 30             *         62 28 0 32   1 0     0   1   32 30                 62
1727471 ID     school 1600510 132   CALDWELL DISTRICT 160051000107 451 VAN BUREN ELEMENTARY SCHOOL   Regular School No Elementary KG 5.0 2017   grade_2 39 0 66   0 0     0   3   55 53             *         108 39 0 66   0 0     0   3   55 53                 108
1727478 ID     school 1600510 132   CALDWELL DISTRICT 160051000731 457 SACAJAWEA ELEMENTARY SCHOOL   Regular School No Elementary PK 5.0 2017   grade_2 17 0 57   0 0     0   4   44 34             *         78 17 0 57   0 0     0   4   44 34                 78
1727501 ID     school 1603480 133   WILDER DISTRICT 160348000585 452 WILDER ELEMENTARY SCHOOL   Regular School No Elementary PK 5.0 2017   grade_2 13 0 29   1 0     0   0   25 18             *         43 13 0 29   1 0     0   0   25 18                 43
1727521 ID     school 1602130 134   MIDDLETON DISTRICT 160213000376 453 MIDDLETON MILL CREEK ELEMENTARY   Regular School No Elementary PK 5.0 2017   grade_2 90 0 7   1 1     0   3   49 53             37         102 90 0 7   1 1     0   3   49 53         37       102
1727528 ID     school 1602130 134   MIDDLETON DISTRICT 160213000675 500 MIDDLETON HEIGHTS ELEMENTARY   Regular School No Elementary PK 5.0 2017   grade_2 86 1 13   1 0     0   2   49 54             50         103 86 1 13   1 0     0   2   49 54         50       103
1727535 ID     school 1602130 134   MIDDLETON DISTRICT 160213000812 546 PURPLE SAGE ELEMENTARY   Regular School No Elementary PK 5.0 2017   grade_2 61 0 19   1 0     0   2   43 40             38         83 61 0 19   1 0     0   2   43 40         38       83
1727556 ID     school 1602460 135   NOTUS DISTRICT 160246000430 520 NOTUS ELEMENTARY SCHOOL   Regular School No Elementary PK 6.0 2017   grade_2 22 0 7   0 1     0   1   14 17             21         31 22 0 7   0 1     0   1   14 17         21       31
1727571 ID     school 1602070 136   MELBA JOINT DISTRICT 160207000359 455 MELBA ELEMENTARY SCHOOL   Regular School No Elementary PK 6.0 2017   grade_2 42 0 13   0 0     0   1   33 23             25         56 42 0 13   0 0     0   1   33 23         25       56
1727589 ID     school 1602550 137   PARMA DISTRICT 160255000449 456 MAXINE JOHNSON ELEMENTARY   Regular School No Elementary PK 4.0 2017   grade_2 48 0 24   0 0     0   4   37 39             56         76 48 0 24   0 0     0   4   37 39         56       76
1727600 ID     school 1600600 139   VALLIVUE SCHOOL DISTRICT 160060000115 460 EAST CANYON ELEMENTARY SCHOOL   Regular School No Elementary PK 5.0 2017   grade_2 60 0 40   1 0     0   1   53 49             65         102 60 0 40   1 0     0   1   53 49         65       102
1727607 ID     school 1600600 139   VALLIVUE SCHOOL DISTRICT 160060000119 461 WEST CANYON ELEMENTARY SCHOOL   Regular School No Elementary PK 5.0 2017   grade_2 62 0 42   0 0     0   2   59 47             73         106 62 0 42   0 0     0   2   59 47         73       106
1727614 ID     school 1600600 139   VALLIVUE SCHOOL DISTRICT 160060000083 505 CENTRAL CANYON ELEMENTARY SCHOOL   Regular School No Elementary PK 5.0 2017   grade_2 64 0 58   0 0     0   2   56 68             89         124 64 0 58   0 0     0   2   56 68         89       124
1727621 ID     school 1600600 139   VALLIVUE SCHOOL DISTRICT 160060000778 519 BIRCH ELEMENTARY SCHOOL   Regular School No Elementary PK 5.0 2017   grade_2 74 0 27   0 0     0   4   57 48             56         105 74 0 27   0 0     0   4   57 48         56       105
1727632 ID     school 1600600 139   VALLIVUE SCHOOL DISTRICT 160060000976 646 LAKEVUE ELEMENTARY SCHOOL   Regular School No Elementary PK 5.0 2017   grade_2 54 0 42   0 0     0   3   41 58             65         99 54 0 42   0 0     0   3   41 58         65       99
1727639 ID     school 1600600 139   VALLIVUE SCHOOL DISTRICT 160060000935 892 DESERT SPRINGS ELEMENTARY SCHOOL   Regular School No Elementary PK 5.0 2017   grade_2 63 0 53   2 0     0   5   74 49             79         123 63 0 53   2 0     0   5   74 49         79       123
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
1727680 ID     school 1601290 148   GRACE JOINT DISTRICT 160129000225 463 GRACE ELEMENTARY SCHOOL   Regular School No Elementary PK 6.0 2017   grade_2 12 0 2   0 0     0   0   6 8             5         14 12 0 2   0 0     0   0   6 8         5       14
1727695 ID     school 1602430 149   NORTH GEM DISTRICT 160243000427 464 NORTH GEM ELEMENTARY   Regular School No Elementary PK 6.0 2017   grade_2 8 0 0   0 0     0   0   3 5             *         8 8 0 0   0 0     0   0   3 5                 8
1727713 ID     school 1603000 150   SODA SPRINGS JOINT DISTRICT 160300000525 466 HOWARD E THIRKILL PRIMARY SCHOOL   Regular School No Elementary PK 4.0 2017   grade_2 56 0 2   0 0     0   1   28 31             *         59 56 0 2   0 0     0   1   28 31                 59
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
1727766 ID     school 1600660 151   CASSIA COUNTY JOINT DISTRICT 160066000123 468 ALMO ELEMENTARY SCHOOL   Regular School No Elementary PK 6.0 2017   grade_2 3 0 0   0 0     0   0   2 1             *         3 3 0 0   0 0     0   0   2 1                 3
1727771 ID     school 1600660 151   CASSIA COUNTY JOINT DISTRICT 160066000126 469 DECLO ELEMENTARY SCHOOL   Regular School No Elementary PK 5.0 2017   grade_2 57 0 15   0 1     0   1   38 36             31         74 57 0 15   0 1     0   1   38 36         31       74
1727778 ID     school 1600660 151   CASSIA COUNTY JOINT DISTRICT 160066000130 470 MOUNTAIN VIEW ELEMENTARY   Regular School No Elementary PK 3.0 2017   grade_2 86 0 46   0 1     0   4   68 69             89         137 86 0 46   0 1     0   4   68 69         89       137
1727783 ID     school 1600660 151   CASSIA COUNTY JOINT DISTRICT 160066000129 471 RAFT RIVER ELEMENTARY SCHOOL   Regular School No Elementary PK 6.0 2017   grade_2 21 0 7   0 0     0   0   13 15             *         28 21 0 7   0 0     0   0   13 15                 28

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