Data source: Big Local News · About: Big Local

33,441 rows where state = "ID" sorted by black_int

View and edit SQL

grade

year

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
1681586 ID     school 1600360 1   BOISE INDEPENDENT DISTRICT 160036000590 287 TRAIL WIND ELEMENTARY   Regular School No 1.0 PK 06 2015   grade_2 70 0 9   2 8     1   1   54 37             16         91 70 0 9   2 8     1   1   54 37         16       91
1681587 ID     school 1600360 1   BOISE INDEPENDENT DISTRICT 160036000590 287 TRAIL WIND ELEMENTARY   Regular School No 1.0 PK 06 2015   grade_3 72 0 8   0 8     0   0   45 43             18         88 72 0 8   0 8     0   0   45 43         18       88
1681590 ID     school 1600360 1   BOISE INDEPENDENT DISTRICT 160036000590 287 TRAIL WIND ELEMENTARY   Regular School No 1.0 PK 06 2015   grade_6 86 0 5   1 5     1   4   47 55             15         102 86 0 5   1 5     1   4   47 55         15       102
1681592 ID     school 1600360 1   BOISE INDEPENDENT DISTRICT 160036000590 287 TRAIL WIND ELEMENTARY   Regular School No 1.0 PK 06 2015   kindergarten 76 0 3   0 5     0   4   41 47             13         88 76 0 3   0 5     0   4   41 47         13       88
1681598 ID     school 1600360 1   BOISE INDEPENDENT DISTRICT 160036000591 288 SHADOW HILLS ELEMENTARY   Regular School No 1.0 PK 06 2015   grade_6 89 0 2   2 1     0   0   45 49             28         94 89 0 2   2 1     0   0   45 49         28       94
1681601 ID     school 1600360 1   BOISE INDEPENDENT DISTRICT 160036000592 300 AMITY ELEMENTARY SCHOOL   Regular School No 1.0 PK 06 2015   grade_1 74 0 8   0 2     0   4   48 40             27         88 74 0 8   0 2     0   4   48 40         27       88
1681605 ID     school 1600360 1   BOISE INDEPENDENT DISTRICT 160036000592 300 AMITY ELEMENTARY SCHOOL   Regular School No 1.0 PK 06 2015   grade_5 92 0 7   1 1     0   4   51 54             26         105 92 0 7   1 1     0   4   51 54         26       105
1681608 ID     school 1600360 1   BOISE INDEPENDENT DISTRICT 160036000592 300 AMITY ELEMENTARY SCHOOL   Regular School No 1.0 PK 06 2015   kindergarten 52 0 7   0 0     0   3   30 32             22         62 52 0 7   0 0     0   3   30 32         22       62
1681616 ID     school 1600360 1   BOISE INDEPENDENT DISTRICT 160036000065 301 MAPLE GROVE ELEMENTARY SCHOOL   Regular School No 1.0 PK 06 2015   kindergarten 62 0 6   0 0     0   2   36 34             16         70 62 0 6   0 0     0   2   36 34         16       70
1681617 ID     school 1600360 1   BOISE INDEPENDENT DISTRICT 160036000055 302 HIGHLANDS ELEMENTARY SCHOOL   Regular School No 1.0 PK 06 2015   grade_1 29 0 0   1 0     0   3   16 17             *         33 29 0 0   1 0     0   3   16 17                 33
1681618 ID     school 1600360 1   BOISE INDEPENDENT DISTRICT 160036000055 302 HIGHLANDS ELEMENTARY SCHOOL   Regular School No 1.0 PK 06 2015   grade_2 46 0 1   0 0     0   1   23 25             *         48 46 0 1   0 0     0   1   23 25                 48
1681619 ID     school 1600360 1   BOISE INDEPENDENT DISTRICT 160036000055 302 HIGHLANDS ELEMENTARY SCHOOL   Regular School No 1.0 PK 06 2015   grade_3 45 0 1   0 0     0   2   18 30             *         48 45 0 1   0 0     0   2   18 30                 48
1681621 ID     school 1600360 1   BOISE INDEPENDENT DISTRICT 160036000055 302 HIGHLANDS ELEMENTARY SCHOOL   Regular School No 1.0 PK 06 2015   grade_5 62 0 1   0 1     0   2   21 45             5         66 62 0 1   0 1     0   2   21 45         5       66
1681622 ID     school 1600360 1   BOISE INDEPENDENT DISTRICT 160036000055 302 HIGHLANDS ELEMENTARY SCHOOL   Regular School No 1.0 PK 06 2015   grade_6 53 0 1   0 1     0   5   27 33             6         60 53 0 1   0 1     0   5   27 33         6       60
1681624 ID     school 1600360 1   BOISE INDEPENDENT DISTRICT 160036000055 302 HIGHLANDS ELEMENTARY SCHOOL   Regular School No 1.0 PK 06 2015   kindergarten 38 0 1   0 0     0   1   20 20             *         40 38 0 1   0 0     0   1   20 20                 40
1681632 ID     school 1600360 1   BOISE INDEPENDENT DISTRICT 160036000053 303 GARFIELD ELEMENTARY SCHOOL   Regular School No 1.0 PK 06 2015   kindergarten 33 0 11   3 1     0   0   22 26             *         48 33 0 11   3 1     0   0   22 26                 48
1681633 ID     school 1600360 1   BOISE INDEPENDENT DISTRICT 160036000076 305 WASHINGTON ELEMENTARY SCHOOL   Regular School No 1.0 PK 06 2015   grade_1 36 0 4   0 0     0   1   20 21             6         41 36 0 4   0 0     0   1   20 21         6       41
1681634 ID     school 1600360 1   BOISE INDEPENDENT DISTRICT 160036000076 305 WASHINGTON ELEMENTARY SCHOOL   Regular School No 1.0 PK 06 2015   grade_2 37 0 4   0 0     0   2   19 24             8         43 37 0 4   0 0     0   2   19 24         8       43
1681635 ID     school 1600360 1   BOISE INDEPENDENT DISTRICT 160036000076 305 WASHINGTON ELEMENTARY SCHOOL   Regular School No 1.0 PK 06 2015   grade_3 47 0 3   0 0     0   1   30 21             *         51 47 0 3   0 0     0   1   30 21                 51
1681636 ID     school 1600360 1   BOISE INDEPENDENT DISTRICT 160036000076 305 WASHINGTON ELEMENTARY SCHOOL   Regular School No 1.0 PK 06 2015   grade_4 52 0 3   0 1     0   1   35 22             11         57 52 0 3   0 1     0   1   35 22         11       57
1681637 ID     school 1600360 1   BOISE INDEPENDENT DISTRICT 160036000076 305 WASHINGTON ELEMENTARY SCHOOL   Regular School No 1.0 PK 06 2015   grade_5 56 0 1   0 1     0   1   33 26             8         59 56 0 1   0 1     0   1   33 26         8       59
1681638 ID     school 1600360 1   BOISE INDEPENDENT DISTRICT 160036000076 305 WASHINGTON ELEMENTARY SCHOOL   Regular School No 1.0 PK 06 2015   grade_6 42 0 2   0 2     0   0   28 18             11         46 42 0 2   0 2     0   0   28 18         11       46
1681639 ID     school 1600360 1   BOISE INDEPENDENT DISTRICT 160036000076 305 WASHINGTON ELEMENTARY SCHOOL   Regular School No 1.0 PK 06 2015   k_12_total 312 0 20   0 5     0   6   184 159             53         343 312 0 20   0 5     0   6   184 159         53       343
1681640 ID     school 1600360 1   BOISE INDEPENDENT DISTRICT 160036000076 305 WASHINGTON ELEMENTARY SCHOOL   Regular School No 1.0 PK 06 2015   kindergarten 42 0 3   0 1     0   0   19 27             *         46 42 0 3   0 1     0   0   19 27                 46
1681653 ID     school 1600360 1   BOISE INDEPENDENT DISTRICT 160036000056 307 HILLCREST ELEMENTARY SCHOOL   Regular School No 1.0 PK 06 2015   grade_5 42 0 6   0 2     0   0   26 24             *         50 42 0 6   0 2     0   0   26 24                 50
1681662 ID     school 1600360 1   BOISE INDEPENDENT DISTRICT 160036000054 308 HAWTHORNE ELEMENTARY SCHOOL   Regular School No 1.0 PK 06 2015   grade_6 23 0 5   0 0     0   1   11 18             *         29 23 0 5   0 0     0   1   11 18                 29
1681666 ID     school 1600360 1   BOISE INDEPENDENT DISTRICT 160036000072 309 ROOSEVELT ELEMENTARY SCHOOL   Regular School No 1.0 PK 06 2015   grade_2 37 0 3   0 1     0   2   20 23             9         43 37 0 3   0 1     0   2   20 23         9       43
1681668 ID     school 1600360 1   BOISE INDEPENDENT DISTRICT 160036000072 309 ROOSEVELT ELEMENTARY SCHOOL   Regular School No 1.0 PK 06 2015   grade_4 50 0 3   0 0     0   1   28 26             8         54 50 0 3   0 0     0   1   28 26         8       54
1681669 ID     school 1600360 1   BOISE INDEPENDENT DISTRICT 160036000072 309 ROOSEVELT ELEMENTARY SCHOOL   Regular School No 1.0 PK 06 2015   grade_5 47 0 0   0 1     1   1   15 35             11         50 47 0 0   0 1     1   1   15 35         11       50
1681670 ID     school 1600360 1   BOISE INDEPENDENT DISTRICT 160036000072 309 ROOSEVELT ELEMENTARY SCHOOL   Regular School No 1.0 PK 06 2015   grade_6 46 0 4   0 3     1   0   20 34             *         54 46 0 4   0 3     1   0   20 34                 54
1681672 ID     school 1600360 1   BOISE INDEPENDENT DISTRICT 160036000072 309 ROOSEVELT ELEMENTARY SCHOOL   Regular School No 1.0 PK 06 2015   kindergarten 34 0 2   0 0     1   1   17 21             10         38 34 0 2   0 0     1   1   17 21         10       38
1681677 ID     school 1600360 1   BOISE INDEPENDENT DISTRICT 160036000071 310 PIERCE PARK ELEMENTARY SCHOOL   Regular School No 1.0 PK 06 2015   grade_5 33 0 5   1 0     0   1   17 23             16         40 33 0 5   1 0     0   1   17 23         16       40
1681681 ID     school 1600360 1   BOISE INDEPENDENT DISTRICT 160036000064 312 MADISON EARLY CHILDHOOD SCHOOL   Special Education School No 1.0 PK KG 2015   k_12_total 1 0 0   0 0     0   0   1 0             *         1 1 0 0   0 0     0   0   1 0                 1
1681682 ID     school 1600360 1   BOISE INDEPENDENT DISTRICT 160036000064 312 MADISON EARLY CHILDHOOD SCHOOL   Special Education School No 1.0 PK KG 2015   kindergarten 1 0 0   0 0     0   0   1 0             *         1 1 0 0   0 0     0   0   1 0                 1
1681683 ID     school 1600360 1   BOISE INDEPENDENT DISTRICT 160036000070 313 OWYHEE ELEMENTARY SCHOOL   Regular School No 1.0 PK 06 2015   grade_1 33 0 4   0 1     0   1   21 18             *         39 33 0 4   0 1     0   1   21 18                 39
1681685 ID     school 1600360 1   BOISE INDEPENDENT DISTRICT 160036000070 313 OWYHEE ELEMENTARY SCHOOL   Regular School No 1.0 PK 06 2015   grade_3 29 0 4   0 4     1   2   27 13             *         40 29 0 4   0 4     1   2   27 13                 40
1681686 ID     school 1600360 1   BOISE INDEPENDENT DISTRICT 160036000070 313 OWYHEE ELEMENTARY SCHOOL   Regular School No 1.0 PK 06 2015   grade_4 31 0 5   0 0     0   0   16 20             *         36 31 0 5   0 0     0   0   16 20                 36
1681687 ID     school 1600360 1   BOISE INDEPENDENT DISTRICT 160036000070 313 OWYHEE ELEMENTARY SCHOOL   Regular School No 1.0 PK 06 2015   grade_5 32 0 1   0 2     0   1   14 22             *         36 32 0 1   0 2     0   1   14 22                 36
1681688 ID     school 1600360 1   BOISE INDEPENDENT DISTRICT 160036000070 313 OWYHEE ELEMENTARY SCHOOL   Regular School No 1.0 PK 06 2015   grade_6 29 0 5   0 3     2   1   23 17             *         40 29 0 5   0 3     2   1   23 17                 40
1681691 ID     school 1600360 1   BOISE INDEPENDENT DISTRICT 160036000042 315 ADAMS ELEMENTARY SCHOOL   Regular School No 1.0 PK 06 2015   grade_1 37 0 4   0 5     0   0   25 21             13         46 37 0 4   0 5     0   0   25 21         13       46
1681693 ID     school 1600360 1   BOISE INDEPENDENT DISTRICT 160036000042 315 ADAMS ELEMENTARY SCHOOL   Regular School No 1.0 PK 06 2015   grade_3 45 0 5   0 2     0   0   27 25             8         52 45 0 5   0 2     0   0   27 25         8       52
1681694 ID     school 1600360 1   BOISE INDEPENDENT DISTRICT 160036000042 315 ADAMS ELEMENTARY SCHOOL   Regular School No 1.0 PK 06 2015   grade_4 42 0 5   0 3     0   0   30 20             9         50 42 0 5   0 3     0   0   30 20         9       50
1681695 ID     school 1600360 1   BOISE INDEPENDENT DISTRICT 160036000042 315 ADAMS ELEMENTARY SCHOOL   Regular School No 1.0 PK 06 2015   grade_5 47 0 6   0 3     0   0   26 30             8         56 47 0 6   0 3     0   0   26 30         8       56
1681696 ID     school 1600360 1   BOISE INDEPENDENT DISTRICT 160036000042 315 ADAMS ELEMENTARY SCHOOL   Regular School No 1.0 PK 06 2015   grade_6 46 0 2   0 4     0   0   31 21             5         52 46 0 2   0 4     0   0   31 21         5       52
1681701 ID     school 1600360 1   BOISE INDEPENDENT DISTRICT 160036000650 316 LIBERTY ELEMENTARY SCHOOL   Regular School No 1.0 PK 06 2015   grade_3 69 0 2   1 1     0   2   40 35             19         75 69 0 2   1 1     0   2   40 35         19       75
1681706 ID     school 1600360 1   BOISE INDEPENDENT DISTRICT 160036000650 316 LIBERTY ELEMENTARY SCHOOL   Regular School No 1.0 PK 06 2015   kindergarten 51 0 5   0 0     0   2   30 28             10         58 51 0 5   0 0     0   2   30 28         10       58
1681741 ID     school 1600360 1   BOISE INDEPENDENT DISTRICT 160036000068 322 MOUNTAIN VIEW ELEMENTARY SCHOOL   Regular School No 1.0 PK 06 2015   grade_3 33 0 6   0 1     0   1   14 27             *         41 33 0 6   0 1     0   1   14 27                 41
1681747 ID     school 1600360 1   BOISE INDEPENDENT DISTRICT 160036000062 323 LONGFELLOW ELEMENTARY SCHOOL   Regular School No 1.0 PK 06 2015   grade_1 35 0 3   0 1     0   2   18 23             8         41 35 0 3   0 1     0   2   18 23         8       41
1681751 ID     school 1600360 1   BOISE INDEPENDENT DISTRICT 160036000062 323 LONGFELLOW ELEMENTARY SCHOOL   Regular School No 1.0 PK 06 2015   grade_5 48 0 4   0 0     0   0   24 28             6         52 48 0 4   0 0     0   0   24 28         6       52
1681752 ID     school 1600360 1   BOISE INDEPENDENT DISTRICT 160036000062 323 LONGFELLOW ELEMENTARY SCHOOL   Regular School No 1.0 PK 06 2015   grade_6 44 0 1   0 2     0   1   24 24             9         48 44 0 1   0 2     0   1   24 24         9       48
1681754 ID     school 1600360 1   BOISE INDEPENDENT DISTRICT 160036000062 323 LONGFELLOW ELEMENTARY SCHOOL   Regular School No 1.0 PK 06 2015   kindergarten 39 0 5   0 0     1   2   22 25             10         47 39 0 5   0 0     1   2   22 25         10       47
1681756 ID     school 1600360 1   BOISE INDEPENDENT DISTRICT 160036000067 324 MONROE ELEMENTARY SCHOOL   Regular School No 1.0 PK 06 2015   grade_2 33 0 8   0 3     2   3   21 28             26         49 33 0 8   0 3     2   3   21 28         26       49
1681759 ID     school 1600360 1   BOISE INDEPENDENT DISTRICT 160036000067 324 MONROE ELEMENTARY SCHOOL   Regular School No 1.0 PK 06 2015   grade_5 36 0 4   1 2     0   1   24 20             16         44 36 0 4   1 2     0   1   24 20         16       44
1681760 ID     school 1600360 1   BOISE INDEPENDENT DISTRICT 160036000067 324 MONROE ELEMENTARY SCHOOL   Regular School No 1.0 PK 06 2015   grade_6 25 0 2   0 1     2   0   15 15             9         30 25 0 2   0 1     2   0   15 15         9       30
1681762 ID     school 1600360 1   BOISE INDEPENDENT DISTRICT 160036000067 324 MONROE ELEMENTARY SCHOOL   Regular School No 1.0 PK 06 2015   kindergarten 34 0 4   0 1     2   2   29 14             18         43 34 0 4   0 1     2   2   29 14         18       43
1681771 ID     school 1600360 1   BOISE INDEPENDENT DISTRICT 160036000049 326 COLLISTER ELEMENTARY SCHOOL   Regular School No 1.0 PK 06 2015   grade_1 25 0 0   0 2     0   0   13 14             *         27 25 0 0   0 2     0   0   13 14                 27
1681772 ID     school 1600360 1   BOISE INDEPENDENT DISTRICT 160036000049 326 COLLISTER ELEMENTARY SCHOOL   Regular School No 1.0 PK 06 2015   grade_2 22 0 0   2 4     0   3   13 18             *         31 22 0 0   2 4     0   3   13 18                 31
1681773 ID     school 1600360 1   BOISE INDEPENDENT DISTRICT 160036000049 326 COLLISTER ELEMENTARY SCHOOL   Regular School No 1.0 PK 06 2015   grade_3 30 0 2   0 2     0   2   17 19             7         36 30 0 2   0 2     0   2   17 19         7       36
1681774 ID     school 1600360 1   BOISE INDEPENDENT DISTRICT 160036000049 326 COLLISTER ELEMENTARY SCHOOL   Regular School No 1.0 PK 06 2015   grade_4 34 0 1   0 4     0   3   23 19             7         42 34 0 1   0 4     0   3   23 19         7       42
1681775 ID     school 1600360 1   BOISE INDEPENDENT DISTRICT 160036000049 326 COLLISTER ELEMENTARY SCHOOL   Regular School No 1.0 PK 06 2015   grade_5 31 0 2   0 3     0   2   21 17             6         38 31 0 2   0 3     0   2   21 17         6       38
1681778 ID     school 1600360 1   BOISE INDEPENDENT DISTRICT 160036000049 326 COLLISTER ELEMENTARY SCHOOL   Regular School No 1.0 PK 06 2015   kindergarten 18 0 1   0 0     0   1   12 8             6         20 18 0 1   0 0     0   1   12 8         6       20
1681788 ID     school 1600360 1   BOISE INDEPENDENT DISTRICT 160036000004 509 RIVERSIDE ELEMENTARY SCHOOL   Regular School No 1.0 PK 06 2015   grade_2 76 0 3   1 8     0   1   49 40             8         89 76 0 3   1 8     0   1   49 40         8       89
1681794 ID     school 1600360 1   BOISE INDEPENDENT DISTRICT 160036000004 509 RIVERSIDE ELEMENTARY SCHOOL   Regular School No 1.0 PK 06 2015   kindergarten 61 0 6   0 4     0   2   42 31             13         73 61 0 6   0 4     0   2   42 31         13       73
1681803 ID     school 1600360 1   BOISE INDEPENDENT DISTRICT 160036000817 563 DEHRYL A DENNIS PROF-TECH CENTER   Vocational Education School No 3.0 07 12 2015   grade_11 1 0 0   0 0     0   0   1 0             *         1 1 0 0   0 0     0   0   1 0                 1
1681804 ID     school 1600360 1   BOISE INDEPENDENT DISTRICT 160036000817 563 DEHRYL A DENNIS PROF-TECH CENTER   Vocational Education School No 3.0 07 12 2015   k_12_total 1 0 0   0 0     0   0   1 0             *         1 1 0 0   0 0     0   0   1 0                 1
1681805 ID     school 1600360 1   BOISE INDEPENDENT DISTRICT 160036000823 573 TREASURE VALLEY MATH/SCIENCE   Regular School No 4.0 04 12 2015   grade_10 7 0 1   0 0     0   0   4 4             *         8 7 0 1   0 0     0   0   4 4                 8
1681806 ID     school 1600360 1   BOISE INDEPENDENT DISTRICT 160036000823 573 TREASURE VALLEY MATH/SCIENCE   Regular School No 4.0 04 12 2015   grade_11 6 0 1   0 0     0   0   5 2             *         7 6 0 1   0 0     0   0   5 2                 7
1681807 ID     school 1600360 1   BOISE INDEPENDENT DISTRICT 160036000823 573 TREASURE VALLEY MATH/SCIENCE   Regular School No 4.0 04 12 2015   grade_12 5 0 0   0 0     0   0   3 2             *         5 5 0 0   0 0     0   0   3 2                 5
1681808 ID     school 1600360 1   BOISE INDEPENDENT DISTRICT 160036000823 573 TREASURE VALLEY MATH/SCIENCE   Regular School No 4.0 04 12 2015   grade_6 6 0 0   0 1     0   0   4 3             *         7 6 0 0   0 1     0   0   4 3                 7
1681809 ID     school 1600360 1   BOISE INDEPENDENT DISTRICT 160036000823 573 TREASURE VALLEY MATH/SCIENCE   Regular School No 4.0 04 12 2015   grade_7 25 0 1   0 2     0   1   18 11             *         29 25 0 1   0 2     0   1   18 11                 29
1681810 ID     school 1600360 1   BOISE INDEPENDENT DISTRICT 160036000823 573 TREASURE VALLEY MATH/SCIENCE   Regular School No 4.0 04 12 2015   grade_8 21 0 1   0 6     0   2   20 10             *         30 21 0 1   0 6     0   2   20 10                 30
1681811 ID     school 1600360 1   BOISE INDEPENDENT DISTRICT 160036000823 573 TREASURE VALLEY MATH/SCIENCE   Regular School No 4.0 04 12 2015   grade_9 15 0 1   0 1     0   0   14 3             *         17 15 0 1   0 1     0   0   14 3                 17
1681812 ID     school 1600360 1   BOISE INDEPENDENT DISTRICT 160036000823 573 TREASURE VALLEY MATH/SCIENCE   Regular School No 4.0 04 12 2015   k_12_total 85 0 5   0 10     0   3   68 35             *         103 85 0 5   0 10     0   3   68 35                 103
1681814 ID     school 1600360 1   BOISE INDEPENDENT DISTRICT 160036000707 665 CYNTHIA MANN ELEMENTARY SCHOOL   Regular School No 1.0 PK 06 2015   grade_2 47 0 2   0 3     0   2   19 35             19         54 47 0 2   0 3     0   2   19 35         19       54
1681815 ID     school 1600360 1   BOISE INDEPENDENT DISTRICT 160036000707 665 CYNTHIA MANN ELEMENTARY SCHOOL   Regular School No 1.0 PK 06 2015   grade_3 52 0 9   0 0     0   5   40 26             28         66 52 0 9   0 0     0   5   40 26         28       66
1681842 ID     school 1600360 1   BOISE INDEPENDENT DISTRICT 160036000982 674 GRACE JORDAN ELEMENTARY   Regular School No 1.0 PK 06 2015   grade_6 40 0 16   0 4     0   4   31 33             *         64 40 0 16   0 4     0   4   31 33                 64
1681848 ID     school 1600360 1   BOISE INDEPENDENT DISTRICT 160036000984 675 FRANK CHURCH HIGH SCHOOL   Alternative Education School No 3.0 07 12 2015   grade_7 2 0 0   0 0     0   1   3 0             *         3 2 0 0   0 0     0   1   3 0                 3
1681849 ID     school 1600360 1   BOISE INDEPENDENT DISTRICT 160036000984 675 FRANK CHURCH HIGH SCHOOL   Alternative Education School No 3.0 07 12 2015   grade_8 1 0 0   0 0     0   0   1 0             *         1 1 0 0   0 0     0   0   1 0                 1
1681858 ID     school 1600360 1   BOISE INDEPENDENT DISTRICT 160036001002 677 EAST JUNIOR HIGH SCHOOL   Regular School No 2.0 07 09 2015   grade_9 147 0 11   1 12     2   7   93 87             24         180 147 0 11   1 12     2   7   93 87         24       180
1681860 ID     school 1600360 1   BOISE INDEPENDENT DISTRICT 160036001004 679 HIDDEN SPRINGS ELEMENTARY SCHOOL   Regular School No 1.0 PK 06 2015   grade_1 50 0 3   0 0     0   4   29 28             *         57 50 0 3   0 0     0   4   29 28                 57
1681861 ID     school 1600360 1   BOISE INDEPENDENT DISTRICT 160036001004 679 HIDDEN SPRINGS ELEMENTARY SCHOOL   Regular School No 1.0 PK 06 2015   grade_2 42 0 0   0 0     0   4   24 22             *         46 42 0 0   0 0     0   4   24 22                 46
1681862 ID     school 1600360 1   BOISE INDEPENDENT DISTRICT 160036001004 679 HIDDEN SPRINGS ELEMENTARY SCHOOL   Regular School No 1.0 PK 06 2015   grade_3 49 0 3   0 0     0   2   30 24             *         54 49 0 3   0 0     0   2   30 24                 54
1681863 ID     school 1600360 1   BOISE INDEPENDENT DISTRICT 160036001004 679 HIDDEN SPRINGS ELEMENTARY SCHOOL   Regular School No 1.0 PK 06 2015   grade_4 56 0 2   0 0     0   2   32 28             *         60 56 0 2   0 0     0   2   32 28                 60
1681865 ID     school 1600360 1   BOISE INDEPENDENT DISTRICT 160036001004 679 HIDDEN SPRINGS ELEMENTARY SCHOOL   Regular School No 1.0 PK 06 2015   grade_6 53 0 2   1 0     0   1   35 22             *         57 53 0 2   1 0     0   1   35 22                 57
1681867 ID     school 1600360 1   BOISE INDEPENDENT DISTRICT 160036001004 679 HIDDEN SPRINGS ELEMENTARY SCHOOL   Regular School No 1.0 PK 06 2015   kindergarten 39 0 1   0 0     0   1   17 24             *         41 39 0 1   0 0     0   1   17 24                 41
1681869 ID     school 1600360 1   BOISE INDEPENDENT DISTRICT 160036000708 9002 ADA COUNTY JUVENILE CENTER   Alternative Education School No 4.0 05 12 2015   grade_11 6 0 0   0 0     0   0   4 2             *         6 6 0 0   0 0     0   0   4 2                 6
1681870 ID     school 1600360 1   BOISE INDEPENDENT DISTRICT 160036000708 9002 ADA COUNTY JUVENILE CENTER   Alternative Education School No 4.0 05 12 2015   grade_12 4 0 0   0 0     0   0   2 2             *         4 4 0 0   0 0     0   0   2 2                 4
1681871 ID     school 1600360 1   BOISE INDEPENDENT DISTRICT 160036000708 9002 ADA COUNTY JUVENILE CENTER   Alternative Education School No 4.0 05 12 2015   grade_7 1 0 0   0 0     0   0   1 0             *         1 1 0 0   0 0     0   0   1 0                 1
1681872 ID     school 1600360 1   BOISE INDEPENDENT DISTRICT 160036000708 9002 ADA COUNTY JUVENILE CENTER   Alternative Education School No 4.0 05 12 2015   grade_8 2 0 0   0 0     0   0   1 1             *         2 2 0 0   0 0     0   0   1 1                 2
1681873 ID     school 1600360 1   BOISE INDEPENDENT DISTRICT 160036000708 9002 ADA COUNTY JUVENILE CENTER   Alternative Education School No 4.0 05 12 2015   grade_9 5 0 1   0 0     0   0   3 3             *         6 5 0 1   0 0     0   0   3 3                 6
1681916 ID     school 1602100 2   JOINT SCHOOL DISTRICT NO. 2 160210000794 239 PEREGRINE ELEMENTARY SCHOOL   Regular School No 1.0 PK 05 2015   kindergarten 60 0 13   2 1     1   7   36 48             43         84 60 0 13   2 1     1   7   36 48         43       84
1681918 ID     school 1602100 2   JOINT SCHOOL DISTRICT NO. 2 160210000793 240 RIVER VALLEY ELEMENTARY SCHOOL   Regular School No 1.0 PK 05 2015   grade_2 59 0 9   2 2     0   3   37 38             25         75 59 0 9   2 2     0   3   37 38         25       75
1681919 ID     school 1602100 2   JOINT SCHOOL DISTRICT NO. 2 160210000793 240 RIVER VALLEY ELEMENTARY SCHOOL   Regular School No 1.0 PK 05 2015   grade_3 59 0 10   2 2     0   2   37 38             21         75 59 0 10   2 2     0   2   37 38         21       75
1681920 ID     school 1602100 2   JOINT SCHOOL DISTRICT NO. 2 160210000793 240 RIVER VALLEY ELEMENTARY SCHOOL   Regular School No 1.0 PK 05 2015   grade_4 57 0 11   0 1     1   2   38 34             25         72 57 0 11   0 1     1   2   38 34         25       72
1681924 ID     school 1602100 2   JOINT SCHOOL DISTRICT NO. 2 160210000818 283 PEPPER RIDGE ELEMENTARY   Regular School No 1.0 PK 05 2015   grade_1 102 0 5   0 1     0   4   57 55             24         112 102 0 5   0 1     0   4   57 55         24       112
1681925 ID     school 1602100 2   JOINT SCHOOL DISTRICT NO. 2 160210000818 283 PEPPER RIDGE ELEMENTARY   Regular School No 1.0 PK 05 2015   grade_2 83 0 8   0 3     1   4   47 52             24         99 83 0 8   0 3     1   4   47 52         24       99
1681926 ID     school 1602100 2   JOINT SCHOOL DISTRICT NO. 2 160210000818 283 PEPPER RIDGE ELEMENTARY   Regular School No 1.0 PK 05 2015   grade_3 102 0 15   1 9     0   3   60 70             27         130 102 0 15   1 9     0   3   60 70         27       130
1681930 ID     school 1602100 2   JOINT SCHOOL DISTRICT NO. 2 160210000818 283 PEPPER RIDGE ELEMENTARY   Regular School No 1.0 PK 05 2015   kindergarten 78 0 11   0 1     0   5   48 47             23         95 78 0 11   0 1     0   5   48 47         23       95
1681935 ID     school 1602100 2   JOINT SCHOOL DISTRICT NO. 2 160210000824 296 HUNTER ELEMENTARY SCHOOL   Regular School No 1.0 PK 05 2015   grade_1 106 0 6   1 0     0   5   61 57             18         118 106 0 6   1 0     0   5   61 57         18       118
1681937 ID     school 1602100 2   JOINT SCHOOL DISTRICT NO. 2 160210000824 296 HUNTER ELEMENTARY SCHOOL   Regular School No 1.0 PK 05 2015   grade_3 107 0 5   0 3     0   1   61 55             18         116 107 0 5   0 3     0   1   61 55         18       116

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