Data source: Big Local News · About: Big Local

400 rows where grade = "grade_2", state = "ID" and year = 2019 sorted by district_state_id

View and edit SQL

year

  • 2019 · 400

grade

  • grade_2 · 400
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
1305015 ID     school 1600360 1   BOISE INDEPENDENT DISTRICT 160036000590 287 TRAIL WIND ELEMENTARY   Regular School No Elementary PK 6.0 2019   grade_2 66 1 2   0 9     0   6   46 38             12         84 66 1 2   0 9     0   6   46 38         12       84
1305023 ID     school 1600360 1   BOISE INDEPENDENT DISTRICT 160036000591 288 SHADOW HILLS ELEMENTARY   Regular School No Elementary PK 6.0 2019   grade_2 45 3 8   1 1     0   4   31 31             17         62 45 3 8   1 1     0   4   31 31         17       62
1305031 ID     school 1600360 1   BOISE INDEPENDENT DISTRICT 160036000592 300 AMITY ELEMENTARY SCHOOL   Regular School No Elementary PK 6.0 2019   grade_2 63 1 7   1 1     0   2   36 39             18         75 63 1 7   1 1     0   2   36 39         18       75
1305039 ID     school 1600360 1   BOISE INDEPENDENT DISTRICT 160036000065 301 MAPLE GROVE ELEMENTARY SCHOOL   Regular School No Elementary PK 6.0 2019   grade_2 47 0 0   0 2     0   4   25 28             18         53 47 0 0   0 2     0   4   25 28         18       53
1305047 ID     school 1600360 1   BOISE INDEPENDENT DISTRICT 160036000055 302 HIGHLANDS ELEMENTARY SCHOOL   Regular School No Elementary PK 6.0 2019   grade_2 45 0 1   0 0     0   0   31 15             *         46 45 0 1   0 0     0   0   31 15                 46
1305055 ID     school 1600360 1   BOISE INDEPENDENT DISTRICT 160036000053 303 GARFIELD ELEMENTARY SCHOOL   Regular School No Elementary PK 6.0 2019   grade_2 35 1 5   0 4     1   5   28 23             28         51 35 1 5   0 4     1   5   28 23         28       51
1305063 ID     school 1600360 1   BOISE INDEPENDENT DISTRICT 160036000076 305 WASHINGTON ELEMENTARY SCHOOL   Regular School No Elementary PK 6.0 2019   grade_2 35 0 1   0 0     0   1   19 18             *         37 35 0 1   0 0     0   1   19 18                 37
1305071 ID     school 1600360 1   BOISE INDEPENDENT DISTRICT 160036000078 306 WHITNEY ELEMENTARY SCHOOL   Regular School No Elementary PK 6.0 2019   grade_2 40 5 24   0 0     0   2   33 38             35         71 40 5 24   0 0     0   2   33 38         35       71
1305079 ID     school 1600360 1   BOISE INDEPENDENT DISTRICT 160036000056 307 HILLCREST ELEMENTARY SCHOOL   Regular School No Elementary PK 6.0 2019   grade_2 33 6 6   1 2     0   2   28 22             22         50 33 6 6   1 2     0   2   28 22         22       50
1305087 ID     school 1600360 1   BOISE INDEPENDENT DISTRICT 160036000054 308 HAWTHORNE ELEMENTARY SCHOOL   Regular School No Elementary PK 6.0 2019   grade_2 34 1 4   0 1     0   3   24 19             18         43 34 1 4   0 1     0   3   24 19         18       43
1305095 ID     school 1600360 1   BOISE INDEPENDENT DISTRICT 160036000072 309 ROOSEVELT ELEMENTARY SCHOOL   Regular School No Elementary PK 6.0 2019   grade_2 35 0 1   1 0     0   2   21 18             10         39 35 0 1   1 0     0   2   21 18         10       39
1305103 ID     school 1600360 1   BOISE INDEPENDENT DISTRICT 160036000071 310 PIERCE PARK ELEMENTARY SCHOOL   Regular School No Elementary PK 6.0 2019   grade_2 36 0 5   0 1     0   1   18 25             9         43 36 0 5   0 1     0   1   18 25         9       43
1305111 ID     school 1600360 1   BOISE INDEPENDENT DISTRICT 160036000070 313 OWYHEE ELEMENTARY SCHOOL   Regular School No Elementary PK 6.0 2019   grade_2 21 0 4   1 1     0   2   13 16             15         29 21 0 4   1 1     0   2   13 16         15       29
1305119 ID     school 1600360 1   BOISE INDEPENDENT DISTRICT 160036000042 315 ADAMS ELEMENTARY SCHOOL   Regular School No Elementary PK 6.0 2019   grade_2 41 0 4   0 0     0   2   26 21             7         47 41 0 4   0 0     0   2   26 21         7       47
1305127 ID     school 1600360 1   BOISE INDEPENDENT DISTRICT 160036000650 316 LIBERTY ELEMENTARY SCHOOL   Regular School No Elementary PK 6.0 2019   grade_2 61 0 4   0 0     0   4   34 35             7         69 61 0 4   0 0     0   4   34 35         7       69
1305135 ID     school 1600360 1   BOISE INDEPENDENT DISTRICT 160036000059 317 JEFFERSON ELEMENTARY SCHOOL   Regular School No Elementary PK 6.0 2019   grade_2 19 9 2   0 3     0   1   18 16             13         34 19 9 2   0 3     0   1   18 16         13       34
1305143 ID     school 1600360 1   BOISE INDEPENDENT DISTRICT 160036000063 319 LOWELL ELEMENTARY SCHOOL   Regular School No Elementary PK 6.0 2019   grade_2 26 3 9   0 1     0   0   20 19             9         39 26 3 9   0 1     0   0   20 19         9       39
1305151 ID     school 1600360 1   BOISE INDEPENDENT DISTRICT 160036000075 320 VALLEY VIEW ELEMENTARY SCHOOL   Regular School No Elementary PK 6.0 2019   grade_2 43 1 10   1 2     0   5   32 30             16         62 43 1 10   1 2     0   5   32 30         16       62
1305159 ID     school 1600360 1   BOISE INDEPENDENT DISTRICT 160036000074 321 TAFT ELEMENTARY SCHOOL   Regular School No Elementary PK 6.0 2019   grade_2 23 13 6   0 2     0   2   19 27             27         46 23 13 6   0 2     0   2   19 27         27       46
1305167 ID     school 1600360 1   BOISE INDEPENDENT DISTRICT 160036000068 322 MOUNTAIN VIEW ELEMENTARY SCHOOL   Regular School No Elementary PK 6.0 2019   grade_2 35 0 3   0 1     0   1   27 13             11         40 35 0 3   0 1     0   1   27 13         11       40
1305175 ID     school 1600360 1   BOISE INDEPENDENT DISTRICT 160036000062 323 LONGFELLOW ELEMENTARY SCHOOL   Regular School No Elementary PK 6.0 2019   grade_2 42 1 3   0 1     1   0   25 23             *         48 42 1 3   0 1     1   0   25 23                 48
1305183 ID     school 1600360 1   BOISE INDEPENDENT DISTRICT 160036000067 324 MONROE ELEMENTARY SCHOOL   Regular School No Elementary PK 6.0 2019   grade_2 28 0 6   0 0     1   2   18 19             14         37 28 0 6   0 0     1   2   18 19         14       37
1305191 ID     school 1600360 1   BOISE INDEPENDENT DISTRICT 160036000060 325 KOELSCH ELEMENTARY SCHOOL   Regular School No Elementary PK 6.0 2019   grade_2 24 6 8   1 2     0   5   24 22             21         46 24 6 8   1 2     0   5   24 22         21       46
1305199 ID     school 1600360 1   BOISE INDEPENDENT DISTRICT 160036000049 326 COLLISTER ELEMENTARY SCHOOL   Regular School No Elementary PK 6.0 2019   grade_2 26 0 2   0 2     0   1   15 16             *         31 26 0 2   0 2     0   1   15 16                 31
1305207 ID     school 1600360 1   BOISE INDEPENDENT DISTRICT 160036000079 327 WHITTIER ELEMENTARY SCHOOL   Regular School No Elementary PK 6.0 2019   grade_2 32 3 25   1 2     1   0   25 39             19         64 32 3 25   1 2     1   0   25 39         19       64
1305215 ID     school 1600360 1   BOISE INDEPENDENT DISTRICT 160036000004 509 RIVERSIDE ELEMENTARY SCHOOL   Regular School No Elementary PK 6.0 2019   grade_2 69 2 4   0 8     0   4   54 33             6         87 69 2 4   0 8     0   4   54 33         6       87
1305223 ID     school 1600360 1   BOISE INDEPENDENT DISTRICT 160036000009 510 HORIZON ELEMENTARY SCHOOL   Regular School No Elementary PK 6.0 2019   grade_2 48 1 25   1 2     0   2   39 40             30         79 48 1 25   1 2     0   2   39 40         30       79
1305239 ID     school 1600360 1   BOISE INDEPENDENT DISTRICT 160036000707 665 CYNTHIA MANN ELEMENTARY SCHOOL   Regular School No Elementary PK 6.0 2019   grade_2 43 1 2   1 0     0   3   27 23             9         50 43 1 2   1 0     0   3   27 23         9       50
1305247 ID     school 1600360 1   BOISE INDEPENDENT DISTRICT 160036000706 666 WHITE PINE ELEMENTARY SCHOOL   Regular School No Elementary PK 6.0 2019   grade_2 55 3 7   1 14     1   1   47 35             23         82 55 3 7   1 14     1   1   47 35         23       82
1305255 ID     school 1600360 1   BOISE INDEPENDENT DISTRICT 160036000980 673 MORLEY NELSON ELEMENTARY   Regular School No Elementary PK 6.0 2019   grade_2 37 11 24   1 2     1   3   41 38             34         79 37 11 24   1 2     1   3   41 38         34       79
1305263 ID     school 1600360 1   BOISE INDEPENDENT DISTRICT 160036000982 674 GRACE JORDAN ELEMENTARY   Regular School No Elementary PK 6.0 2019   grade_2 39 5 15   0 2     0   3   36 28             29         64 39 5 15   0 2     0   3   36 28         29       64
1305286 ID     school 1600360 1   BOISE INDEPENDENT DISTRICT 160036001004 679 HIDDEN SPRINGS ELEMENTARY SCHOOL   Regular School No Elementary PK 6.0 2019   grade_2 43 2 1   0 0     0   1   26 21             *         47 43 2 1   0 0     0   1   26 21                 47
1306631 ID     school 1600420 101   BOUNDARY COUNTY DISTRICT 160042000092 433 NAPLES ELEMENTARY SCHOOL   Regular School No Elementary KG 5.0 2019   grade_2 18 0 2   1 0     0   0   9 12             10         21 18 0 2   1 0     0   0   9 12         10       21
1306638 ID     school 1600420 101   BOUNDARY COUNTY DISTRICT 160042000091 434 MOUNT HALL ELEMENTARY SCHOOL   Regular School No Elementary KG 5.0 2019   grade_2 24 1 0   0 0     0   1   11 15             15         26 24 1 0   0 0     0   1   11 15         15       26
1306645 ID     school 1600420 101   BOUNDARY COUNTY DISTRICT 160042000094 437 VALLEY VIEW ELEMENTARY SCHOOL   Regular School No Elementary PK 5.0 2019   grade_2 48 0 7   1 0     0   1   31 26             36         57 48 0 7   1 0     0   1   31 26         36       57
1305694 ID     school 1602060 11   MEADOWS VALLEY DISTRICT 160206000826 342 MEADOWS VALLEY SCHOOL   Regular School No Other PK 12.0 2019   grade_2 7 0 0   0 0     0   0   5 2             *         7 7 0 0   0 0     0   0   5 2                 7
1306660 ID     school 1600490 111   BUTTE COUNTY JOINT DISTRICT 160049000011 438 HOWE ELEMENTARY SCHOOL   Regular School No Elementary PK 5.0 2019   grade_2 3 0 0   0 0     0   0   2 1             *         3 3 0 0   0 0     0   0   2 1                 3
1306666 ID     school 1600490 111   BUTTE COUNTY JOINT DISTRICT 160049000007 439 ARCO ELEMENTARY SCHOOL   Regular School No Elementary PK 5.0 2019   grade_2 23 0 0   1 0     0   2   13 13             *         26 23 0 0   1 0     0   2   13 13                 26
1306678 ID     school 1600540 121   CAMAS COUNTY DISTRICT 160054000110 440 CAMAS COUNTY ELEM/JR HIGH SCHOOL   Regular School No Elementary PK 8.0 2019   grade_2 16 0 0   0 0     0   0   7 9             8         16 16 0 0   0 0     0   0   7 9         8       16
1305712 ID     school 1600840 13   COUNCIL DISTRICT 160084000162 348 COUNCIL ELEMENTARY SCHOOL   Regular School No Elementary PK 6.0 2019   grade_2 18 1 1   0 0     0   0   16 4             12         20 18 1 1   0 0     0   0   16 4         12       20
1306696 ID     school 1602340 131   NAMPA SCHOOL DISTRICT 160234000375 213 IOWA ELEMENTARY   Regular School No Elementary PK 5.0 2019   grade_2 37 1 35   0 2     2   1   38 40             50         78 37 1 35   0 2     2   1   38 40         50       78
1306703 ID     school 1602340 131   NAMPA SCHOOL DISTRICT 160234000379 214 SHERMAN ELEMENTARY   Regular School No Elementary PK 5.0 2019   grade_2 29 2 27   0 1     1   1   29 32             *         61 29 2 27   0 1     1   1   29 32                 61
1306710 ID     school 1602340 131   NAMPA SCHOOL DISTRICT 160234000383 215 PARK RIDGE ELEMENTARY   Regular School No Elementary PK 5.0 2019   grade_2 28 0 22   0 1     0   3   23 31             39         54 28 0 22   0 1     0   3   23 31         39       54
1306717 ID     school 1602340 131   NAMPA SCHOOL DISTRICT 160234000409 444 CENTENNIAL ELEMENTARY SCHOOL   Regular School No Elementary PK 5.0 2019   grade_2 46 0 34   0 0     2   5   45 42             67         87 46 0 34   0 0     2   5   45 42         67       87
1306724 ID     school 1602340 131   NAMPA SCHOOL DISTRICT 160234000410 447 CENTRAL ELEMENTARY   Regular School No Elementary PK 5.0 2019   grade_2 26 0 32   0 0     0   5   38 25             *         63 26 0 32   0 0     0   5   38 25                 63
1306731 ID     school 1602340 131   NAMPA SCHOOL DISTRICT 160234000677 450 GREENHURST ELEMENTARY SCHOOL   Regular School No Elementary PK 5.0 2019   grade_2 36 1 12   0 0     0   3   26 26             35         52 36 1 12   0 0     0   3   26 26         35       52
1306738 ID     school 1602340 131   NAMPA SCHOOL DISTRICT 160234000774 527 OWYHEE ELEMENTARY SCHOOL   Regular School No Elementary PK 5.0 2019   grade_2 43 0 15   0 0     0   4   33 29             21         62 43 0 15   0 0     0   4   33 29         21       62
1306745 ID     school 1602340 131   NAMPA SCHOOL DISTRICT 160234000775 528 REAGAN ELEMENTARY SCHOOL   Regular School No Elementary PK 5.0 2019   grade_2 56 0 20   0 0     1   6   44 39             44         83 56 0 20   0 0     1   6   44 39         44       83
1306752 ID     school 1602340 131   NAMPA SCHOOL DISTRICT 160234000773 529 ROOSEVELT ELEMENTARY SCHOOL   Regular School No Elementary PK 5.0 2019   grade_2 51 0 23   0 0     0   7   40 41             48         81 51 0 23   0 0     0   7   40 41         48       81
1306759 ID     school 1602340 131   NAMPA SCHOOL DISTRICT 160234000833 581 WILLOW CREEK ELEMENTARY   Regular School No Elementary PK 5.0 2019   grade_2 48 0 40   0 3     2   5   52 46             75         98 48 0 40   0 3     2   5   52 46         75       98
1306771 ID     school 1602340 131   NAMPA SCHOOL DISTRICT 160234000986 647 LAKE RIDGE ELEMENTARY   Regular School No Elementary PK 5.0 2019   grade_2 73 0 25   1 0     0   1   59 41             41         100 73 0 25   1 0     0   1   59 41         41       100
1306782 ID     school 1602340 131   NAMPA SCHOOL DISTRICT 160234000947 890 ENDEAVOR ELEMENTARY SCHOOL   Regular School No Elementary PK 5.0 2019   grade_2 28 1 44   1 0     1   1   47 29             65         76 28 1 44   1 0     1   1   47 29         65       76
1306794 ID     school 1602340 131   NAMPA SCHOOL DISTRICT 160234000507 996 SNAKE RIVER ELEMENTARY   Regular School No Elementary PK 5.0 2019   grade_2 21 0 35   0 1     1   2   32 28             49         60 21 0 35   0 1     1   2   32 28         49       60
1306818 ID     school 1602340 131   NAMPA SCHOOL DISTRICT 160234000941 2889 NEW HORIZON MAGNET SCHOOL   Regular School No Elementary PK 5.0 2019   grade_2 16 1 67   0 1     0   1   41 45             52         86 16 1 67   0 1     0   1   41 45         52       86
1306834 ID     school 1600510 132   CALDWELL DISTRICT 160051000835 76 LEWIS AND CLARK ELEMENTARY   Regular School No Elementary PK 5.0 2019   grade_2 23 0 34   2 0     1   3   27 36             30         63 23 0 34   2 0     1   3   27 36         30       63
1306845 ID     school 1600510 132   CALDWELL DISTRICT 160051000609 289 WILSON ELEMENTARY SCHOOL   Regular School No Elementary PK 5.0 2019   grade_2 43 0 36   1 1     0   5   47 39             31         86 43 0 36   1 1     0   5   47 39         31       86
1306852 ID     school 1600510 132   CALDWELL DISTRICT 160051000108 448 WASHINGTON ELEMENTARY SCHOOL   Regular School No Elementary PK 5.0 2019   grade_2 34 0 59   0 0     1   3   59 38             48         97 34 0 59   0 0     1   3   59 38         48       97
1306859 ID     school 1600510 132   CALDWELL DISTRICT 160051000106 449 LINCOLN ELEMENTARY SCHOOL   Regular School No Elementary PK 5.0 2019   grade_2 33 1 31   0 0     1   1   34 33             41         67 33 1 31   0 0     1   1   34 33         41       67
1306866 ID     school 1600510 132   CALDWELL DISTRICT 160051000107 451 VAN BUREN ELEMENTARY SCHOOL   Regular School No Elementary KG 5.0 2019   grade_2 24 0 60   0 0     0   2   43 43             43         86 24 0 60   0 0     0   2   43 43         43       86
1306873 ID     school 1600510 132   CALDWELL DISTRICT 160051000731 457 SACAJAWEA ELEMENTARY SCHOOL   Regular School No Elementary PK 5.0 2019   grade_2 26 0 50   0 0     0   3   39 40             43         79 26 0 50   0 0     0   3   39 40         43       79
1306898 ID     school 1603480 133   WILDER DISTRICT 160348000585 452 WILDER ELEMENTARY SCHOOL   Regular School No Elementary PK 6.0 2019   grade_2 14 0 27   0 0     0   0   19 22             *         41 14 0 27   0 0     0   0   19 22                 41
1306918 ID     school 1602130 134   MIDDLETON DISTRICT 160213000376 453 MIDDLETON MILL CREEK ELEMENTARY   Regular School No Elementary PK 5.0 2019   grade_2 97 1 10   0 0     0   1   55 54             32         109 97 1 10   0 0     0   1   55 54         32       109
1306925 ID     school 1602130 134   MIDDLETON DISTRICT 160213000675 500 MIDDLETON HEIGHTS ELEMENTARY   Regular School No Elementary PK 5.0 2019   grade_2 83 1 14   0 0     0   2   47 53             44         100 83 1 14   0 0     0   2   47 53         44       100
1306932 ID     school 1602130 134   MIDDLETON DISTRICT 160213000812 546 PURPLE SAGE ELEMENTARY   Regular School No Elementary PK 5.0 2019   grade_2 54 0 14   1 0     0   2   36 35             31         71 54 0 14   1 0     0   2   36 35         31       71
1306951 ID     school 1602460 135   NOTUS DISTRICT 160246000430 520 NOTUS ELEMENTARY SCHOOL   Regular School No Elementary PK 6.0 2019   grade_2 23 0 8   0 0     0   1   13 19             21         32 23 0 8   0 0     0   1   13 19         21       32
1306966 ID     school 1602070 136   MELBA JOINT DISTRICT 160207000359 455 MELBA ELEMENTARY SCHOOL   Regular School No Elementary PK 6.0 2019   grade_2 40 0 14   0 0     0   0   30 24             22         54 40 0 14   0 0     0   0   30 24         22       54
1306984 ID     school 1602550 137   PARMA DISTRICT 160255000449 456 MAXINE JOHNSON ELEMENTARY   Regular School No Elementary PK 4.0 2019   grade_2 43 0 24   0 0     0   3   37 33             40         70 43 0 24   0 0     0   3   37 33         40       70
1306995 ID     school 1600600 139   VALLIVUE SCHOOL DISTRICT 160060000115 460 EAST CANYON ELEMENTARY SCHOOL   Regular School No Elementary PK 5.0 2019   grade_2 49 0 33   0 0     0   1   46 37             50         83 49 0 33   0 0     0   1   46 37         50       83
1307002 ID     school 1600600 139   VALLIVUE SCHOOL DISTRICT 160060000119 461 WEST CANYON ELEMENTARY SCHOOL   Regular School No Elementary PK 5.0 2019   grade_2 49 0 26   0 0     0   2   38 39             37         77 49 0 26   0 0     0   2   38 39         37       77
1307009 ID     school 1600600 139   VALLIVUE SCHOOL DISTRICT 160060000083 505 CENTRAL CANYON ELEMENTARY SCHOOL   Regular School No Elementary PK 5.0 2019   grade_2 39 0 45   0 0     0   0   37 47             58         84 39 0 45   0 0     0   0   37 47         58       84
1307016 ID     school 1600600 139   VALLIVUE SCHOOL DISTRICT 160060000778 519 BIRCH ELEMENTARY SCHOOL   Regular School No Elementary PK 5.0 2019   grade_2 82 3 22   0 0     1   5   60 53             53         113 82 3 22   0 0     1   5   60 53         53       113
1307027 ID     school 1600600 139   VALLIVUE SCHOOL DISTRICT 160060000976 646 LAKEVUE ELEMENTARY SCHOOL   Regular School No Elementary PK 5.0 2019   grade_2 59 2 40   0 0     0   3   49 55             59         104 59 2 40   0 0     0   3   49 55         59       104
1307034 ID     school 1600600 139   VALLIVUE SCHOOL DISTRICT 160060000935 892 DESERT SPRINGS ELEMENTARY SCHOOL   Regular School No Elementary PK 5.0 2019   grade_2 63 0 37   0 1     0   5   41 65             62         106 63 0 37   0 1     0   5   41 65         62       106
1307054 ID     school 1600600 139   VALLIVUE SCHOOL DISTRICT 160060001092 1397 SKYWAY ELEMENTARY   Regular School No Elementary KG 5.0 2019   grade_2 70 0 65   1 0     0   0   64 72             82         136 70 0 65   1 0     0   0   64 72         82       136
1307073 ID     school 1601290 148   GRACE JOINT DISTRICT 160129000228 462 THATCHER ELEMENTARY SCHOOL   Regular School No Elementary 01 5.0 2019   grade_2 16 0 1   0 0     0   0   11 6             *         17 16 0 1   0 0     0   0   11 6                 17
1307079 ID     school 1601290 148   GRACE JOINT DISTRICT 160129000225 463 GRACE ELEMENTARY SCHOOL   Regular School No Elementary PK 6.0 2019   grade_2 18 0 1   0 0     0   0   8 11             *         19 18 0 1   0 0     0   0   8 11                 19
1307092 ID     school 1602430 149   NORTH GEM DISTRICT 160243000427 464 NORTH GEM ELEMENTARY   Regular School No Elementary PK 6.0 2019   grade_2 7 0 0   0 0     0   0   4 3             *         7 7 0 0   0 0     0   0   4 3                 7
1307113 ID     school 1603000 150   SODA SPRINGS JOINT DISTRICT 160300000525 466 HOWARD E THIRKILL PRIMARY SCHOOL   Regular School No Elementary PK 4.0 2019   grade_2 73 0 3   0 0     0   2   44 34             *         78 73 0 3   0 0     0   2   44 34                 78
1307119 ID     school   150   SODA SPRINGS JOINT DISTRICT   1025 BORDER DISTRICT - FREEDOM ELEMENTARY             2019   grade_2 2 0 0   0 0     0   0   0 2             *         2 2 0 0   0 0     0   0   0 2                 2
1307160 ID     school 1600660 151   CASSIA COUNTY JOINT DISTRICT 160066000387 216 WHITE PINE ELEMENTARY   Regular School No Elementary KG 6.0 2019   grade_2 48 0 25   1 0     0   3   40 37             41         77 48 0 25   1 0     0   3   40 37         41       77
1307172 ID     school 1600660 151   CASSIA COUNTY JOINT DISTRICT 160066000123 468 ALMO ELEMENTARY SCHOOL   Regular School No Elementary PK 6.0 2019   grade_2 3 0 0   0 0     0   0   3 0             *         3 3 0 0   0 0     0   0   3 0                 3
1307177 ID     school 1600660 151   CASSIA COUNTY JOINT DISTRICT 160066000126 469 DECLO ELEMENTARY SCHOOL   Regular School No Elementary PK 5.0 2019   grade_2 55 1 16   0 0     0   0   39 33             34         72 55 1 16   0 0     0   0   39 33         34       72
1307184 ID     school 1600660 151   CASSIA COUNTY JOINT DISTRICT 160066000130 470 MOUNTAIN VIEW ELEMENTARY   Regular School No Elementary KG 6.0 2019   grade_2 37 0 25   0 0     0   0   32 30             38         62 37 0 25   0 0     0   0   32 30         38       62
1307192 ID     school 1600660 151   CASSIA COUNTY JOINT DISTRICT 160066000129 471 RAFT RIVER ELEMENTARY SCHOOL   Regular School No Elementary PK 6.0 2019   grade_2 14 0 5   0 0     0   0   8 11             12         19 14 0 5   0 0     0   0   8 11         12       19
1307200 ID     school 1600660 151   CASSIA COUNTY JOINT DISTRICT 160066000131 473 OAKLEY ELEMENTARY SCHOOL   Regular School No Elementary PK 6.0 2019   grade_2 24 0 11   0 0     0   0   20 15             15         35 24 0 11   0 0     0   0   20 15         15       35
1307208 ID     school 1600660 151   CASSIA COUNTY JOINT DISTRICT 160066000128 474 DWORSHAK ELEMENTARY SCHOOL   Regular School No Elementary KG 6.0 2019   grade_2 33 0 29   0 0     0   0   28 34             38         62 33 0 29   0 0     0   0   28 34         38       62
1307216 ID     school 1600660 151   CASSIA COUNTY JOINT DISTRICT 160066000122 475 ALBION ELEMENTARY SCHOOL   Regular School No Elementary PK 5.0 2019   grade_2 8 0 0   0 0     0   0   5 3             *         8 8 0 0   0 0     0   0   5 3                 8
1307230 ID     school 1600660 151   CASSIA COUNTY JOINT DISTRICT 160066001088 1395 JOHN V EVANS ELEMENTARY   Regular School No Elementary KG 6.0 2019   grade_2 43 2 29   1 0     0   0   37 38             44         75 43 2 29   1 0     0   0   37 38         44       75
1307246 ID     school 1600750 161   CLARK COUNTY DISTRICT 160075000145 478 LINDY ROSS ELEMENTARY SCHOOL   Regular School No Elementary PK 8.0 2019   grade_2 1 0 4   0 0     0   0   4 1             *         5 1 0 4   0 0     0   0   4 1                 5
1307268 ID     school 1602520 171   OROFINO JOINT DISTRICT 160252000439 479 OROFINO ELEMENTARY SCHOOL   Regular School No Elementary PK 6.0 2019   grade_2 51 0 6   1 1     0   0   28 31             34         59 51 0 6   1 1     0   0   28 31         34       59
1307276 ID     school 1602520 171   OROFINO JOINT DISTRICT 160252000436 481 CAVENDISH-TEAKEAN ELEMENTARY SCHOOL   Regular School No Elementary PK 6.0 2019   grade_2 2 0 0   0 0     0   1   1 2             *         3 2 0 0   0 0     0   1   1 2                 3
1307284 ID     school 1602520 171   OROFINO JOINT DISTRICT 160252000442 482 PECK ELEMENTARY SCHOOL   Regular School No Elementary PK 6.0 2019   grade_2 4 0 1   0 0     0   0   3 2             *         5 4 0 1   0 0     0   0   3 2                 5
1307297 ID     school 1602520 171   OROFINO JOINT DISTRICT 160252000983 2520 TIMBERLINE ELEMENTARY   Regular School No Elementary PK 5.0 2019   grade_2 15 0 0   0 0     0   0   8 7             *         15 15 0 0   0 0     0   0   8 7                 15
1307311 ID     school 1600720 181   CHALLIS JOINT DISTRICT 160072000143 486 STANLEY ELEM/JR HIGH SCHOOL   Regular School No Elementary KG 8.0 2019   grade_2 2 0 0   0 0     0   0   0 2             *         2 2 0 0   0 0     0   0   0 2                 2
1307319 ID     school 1600720 181   CHALLIS JOINT DISTRICT 160072000139 489 CHALLIS ELEMENTARY SCHOOL   Regular School No Elementary PK 6.0 2019   grade_2 24 0 1   0 0     0   0   11 14             *         25 24 0 1   0 0     0   0   11 14                 25
1307334 ID     school 1601900 182   MACKAY JOINT DISTRICT 160190000331 490 MACKAY ELEMENTARY SCHOOL   Regular School No Elementary PK 6.0 2019   grade_2 12 0 0   0 0     1   0   9 4             *         13 12 0 0   0 0     1   0   9 4                 13
1307354 ID     school 1601230 192   GLENNS FERRY JOINT DISTRICT 160123000219 492 GLENNS FERRY ELEMENTARY SCHOOL   Regular School No Elementary PK 5.0 2019   grade_2 22 0 7   0 0     0   0   19 10             23         29 22 0 7   0 0     0   0   19 10         23       29
1307369 ID     school 1602250 193   MOUNTAIN HOME DISTRICT 160225000403 493 WEST ELEMENTARY SCHOOL   Regular School No Elementary PK 4.0 2019   grade_2 53 0 28   0 2     0   3   44 42             53         86 53 0 28   0 2     0   3   44 42         53       86
1307375 ID     school 1602250 193   MOUNTAIN HOME DISTRICT 160225000396 494 EAST ELEMENTARY SCHOOL   Regular School No Elementary PK 4.0 2019   grade_2 65 2 18   0 0     0   2   52 35             52         87 65 2 18   0 0     0   2   52 35         52       87
1307381 ID     school 1602250 193   MOUNTAIN HOME DISTRICT 160225000402 495 NORTH ELEMENTARY SCHOOL   Regular School No Elementary PK 4.0 2019   grade_2 44 0 22   0 0     0   5   35 36             40         71 44 0 22   0 0     0   5   35 36         40       71

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