Data source: Big Local News · About: Big Local

4,725 rows where state = "ID" and year = 2017 sorted by black_int

View and edit SQL

grade

year

  • 2017 · 4,625
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
1725997 ID     school 1602100 2   JOINT SCHOOL DISTRICT NO. 2 160210000362 332 EAGLE ELEMENTARY SCHOOL OF THE ARTS   Regular School No Elementary PK 5.0 2017   kindergarten 53 0 11   1 0     0   4   27 42             14         69 53 0 11   1 0     0   4   27 42         14       69
1725998 ID     school 1602100 2   JOINT SCHOOL DISTRICT NO. 2 160210000364 333 SUMMERWIND SCHOOL OF MATH AND SCIENCE   Regular School No Elementary PK 5.0 2017   grade_1 50 0 11   1 2     1   3   30 38             28         68 50 0 11   1 2     1   3   30 38         28       68
1725999 ID     school 1602100 2   JOINT SCHOOL DISTRICT NO. 2 160210000364 333 SUMMERWIND SCHOOL OF MATH AND SCIENCE   Regular School No Elementary PK 5.0 2017   grade_2 63 0 3   1 0     0   6   42 31             35         73 63 0 3   1 0     0   6   42 31         35       73
1726002 ID     school 1602100 2   JOINT SCHOOL DISTRICT NO. 2 160210000364 333 SUMMERWIND SCHOOL OF MATH AND SCIENCE   Regular School No Elementary PK 5.0 2017   grade_5 47 0 15   0 1     0   5   37 31             38         68 47 0 15   0 1     0   5   37 31         38       68
1726004 ID     school 1602100 2   JOINT SCHOOL DISTRICT NO. 2 160210000364 333 SUMMERWIND SCHOOL OF MATH AND SCIENCE   Regular School No Elementary PK 5.0 2017   kindergarten 75 0 13   1 3     0   3   56 39             29         95 75 0 13   1 3     0   3   56 39         29       95
1726007 ID     school 1602100 2   JOINT SCHOOL DISTRICT NO. 2 160210000373 334 STAR ELEMENTARY SCHOOL   Regular School No Elementary PK 5.0 2017   grade_3 61 0 6   1 1     0   6   39 36             26         75 61 0 6   1 1     0   6   39 36         26       75
1726011 ID     school 1602100 2   JOINT SCHOOL DISTRICT NO. 2 160210000373 334 STAR ELEMENTARY SCHOOL   Regular School No Elementary PK 5.0 2017   kindergarten 55 0 5   1 1     0   2   31 33             15         64 55 0 5   1 1     0   2   31 33         15       64
1726013 ID     school 1602100 2   JOINT SCHOOL DISTRICT NO. 2 160210000374 335 USTICK ELEMENTARY SCHOOL   Regular School No Elementary PK 5.0 2017   grade_2 44 0 19   0 6     0   3   38 34             *         72 44 0 19   0 6     0   3   38 34                 72
1726033 ID     school 1602100 2   JOINT SCHOOL DISTRICT NO. 2 160210000366 338 CHRISTINE DONNELL SCHOOL OF THE ARTS   Regular School No Elementary PK 6.0 2017   grade_1 61 0 4   1 3     1   2   28 44             13         72 61 0 4   1 3     1   2   28 44         13       72
1726034 ID     school 1602100 2   JOINT SCHOOL DISTRICT NO. 2 160210000366 338 CHRISTINE DONNELL SCHOOL OF THE ARTS   Regular School No Elementary PK 6.0 2017   grade_2 70 0 7   1 0     0   8   41 45             14         86 70 0 7   1 0     0   8   41 45         14       86
1726035 ID     school 1602100 2   JOINT SCHOOL DISTRICT NO. 2 160210000366 338 CHRISTINE DONNELL SCHOOL OF THE ARTS   Regular School No Elementary PK 6.0 2017   grade_3 83 0 7   1 1     1   3   39 57             27         96 83 0 7   1 1     1   3   39 57         27       96
1726037 ID     school 1602100 2   JOINT SCHOOL DISTRICT NO. 2 160210000366 338 CHRISTINE DONNELL SCHOOL OF THE ARTS   Regular School No Elementary PK 6.0 2017   grade_5 84 0 6   0 3     0   3   43 53             22         96 84 0 6   0 3     0   3   43 53         22       96
1726038 ID     school 1602100 2   JOINT SCHOOL DISTRICT NO. 2 160210000366 338 CHRISTINE DONNELL SCHOOL OF THE ARTS   Regular School No Elementary PK 6.0 2017   grade_6 26 0 7   0 1     0   2   19 17             12         36 26 0 7   0 1     0   2   19 17         12       36
1726040 ID     school 1602100 2   JOINT SCHOOL DISTRICT NO. 2 160210000366 338 CHRISTINE DONNELL SCHOOL OF THE ARTS   Regular School No Elementary PK 6.0 2017   kindergarten 58 0 5   1 0     1   6   37 34             11         71 58 0 5   1 0     1   6   37 34         11       71
1726043 ID     school 1602100 2   JOINT SCHOOL DISTRICT NO. 2 160210000639 339 BARBARA MORGAN STEM ACADEMY   Regular School No Elementary KG 5.0 2017   grade_3 68 0 6   0 2     0   2   42 36             22         78 68 0 6   0 2     0   2   42 36         22       78
1726044 ID     school 1602100 2   JOINT SCHOOL DISTRICT NO. 2 160210000639 339 BARBARA MORGAN STEM ACADEMY   Regular School No Elementary KG 5.0 2017   grade_4 56 0 18   1 1     0   4   51 29             36         80 56 0 18   1 1     0   4   51 29         36       80
1726045 ID     school 1602100 2   JOINT SCHOOL DISTRICT NO. 2 160210000639 339 BARBARA MORGAN STEM ACADEMY   Regular School No Elementary KG 5.0 2017   grade_5 49 0 17   0 3     0   4   45 28             35         73 49 0 17   0 3     0   4   45 28         35       73
1726050 ID     school 1602100 2   JOINT SCHOOL DISTRICT NO. 2 160210000624 340 EAGLE HILLS ELEMENTARY SCHOOL   Regular School No Elementary PK 5.0 2017   grade_3 83 0 3   1 1     0   8   54 42             17         96 83 0 3   1 1     0   8   54 42         17       96
1726054 ID     school 1602100 2   JOINT SCHOOL DISTRICT NO. 2 160210000624 340 EAGLE HILLS ELEMENTARY SCHOOL   Regular School No Elementary PK 5.0 2017   kindergarten 63 0 8   0 0     1   1   43 30             16         73 63 0 8   0 0     1   1   43 30         16       73
1726061 ID     school 1602100 2   JOINT SCHOOL DISTRICT NO. 2 160210000368 341 MARY MCPHERSON ELEMENTARY   Regular School No Elementary PK 5.0 2017   kindergarten 59 0 10   0 0     0   6   42 33             16         75 59 0 10   0 0     0   6   42 33         16       75
1726062 ID     school 1602100 2   JOINT SCHOOL DISTRICT NO. 2 160210000598 343 JOPLIN ELEMENTARY SCHOOL   Regular School No Elementary PK 5.0 2017   grade_1 47 0 5   1 2     0   2   23 34             23         57 47 0 5   1 2     0   2   23 34         23       57
1726066 ID     school 1602100 2   JOINT SCHOOL DISTRICT NO. 2 160210000598 343 JOPLIN ELEMENTARY SCHOOL   Regular School No Elementary PK 5.0 2017   grade_5 55 0 3   0 0     0   6   37 27             25         64 55 0 3   0 0     0   6   37 27         25       64
1726068 ID     school 1602100 2   JOINT SCHOOL DISTRICT NO. 2 160210000598 343 JOPLIN ELEMENTARY SCHOOL   Regular School No Elementary PK 5.0 2017   kindergarten 42 0 4   0 3     0   2   25 26             17         51 42 0 4   0 3     0   2   25 26         17       51
1726069 ID     school 1602100 2   JOINT SCHOOL DISTRICT NO. 2 160210000770 504 PONDEROSA ELEMENTARY SCHOOL   Regular School No Elementary PK 5.0 2017   grade_1 79 0 9   1 0     0   5   48 46             37         94 79 0 9   1 0     0   5   48 46         37       94
1726078 ID     school 1602100 2   JOINT SCHOOL DISTRICT NO. 2 160210000010 507 PIONEER SCHOOL OF THE ARTS   Regular School No Elementary PK 5.0 2017   grade_3 104 0 7   1 1     1   3   48 69             29         117 104 0 7   1 1     1   3   48 69         29       117
1726083 ID     school 1602100 2   JOINT SCHOOL DISTRICT NO. 2 160210000801 521 DISCOVERY ELEMENTARY SCHOOL   Regular School No Elementary PK 5.0 2017   grade_1 67 0 7   1 2     0   2   40 39             15         79 67 0 7   1 2     0   2   40 39         15       79
1726084 ID     school 1602100 2   JOINT SCHOOL DISTRICT NO. 2 160210000801 521 DISCOVERY ELEMENTARY SCHOOL   Regular School No Elementary PK 5.0 2017   grade_2 69 0 9   2 2     1   3   51 35             16         86 69 0 9   2 2     1   3   51 35         16       86
1726087 ID     school 1602100 2   JOINT SCHOOL DISTRICT NO. 2 160210000801 521 DISCOVERY ELEMENTARY SCHOOL   Regular School No Elementary PK 5.0 2017   grade_5 96 0 14   0 4     0   5   59 60             22         119 96 0 14   0 4     0   5   59 60         22       119
1726091 ID     school 1602100 2   JOINT SCHOOL DISTRICT NO. 2 160210000593 523 CECIL D ANDRUS ELEMENTARY   Regular School No Elementary PK 5.0 2017   grade_2 90 0 6   2 2     1   1   52 50             21         102 90 0 6   2 2     1   1   52 50         21       102
1726094 ID     school 1602100 2   JOINT SCHOOL DISTRICT NO. 2 160210000593 523 CECIL D ANDRUS ELEMENTARY   Regular School No Elementary PK 5.0 2017   grade_5 106 0 11   0 4     0   6   81 46             17         127 106 0 11   0 4     0   6   81 46         17       127
1726097 ID     school 1602100 2   JOINT SCHOOL DISTRICT NO. 2 160210000597 524 CHAPARRAL ELEMENTARY   Regular School No Elementary PK 5.0 2017   grade_1 64 0 12   0 1     1   3   44 37             26         81 64 0 12   0 1     1   3   44 37         26       81
1726099 ID     school 1602100 2   JOINT SCHOOL DISTRICT NO. 2 160210000597 524 CHAPARRAL ELEMENTARY   Regular School No Elementary PK 5.0 2017   grade_3 71 0 13   0 0     1   1   39 47             32         86 71 0 13   0 0     1   1   39 47         32       86
1726100 ID     school 1602100 2   JOINT SCHOOL DISTRICT NO. 2 160210000597 524 CHAPARRAL ELEMENTARY   Regular School No Elementary PK 5.0 2017   grade_4 63 0 12   0 2     0   2   30 49             20         79 63 0 12   0 2     0   2   30 49         20       79
1726101 ID     school 1602100 2   JOINT SCHOOL DISTRICT NO. 2 160210000597 524 CHAPARRAL ELEMENTARY   Regular School No Elementary PK 5.0 2017   grade_5 72 0 8   1 1     1   0   37 46             22         83 72 0 8   1 1     1   0   37 46         22       83
1726103 ID     school 1602100 2   JOINT SCHOOL DISTRICT NO. 2 160210000597 524 CHAPARRAL ELEMENTARY   Regular School No Elementary PK 5.0 2017   kindergarten 85 0 10   0 1     0   1   44 53             26         97 85 0 10   0 1     0   1   44 53         26       97
1726105 ID     school 1602100 2   JOINT SCHOOL DISTRICT NO. 2 160210000595 525 ELIZA HART SPALDING STEM ACADEMY   Regular School No Elementary PK 5.0 2017   grade_2 102 0 12   2 2     0   7   68 57             29         125 102 0 12   2 2     0   7   68 57         29       125
1726111 ID     school 1602100 2   JOINT SCHOOL DISTRICT NO. 2 160210000601 526 SEVEN OAKS ELEMENTARY   Regular School No Elementary PK 5.0 2017   grade_1 51 0 8   0 1     0   1   40 21             12         61 51 0 8   0 1     0   1   40 21         12       61
1726112 ID     school 1602100 2   JOINT SCHOOL DISTRICT NO. 2 160210000601 526 SEVEN OAKS ELEMENTARY   Regular School No Elementary PK 5.0 2017   grade_2 70 0 4   0 0     0   1   34 41             8         75 70 0 4   0 0     0   1   34 41         8       75
1726115 ID     school 1602100 2   JOINT SCHOOL DISTRICT NO. 2 160210000601 526 SEVEN OAKS ELEMENTARY   Regular School No Elementary PK 5.0 2017   grade_5 52 0 6   0 0     1   3   31 31             9         62 52 0 6   0 0     1   3   31 31         9       62
1726117 ID     school 1602100 2   JOINT SCHOOL DISTRICT NO. 2 160210000601 526 SEVEN OAKS ELEMENTARY   Regular School No Elementary PK 5.0 2017   kindergarten 50 0 7   0 0     0   0   35 22             6         57 50 0 7   0 0     0   0   35 22         6       57
1726138 ID     school 1602100 2   JOINT SCHOOL DISTRICT NO. 2 160210000931 594 PATHWAYS MIDDLE SCHOOL   Alternative School No Middle 07 8.0 2017   grade_8 72 0 2   1 0     0   5   56 24             30         80 72 0 2   1 0     0   5   56 24         30       80
1726143 ID     school 1602100 2   JOINT SCHOOL DISTRICT NO. 2 160210000903 597 CENTRAL ACADEMY HIGH SCHOOL   Alternative School No High 09 12.0 2017   grade_9 18 0 3   1 1     0   1   13 11             13         24 18 0 3   1 1     0   1   13 11         13       24
1726150 ID     school 1602100 2   JOINT SCHOOL DISTRICT NO. 2 160210000989 899 SIENA ELEMENTARY   Regular School No Elementary PK 5.0 2017   grade_1 80 0 11   1 3     0   1   52 44             9         96 80 0 11   1 3     0   1   52 44         9       96
1726151 ID     school 1602100 2   JOINT SCHOOL DISTRICT NO. 2 160210000989 899 SIENA ELEMENTARY   Regular School No Elementary PK 5.0 2017   grade_2 96 0 10   0 4     0   4   67 47             15         114 96 0 10   0 4     0   4   67 47         15       114
1726156 ID     school 1602100 2   JOINT SCHOOL DISTRICT NO. 2 160210000989 899 SIENA ELEMENTARY   Regular School No Elementary PK 5.0 2017   kindergarten 65 0 15   0 3     0   4   43 44             6         87 65 0 15   0 3     0   4   43 44         6       87
1726157 ID     school 1602100 2   JOINT SCHOOL DISTRICT NO. 2 160210000466 982 EAGLE ACADEMY   Alternative School No High 09 12.0 2017   grade_10 28 0 1   2 0     0   1   16 16             15         32 28 0 1   2 0     0   1   16 16         15       32
1726158 ID     school 1602100 2   JOINT SCHOOL DISTRICT NO. 2 160210000466 982 EAGLE ACADEMY   Alternative School No High 09 12.0 2017   grade_11 25 0 5   0 1     0   2   16 17             16         33 25 0 5   0 1     0   2   16 17         16       33
1726160 ID     school 1602100 2   JOINT SCHOOL DISTRICT NO. 2 160210000466 982 EAGLE ACADEMY   Alternative School No High 09 12.0 2017   grade_9 19 0 1   0 0     0   0   16 4             14         20 19 0 1   0 0     0   0   16 4         14       20
1726166 ID     school 1602100 2   JOINT SCHOOL DISTRICT NO. 2 160210000714 1228 MERIDIAN ACADEMY   Alternative School No High 09 12.0 2017   grade_10 28 0 1   0 0     0   1   18 12             *         30 28 0 1   0 0     0   1   18 12                 30
1726177 ID     school 1602100 2   JOINT SCHOOL DISTRICT NO. 2 160210000955 1290 PARAMOUNT ELEMENTARY SCHOOL   Regular School No Elementary PK 5.0 2017   grade_2 81 0 3   0 1     0   0   50 35             7         85 81 0 3   0 1     0   0   50 35         7       85
1726179 ID     school 1602100 2   JOINT SCHOOL DISTRICT NO. 2 160210000955 1290 PARAMOUNT ELEMENTARY SCHOOL   Regular School No Elementary PK 5.0 2017   grade_4 94 0 4   0 3     0   3   68 36             7         104 94 0 4   0 3     0   3   68 36         7       104
1726182 ID     school 1602100 2   JOINT SCHOOL DISTRICT NO. 2 160210000955 1290 PARAMOUNT ELEMENTARY SCHOOL   Regular School No Elementary PK 5.0 2017   kindergarten 79 0 10   0 5     0   1   45 50             10         95 79 0 10   0 5     0   1   45 50         10       95
1726184 ID     school 1602100 2   JOINT SCHOOL DISTRICT NO. 2 160210001025 1297 REBOUND SCHOOL OF OPPORTUNITY   Alternative School No Other 06 12.0 2017   grade_11 14 0 5   0 0     0   1   16 4             *         20 14 0 5   0 0     0   1   16 4                 20
1726186 ID     school 1602100 2   JOINT SCHOOL DISTRICT NO. 2 160210001025 1297 REBOUND SCHOOL OF OPPORTUNITY   Alternative School No Other 06 12.0 2017   grade_7 1 0 0   0 0     0   0   1 0             *         1 1 0 0   0 0     0   0   1 0                 1
1726187 ID     school 1602100 2   JOINT SCHOOL DISTRICT NO. 2 160210001025 1297 REBOUND SCHOOL OF OPPORTUNITY   Alternative School No Other 06 12.0 2017   grade_9 5 0 1   0 0     0   0   4 2             *         6 5 0 1   0 0     0   0   4 2                 6
1726191 ID     school 1602100 2   JOINT SCHOOL DISTRICT NO. 2 160210001060 1356 WILLOW CREEK ELEMENTARY SCHOOL   Regular School No Elementary PK 5.0 2017   grade_3 81 0 5   3 2     0   4   61 34             15         95 81 0 5   3 2     0   4   61 34         15       95
1726193 ID     school 1602100 2   JOINT SCHOOL DISTRICT NO. 2 160210001060 1356 WILLOW CREEK ELEMENTARY SCHOOL   Regular School No Elementary PK 5.0 2017   grade_5 81 0 11   0 2     1   3   56 42             17         98 81 0 11   0 2     1   3   56 42         17       98
1726195 ID     school 1602100 2   JOINT SCHOOL DISTRICT NO. 2 160210001060 1356 WILLOW CREEK ELEMENTARY SCHOOL   Regular School No Elementary PK 5.0 2017   kindergarten 73 0 13   1 1     0   3   55 36             17         91 73 0 13   1 1     0   3   55 36         17       91
1726196 ID     school 1602100 2   JOINT SCHOOL DISTRICT NO. 2 160210001070 1374 VIRTUAL SCHOOL HOUSE   Regular School No Elementary PK 8.0 2017   grade_1 5 0 0   0 0     0   0   3 2             *         5 5 0 0   0 0     0   0   3 2                 5
1726197 ID     school 1602100 2   JOINT SCHOOL DISTRICT NO. 2 160210001070 1374 VIRTUAL SCHOOL HOUSE   Regular School No Elementary PK 8.0 2017   grade_2 9 0 0   0 0     0   0   4 5             *         9 9 0 0   0 0     0   0   4 5                 9
1726198 ID     school 1602100 2   JOINT SCHOOL DISTRICT NO. 2 160210001070 1374 VIRTUAL SCHOOL HOUSE   Regular School No Elementary PK 8.0 2017   grade_3 9 0 0   0 0     0   0   4 5             *         9 9 0 0   0 0     0   0   4 5                 9
1726199 ID     school 1602100 2   JOINT SCHOOL DISTRICT NO. 2 160210001070 1374 VIRTUAL SCHOOL HOUSE   Regular School No Elementary PK 8.0 2017   grade_4 7 0 0   0 0     0   0   6 1             *         7 7 0 0   0 0     0   0   6 1                 7
1726200 ID     school 1602100 2   JOINT SCHOOL DISTRICT NO. 2 160210001070 1374 VIRTUAL SCHOOL HOUSE   Regular School No Elementary PK 8.0 2017   grade_5 10 0 0   0 0     0   0   3 7             *         10 10 0 0   0 0     0   0   3 7                 10
1726201 ID     school 1602100 2   JOINT SCHOOL DISTRICT NO. 2 160210001070 1374 VIRTUAL SCHOOL HOUSE   Regular School No Elementary PK 8.0 2017   grade_6 1 0 0   0 0     0   0   0 1             *         1 1 0 0   0 0     0   0   0 1                 1
1726202 ID     school 1602100 2   JOINT SCHOOL DISTRICT NO. 2 160210001070 1374 VIRTUAL SCHOOL HOUSE   Regular School No Elementary PK 8.0 2017   grade_7 8 0 0   0 0     0   0   5 3             *         8 8 0 0   0 0     0   0   5 3                 8
1726203 ID     school 1602100 2   JOINT SCHOOL DISTRICT NO. 2 160210001070 1374 VIRTUAL SCHOOL HOUSE   Regular School No Elementary PK 8.0 2017   grade_8 2 0 0   0 0     0   0   2 0             *         2 2 0 0   0 0     0   0   2 0                 2
1726204 ID     school 1602100 2   JOINT SCHOOL DISTRICT NO. 2 160210001070 1374 VIRTUAL SCHOOL HOUSE   Regular School No Elementary PK 8.0 2017   k_12_total 59 0 0   0 0     0   0   30 29             13         59 59 0 0   0 0     0   0   30 29         13       59
1726205 ID     school 1602100 2   JOINT SCHOOL DISTRICT NO. 2 160210001070 1374 VIRTUAL SCHOOL HOUSE   Regular School No Elementary PK 8.0 2017   kindergarten 8 0 0   0 0     0   0   3 5             *         8 8 0 0   0 0     0   0   3 5                 8
1726208 ID     school 1602100 2   JOINT SCHOOL DISTRICT NO. 2 160210001071 1375 IDAHO FINE ARTS ACADEMY   Regular School No Other 06 12.0 2017   grade_12 20 0 2   0 0     0   0   5 17             *         22 20 0 2   0 0     0   0   5 17                 22
1726209 ID     school 1602100 2   JOINT SCHOOL DISTRICT NO. 2 160210001071 1375 IDAHO FINE ARTS ACADEMY   Regular School No Other 06 12.0 2017   grade_6 26 0 3   1 0     0   0   5 25             *         30 26 0 3   1 0     0   0   5 25                 30
1726210 ID     school 1602100 2   JOINT SCHOOL DISTRICT NO. 2 160210001071 1375 IDAHO FINE ARTS ACADEMY   Regular School No Other 06 12.0 2017   grade_7 24 0 2   0 0     1   0   4 23             *         27 24 0 2   0 0     1   0   4 23                 27
1726211 ID     school 1602100 2   JOINT SCHOOL DISTRICT NO. 2 160210001071 1375 IDAHO FINE ARTS ACADEMY   Regular School No Other 06 12.0 2017   grade_8 27 0 2   0 0     0   2   8 23             *         31 27 0 2   0 0     0   2   8 23                 31
1726212 ID     school 1602100 2   JOINT SCHOOL DISTRICT NO. 2 160210001071 1375 IDAHO FINE ARTS ACADEMY   Regular School No Other 06 12.0 2017   grade_9 22 0 1   0 1     0   0   5 19             *         24 22 0 1   0 1     0   0   5 19                 24
1726215 ID     school 1602100 2   JOINT SCHOOL DISTRICT NO. 2 160210001081 1383 HILLSDALE ELEMENTARY   Regular School No Elementary PK 5.0 2017   grade_2 77 0 16   0 0     0   3   48 48             28         96 77 0 16   0 0     0   3   48 48         28       96
1726218 ID     school 1602100 2   JOINT SCHOOL DISTRICT NO. 2 160210001081 1383 HILLSDALE ELEMENTARY   Regular School No Elementary PK 5.0 2017   grade_5 65 0 9   0 1     0   8   37 46             17         83 65 0 9   0 1     0   8   37 46         17       83
1726225 ID     school 1602100 2   JOINT SCHOOL DISTRICT NO. 2 160210000945 2511 GALILEO MAGNET SCHOOL   Regular School No Elementary PK 8.0 2017   grade_1 82 0 5   0 1     1   5   51 43             9         94 82 0 5   0 1     1   5   51 43         9       94
1726226 ID     school 1602100 2   JOINT SCHOOL DISTRICT NO. 2 160210000945 2511 GALILEO MAGNET SCHOOL   Regular School No Elementary PK 8.0 2017   grade_2 88 0 6   0 0     0   1   57 38             10         95 88 0 6   0 0     0   1   57 38         10       95
1726228 ID     school 1602100 2   JOINT SCHOOL DISTRICT NO. 2 160210000945 2511 GALILEO MAGNET SCHOOL   Regular School No Elementary PK 8.0 2017   grade_4 86 0 4   0 1     0   4   52 43             7         95 86 0 4   0 1     0   4   52 43         7       95
1726229 ID     school 1602100 2   JOINT SCHOOL DISTRICT NO. 2 160210000945 2511 GALILEO MAGNET SCHOOL   Regular School No Elementary PK 8.0 2017   grade_5 81 0 5   1 2     1   2   54 38             8         92 81 0 5   1 2     1   2   54 38         8       92
1726230 ID     school 1602100 2   JOINT SCHOOL DISTRICT NO. 2 160210000945 2511 GALILEO MAGNET SCHOOL   Regular School No Elementary PK 8.0 2017   grade_6 75 0 3   0 1     0   4   51 32             *         83 75 0 3   0 1     0   4   51 32                 83
1726231 ID     school 1602100 2   JOINT SCHOOL DISTRICT NO. 2 160210000945 2511 GALILEO MAGNET SCHOOL   Regular School No Elementary PK 8.0 2017   grade_7 63 0 3   0 0     0   4   39 31             *         70 63 0 3   0 0     0   4   39 31                 70
1726232 ID     school 1602100 2   JOINT SCHOOL DISTRICT NO. 2 160210000945 2511 GALILEO MAGNET SCHOOL   Regular School No Elementary PK 8.0 2017   grade_8 58 0 3   0 1     0   3   39 26             9         65 58 0 3   0 1     0   3   39 26         9       65
1726247 ID     school 1601770 3   KUNA JOINT DISTRICT 160177000596 345 HUBBARD ELEMENTARY SCHOOL   Regular School No Elementary KG 2.0 2017   grade_1 71 0 12   0 1     0   2   46 40             49         86 71 0 12   0 1     0   2   46 40         49       86
1726248 ID     school 1601770 3   KUNA JOINT DISTRICT 160177000596 345 HUBBARD ELEMENTARY SCHOOL   Regular School No Elementary KG 2.0 2017   grade_2 69 0 7   1 0     2   6   37 48             39         85 69 0 7   1 0     2   6   37 48         39       85
1726249 ID     school 1601770 3   KUNA JOINT DISTRICT 160177000596 345 HUBBARD ELEMENTARY SCHOOL   Regular School No Elementary KG 2.0 2017   k_12_total 241 0 23   1 1     4   12   140 142             138         282 241 0 23   1 1     4   12   140 142         138       282
1726250 ID     school 1601770 3   KUNA JOINT DISTRICT 160177000596 345 HUBBARD ELEMENTARY SCHOOL   Regular School No Elementary KG 2.0 2017   kindergarten 101 0 4   0 0     2   4   57 54             50         111 101 0 4   0 0     2   4   57 54         50       111
1726251 ID     school 1601770 3   KUNA JOINT DISTRICT 160177000904 595 REED ELEMENTARY SCHOOL   Regular School No Elementary PK 6.0 2017   grade_1 61 0 25   0 0     0   1   57 30             54         87 61 0 25   0 0     0   1   57 30         54       87
1726253 ID     school 1601770 3   KUNA JOINT DISTRICT 160177000904 595 REED ELEMENTARY SCHOOL   Regular School No Elementary PK 6.0 2017   grade_3 52 0 26   1 0     0   4   34 49             43         83 52 0 26   1 0     0   4   34 49         43       83
1726254 ID     school 1601770 3   KUNA JOINT DISTRICT 160177000904 595 REED ELEMENTARY SCHOOL   Regular School No Elementary PK 6.0 2017   grade_4 63 0 32   1 0     0   3   43 56             44         99 63 0 32   1 0     0   3   43 56         44       99
1726258 ID     school 1601770 3   KUNA JOINT DISTRICT 160177000904 595 REED ELEMENTARY SCHOOL   Regular School No Elementary PK 6.0 2017   kindergarten 40 0 31   2 1     0   2   43 33             46         76 40 0 31   2 1     0   2   43 33         46       76
1726259 ID     school 1601770 3   KUNA JOINT DISTRICT 160177000913 596 INDIAN CREEK ELEMENTARY   Regular School No Elementary PK 3.0 2017   grade_1 49 0 5   0 1     0   2   31 26             26         57 49 0 5   0 1     0   2   31 26         26       57
1726260 ID     school 1601770 3   KUNA JOINT DISTRICT 160177000913 596 INDIAN CREEK ELEMENTARY   Regular School No Elementary PK 3.0 2017   grade_2 43 0 7   0 0     0   2   24 28             23         52 43 0 7   0 0     0   2   24 28         23       52
1726261 ID     school 1601770 3   KUNA JOINT DISTRICT 160177000913 596 INDIAN CREEK ELEMENTARY   Regular School No Elementary PK 3.0 2017   grade_3 57 0 3   0 0     0   0   30 30             25         60 57 0 3   0 0     0   0   30 30         25       60
1726262 ID     school 1601770 3   KUNA JOINT DISTRICT 160177000913 596 INDIAN CREEK ELEMENTARY   Regular School No Elementary PK 3.0 2017   k_12_total 197 0 18   0 3     0   5   112 111             98         223 197 0 18   0 3     0   5   112 111         98       223
1726263 ID     school 1601770 3   KUNA JOINT DISTRICT 160177000913 596 INDIAN CREEK ELEMENTARY   Regular School No Elementary PK 3.0 2017   kindergarten 48 0 3   0 2     0   1   27 27             24         54 48 0 3   0 2     0   1   27 27         24       54
1726264 ID     school 1601770 3   KUNA JOINT DISTRICT 160177000915 635 ROSS ELEMENTARY SCHOOL   Regular School No Elementary 03 6.0 2017   grade_4 70 0 5   0 0     0   4   40 39             45         79 70 0 5   0 0     0   4   40 39         45       79
1726265 ID     school 1601770 3   KUNA JOINT DISTRICT 160177000915 635 ROSS ELEMENTARY SCHOOL   Regular School No Elementary 03 6.0 2017   grade_5 53 0 4   0 2     1   1   34 27             28         61 53 0 4   0 2     1   1   34 27         28       61
1726269 ID     school 1601770 3   KUNA JOINT DISTRICT 160177000805 850 FREMONT H TEED MIDDLE SCHOOL   Regular School No Elementary 02 6.0 2017   grade_4 100 0 11   1 0     2   5   66 53             58         119 100 0 11   1 0     2   5   66 53         58       119
1726271 ID     school 1601770 3   KUNA JOINT DISTRICT 160177000805 850 FREMONT H TEED MIDDLE SCHOOL   Regular School No Elementary 02 6.0 2017   grade_6 91 0 8   0 0     1   6   58 48             50         106 91 0 8   0 0     1   6   58 48         50       106
1726273 ID     school 1601770 3   KUNA JOINT DISTRICT 160177000951 887 CRIMSON POINT ELEMENTARY SCHOOL   Regular School No Elementary PK 6.0 2017   grade_1 59 0 3   0 0     1   4   38 29             29         67 59 0 3   0 0     1   4   38 29         29       67

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