Data source: Big Local News · About: Big Local

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

View and edit SQL

year

  • 2017 · 391

grade

  • grade_2 · 391
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
1725609 ID     school 1600360 1   BOISE INDEPENDENT DISTRICT 160036000590 287 TRAIL WIND ELEMENTARY   Regular School No Elementary PK 6.0 2017   grade_2 91 0 5   0 6     2   5   57 52             17         109 91 0 5   0 6     2   5   57 52         17       109
1725625 ID     school 1600360 1   BOISE INDEPENDENT DISTRICT 160036000592 300 AMITY ELEMENTARY SCHOOL   Regular School No Elementary PK 6.0 2017   grade_2 64 0 8   0 0     1   2   33 42             27         75 64 0 8   0 0     1   2   33 42         27       75
1725633 ID     school 1600360 1   BOISE INDEPENDENT DISTRICT 160036000065 301 MAPLE GROVE ELEMENTARY SCHOOL   Regular School No Elementary PK 6.0 2017   grade_2 69 0 3   0 2     0   1   40 35             23         75 69 0 3   0 2     0   1   40 35         23       75
1725641 ID     school 1600360 1   BOISE INDEPENDENT DISTRICT 160036000055 302 HIGHLANDS ELEMENTARY SCHOOL   Regular School No Elementary PK 6.0 2017   grade_2 40 0 2   0 1     0   1   24 20             *         44 40 0 2   0 1     0   1   24 20                 44
1725657 ID     school 1600360 1   BOISE INDEPENDENT DISTRICT 160036000076 305 WASHINGTON ELEMENTARY SCHOOL   Regular School No Elementary PK 6.0 2017   grade_2 39 0 2   0 1     0   2   20 24             6         44 39 0 2   0 1     0   2   20 24         6       44
1725689 ID     school 1600360 1   BOISE INDEPENDENT DISTRICT 160036000072 309 ROOSEVELT ELEMENTARY SCHOOL   Regular School No Elementary PK 6.0 2017   grade_2 41 0 1   0 0     1   2   23 22             11         45 41 0 1   0 0     1   2   23 22         11       45
1725697 ID     school 1600360 1   BOISE INDEPENDENT DISTRICT 160036000071 310 PIERCE PARK ELEMENTARY SCHOOL   Regular School No Elementary PK 6.0 2017   grade_2 59 0 3   0 0     0   2   28 36             *         64 59 0 3   0 0     0   2   28 36                 64
1725705 ID     school 1600360 1   BOISE INDEPENDENT DISTRICT 160036000070 313 OWYHEE ELEMENTARY SCHOOL   Regular School No Elementary PK 6.0 2017   grade_2 26 0 4   1 0     0   4   19 16             *         35 26 0 4   1 0     0   4   19 16                 35
1725713 ID     school 1600360 1   BOISE INDEPENDENT DISTRICT 160036000042 315 ADAMS ELEMENTARY SCHOOL   Regular School No Elementary PK 6.0 2017   grade_2 47 0 3   0 0     0   1   23 28             6         51 47 0 3   0 0     0   1   23 28         6       51
1725721 ID     school 1600360 1   BOISE INDEPENDENT DISTRICT 160036000650 316 LIBERTY ELEMENTARY SCHOOL   Regular School No Elementary PK 6.0 2017   grade_2 64 0 4   0 1     0   1   38 32             10         70 64 0 4   0 1     0   1   38 32         10       70
1725745 ID     school 1600360 1   BOISE INDEPENDENT DISTRICT 160036000075 320 VALLEY VIEW ELEMENTARY SCHOOL   Regular School No Elementary PK 6.0 2017   grade_2 38 0 4   0 1     0   2   24 21             *         45 38 0 4   0 1     0   2   24 21                 45
1725769 ID     school 1600360 1   BOISE INDEPENDENT DISTRICT 160036000062 323 LONGFELLOW ELEMENTARY SCHOOL   Regular School No Elementary PK 6.0 2017   grade_2 46 0 4   0 0     0   4   26 28             9         54 46 0 4   0 0     0   4   26 28         9       54
1725777 ID     school 1600360 1   BOISE INDEPENDENT DISTRICT 160036000067 324 MONROE ELEMENTARY SCHOOL   Regular School No Elementary PK 6.0 2017   grade_2 46 0 3   0 0     2   2   32 21             *         53 46 0 3   0 0     2   2   32 21                 53
1725793 ID     school 1600360 1   BOISE INDEPENDENT DISTRICT 160036000049 326 COLLISTER ELEMENTARY SCHOOL   Regular School No Elementary PK 6.0 2017   grade_2 29 0 2   0 2     0   1   19 15             10         34 29 0 2   0 2     0   1   19 15         10       34
1725835 ID     school 1600360 1   BOISE INDEPENDENT DISTRICT 160036000707 665 CYNTHIA MANN ELEMENTARY SCHOOL   Regular School No Elementary PK 6.0 2017   grade_2 36 0 5   0 1     0   2   25 19             *         44 36 0 5   0 1     0   2   25 19                 44
1725882 ID     school 1600360 1   BOISE INDEPENDENT DISTRICT 160036001004 679 HIDDEN SPRINGS ELEMENTARY SCHOOL   Regular School No Elementary PK 6.0 2017   grade_2 43 0 1   0 0     0   2   18 28             *         46 43 0 1   0 0     0   2   18 28                 46
1725957 ID     school 1602100 2   JOINT SCHOOL DISTRICT NO. 2 160210000824 296 HUNTER ELEMENTARY SCHOOL   Regular School No Elementary PK 5.0 2017   grade_2 106 0 5   0 2     0   6   61 58             17         119 106 0 5   0 2     0   6   61 58         17       119
1725971 ID     school 1602100 2   JOINT SCHOOL DISTRICT NO. 2 160210000717 329 CHIEF JOSEPH SCHOOL OF THE ARTS   Regular School No Elementary PK 5.0 2017   grade_2 60 0 15   0 2     1   7   39 46             39         85 60 0 15   0 2     1   7   39 46         39       85
1725992 ID     school 1602100 2   JOINT SCHOOL DISTRICT NO. 2 160210000362 332 EAGLE ELEMENTARY SCHOOL OF THE ARTS   Regular School No Elementary PK 5.0 2017   grade_2 66 0 2   0 1     0   4   28 45             14         73 66 0 2   0 1     0   4   28 45         14       73
1725999 ID     school 1602100 2   JOINT SCHOOL DISTRICT NO. 2 160210000364 333 SUMMERWIND SCHOOL OF MATH AND SCIENCE   Regular School No Elementary PK 5.0 2017   grade_2 63 0 3   1 0     0   6   42 31             35         73 63 0 3   1 0     0   6   42 31         35       73
1726013 ID     school 1602100 2   JOINT SCHOOL DISTRICT NO. 2 160210000374 335 USTICK ELEMENTARY SCHOOL   Regular School No Elementary PK 5.0 2017   grade_2 44 0 19   0 6     0   3   38 34             *         72 44 0 19   0 6     0   3   38 34                 72
1726034 ID     school 1602100 2   JOINT SCHOOL DISTRICT NO. 2 160210000366 338 CHRISTINE DONNELL SCHOOL OF THE ARTS   Regular School No Elementary PK 6.0 2017   grade_2 70 0 7   1 0     0   8   41 45             14         86 70 0 7   1 0     0   8   41 45         14       86
1726084 ID     school 1602100 2   JOINT SCHOOL DISTRICT NO. 2 160210000801 521 DISCOVERY ELEMENTARY SCHOOL   Regular School No Elementary PK 5.0 2017   grade_2 69 0 9   2 2     1   3   51 35             16         86 69 0 9   2 2     1   3   51 35         16       86
1726091 ID     school 1602100 2   JOINT SCHOOL DISTRICT NO. 2 160210000593 523 CECIL D ANDRUS ELEMENTARY   Regular School No Elementary PK 5.0 2017   grade_2 90 0 6   2 2     1   1   52 50             21         102 90 0 6   2 2     1   1   52 50         21       102
1726105 ID     school 1602100 2   JOINT SCHOOL DISTRICT NO. 2 160210000595 525 ELIZA HART SPALDING STEM ACADEMY   Regular School No Elementary PK 5.0 2017   grade_2 102 0 12   2 2     0   7   68 57             29         125 102 0 12   2 2     0   7   68 57         29       125
1726112 ID     school 1602100 2   JOINT SCHOOL DISTRICT NO. 2 160210000601 526 SEVEN OAKS ELEMENTARY   Regular School No Elementary PK 5.0 2017   grade_2 70 0 4   0 0     0   1   34 41             8         75 70 0 4   0 0     0   1   34 41         8       75
1726151 ID     school 1602100 2   JOINT SCHOOL DISTRICT NO. 2 160210000989 899 SIENA ELEMENTARY   Regular School No Elementary PK 5.0 2017   grade_2 96 0 10   0 4     0   4   67 47             15         114 96 0 10   0 4     0   4   67 47         15       114
1726177 ID     school 1602100 2   JOINT SCHOOL DISTRICT NO. 2 160210000955 1290 PARAMOUNT ELEMENTARY SCHOOL   Regular School No Elementary PK 5.0 2017   grade_2 81 0 3   0 1     0   0   50 35             7         85 81 0 3   0 1     0   0   50 35         7       85
1726197 ID     school 1602100 2   JOINT SCHOOL DISTRICT NO. 2 160210001070 1374 VIRTUAL SCHOOL HOUSE   Regular School No Elementary PK 8.0 2017   grade_2 9 0 0   0 0     0   0   4 5             *         9 9 0 0   0 0     0   0   4 5                 9
1726215 ID     school 1602100 2   JOINT SCHOOL DISTRICT NO. 2 160210001081 1383 HILLSDALE ELEMENTARY   Regular School No Elementary PK 5.0 2017   grade_2 77 0 16   0 0     0   3   48 48             28         96 77 0 16   0 0     0   3   48 48         28       96
1726226 ID     school 1602100 2   JOINT SCHOOL DISTRICT NO. 2 160210000945 2511 GALILEO MAGNET SCHOOL   Regular School No Elementary PK 8.0 2017   grade_2 88 0 6   0 0     0   1   57 38             10         95 88 0 6   0 0     0   1   57 38         10       95
1726248 ID     school 1601770 3   KUNA JOINT DISTRICT 160177000596 345 HUBBARD ELEMENTARY SCHOOL   Regular School No Elementary KG 2.0 2017   grade_2 69 0 7   1 0     2   6   37 48             39         85 69 0 7   1 0     2   6   37 48         39       85
1726260 ID     school 1601770 3   KUNA JOINT DISTRICT 160177000913 596 INDIAN CREEK ELEMENTARY   Regular School No Elementary PK 3.0 2017   grade_2 43 0 7   0 0     0   2   24 28             23         52 43 0 7   0 0     0   2   24 28         23       52
1726274 ID     school 1601770 3   KUNA JOINT DISTRICT 160177000951 887 CRIMSON POINT ELEMENTARY SCHOOL   Regular School No Elementary PK 6.0 2017   grade_2 65 0 7   0 1     0   2   30 45             38         75 65 0 7   0 1     0   2   30 45         38       75
1726298 ID     school 1602060 11   MEADOWS VALLEY DISTRICT 160206000826 342 MEADOWS VALLEY SCHOOL   Regular School No Other PK 12.0 2017   grade_2 13 0 2   0 0     0   0   6 9             *         15 13 0 2   0 0     0   0   6 9                 15
1726332 ID     school 1601950 21   MARSH VALLEY JOINT DISTRICT 160195000346 349 LAVA ELEMENTARY SCHOOL   Regular School No Elementary PK 6.0 2017   grade_2 7 0 2   0 0     0   0   5 4             *         9 7 0 2   0 0     0   0   5 4                 9
1726340 ID     school 1601950 21   MARSH VALLEY JOINT DISTRICT 160195000344 350 DOWNEY ELEMENTARY SCHOOL   Regular School No Elementary PK 6.0 2017   grade_2 17 0 1   0 0     0   1   12 7             *         19 17 0 1   0 0     0   1   12 7                 19
1726348 ID     school 1601950 21   MARSH VALLEY JOINT DISTRICT 160195000345 351 INKOM ELEMENTARY SCHOOL   Regular School No Elementary PK 6.0 2017   grade_2 31 0 0   0 0     0   1   17 15             15         32 31 0 0   0 0     0   1   17 15         15       32
1726390 ID     school 1602640 25   POCATELLO DISTRICT 160264000467 353 EDAHOW ELEMENTARY SCHOOL   Regular School No Elementary KG 5.0 2017   grade_2 38 0 6   1 0     0   1   23 23             22         46 38 0 6   1 0     0   1   23 23         22       46
1726411 ID     school 1602640 25   POCATELLO DISTRICT 160264000464 356 CHUBBUCK ELEMENTARY SCHOOL   Regular School No Elementary PK 5.0 2017   grade_2 79 0 11   3 2     0   4   51 48             48         99 79 0 11   3 2     0   4   51 48         48       99
1726418 ID     school 1602640 25   POCATELLO DISTRICT 160264000642 357 GATE CITY ELEMENTARY SCHOOL   Regular School No Elementary KG 5.0 2017   grade_2 65 0 3   0 0     2   3   31 42             *         73 65 0 3   0 0     2   3   31 42                 73
1726425 ID     school 1602640 25   POCATELLO DISTRICT 160264000659 358 RULON M ELLIS ELEMENTARY SCHOOL   Regular School No Elementary PK 5.0 2017   grade_2 49 0 5   0 1     1   6   37 25             33         62 49 0 5   0 1     1   6   37 25         33       62
1726432 ID     school 1602640 25   POCATELLO DISTRICT 160264000484 359 WASHINGTON ELEMENTARY SCHOOL   Regular School No Elementary KG 5.0 2017   grade_2 20 0 4   1 2     0   1   16 12             *         28 20 0 4   1 2     0   1   16 12                 28
1726439 ID     school 1602640 25   POCATELLO DISTRICT 160264000483 360 TYHEE ELEMENTARY SCHOOL   Regular School No Elementary PK 5.0 2017   grade_2 56 0 4   17 0     1   4   40 42             37         82 56 0 4   17 0     1   4   40 42         37       82
1726446 ID     school 1602640 25   POCATELLO DISTRICT 160264000481 361 SYRINGA ELEMENTARY SCHOOL   Regular School No Elementary PK 5.0 2017   grade_2 62 0 11   2 2     0   1   36 42             35         78 62 0 11   2 2     0   1   36 42         35       78
1726460 ID     school 1602640 25   POCATELLO DISTRICT 160264000475 365 JEFFERSON ELEMENTARY SCHOOL   Regular School No Elementary PK 5.0 2017   grade_2 51 0 9   0 0     1   3   35 29             44         64 51 0 9   0 0     1   3   35 29         44       64
1726467 ID     school 1602640 25   POCATELLO DISTRICT 160264000482 366 TENDOY ELEMENTARY SCHOOL   Regular School No Elementary PK 6.0 2017   grade_2 35 0 6   1 0     0   6   27 21             31         48 35 0 6   1 0     0   6   27 21         31       48
1726474 ID     school 1602640 25   POCATELLO DISTRICT 160264000476 368 LEWIS & CLARK ELEMENTARY SCHOOL   Regular School No Elementary KG 5.0 2017   grade_2 58 0 19   1 0     2   5   44 41             60         85 58 0 19   1 0     2   5   44 41         60       85
1726508 ID     school 1600240 33   BEAR LAKE COUNTY DISTRICT 160024000016 370 A J WINTERS ELEMENTARY SCHOOL   Regular School No Elementary PK 5.0 2017   grade_2 45 0 1   1 0     0   0   25 22             30         47 45 0 1   1 0     0   0   25 22         30       47
1726515 ID     school 1600240 33   BEAR LAKE COUNTY DISTRICT 160024000021 371 GEORGETOWN ELEMENTARY SCHOOL   Regular School No Elementary PK 5.0 2017   grade_2 16 0 0   0 0     0   0   8 8             5         16 16 0 0   0 0     0   0   8 8         5       16
1726522 ID     school 1600240 33   BEAR LAKE COUNTY DISTRICT 160024000019 372 PARIS ELEMENTARY SCHOOL   Regular School No Elementary PK 5.0 2017   grade_2 16 0 0   0 0     0   0   8 8             11         16 16 0 0   0 0     0   0   8 8         11       16
1726543 ID     school 1603060 41   ST MARIES JOINT DISTRICT 160306000485 254 HEYBURN ELEMENTARY SCHOOL   Regular School No Elementary PK 5.0 2017   grade_2 56 0 4   0 0     0   5   41 24             *         65 56 0 4   0 0     0   5   41 24                 65
1726550 ID     school 1603060 41   ST MARIES JOINT DISTRICT 160306000536 374 UPRIVER ELEMENTARY SCHOOL   Regular School No Elementary KG 6.0 2017   grade_2 7 0 0   0 0     0   3   5 5             *         10 7 0 0   0 0     0   3   5 5                 10
1726570 ID     school 1600815 44   PLUMMER-WORLEY JOINT DISTRICT 160081500719 752 LAKESIDE ELEMENTARY SCHOOL   Regular School No Elementary PK 6.0 2017   grade_2 3 0 5   16 0     0   2   16 10             *         26 3 0 5   16 0     0   2   16 10                 26
1726608 ID     school 1600270 55   BLACKFOOT DISTRICT 160027000031 382 DONALD D STALKER ELEMENTARY   Regular School No Elementary PK 5.0 2017   grade_2 24 0 15   10 0     0   5   20 34             31         54 24 0 15   10 0     0   5   20 34         31       54
1726615 ID     school 1600270 55   BLACKFOOT DISTRICT 160027000025 384 RIDGE CREST ELEMENTARY SCHOOL   Regular School No Elementary PK 5.0 2017   grade_2 40 0 19   2 1     0   6   30 38             41         68 40 0 19   2 1     0   6   30 38         41       68
1726622 ID     school 1600270 55   BLACKFOOT DISTRICT 160027000032 385 WAPELLO ELEMENTARY SCHOOL   Regular School No Elementary KG 5.0 2017   grade_2 44 0 1   0 0     0   1   29 17             16         46 44 0 1   0 0     0   1   29 17         16       46
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
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
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
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
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
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
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
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
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

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