Data source: Big Local News · About: Big Local

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

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
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
1728388 ID     school 1603270 262   VALLEY DISTRICT 160327000558 119 VALLEY SCHOOL   Regular School No Other PK 12.0 2017   grade_2 18 0 26   0 1     0   0   24 21             32         45 18 0 26   0 1     0   0   24 21         32       45
1728774 ID     school 1603030 292   SOUTH LEMHI DISTRICT 160303000528 137 LEADORE SCHOOL   Regular School No Other PK 12.0 2017   grade_2 6 0 0   0 0     0   0   2 4             *         6 6 0 0   0 0     0   0   2 4                 6
1728861 ID     school 1600900 314   DIETRICH DISTRICT 160090000165 143 DIETRICH SCHOOL   Regular School No Other PK 12.0 2017   grade_2 12 0 7   0 0     0   0   10 9             *         19 12 0 7   0 0     0   0   10 9                 19
1728875 ID     school 1602760 316   RICHFIELD DISTRICT 160276000497 144 RICHFIELD SCHOOL   Regular School No Other PK 12.0 2017   grade_2 11 0 4   0 0     0   0   11 4             *         15 11 0 4   0 0     0   0   11 4                 15
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
1729335 ID     school 1602820 382   ROCKLAND DISTRICT 160282000501 169 ROCKLAND PUBLIC SCHOOL   Regular School No Other PK 12.0 2017   grade_2 11 0 0   0 0     0   0   6 5             5         11 11 0 0   0 0     0   0   6 5         5       11
1729392 ID     school 1603300 393   WALLACE DISTRICT 160330000562 173 SILVER HILLS ELEMENTARY SCHOOL   Regular School No Elementary PK 6.0 2017   grade_2 42 0 1   1 0     0   0   21 23             26         44 42 0 1   1 0     0   0   21 23         26       44
1729623 ID     school 1600690 417   CASTLEFORD DISTRICT 160069000137 185 CASTLEFORD SCHOOL   Regular School No Other PK 12.0 2017   grade_2 13 0 7   2 0     0   0   13 9             12         22 13 0 7   2 0     0   0   13 9         12       22
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
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
1728412 ID     school 1600780 271   COEUR D'ALENE DISTRICT 160078000799 217 SKYWAY ELEMENTARY SCHOOL   Regular School No Elementary PK 5.0 2017   grade_2 99 1 4   3 0     0   1   69 39             40         108 99 1 4   3 0     0   1   69 39         40       108
1728320 ID     school 1602790 252   RIRIE JOINT DISTRICT 160279000435 229 RIRIE ELEMENTARY SCHOOL   Regular School No Elementary PK 6.0 2017   grade_2 38 0 5   0 0     1   0   25 19             25         44 38 0 5   0 0     1   0   25 19         25       44
1728093 ID     school 1601020 221   EMMETT INDEPENDENT DISTRICT 160102000797 230 KENNETH J CARBERRY ELEMENTARY   Regular School No Elementary PK 5.0 2017   grade_2 78 0 13   0 2     0   2   44 51             62         95 78 0 13   0 2     0   2   44 51         62       95
1725932 ID     school 1602100 2   JOINT SCHOOL DISTRICT NO. 2 160210000794 239 PEREGRINE ELEMENTARY SCHOOL   Regular School No Elementary PK 5.0 2017   grade_2 59 1 15   2 0     0   3   37 43             35         80 59 1 15   2 0     0   3   37 43         35       80
1725939 ID     school 1602100 2   JOINT SCHOOL DISTRICT NO. 2 160210000793 240 RIVER VALLEY ELEMENTARY SCHOOL   Regular School No Elementary PK 5.0 2017   grade_2 55 1 14   0 2     1   6   50 29             27         79 55 1 14   0 2     1   6   50 29         27       79
1729423 ID     school 1603180 401   TETON COUNTY DISTRICT 160318000754 249 DRIGGS ELEMENTARY SCHOOL   Regular School No Elementary PK 3.0 2017   grade_2 46 0 30   0 0     0   1   39 38             38         77 46 0 30   0 0     0   1   39 38         38       77
1728099 ID     school 1601020 221   EMMETT INDEPENDENT DISTRICT 160102000798 251 SHADOW BUTTE ELEMENTARY SCHOOL   Regular School No Elementary KG 5.0 2017   grade_2 66 1 6   0 2     0   6   48 33             *         81 66 1 6   0 2     0   6   48 33                 81
1728581 ID     school 1602670 273   POST FALLS DISTRICT 160267000800 253 MULLAN TRAIL ELEMENTARY SCHOOL   Regular School No Elementary PK 5.0 2017   grade_2 52 0 8   0 0     0   4   29 35             43         64 52 0 8   0 0     0   4   29 35         43       64
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
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
1728682 ID     school 1601200 282   GENESEE JOINT DISTRICT 160120000845 269 GENESEE SCHOOL   Regular School No Other PK 12.0 2017   grade_2 23 0 2   0 0     0   1   15 11             10         26 23 0 2   0 0     0   1   15 11         10       26
1728796 ID     school 1602400 302   NEZPERCE JOINT DISTRICT 160240000848 272 NEZPERCE SCHOOL   Regular School No Other PK 12.0 2017   grade_2 7 0 0   1 0     0   1   6 3             *         9 7 0 0   1 0     0   1   6 3                 9
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
1728171 ID     school 1601380 233   HAGERMAN JOINT DISTRICT 160138000840 280 HAGERMAN SCHOOL   Regular School No Other PK 12.0 2017   grade_2 11 0 5   0 0     0   1   6 11             12         17 11 0 5   0 0     0   1   6 11         12       17
1725946 ID     school 1602100 2   JOINT SCHOOL DISTRICT NO. 2 160210000818 283 PEPPER RIDGE ELEMENTARY   Regular School No Elementary PK 5.0 2017   grade_2 81 1 6   0 0     1   1   48 42             25         90 81 1 6   0 0     1   1   48 42         25       90
1728826 ID     school 1601440 305   HIGHLAND JOINT DISTRICT 160144000849 285 HIGHLAND SCHOOL   Regular School No Other PK 12.0 2017   grade_2 9 0 2   0 0     0   0   5 6             *         11 9 0 2   0 0     0   0   5 6                 11
1729729 ID     school 1602160 433   MIDVALE DISTRICT 160216000857 286 MIDVALE SCHOOL   Regular School No Other PK 12.0 2017   grade_2 7 0 2   0 0     0   0   7 2             *         9 7 0 2   0 0     0   0   7 2                 9
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
1725617 ID     school 1600360 1   BOISE INDEPENDENT DISTRICT 160036000591 288 SHADOW HILLS ELEMENTARY   Regular School No Elementary PK 6.0 2017   grade_2 78 2 8   0 0     0   5   48 45             33         93 78 2 8   0 0     0   5   48 45         33       93
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
1728051 ID     school 1601110 215   FREMONT COUNTY JOINT DISTRICT 160111000622 290 HENRYS FORK ELEMENTARY   Regular School No Elementary PK 5.0 2017   grade_2 70 0 22   0 1     0   0   46 47             64         93 70 0 22   0 1     0   0   46 47         64       93
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
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
1728358 ID     school 1601590 261   JEROME JOINT DISTRICT 160159000289 297 JEROME ACADEMY   Special Education School No Other 01 12.0 2017   grade_2 0 0 1   0 0     0   0   1 0             *         1 0 0 1   0 0     0   0   1 0                 1
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
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
1725649 ID     school 1600360 1   BOISE INDEPENDENT DISTRICT 160036000053 303 GARFIELD ELEMENTARY SCHOOL   Regular School No Elementary PK 6.0 2017   grade_2 38 4 15   1 3     0   0   23 38             *         61 38 4 15   1 3     0   0   23 38                 61
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
1725665 ID     school 1600360 1   BOISE INDEPENDENT DISTRICT 160036000078 306 WHITNEY ELEMENTARY SCHOOL   Regular School No Elementary PK 6.0 2017   grade_2 55 4 23   0 1     0   2   41 44             *         85 55 4 23   0 1     0   2   41 44                 85
1725673 ID     school 1600360 1   BOISE INDEPENDENT DISTRICT 160036000056 307 HILLCREST ELEMENTARY SCHOOL   Regular School No Elementary PK 6.0 2017   grade_2 27 3 11   1 3     0   1   27 19             *         46 27 3 11   1 3     0   1   27 19                 46
1725681 ID     school 1600360 1   BOISE INDEPENDENT DISTRICT 160036000054 308 HAWTHORNE ELEMENTARY SCHOOL   Regular School No Elementary PK 6.0 2017   grade_2 27 2 7   0 0     0   6   31 11             *         42 27 2 7   0 0     0   6   31 11                 42
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
1725729 ID     school 1600360 1   BOISE INDEPENDENT DISTRICT 160036000059 317 JEFFERSON ELEMENTARY SCHOOL   Regular School No Elementary PK 6.0 2017   grade_2 26 9 6   2 5     0   2   30 20             *         50 26 9 6   2 5     0   2   30 20                 50
1725737 ID     school 1600360 1   BOISE INDEPENDENT DISTRICT 160036000063 319 LOWELL ELEMENTARY SCHOOL   Regular School No Elementary PK 6.0 2017   grade_2 46 3 3   0 0     0   1   25 28             *         53 46 3 3   0 0     0   1   25 28                 53
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
1725753 ID     school 1600360 1   BOISE INDEPENDENT DISTRICT 160036000074 321 TAFT ELEMENTARY SCHOOL   Regular School No Elementary PK 6.0 2017   grade_2 25 14 8   0 5     2   2   31 25             *         56 25 14 8   0 5     2   2   31 25                 56
1725761 ID     school 1600360 1   BOISE INDEPENDENT DISTRICT 160036000068 322 MOUNTAIN VIEW ELEMENTARY SCHOOL   Regular School No Elementary PK 6.0 2017   grade_2 34 3 6   0 0     0   0   16 27             *         43 34 3 6   0 0     0   0   16 27                 43
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
1725785 ID     school 1600360 1   BOISE INDEPENDENT DISTRICT 160036000060 325 KOELSCH ELEMENTARY SCHOOL   Regular School No Elementary PK 6.0 2017   grade_2 42 5 12   1 2     1   2   23 42             *         65 42 5 12   1 2     1   2   23 42                 65
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
1725801 ID     school 1600360 1   BOISE INDEPENDENT DISTRICT 160036000079 327 WHITTIER ELEMENTARY SCHOOL   Regular School No Elementary PK 6.0 2017   grade_2 45 8 23   1 1     1   2   46 35             *         81 45 8 23   1 1     1   2   46 35                 81
1725964 ID     school 1602100 2   JOINT SCHOOL DISTRICT NO. 2 160210000637 328 FRONTIER ELEMENTARY SCHOOL   Regular School No Elementary PK 5.0 2017   grade_2 35 2 5   1 3     0   1   28 19             *         47 35 2 5   1 3     0   1   28 19                 47
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
1725978 ID     school 1602100 2   JOINT SCHOOL DISTRICT NO. 2 160210000640 330 SILVER SAGE ELEMENTARY SCHOOL   Regular School No Elementary PK 5.0 2017   grade_2 49 1 9   1 0     0   1   26 35             19         61 49 1 9   1 0     0   1   26 35         19       61
1725985 ID     school 1602100 2   JOINT SCHOOL DISTRICT NO. 2 160210000365 331 LAKE HAZEL ELEMENTARY SCHOOL   Regular School No Elementary PK 5.0 2017   grade_2 69 1 5   0 1     1   4   49 32             31         81 69 1 5   0 1     1   4   49 32         31       81
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
1726006 ID     school 1602100 2   JOINT SCHOOL DISTRICT NO. 2 160210000373 334 STAR ELEMENTARY SCHOOL   Regular School No Elementary PK 5.0 2017   grade_2 66 2 9   0 0     0   3   41 39             31         80 66 2 9   0 0     0   3   41 39         31       80
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
1726020 ID     school 1602100 2   JOINT SCHOOL DISTRICT NO. 2 160210000371 336 MERIDIAN ELEMENTARY SCHOOL   Regular School No Elementary PK 5.0 2017   grade_2 42 2 16   0 1     1   3   36 29             *         65 42 2 16   0 1     1   3   36 29                 65
1726027 ID     school 1602100 2   JOINT SCHOOL DISTRICT NO. 2 160210000363 337 McMillan Elementary   Regular School No Elementary PK 5.0 2017   grade_2 29 7 13   1 6     0   3   33 26             32         59 29 7 13   1 6     0   3   33 26         32       59
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
1726042 ID     school 1602100 2   JOINT SCHOOL DISTRICT NO. 2 160210000639 339 BARBARA MORGAN STEM ACADEMY   Regular School No Elementary KG 5.0 2017   grade_2 48 1 18   1 0     0   3   30 41             28         71 48 1 18   1 0     0   3   30 41         28       71
1726049 ID     school 1602100 2   JOINT SCHOOL DISTRICT NO. 2 160210000624 340 EAGLE HILLS ELEMENTARY SCHOOL   Regular School No Elementary PK 5.0 2017   grade_2 79 1 12   0 0     0   5   48 49             23         97 79 1 12   0 0     0   5   48 49         23       97
1726056 ID     school 1602100 2   JOINT SCHOOL DISTRICT NO. 2 160210000368 341 MARY MCPHERSON ELEMENTARY   Regular School No Elementary PK 5.0 2017   grade_2 55 2 7   0 3     1   6   38 36             18         74 55 2 7   0 3     1   6   38 36         18       74
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
1726063 ID     school 1602100 2   JOINT SCHOOL DISTRICT NO. 2 160210000598 343 JOPLIN ELEMENTARY SCHOOL   Regular School No Elementary PK 5.0 2017   grade_2 47 2 8   0 2     0   3   39 23             15         62 47 2 8   0 2     0   3   39 23         15       62
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
1726316 ID     school 1600840 13   COUNCIL DISTRICT 160084000162 348 COUNCIL ELEMENTARY SCHOOL   Regular School No Elementary PK 6.0 2017   grade_2 20 1 0   0 0     0   0   12 9             10         21 20 1 0   0 0     0   0   12 9         10       21
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
1726356 ID     school 1601950 21   MARSH VALLEY JOINT DISTRICT 160195000349 352 MOUNTAIN VIEW ELEMENTARY SCHOOL   Regular School No Elementary PK 6.0 2017   grade_2 32 1 3   0 0     0   0   18 18             15         36 32 1 3   0 0     0   0   18 18         15       36
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
1726397 ID     school 1602640 25   POCATELLO DISTRICT 160264000470 354 GREENACRES ELEMENTARY SCHOOL   Regular School No Elementary KG 5.0 2017   grade_2 46 1 8   1 0     0   6   36 26             43         62 46 1 8   1 0     0   6   36 26         43       62
1726404 ID     school 1602640 25   POCATELLO DISTRICT 160264000473 355 INDIAN HILLS ELEMENTARY SCHOOL   Regular School No Elementary KG 5.0 2017   grade_2 72 1 13   2 3     0   5   43 53             53         96 72 1 13   2 3     0   5   43 53         53       96
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
1726453 ID     school 1602640 25   POCATELLO DISTRICT 160264000465 362 CLAUDE A WILCOX ELEMENTARY SCHOOL   Regular School No Elementary PK 6.0 2017   grade_2 61 1 15   5 0     0   2   36 48             63         84 61 1 15   5 0     0   2   36 48         63       84
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
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

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