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
1681938 ID     school 1602100 2   JOINT SCHOOL DISTRICT NO. 2 160210000824 296 HUNTER ELEMENTARY SCHOOL   Regular School No 1.0 PK 05 2015   grade_4 135 0 3   0 0     0   4   81 61             31         142 135 0 3   0 0     0   4   81 61         31       142
1681939 ID     school 1602100 2   JOINT SCHOOL DISTRICT NO. 2 160210000824 296 HUNTER ELEMENTARY SCHOOL   Regular School No 1.0 PK 05 2015   grade_5 131 0 4   0 2     1   5   74 69             25         143 131 0 4   0 2     1   5   74 69         25       143
1681941 ID     school 1602100 2   JOINT SCHOOL DISTRICT NO. 2 160210000824 296 HUNTER ELEMENTARY SCHOOL   Regular School No 1.0 PK 05 2015   kindergarten 85 0 5   0 1     0   1   39 53             16         92 85 0 5   0 1     0   1   39 53         16       92
1681949 ID     school 1602100 2   JOINT SCHOOL DISTRICT NO. 2 160210000717 329 CHIEF JOSEPH SCHOOL OF THE ARTS   Regular School No 1.0 PK 05 2015   grade_1 80 0 15   0 1     2   3   45 56             54         101 80 0 15   0 1     2   3   45 56         54       101
1681955 ID     school 1602100 2   JOINT SCHOOL DISTRICT NO. 2 160210000717 329 CHIEF JOSEPH SCHOOL OF THE ARTS   Regular School No 1.0 PK 05 2015   kindergarten 61 0 12   0 2     1   4   44 36             38         80 61 0 12   0 2     1   4   44 36         38       80
1681964 ID     school 1602100 2   JOINT SCHOOL DISTRICT NO. 2 160210000365 331 LAKE HAZEL ELEMENTARY SCHOOL   Regular School No 1.0 PK 05 2015   grade_2 66 0 4   2 1     0   2   42 33             31         75 66 0 4   2 1     0   2   42 33         31       75
1681966 ID     school 1602100 2   JOINT SCHOOL DISTRICT NO. 2 160210000365 331 LAKE HAZEL ELEMENTARY SCHOOL   Regular School No 1.0 PK 05 2015   grade_4 48 0 9   2 2     1   4   33 33             15         66 48 0 9   2 2     1   4   33 33         15       66
1681967 ID     school 1602100 2   JOINT SCHOOL DISTRICT NO. 2 160210000365 331 LAKE HAZEL ELEMENTARY SCHOOL   Regular School No 1.0 PK 05 2015   grade_5 58 0 12   1 0     0   2   33 40             18         73 58 0 12   1 0     0   2   33 40         18       73
1681970 ID     school 1602100 2   JOINT SCHOOL DISTRICT NO. 2 160210000362 332 EAGLE ELEMENTARY SCHOOL OF THE ARTS   Regular School No 1.0 PK 05 2015   grade_1 61 0 2   0 0     1   5   31 38             15         69 61 0 2   0 0     1   5   31 38         15       69
1681973 ID     school 1602100 2   JOINT SCHOOL DISTRICT NO. 2 160210000362 332 EAGLE ELEMENTARY SCHOOL OF THE ARTS   Regular School No 1.0 PK 05 2015   grade_4 70 0 5   1 2     0   2   33 47             12         80 70 0 5   1 2     0   2   33 47         12       80
1681974 ID     school 1602100 2   JOINT SCHOOL DISTRICT NO. 2 160210000362 332 EAGLE ELEMENTARY SCHOOL OF THE ARTS   Regular School No 1.0 PK 05 2015   grade_5 79 0 3   0 0     1   5   32 56             16         88 79 0 3   0 0     1   5   32 56         16       88
1681976 ID     school 1602100 2   JOINT SCHOOL DISTRICT NO. 2 160210000362 332 EAGLE ELEMENTARY SCHOOL OF THE ARTS   Regular School No 1.0 PK 05 2015   kindergarten 55 0 3   1 0     0   3   24 38             15         62 55 0 3   1 0     0   3   24 38         15       62
1681979 ID     school 1602100 2   JOINT SCHOOL DISTRICT NO. 2 160210000364 333 SUMMERWIND SCHOOL OF MATH AND SCIENCE   Regular School No 1.0 PK 05 2015   grade_3 51 0 14   0 1     0   4   39 31             38         70 51 0 14   0 1     0   4   39 31         38       70
1681981 ID     school 1602100 2   JOINT SCHOOL DISTRICT NO. 2 160210000364 333 SUMMERWIND SCHOOL OF MATH AND SCIENCE   Regular School No 1.0 PK 05 2015   grade_5 34 0 10   1 0     1   5   24 27             26         51 34 0 10   1 0     1   5   24 27         26       51
1681983 ID     school 1602100 2   JOINT SCHOOL DISTRICT NO. 2 160210000364 333 SUMMERWIND SCHOOL OF MATH AND SCIENCE   Regular School No 1.0 PK 05 2015   kindergarten 68 0 5   0 0     0   4   41 36             30         77 68 0 5   0 0     0   4   41 36         30       77
1681988 ID     school 1602100 2   JOINT SCHOOL DISTRICT NO. 2 160210000373 334 STAR ELEMENTARY SCHOOL   Regular School No 1.0 PK 06 2015   grade_5 79 0 13   1 0     0   4   49 48             44         97 79 0 13   1 0     0   4   49 48         44       97
1681995 ID     school 1602100 2   JOINT SCHOOL DISTRICT NO. 2 160210000374 335 USTICK ELEMENTARY SCHOOL   Regular School No 1.0 PK 05 2015   grade_5 64 0 17   2 1     0   1   43 42             47         85 64 0 17   2 1     0   1   43 42         47       85
1681998 ID     school 1602100 2   JOINT SCHOOL DISTRICT NO. 2 160210000371 336 MERIDIAN ELEMENTARY SCHOOL   Regular School No 1.0 PK 05 2015   grade_1 52 0 14   0 0     0   6   38 34             52         72 52 0 14   0 0     0   6   38 34         52       72
1682000 ID     school 1602100 2   JOINT SCHOOL DISTRICT NO. 2 160210000371 336 MERIDIAN ELEMENTARY SCHOOL   Regular School No 1.0 PK 05 2015   grade_3 52 0 11   1 0     0   6   39 31             52         70 52 0 11   1 0     0   6   39 31         52       70
1682004 ID     school 1602100 2   JOINT SCHOOL DISTRICT NO. 2 160210000371 336 MERIDIAN ELEMENTARY SCHOOL   Regular School No 1.0 PK 05 2015   kindergarten 50 0 20   0 0     1   2   35 38             46         73 50 0 20   0 0     1   2   35 38         46       73
1682012 ID     school 1602100 2   JOINT SCHOOL DISTRICT NO. 2 160210000366 338 CHRISTINE DONNELL SCHOOL OF THE ARTS   Regular School No 1.0 PK 07 2015   grade_1 57 0 3   1 1     1   1   28 36             21         64 57 0 3   1 1     1   1   28 36         21       64
1682013 ID     school 1602100 2   JOINT SCHOOL DISTRICT NO. 2 160210000366 338 CHRISTINE DONNELL SCHOOL OF THE ARTS   Regular School No 1.0 PK 07 2015   grade_2 84 0 5   0 4     0   2   48 47             21         95 84 0 5   0 4     0   2   48 47         21       95
1682016 ID     school 1602100 2   JOINT SCHOOL DISTRICT NO. 2 160210000366 338 CHRISTINE DONNELL SCHOOL OF THE ARTS   Regular School No 1.0 PK 07 2015   grade_5 83 0 4   0 2     1   5   52 43             22         95 83 0 4   0 2     1   5   52 43         22       95
1682017 ID     school 1602100 2   JOINT SCHOOL DISTRICT NO. 2 160210000366 338 CHRISTINE DONNELL SCHOOL OF THE ARTS   Regular School No 1.0 PK 07 2015   grade_6 53 0 4   0 2     0   1   25 35             19         60 53 0 4   0 2     0   1   25 35         19       60
1682019 ID     school 1602100 2   JOINT SCHOOL DISTRICT NO. 2 160210000366 338 CHRISTINE DONNELL SCHOOL OF THE ARTS   Regular School No 1.0 PK 07 2015   kindergarten 55 0 6   1 0     0   2   39 25             12         64 55 0 6   1 0     0   2   39 25         12       64
1682021 ID     school 1602100 2   JOINT SCHOOL DISTRICT NO. 2 160210000639 339 BARBARA MORGAN STEM ACADEMY   Regular School No 1.0 KG 05 2015   grade_2 57 0 11   1 1     0   2   43 29             40         72 57 0 11   1 1     0   2   43 29         40       72
1682022 ID     school 1602100 2   JOINT SCHOOL DISTRICT NO. 2 160210000639 339 BARBARA MORGAN STEM ACADEMY   Regular School No 1.0 KG 05 2015   grade_3 55 0 14   0 2     0   2   43 30             37         73 55 0 14   0 2     0   2   43 30         37       73
1682026 ID     school 1602100 2   JOINT SCHOOL DISTRICT NO. 2 160210000639 339 BARBARA MORGAN STEM ACADEMY   Regular School No 1.0 KG 05 2015   kindergarten 55 0 13   1 0     0   2   32 39             27         71 55 0 13   1 0     0   2   32 39         27       71
1682027 ID     school 1602100 2   JOINT SCHOOL DISTRICT NO. 2 160210000624 340 EAGLE HILLS ELEMENTARY SCHOOL   Regular School No 1.0 PK 05 2015   grade_1 70 0 4   1 0     0   3   51 27             26         78 70 0 4   1 0     0   3   51 27         26       78
1682029 ID     school 1602100 2   JOINT SCHOOL DISTRICT NO. 2 160210000624 340 EAGLE HILLS ELEMENTARY SCHOOL   Regular School No 1.0 PK 05 2015   grade_3 70 0 4   4 1     1   0   44 36             10         80 70 0 4   4 1     1   0   44 36         10       80
1682030 ID     school 1602100 2   JOINT SCHOOL DISTRICT NO. 2 160210000624 340 EAGLE HILLS ELEMENTARY SCHOOL   Regular School No 1.0 PK 05 2015   grade_4 86 0 6   1 3     1   2   52 47             21         99 86 0 6   1 3     1   2   52 47         21       99
1682031 ID     school 1602100 2   JOINT SCHOOL DISTRICT NO. 2 160210000624 340 EAGLE HILLS ELEMENTARY SCHOOL   Regular School No 1.0 PK 05 2015   grade_5 72 0 10   3 1     1   4   55 36             22         91 72 0 10   3 1     1   4   55 36         22       91
1682035 ID     school 1602100 2   JOINT SCHOOL DISTRICT NO. 2 160210000368 341 MARY MCPHERSON ELEMENTARY   Regular School No 1.0 PK 05 2015   grade_2 69 0 11   0 0     0   0   45 35             19         80 69 0 11   0 0     0   0   45 35         19       80
1682040 ID     school 1602100 2   JOINT SCHOOL DISTRICT NO. 2 160210000368 341 MARY MCPHERSON ELEMENTARY   Regular School No 1.0 PK 05 2015   kindergarten 76 0 12   0 1     1   3   48 45             15         93 76 0 12   0 1     1   3   48 45         15       93
1682043 ID     school 1602100 2   JOINT SCHOOL DISTRICT NO. 2 160210000598 343 JOPLIN ELEMENTARY SCHOOL   Regular School No 1.0 PK 05 2015   grade_3 59 0 6   0 0     0   6   40 31             28         71 59 0 6   0 0     0   6   40 31         28       71
1682047 ID     school 1602100 2   JOINT SCHOOL DISTRICT NO. 2 160210000598 343 JOPLIN ELEMENTARY SCHOOL   Regular School No 1.0 PK 05 2015   kindergarten 43 0 7   0 1     0   2   31 22             13         53 43 0 7   0 1     0   2   31 22         13       53
1682048 ID     school 1602100 2   JOINT SCHOOL DISTRICT NO. 2 160210000770 504 PONDEROSA ELEMENTARY SCHOOL   Regular School No 1.0 PK 05 2015   grade_1 104 0 10   0 0     1   2   56 61             41         117 104 0 10   0 0     1   2   56 61         41       117
1682050 ID     school 1602100 2   JOINT SCHOOL DISTRICT NO. 2 160210000770 504 PONDEROSA ELEMENTARY SCHOOL   Regular School No 1.0 PK 05 2015   grade_3 66 0 14   0 0     0   9   44 45             35         89 66 0 14   0 0     0   9   44 45         35       89
1682051 ID     school 1602100 2   JOINT SCHOOL DISTRICT NO. 2 160210000770 504 PONDEROSA ELEMENTARY SCHOOL   Regular School No 1.0 PK 05 2015   grade_4 86 0 13   0 1     0   2   50 52             37         102 86 0 13   0 1     0   2   50 52         37       102
1682054 ID     school 1602100 2   JOINT SCHOOL DISTRICT NO. 2 160210000770 504 PONDEROSA ELEMENTARY SCHOOL   Regular School No 1.0 PK 05 2015   kindergarten 82 0 9   0 1     0   2   58 36             19         94 82 0 9   0 1     0   2   58 36         19       94
1682055 ID     school 1602100 2   JOINT SCHOOL DISTRICT NO. 2 160210000010 507 PIONEER SCHOOL OF THE ARTS   Regular School No 1.0 PK 05 2015   grade_1 101 0 5   1 1     1   4   51 62             27         113 101 0 5   1 1     1   4   51 62         27       113
1682064 ID     school 1602100 2   JOINT SCHOOL DISTRICT NO. 2 160210000801 521 DISCOVERY ELEMENTARY SCHOOL   Regular School No 1.0 PK 05 2015   grade_3 87 0 12   0 3     0   7   47 62             24         109 87 0 12   0 3     0   7   47 62         24       109
1682066 ID     school 1602100 2   JOINT SCHOOL DISTRICT NO. 2 160210000801 521 DISCOVERY ELEMENTARY SCHOOL   Regular School No 1.0 PK 05 2015   grade_5 68 0 13   0 2     0   4   48 39             16         87 68 0 13   0 2     0   4   48 39         16       87
1682071 ID     school 1602100 2   JOINT SCHOOL DISTRICT NO. 2 160210000593 523 CECIL D ANDRUS ELEMENTARY   Regular School No 1.0 PK 05 2015   grade_3 98 0 9   0 6     0   2   68 47             29         115 98 0 9   0 6     0   2   68 47         29       115
1682073 ID     school 1602100 2   JOINT SCHOOL DISTRICT NO. 2 160210000593 523 CECIL D ANDRUS ELEMENTARY   Regular School No 1.0 PK 05 2015   grade_5 96 0 6   0 2     0   5   59 50             16         109 96 0 6   0 2     0   5   59 50         16       109
1682075 ID     school 1602100 2   JOINT SCHOOL DISTRICT NO. 2 160210000593 523 CECIL D ANDRUS ELEMENTARY   Regular School No 1.0 PK 05 2015   kindergarten 73 0 4   1 2     0   1   38 43             23         81 73 0 4   1 2     0   1   38 43         23       81
1682076 ID     school 1602100 2   JOINT SCHOOL DISTRICT NO. 2 160210000597 524 CHAPARRAL ELEMENTARY   Regular School No 1.0 PK 05 2015   grade_1 90 0 10   0 0     0   3   46 57             38         103 90 0 10   0 0     0   3   46 57         38       103
1682077 ID     school 1602100 2   JOINT SCHOOL DISTRICT NO. 2 160210000597 524 CHAPARRAL ELEMENTARY   Regular School No 1.0 PK 05 2015   grade_2 75 0 10   0 1     0   4   32 58             24         90 75 0 10   0 1     0   4   32 58         24       90
1682078 ID     school 1602100 2   JOINT SCHOOL DISTRICT NO. 2 160210000597 524 CHAPARRAL ELEMENTARY   Regular School No 1.0 PK 05 2015   grade_3 81 0 9   0 2     1   0   39 54             33         93 81 0 9   0 2     1   0   39 54         33       93
1682080 ID     school 1602100 2   JOINT SCHOOL DISTRICT NO. 2 160210000597 524 CHAPARRAL ELEMENTARY   Regular School No 1.0 PK 05 2015   grade_5 90 0 9   1 1     1   4   41 65             32         106 90 0 9   1 1     1   4   41 65         32       106
1682082 ID     school 1602100 2   JOINT SCHOOL DISTRICT NO. 2 160210000597 524 CHAPARRAL ELEMENTARY   Regular School No 1.0 PK 05 2015   kindergarten 65 0 7   0 1     0   4   42 35             22         77 65 0 7   0 1     0   4   42 35         22       77
1682087 ID     school 1602100 2   JOINT SCHOOL DISTRICT NO. 2 160210000595 525 ELIZA HART SPALDING STEM ACADEMY   Regular School No 1.0 PK 05 2015   grade_5 87 0 10   1 2     1   3   54 50             23         104 87 0 10   1 2     1   3   54 50         23       104
1682089 ID     school 1602100 2   JOINT SCHOOL DISTRICT NO. 2 160210000595 525 ELIZA HART SPALDING STEM ACADEMY   Regular School No 1.0 PK 05 2015   kindergarten 101 0 11   2 2     1   6   61 62             23         123 101 0 11   2 2     1   6   61 62         23       123
1682092 ID     school 1602100 2   JOINT SCHOOL DISTRICT NO. 2 160210000601 526 SEVEN OAKS ELEMENTARY   Regular School No 1.0 PK 05 2015   grade_3 53 0 4   0 0     0   3   34 26             8         60 53 0 4   0 0     0   3   34 26         8       60
1682094 ID     school 1602100 2   JOINT SCHOOL DISTRICT NO. 2 160210000601 526 SEVEN OAKS ELEMENTARY   Regular School No 1.0 PK 05 2015   grade_5 54 0 2   0 0     0   3   34 25             *         59 54 0 2   0 0     0   3   34 25                 59
1682096 ID     school 1602100 2   JOINT SCHOOL DISTRICT NO. 2 160210000601 526 SEVEN OAKS ELEMENTARY   Regular School No 1.0 PK 05 2015   kindergarten 54 0 3   0 0     0   0   21 36             *         57 54 0 3   0 0     0   0   21 36                 57
1682110 ID     school 1602100 2   JOINT SCHOOL DISTRICT NO. 2 160210000902 593 PROSPECT ELEMENTARY SCHOOL   Regular School No 1.0 PK 05 2015   grade_2 86 0 13   1 3     0   6   57 52             25         109 86 0 13   1 3     0   6   57 52         25       109
1682115 ID     school 1602100 2   JOINT SCHOOL DISTRICT NO. 2 160210000902 593 PROSPECT ELEMENTARY SCHOOL   Regular School No 1.0 PK 05 2015   kindergarten 88 0 12   0 1     1   2   59 45             19         104 88 0 12   0 1     1   2   59 45         19       104
1682116 ID     school 1602100 2   JOINT SCHOOL DISTRICT NO. 2 160210000931 594 PATHWAYS MIDDLE SCHOOL   Alternative Education School No 2.0 07 08 2015   grade_7 43 0 1   1 0     0   2   36 11             24         47 43 0 1   1 0     0   2   36 11         24       47
1682120 ID     school 1602100 2   JOINT SCHOOL DISTRICT NO. 2 160210000903 597 CENTRAL ACADEMY HIGH SCHOOL   Alternative Education School No 3.0 09 12 2015   grade_11 23 0 4   0 0     0   2   16 13             13         29 23 0 4   0 0     0   2   16 13         13       29
1682121 ID     school 1602100 2   JOINT SCHOOL DISTRICT NO. 2 160210000903 597 CENTRAL ACADEMY HIGH SCHOOL   Alternative Education School No 3.0 09 12 2015   grade_12 33 0 5   0 0     0   0   19 19             16         38 33 0 5   0 0     0   0   19 19         16       38
1682131 ID     school 1602100 2   JOINT SCHOOL DISTRICT NO. 2 160210000989 899 SIENA ELEMENTARY   Regular School No 1.0 PK 07 2015   grade_3 119 0 9   2 1     0   7   70 68             29         138 119 0 9   2 1     0   7   70 68         29       138
1682132 ID     school 1602100 2   JOINT SCHOOL DISTRICT NO. 2 160210000989 899 SIENA ELEMENTARY   Regular School No 1.0 PK 07 2015   grade_4 117 0 11   0 3     0   5   85 51             16         136 117 0 11   0 3     0   5   85 51         16       136
1682135 ID     school 1602100 2   JOINT SCHOOL DISTRICT NO. 2 160210000989 899 SIENA ELEMENTARY   Regular School No 1.0 PK 07 2015   kindergarten 107 0 14   0 3     1   6   81 50             18         131 107 0 14   0 3     1   6   81 50         18       131
1682136 ID     school 1602100 2   JOINT SCHOOL DISTRICT NO. 2 160210000466 982 EAGLE ACADEMY   Alternative Education School No 3.0 09 12 2015   grade_10 28 0 3   0 0     0   1   18 14             22         32 28 0 3   0 0     0   1   18 14         22       32
1682138 ID     school 1602100 2   JOINT SCHOOL DISTRICT NO. 2 160210000466 982 EAGLE ACADEMY   Alternative Education School No 3.0 09 12 2015   grade_12 24 0 6   0 0     0   0   19 11             10         30 24 0 6   0 0     0   0   19 11         10       30
1682139 ID     school 1602100 2   JOINT SCHOOL DISTRICT NO. 2 160210000466 982 EAGLE ACADEMY   Alternative Education School No 3.0 09 12 2015   grade_9 30 0 4   1 0     0   0   24 11             25         35 30 0 4   1 0     0   0   24 11         25       35
1682144 ID     school 1602100 2   JOINT SCHOOL DISTRICT NO. 2 160210000714 1228 MERIDIAN ACADEMY   Alternative Education School No 3.0 09 12 2015   grade_10 34 0 4   0 0     0   1   20 19             26         39 34 0 4   0 0     0   1   20 19         26       39
1682152 ID     school 1602100 2   JOINT SCHOOL DISTRICT NO. 2 160210001000 1235 RENAISSANCE HIGH SCHOOL   Regular School No 3.0 09 12 2015   grade_9 156 0 18   1 10     0   9   69 125             38         194 156 0 18   1 10     0   9   69 125         38       194
1682157 ID     school 1602100 2   JOINT SCHOOL DISTRICT NO. 2 160210000955 1290 PARAMOUNT ELEMENTARY SCHOOL   Regular School No 1.0 PK 05 2015   grade_4 136 0 19   0 2     0   8   70 95             24         165 136 0 19   0 2     0   8   70 95         24       165
1682160 ID     school 1602100 2   JOINT SCHOOL DISTRICT NO. 2 160210000955 1290 PARAMOUNT ELEMENTARY SCHOOL   Regular School No 1.0 PK 05 2015   kindergarten 65 0 3   0 1     0   1   43 27             *         70 65 0 3   0 1     0   1   43 27                 70
1682161 ID     school 1602100 2   JOINT SCHOOL DISTRICT NO. 2 160210001025 1297 REBOUND SCHOOL OF OPPORTUNITY   Alternative Education School No 3.0 07 12 2015   grade_10 15 0 0   0 1     0   0   5 11             *         16 15 0 0   0 1     0   0   5 11                 16
1682162 ID     school 1602100 2   JOINT SCHOOL DISTRICT NO. 2 160210001025 1297 REBOUND SCHOOL OF OPPORTUNITY   Alternative Education School No 3.0 07 12 2015   grade_11 8 0 2   0 1     0   2   9 4             *         13 8 0 2   0 1     0   2   9 4                 13
1682164 ID     school 1602100 2   JOINT SCHOOL DISTRICT NO. 2 160210001025 1297 REBOUND SCHOOL OF OPPORTUNITY   Alternative Education School No 3.0 07 12 2015   grade_8 3 0 0   0 0     0   0   2 1             *         3 3 0 0   0 0     0   0   2 1                 3
1682167 ID     school 1602100 2   JOINT SCHOOL DISTRICT NO. 2 160210001060 1356 WILLOW CREEK ELEMENTARY SCHOOL   Regular School No 1.0 PK 03 2015   grade_1 63 0 4   0 2     0   3   43 29             16         72 63 0 4   0 2     0   3   43 29         16       72
1682169 ID     school 1602100 2   JOINT SCHOOL DISTRICT NO. 2 160210001060 1356 WILLOW CREEK ELEMENTARY SCHOOL   Regular School No 1.0 PK 03 2015   grade_3 57 0 8   0 2     1   3   34 37             18         71 57 0 8   0 2     1   3   34 37         18       71
1682171 ID     school 1602100 2   JOINT SCHOOL DISTRICT NO. 2 160210001060 1356 WILLOW CREEK ELEMENTARY SCHOOL   Regular School No 1.0 PK 03 2015   kindergarten 55 0 11   0 0     0   1   29 38             8         67 55 0 11   0 0     0   1   29 38         8       67
1682172 ID     school 1602100 2   JOINT SCHOOL DISTRICT NO. 2 160210001070 1374 VIRTUAL SCHOOL HOUSE   Regular School No 1.0 PK 08 2015   grade_2 1 0 0   0 0     0   0   1 0             *         1 1 0 0   0 0     0   0   1 0                 1
1682173 ID     school 1602100 2   JOINT SCHOOL DISTRICT NO. 2 160210001070 1374 VIRTUAL SCHOOL HOUSE   Regular School No 1.0 PK 08 2015   grade_5 1 0 0   0 0     0   0   1 0             *         1 1 0 0   0 0     0   0   1 0                 1
1682174 ID     school 1602100 2   JOINT SCHOOL DISTRICT NO. 2 160210001070 1374 VIRTUAL SCHOOL HOUSE   Regular School No 1.0 PK 08 2015   grade_6 1 0 0   0 0     0   0   0 1             *         1 1 0 0   0 0     0   0   0 1                 1
1682175 ID     school 1602100 2   JOINT SCHOOL DISTRICT NO. 2 160210001070 1374 VIRTUAL SCHOOL HOUSE   Regular School No 1.0 PK 08 2015   grade_7 1 0 0   0 0     0   0   1 0             *         1 1 0 0   0 0     0   0   1 0                 1
1682176 ID     school 1602100 2   JOINT SCHOOL DISTRICT NO. 2 160210001070 1374 VIRTUAL SCHOOL HOUSE   Regular School No 1.0 PK 08 2015   k_12_total 5 0 0   0 0     0   0   4 1             *         5 5 0 0   0 0     0   0   4 1                 5
1682177 ID     school 1602100 2   JOINT SCHOOL DISTRICT NO. 2 160210001070 1374 VIRTUAL SCHOOL HOUSE   Regular School No 1.0 PK 08 2015   kindergarten 1 0 0   0 0     0   0   1 0             *         1 1 0 0   0 0     0   0   1 0                 1
1682178 ID     school 1602100 2   JOINT SCHOOL DISTRICT NO. 2 160210001071 1375 IDAHO FINE ARTS ACADEMY   Regular School No 4.0 06 12 2015   grade_10 21 0 1   0 0     0   1   6 17             *         23 21 0 1   0 0     0   1   6 17                 23
1682179 ID     school 1602100 2   JOINT SCHOOL DISTRICT NO. 2 160210001071 1375 IDAHO FINE ARTS ACADEMY   Regular School No 4.0 06 12 2015   grade_11 23 0 1   0 1     1   0   10 16             *         26 23 0 1   0 1     1   0   10 16                 26
1682180 ID     school 1602100 2   JOINT SCHOOL DISTRICT NO. 2 160210001071 1375 IDAHO FINE ARTS ACADEMY   Regular School No 4.0 06 12 2015   grade_12 16 0 0   0 0     0   0   2 14             *         16 16 0 0   0 0     0   0   2 14                 16
1682181 ID     school 1602100 2   JOINT SCHOOL DISTRICT NO. 2 160210001071 1375 IDAHO FINE ARTS ACADEMY   Regular School No 4.0 06 12 2015   grade_6 25 0 2   0 1     0   1   7 22             *         29 25 0 2   0 1     0   1   7 22                 29
1682182 ID     school 1602100 2   JOINT SCHOOL DISTRICT NO. 2 160210001071 1375 IDAHO FINE ARTS ACADEMY   Regular School No 4.0 06 12 2015   grade_7 26 0 1   0 1     0   0   7 21             *         28 26 0 1   0 1     0   0   7 21                 28
1682184 ID     school 1602100 2   JOINT SCHOOL DISTRICT NO. 2 160210001071 1375 IDAHO FINE ARTS ACADEMY   Regular School No 4.0 06 12 2015   grade_9 22 0 0   0 0     0   5   3 24             *         27 22 0 0   0 0     0   5   3 24                 27
1682187 ID     school 1602100 2   JOINT SCHOOL DISTRICT NO. 2 160210000945 2511 GALILEO MAGNET SCHOOL   Regular School No 1.0 PK 08 2015   grade_2 83 0 2   0 1     0   4   47 43             12         90 83 0 2   0 1     0   4   47 43         12       90
1682188 ID     school 1602100 2   JOINT SCHOOL DISTRICT NO. 2 160210000945 2511 GALILEO MAGNET SCHOOL   Regular School No 1.0 PK 08 2015   grade_3 78 0 5   1 2     1   2   54 35             10         89 78 0 5   1 2     1   2   54 35         10       89
1682190 ID     school 1602100 2   JOINT SCHOOL DISTRICT NO. 2 160210000945 2511 GALILEO MAGNET SCHOOL   Regular School No 1.0 PK 08 2015   grade_5 82 0 4   0 0     0   3   48 41             *         89 82 0 4   0 0     0   3   48 41                 89
1682191 ID     school 1602100 2   JOINT SCHOOL DISTRICT NO. 2 160210000945 2511 GALILEO MAGNET SCHOOL   Regular School No 1.0 PK 08 2015   grade_6 65 0 4   1 1     0   3   45 29             13         74 65 0 4   1 1     0   3   45 29         13       74
1682192 ID     school 1602100 2   JOINT SCHOOL DISTRICT NO. 2 160210000945 2511 GALILEO MAGNET SCHOOL   Regular School No 1.0 PK 08 2015   grade_7 60 0 5   1 0     0   1   36 31             6         67 60 0 5   1 0     0   1   36 31         6       67
1682193 ID     school 1602100 2   JOINT SCHOOL DISTRICT NO. 2 160210000945 2511 GALILEO MAGNET SCHOOL   Regular School No 1.0 PK 08 2015   grade_8 55 0 3   0 0     0   2   32 28             *         60 55 0 3   0 0     0   2   32 28                 60
1682195 ID     school 1602100 2   JOINT SCHOOL DISTRICT NO. 2 160210000945 2511 GALILEO MAGNET SCHOOL   Regular School No 1.0 PK 08 2015   kindergarten 79 0 5   0 0     0   1   49 36             *         85 79 0 5   0 0     0   1   49 36                 85
1682209 ID     school 1601770 3   KUNA JOINT DISTRICT 160177000596 345 HUBBARD ELEMENTARY SCHOOL   Regular School No 1.0 PK 03 2015   grade_2 89 0 9   1 0     1   3   57 46             47         103 89 0 9   1 0     1   3   57 46         47       103
1682212 ID     school 1601770 3   KUNA JOINT DISTRICT 160177000596 345 HUBBARD ELEMENTARY SCHOOL   Regular School No 1.0 PK 03 2015   kindergarten 74 0 8   0 0     1   4   42 45             34         87 74 0 8   0 0     1   4   42 45         34       87
1682214 ID     school 1601770 3   KUNA JOINT DISTRICT 160177000904 595 REED ELEMENTARY SCHOOL   Regular School No 1.0 PK 06 2015   grade_2 66 0 26   0 0     0   3   41 54             44         95 66 0 26   0 0     0   3   41 54         44       95
1682217 ID     school 1601770 3   KUNA JOINT DISTRICT 160177000904 595 REED ELEMENTARY SCHOOL   Regular School No 1.0 PK 06 2015   grade_5 66 0 25   1 1     0   5   50 48             52         98 66 0 25   1 1     0   5   50 48         52       98

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