Data source: Big Local News · About: Big Local

4,796 rows where state = "ID" and year = 2019 sorted by black

View and edit SQL

year

  • 2019 · 1,773
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
1305014 ID     school 1600360 1   BOISE INDEPENDENT DISTRICT 160036000590 287 TRAIL WIND ELEMENTARY   Regular School No Elementary PK 6.0 2019   grade_1 50 1 7   0 13     1   3   43 32             8         75 50 1 7   0 13     1   3   43 32         8       75
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
1305018 ID     school 1600360 1   BOISE INDEPENDENT DISTRICT 160036000590 287 TRAIL WIND ELEMENTARY   Regular School No Elementary PK 6.0 2019   grade_5 73 1 8   0 6     2   6   47 49             7         96 73 1 8   0 6     2   6   47 49         7       96
1305029 ID     school 1600360 1   BOISE INDEPENDENT DISTRICT 160036000591 288 SHADOW HILLS ELEMENTARY   Regular School No Elementary PK 6.0 2019   kindergarten 57 1 11   0 1     0   2   36 36             16         72 57 1 11   0 1     0   2   36 36         16       72
1305030 ID     school 1600360 1   BOISE INDEPENDENT DISTRICT 160036000592 300 AMITY ELEMENTARY SCHOOL   Regular School No Elementary PK 6.0 2019   grade_1 63 1 4   0 2     0   0   41 29             16         70 63 1 4   0 2     0   0   41 29         16       70
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
1305038 ID     school 1600360 1   BOISE INDEPENDENT DISTRICT 160036000065 301 MAPLE GROVE ELEMENTARY SCHOOL   Regular School No Elementary PK 6.0 2019   grade_1 48 1 3   1 2     2   5   34 28             21         62 48 1 3   1 2     2   5   34 28         21       62
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
1305064 ID     school 1600360 1   BOISE INDEPENDENT DISTRICT 160036000076 305 WASHINGTON ELEMENTARY SCHOOL   Regular School No Elementary PK 6.0 2019   grade_3 35 1 2   0 0     0   1   14 25             *         39 35 1 2   0 0     0   1   14 25                 39
1305069 ID     school 1600360 1   BOISE INDEPENDENT DISTRICT 160036000076 305 WASHINGTON ELEMENTARY SCHOOL   Regular School No Elementary PK 6.0 2019   kindergarten 29 1 5   0 1     0   1   17 20             *         37 29 1 5   0 1     0   1   17 20                 37
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
1305101 ID     school 1600360 1   BOISE INDEPENDENT DISTRICT 160036000072 309 ROOSEVELT ELEMENTARY SCHOOL   Regular School No Elementary PK 6.0 2019   kindergarten 31 1 6   0 0     0   2   18 22             8         40 31 1 6   0 0     0   2   18 22         8       40
1305102 ID     school 1600360 1   BOISE INDEPENDENT DISTRICT 160036000071 310 PIERCE PARK ELEMENTARY SCHOOL   Regular School No Elementary PK 6.0 2019   grade_1 32 1 7   0 2     0   0   21 21             13         42 32 1 7   0 2     0   0   21 21         13       42
1305106 ID     school 1600360 1   BOISE INDEPENDENT DISTRICT 160036000071 310 PIERCE PARK ELEMENTARY SCHOOL   Regular School No Elementary PK 6.0 2019   grade_5 36 1 5   1 1     1   1   28 18             13         46 36 1 5   1 1     1   1   28 18         13       46
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
1305152 ID     school 1600360 1   BOISE INDEPENDENT DISTRICT 160036000075 320 VALLEY VIEW ELEMENTARY SCHOOL   Regular School No Elementary PK 6.0 2019   grade_3 47 1 7   2 1     0   3   33 28             17         61 47 1 7   2 1     0   3   33 28         17       61
1305155 ID     school 1600360 1   BOISE INDEPENDENT DISTRICT 160036000075 320 VALLEY VIEW ELEMENTARY SCHOOL   Regular School No Elementary PK 6.0 2019   grade_6 51 1 12   0 1     0   3   33 35             21         68 51 1 12   0 1     0   3   33 35         21       68
1305168 ID     school 1600360 1   BOISE INDEPENDENT DISTRICT 160036000068 322 MOUNTAIN VIEW ELEMENTARY SCHOOL   Regular School No Elementary PK 6.0 2019   grade_3 35 1 12   0 0     0   1   20 29             17         49 35 1 12   0 0     0   1   20 29         17       49
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
1305178 ID     school 1600360 1   BOISE INDEPENDENT DISTRICT 160036000062 323 LONGFELLOW ELEMENTARY SCHOOL   Regular School No Elementary PK 6.0 2019   grade_5 41 1 3   0 1     0   4   26 24             6         50 41 1 3   0 1     0   4   26 24         6       50
1305179 ID     school 1600360 1   BOISE INDEPENDENT DISTRICT 160036000062 323 LONGFELLOW ELEMENTARY SCHOOL   Regular School No Elementary PK 6.0 2019   grade_6 46 1 2   0 0     0   2   21 30             *         51 46 1 2   0 0     0   2   21 30                 51
1305221 ID     school 1600360 1   BOISE INDEPENDENT DISTRICT 160036000004 509 RIVERSIDE ELEMENTARY SCHOOL   Regular School No Elementary PK 6.0 2019   kindergarten 43 1 6   0 12     0   7   39 30             5         69 43 1 6   0 12     0   7   39 30         5       69
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
1305236 ID     school 1600360 1   BOISE INDEPENDENT DISTRICT 160036000823 573 TREASURE VALLEY MATH/SCIENCE   Regular School No Other 04 12.0 2019   grade_9 8 1 0   0 5     0   0   10 4             *         14 8 1 0   0 5     0   0   10 4                 14
1305237 ID     school 1600360 1   BOISE INDEPENDENT DISTRICT 160036000823 573 TREASURE VALLEY MATH/SCIENCE   Regular School No Other 04 12.0 2019   k_12_total 62 1 4   0 19     0   4   60 30             *         90 62 1 4   0 19     0   4   60 30                 90
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
1305241 ID     school 1600360 1   BOISE INDEPENDENT DISTRICT 160036000707 665 CYNTHIA MANN ELEMENTARY SCHOOL   Regular School No Elementary PK 6.0 2019   grade_4 33 1 3   1 2     0   1   28 13             11         41 33 1 3   1 2     0   1   28 13         11       41
1305270 ID     school 1600360 1   BOISE INDEPENDENT DISTRICT 160036000984 675 FRANK CHURCH HIGH SCHOOL   Alternative School No High 06 12.0 2019   grade_10 66 1 21   1 1     0   4   48 46             *         94 66 1 21   1 1     0   4   48 46                 94
1305281 ID     school 1600360 1   BOISE INDEPENDENT DISTRICT 160036001002 677 EAST JUNIOR HIGH SCHOOL   Regular School No Middle 07 9.0 2019   grade_7 189 1 15   1 15     1   10   123 109             49         232 189 1 15   1 15     1   10   123 109         49       232
1305285 ID     school 1600360 1   BOISE INDEPENDENT DISTRICT 160036001004 679 HIDDEN SPRINGS ELEMENTARY SCHOOL   Regular School No Elementary PK 6.0 2019   grade_1 32 1 2   0 0     0   2   18 19             *         37 32 1 2   0 0     0   2   18 19                 37
1305287 ID     school 1600360 1   BOISE INDEPENDENT DISTRICT 160036001004 679 HIDDEN SPRINGS ELEMENTARY SCHOOL   Regular School No Elementary PK 6.0 2019   grade_3 45 1 2   0 1     0   4   29 24             *         53 45 1 2   0 1     0   4   29 24                 53
1305319 ID     school 1602100 2   JOINT SCHOOL DISTRICT NO. 2 160210000319 106 EAGLE MIDDLE SCHOOL   Regular School No Middle 06 8.0 2019   grade_7 265 1 20   2 5     2   8   159 144             32         303 265 1 20   2 5     2   8   159 144         32       303
1305349 ID     school 1602100 2   JOINT SCHOOL DISTRICT NO. 2 160210000818 283 PEPPER RIDGE ELEMENTARY   Regular School No Elementary PK 5.0 2019   grade_1 81 1 12   1 0     0   5   56 44             22         100 81 1 12   1 0     0   5   56 44         22       100
1305352 ID     school 1602100 2   JOINT SCHOOL DISTRICT NO. 2 160210000818 283 PEPPER RIDGE ELEMENTARY   Regular School No Elementary PK 5.0 2019   grade_4 76 1 5   0 1     1   2   46 40             19         86 76 1 5   0 1     1   2   46 40         19       86
1305357 ID     school 1602100 2   JOINT SCHOOL DISTRICT NO. 2 160210000819 284 SAWTOOTH MIDDLE SCHOOL   Regular School No Middle 06 8.0 2019   grade_7 288 1 34   1 4     2   10   183 157             66         340 288 1 34   1 4     2   10   183 157         66       340
1305361 ID     school 1602100 2   JOINT SCHOOL DISTRICT NO. 2 160210000824 296 HUNTER ELEMENTARY SCHOOL   Regular School No Elementary PK 5.0 2019   grade_2 107 1 15   0 1     0   2   61 65             20         126 107 1 15   0 1     0   2   61 65         20       126
1305362 ID     school 1602100 2   JOINT SCHOOL DISTRICT NO. 2 160210000824 296 HUNTER ELEMENTARY SCHOOL   Regular School No Elementary PK 5.0 2019   grade_3 117 1 13   0 2     0   6   74 65             14         139 117 1 13   0 2     0   6   74 65         14       139
1305363 ID     school 1602100 2   JOINT SCHOOL DISTRICT NO. 2 160210000824 296 HUNTER ELEMENTARY SCHOOL   Regular School No Elementary PK 5.0 2019   grade_4 122 1 11   0 3     2   6   80 65             23         145 122 1 11   0 3     2   6   80 65         23       145
1305375 ID     school 1602100 2   JOINT SCHOOL DISTRICT NO. 2 160210000717 329 CHIEF JOSEPH SCHOOL OF THE ARTS   Regular School No Elementary PK 5.0 2019   grade_2 60 1 14   0 1     0   3   35 44             28         79 60 1 14   0 1     0   3   35 44         28       79
1305376 ID     school 1602100 2   JOINT SCHOOL DISTRICT NO. 2 160210000717 329 CHIEF JOSEPH SCHOOL OF THE ARTS   Regular School No Elementary PK 5.0 2019   grade_3 63 1 17   0 1     1   2   36 49             43         85 63 1 17   0 1     1   2   36 49         43       85
1305381 ID     school 1602100 2   JOINT SCHOOL DISTRICT NO. 2 160210000640 330 SILVER SAGE ELEMENTARY SCHOOL   Regular School No Elementary PK 5.0 2019   grade_1 43 1 3   0 1     1   4   28 25             15         53 43 1 3   0 1     1   4   28 25         15       53
1305382 ID     school 1602100 2   JOINT SCHOOL DISTRICT NO. 2 160210000640 330 SILVER SAGE ELEMENTARY SCHOOL   Regular School No Elementary PK 5.0 2019   grade_2 35 1 6   0 1     1   5   30 19             17         49 35 1 6   0 1     1   5   30 19         17       49
1305387 ID     school 1602100 2   JOINT SCHOOL DISTRICT NO. 2 160210000640 330 SILVER SAGE ELEMENTARY SCHOOL   Regular School No Elementary PK 5.0 2019   kindergarten 27 1 5   0 1     0   1   20 15             12         35 27 1 5   0 1     0   1   20 15         12       35
1305390 ID     school 1602100 2   JOINT SCHOOL DISTRICT NO. 2 160210000365 331 LAKE HAZEL ELEMENTARY SCHOOL   Regular School No Elementary PK 5.0 2019   grade_3 57 1 9   0 3     2   4   35 41             29         76 57 1 9   0 3     2   4   35 41         29       76
1305391 ID     school 1602100 2   JOINT SCHOOL DISTRICT NO. 2 160210000365 331 LAKE HAZEL ELEMENTARY SCHOOL   Regular School No Elementary PK 5.0 2019   grade_4 71 1 7   0 1     0   5   48 37             23         85 71 1 7   0 1     0   5   48 37         23       85
1305392 ID     school 1602100 2   JOINT SCHOOL DISTRICT NO. 2 160210000365 331 LAKE HAZEL ELEMENTARY SCHOOL   Regular School No Elementary PK 5.0 2019   grade_5 55 1 9   0 4     0   4   33 40             19         73 55 1 9   0 4     0   4   33 40         19       73
1305419 ID     school 1602100 2   JOINT SCHOOL DISTRICT NO. 2 160210000374 335 USTICK ELEMENTARY SCHOOL   Regular School No Elementary PK 5.0 2019   grade_4 60 1 18   0 9     0   5   47 46             57         93 60 1 18   0 9     0   5   47 46         57       93
1305423 ID     school 1602100 2   JOINT SCHOOL DISTRICT NO. 2 160210000371 336 MERIDIAN ELEMENTARY SCHOOL   Regular School No Elementary PK 5.0 2019   grade_1 55 1 11   1 0     1   3   42 30             *         72 55 1 11   1 0     1   3   42 30                 72
1305431 ID     school 1602100 2   JOINT SCHOOL DISTRICT NO. 2 160210000363 337 McMillan Elementary   Regular School No Elementary PK 5.0 2019   grade_2 26 1 7   0 1     0   2   12 25             17         37 26 1 7   0 1     0   2   12 25         17       37
1305434 ID     school 1602100 2   JOINT SCHOOL DISTRICT NO. 2 160210000363 337 McMillan Elementary   Regular School No Elementary PK 5.0 2019   grade_5 30 1 15   0 1     0   1   23 25             25         48 30 1 15   0 1     0   1   23 25         25       48
1305438 ID     school 1602100 2   JOINT SCHOOL DISTRICT NO. 2 160210000366 338 CHRISTINE DONNELL SCHOOL OF THE ARTS   Regular School No Elementary PK 6.0 2019   grade_2 66 1 5   0 0     1   11   40 44             18         84 66 1 5   0 0     1   11   40 44         18       84
1305443 ID     school 1602100 2   JOINT SCHOOL DISTRICT NO. 2 160210000366 338 CHRISTINE DONNELL SCHOOL OF THE ARTS   Regular School No Elementary PK 6.0 2019   k_12_total 432 1 31   3 6     4   35   220 292             103         512 432 1 31   3 6     4   35   220 292         103       512
1305446 ID     school 1602100 2   JOINT SCHOOL DISTRICT NO. 2 160210000639 339 BARBARA MORGAN STEM ACADEMY   Regular School No Elementary KG 5.0 2019   grade_2 59 1 14   0 0     0   1   41 34             23         75 59 1 14   0 0     0   1   41 34         23       75
1305448 ID     school 1602100 2   JOINT SCHOOL DISTRICT NO. 2 160210000639 339 BARBARA MORGAN STEM ACADEMY   Regular School No Elementary KG 5.0 2019   grade_4 60 1 18   1 1     0   3   43 41             26         84 60 1 18   1 1     0   3   43 41         26       84
1305455 ID     school 1602100 2   JOINT SCHOOL DISTRICT NO. 2 160210000624 340 EAGLE HILLS ELEMENTARY SCHOOL   Regular School No Elementary PK 5.0 2019   grade_4 93 1 9   0 0     0   2   58 47             14         105 93 1 9   0 0     0   2   58 47         14       105
1305457 ID     school 1602100 2   JOINT SCHOOL DISTRICT NO. 2 160210000624 340 EAGLE HILLS ELEMENTARY SCHOOL   Regular School No Elementary PK 5.0 2019   k_12_total 502 1 53   3 7     1   18   291 294             87         585 502 1 53   3 7     1   18   291 294         87       585
1305462 ID     school 1602100 2   JOINT SCHOOL DISTRICT NO. 2 160210000368 341 MARY MCPHERSON ELEMENTARY   Regular School No Elementary PK 5.0 2019   grade_4 72 1 6   0 4     1   5   50 39             13         89 72 1 6   0 4     1   5   50 39         13       89
1305463 ID     school 1602100 2   JOINT SCHOOL DISTRICT NO. 2 160210000368 341 MARY MCPHERSON ELEMENTARY   Regular School No Elementary PK 5.0 2019   grade_5 73 1 11   0 1     0   5   42 49             10         91 73 1 11   0 1     0   5   42 49         10       91
1305465 ID     school 1602100 2   JOINT SCHOOL DISTRICT NO. 2 160210000368 341 MARY MCPHERSON ELEMENTARY   Regular School No Elementary PK 5.0 2019   kindergarten 68 1 10   1 0     0   1   50 31             9         81 68 1 10   1 0     0   1   50 31         9       81
1305469 ID     school 1602100 2   JOINT SCHOOL DISTRICT NO. 2 160210000598 343 JOPLIN ELEMENTARY SCHOOL   Regular School No Elementary PK 5.0 2019   grade_4 54 1 9   0 0     0   3   36 31             11         67 54 1 9   0 0     0   3   36 31         11       67
1305474 ID     school 1602100 2   JOINT SCHOOL DISTRICT NO. 2 160210000770 504 PONDEROSA ELEMENTARY SCHOOL   Regular School No Elementary PK 5.0 2019   grade_2 86 1 14   1 1     0   3   48 58             32         106 86 1 14   1 1     0   3   48 58         32       106
1305480 ID     school 1602100 2   JOINT SCHOOL DISTRICT NO. 2 160210000010 507 PIONEER SCHOOL OF THE ARTS   Regular School No Elementary PK 5.0 2019   grade_1 107 1 2   0 3     0   10   66 57             20         123 107 1 2   0 3     0   10   66 57         20       123
1305482 ID     school 1602100 2   JOINT SCHOOL DISTRICT NO. 2 160210000010 507 PIONEER SCHOOL OF THE ARTS   Regular School No Elementary PK 5.0 2019   grade_3 101 1 8   0 2     0   6   49 69             16         118 101 1 8   0 2     0   6   49 69         16       118
1305495 ID     school 1602100 2   JOINT SCHOOL DISTRICT NO. 2 160210000593 523 CECIL D ANDRUS ELEMENTARY   Regular School No Elementary PK 5.0 2019   grade_2 85 1 3   0 4     0   5   56 42             15         98 85 1 3   0 4     0   5   56 42         15       98
1305501 ID     school 1602100 2   JOINT SCHOOL DISTRICT NO. 2 160210000597 524 CHAPARRAL ELEMENTARY   Regular School No Elementary PK 5.0 2019   grade_1 63 1 5   0 1     0   4   34 40             24         74 63 1 5   0 1     0   4   34 40         24       74
1305504 ID     school 1602100 2   JOINT SCHOOL DISTRICT NO. 2 160210000597 524 CHAPARRAL ELEMENTARY   Regular School No Elementary PK 5.0 2019   grade_4 52 1 6   1 0     0   3   33 30             13         63 52 1 6   1 0     0   3   33 30         13       63
1305507 ID     school 1602100 2   JOINT SCHOOL DISTRICT NO. 2 160210000597 524 CHAPARRAL ELEMENTARY   Regular School No Elementary PK 5.0 2019   kindergarten 84 1 9   0 1     1   3   49 50             23         99 84 1 9   0 1     1   3   49 50         23       99
1305508 ID     school 1602100 2   JOINT SCHOOL DISTRICT NO. 2 160210000595 525 ELIZA HART SPALDING STEM ACADEMY   Regular School No Elementary PK 5.0 2019   grade_1 105 1 7   1 1     0   5   65 55             28         120 105 1 7   1 1     0   5   65 55         28       120
1305515 ID     school 1602100 2   JOINT SCHOOL DISTRICT NO. 2 160210000601 526 SEVEN OAKS ELEMENTARY   Regular School No Elementary PK 5.0 2019   grade_1 43 1 9   1 3     1   0   28 30             10         58 43 1 9   1 3     1   0   28 30         10       58
1305516 ID     school 1602100 2   JOINT SCHOOL DISTRICT NO. 2 160210000601 526 SEVEN OAKS ELEMENTARY   Regular School No Elementary PK 5.0 2019   grade_2 56 1 10   1 1     0   0   36 33             11         69 56 1 10   1 1     0   0   36 33         11       69
1305517 ID     school 1602100 2   JOINT SCHOOL DISTRICT NO. 2 160210000601 526 SEVEN OAKS ELEMENTARY   Regular School No Elementary PK 5.0 2019   grade_3 58 1 13   1 1     0   1   48 27             11         75 58 1 13   1 1     0   1   48 27         11       75
1305518 ID     school 1602100 2   JOINT SCHOOL DISTRICT NO. 2 160210000601 526 SEVEN OAKS ELEMENTARY   Regular School No Elementary PK 5.0 2019   grade_4 68 1 8   0 3     0   1   40 41             13         81 68 1 8   0 3     0   1   40 41         13       81
1305536 ID     school 1602100 2   JOINT SCHOOL DISTRICT NO. 2 160210000902 593 PROSPECT ELEMENTARY SCHOOL   Regular School No Elementary PK 5.0 2019   grade_3 110 1 8   0 5     1   5   78 52             31         130 110 1 8   0 5     1   5   78 52         31       130
1305538 ID     school 1602100 2   JOINT SCHOOL DISTRICT NO. 2 160210000902 593 PROSPECT ELEMENTARY SCHOOL   Regular School No Elementary PK 5.0 2019   grade_5 110 1 17   1 2     0   7   72 66             23         138 110 1 17   1 2     0   7   72 66         23       138
1305541 ID     school 1602100 2   JOINT SCHOOL DISTRICT NO. 2 160210000931 594 PATHWAYS MIDDLE SCHOOL   Alternative School No Middle 06 8.0 2019   grade_6 26 1 0   0 0     0   3   22 8             *         30 26 1 0   0 0     0   3   22 8                 30
1305544 ID     school 1602100 2   JOINT SCHOOL DISTRICT NO. 2 160210000931 594 PATHWAYS MIDDLE SCHOOL   Alternative School No Middle 06 8.0 2019   k_12_total 143 1 6   0 3     0   6   101 58             51         159 143 1 6   0 3     0   6   101 58         51       159
1305555 ID     school 1602100 2   JOINT SCHOOL DISTRICT NO. 2 160210000989 899 SIENA ELEMENTARY   Regular School No Elementary PK 5.0 2019   grade_1 87 1 5   0 4     0   2   45 54             13         99 87 1 5   0 4     0   2   45 54         13       99
1305564 ID     school 1602100 2   JOINT SCHOOL DISTRICT NO. 2 160210000466 982 EAGLE ACADEMY   Alternative School No High 09 12.0 2019   grade_12 49 1 5   1 0     0   2   38 20             *         58 49 1 5   1 0     0   2   38 20                 58
1305565 ID     school 1602100 2   JOINT SCHOOL DISTRICT NO. 2 160210000466 982 EAGLE ACADEMY   Alternative School No High 09 12.0 2019   grade_9 19 1 2   0 0     0   0   12 10             11         22 19 1 2   0 0     0   0   12 10         11       22
1305567 ID     school 1602100 2   JOINT SCHOOL DISTRICT NO. 2 160210000602 1145 CROSSROADS MIDDLE SCHOOL   Alternative School No Middle 06 8.0 2019   grade_6 27 1 2   0 0     0   1   15 16             20         31 27 1 2   0 0     0   1   15 16         20       31
1305569 ID     school 1602100 2   JOINT SCHOOL DISTRICT NO. 2 160210000602 1145 CROSSROADS MIDDLE SCHOOL   Alternative School No Middle 06 8.0 2019   grade_8 46 1 9   1 2     0   2   37 24             33         61 46 1 9   1 2     0   2   37 24         33       61
1305583 ID     school 1602100 2   JOINT SCHOOL DISTRICT NO. 2 160210000955 1290 PARAMOUNT ELEMENTARY SCHOOL   Regular School No Elementary PK 5.0 2019   grade_3 78 1 4   0 0     1   0   39 45             *         84 78 1 4   0 0     1   0   39 45                 84
1305584 ID     school 1602100 2   JOINT SCHOOL DISTRICT NO. 2 160210000955 1290 PARAMOUNT ELEMENTARY SCHOOL   Regular School No Elementary PK 5.0 2019   grade_4 98 1 2   0 2     1   2   58 48             *         106 98 1 2   0 2     1   2   58 48                 106
1305589 ID     school 1602100 2   JOINT SCHOOL DISTRICT NO. 2 160210001025 1297 REBOUND SCHOOL OF OPPORTUNITY   Alternative School No High 06 12.0 2019   grade_11 23 1 5   0 0     0   0   16 13             *         29 23 1 5   0 0     0   0   16 13                 29
1305592 ID     school 1602100 2   JOINT SCHOOL DISTRICT NO. 2 160210001025 1297 REBOUND SCHOOL OF OPPORTUNITY   Alternative School No High 06 12.0 2019   grade_9 8 1 1   0 0     0   1   2 9             *         11 8 1 1   0 0     0   1   2 9                 11
1305594 ID     school 1602100 2   JOINT SCHOOL DISTRICT NO. 2 160210001060 1356 WILLOW CREEK ELEMENTARY SCHOOL   Regular School No Elementary PK 5.0 2019   grade_1 83 1 9   0 2     0   1   60 36             15         96 83 1 9   0 2     0   1   60 36         15       96
1305597 ID     school 1602100 2   JOINT SCHOOL DISTRICT NO. 2 160210001060 1356 WILLOW CREEK ELEMENTARY SCHOOL   Regular School No Elementary PK 5.0 2019   grade_4 106 1 15   0 0     1   5   66 62             16         128 106 1 15   0 0     1   5   66 62         16       128
1305603 ID     school 1602100 2   JOINT SCHOOL DISTRICT NO. 2 160210001071 1375 IDAHO FINE ARTS ACADEMY   Regular School No High 06 12.0 2019   grade_12 21 1 1   0 1     0   0   8 16             *         24 21 1 1   0 1     0   0   8 16                 24
1305608 ID     school 1602100 2   JOINT SCHOOL DISTRICT NO. 2 160210001071 1375 IDAHO FINE ARTS ACADEMY   Regular School No High 06 12.0 2019   k_12_total 168 1 15   1 3     1   5   43 151             20         194 168 1 15   1 3     1   5   43 151         20       194
1305609 ID     school 1602100 2   JOINT SCHOOL DISTRICT NO. 2 160210001081 1383 HILLSDALE ELEMENTARY   Regular School No Elementary PK 5.0 2019   grade_1 110 1 3   2 1     0   6   64 59             16         123 110 1 3   2 1     0   6   64 59         16       123
1305610 ID     school 1602100 2   JOINT SCHOOL DISTRICT NO. 2 160210001081 1383 HILLSDALE ELEMENTARY   Regular School No Elementary PK 5.0 2019   grade_2 88 1 10   0 0     0   10   55 54             16         109 88 1 10   0 0     0   10   55 54         16       109
1305620 ID     school 1602100 2   JOINT SCHOOL DISTRICT NO. 2 160210001104 1406 STAR MIDDLE SCHOOL   Regular School No Middle 06 8.0 2019   grade_6 182 1 16   0 2     1   3   107 98             38         205 182 1 16   0 2     1   3   107 98         38       205
1305625 ID     school 1602100 2   JOINT SCHOOL DISTRICT NO. 2 160210000945 2511 GALILEO MAGNET SCHOOL   Regular School No Elementary PK 8.0 2019   grade_2 82 1 12   0 1     0   0   45 51             5         96 82 1 12   0 1     0   0   45 51         5       96
1305628 ID     school 1602100 2   JOINT SCHOOL DISTRICT NO. 2 160210000945 2511 GALILEO MAGNET SCHOOL   Regular School No Elementary PK 8.0 2019   grade_5 83 1 8   1 0     0   3   57 39             7         96 83 1 8   1 0     0   3   57 39         7       96
1305638 ID     school 1601770 3   KUNA JOINT DISTRICT 160177000306 13 KUNA MIDDLE SCHOOL   Regular School No Middle 06 8.0 2019   grade_6 249 1 49   0 1     0   13   161 152             121         313 249 1 49   0 1     0   13   161 152         121       313
1305649 ID     school 1601770 3   KUNA JOINT DISTRICT 160177000596 345 HUBBARD ELEMENTARY SCHOOL   Regular School No Elementary PK 5.0 2019   grade_3 46 1 6   0 1     0   0   33 21             25         54 46 1 6   0 1     0   0   33 21         25       54
1305651 ID     school 1601770 3   KUNA JOINT DISTRICT 160177000596 345 HUBBARD ELEMENTARY SCHOOL   Regular School No Elementary PK 5.0 2019   kindergarten 50 1 7   0 1     0   0   28 31             38         59 50 1 7   0 1     0   0   28 31         38       59
1305652 ID     school 1601770 3   KUNA JOINT DISTRICT 160177000904 595 REED ELEMENTARY SCHOOL   Regular School No Elementary PK 5.0 2019   grade_1 71 1 26   1 0     0   2   48 53             47         101 71 1 26   1 0     0   2   48 53         47       101
1305656 ID     school 1601770 3   KUNA JOINT DISTRICT 160177000904 595 REED ELEMENTARY SCHOOL   Regular School No Elementary PK 5.0 2019   grade_5 58 1 26   1 1     0   6   42 51             47         93 58 1 26   1 1     0   6   42 51         47       93
1305664 ID     school 1601770 3   KUNA JOINT DISTRICT 160177000915 635 ROSS ELEMENTARY SCHOOL   Regular School No Elementary 04 5.0 2019   grade_4 101 1 18   1 0     1   4   58 68             55         126 101 1 18   1 0     1   4   58 68         55       126

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