Data source: Big Local News · About: Big Local

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

View and edit SQL

grade

year

  • 2019 · 4,796
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
1305230 ID     school 1600360 1   BOISE INDEPENDENT DISTRICT 160036000823 573 TREASURE VALLEY MATH/SCIENCE   Regular School No Other 04 12.0 2019   grade_10 6 0 1   0 2     0   1   8 2             *         10 6 0 1   0 2     0   1   8 2                 10
1305231 ID     school 1600360 1   BOISE INDEPENDENT DISTRICT 160036000823 573 TREASURE VALLEY MATH/SCIENCE   Regular School No Other 04 12.0 2019   grade_11 8 0 0   0 0     0   0   5 3             *         8 8 0 0   0 0     0   0   5 3                 8
1305232 ID     school 1600360 1   BOISE INDEPENDENT DISTRICT 160036000823 573 TREASURE VALLEY MATH/SCIENCE   Regular School No Other 04 12.0 2019   grade_12 4 0 1   0 0     0   0   3 2             *         5 4 0 1   0 0     0   0   3 2                 5
1305233 ID     school 1600360 1   BOISE INDEPENDENT DISTRICT 160036000823 573 TREASURE VALLEY MATH/SCIENCE   Regular School No Other 04 12.0 2019   grade_6 0 0 0   0 4     0   0   1 3             *         4 0 0 0   0 4     0   0   1 3                 4
1305234 ID     school 1600360 1   BOISE INDEPENDENT DISTRICT 160036000823 573 TREASURE VALLEY MATH/SCIENCE   Regular School No Other 04 12.0 2019   grade_7 18 0 1   0 2     0   2   16 7             *         23 18 0 1   0 2     0   2   16 7                 23
1305235 ID     school 1600360 1   BOISE INDEPENDENT DISTRICT 160036000823 573 TREASURE VALLEY MATH/SCIENCE   Regular School No Other 04 12.0 2019   grade_8 18 0 1   0 6     0   1   17 9             *         26 18 0 1   0 6     0   1   17 9                 26
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
1305690 ID     school 1602060 11   MEADOWS VALLEY DISTRICT 160206000826 342 MEADOWS VALLEY SCHOOL   Regular School No Other PK 12.0 2019   grade_1 5 0 3   0 0     0   0   6 2             *         8 5 0 3   0 0     0   0   6 2                 8
1305691 ID     school 1602060 11   MEADOWS VALLEY DISTRICT 160206000826 342 MEADOWS VALLEY SCHOOL   Regular School No Other PK 12.0 2019   grade_10 9 0 0   0 0     0   1   7 3             5         10 9 0 0   0 0     0   1   7 3         5       10
1305692 ID     school 1602060 11   MEADOWS VALLEY DISTRICT 160206000826 342 MEADOWS VALLEY SCHOOL   Regular School No Other PK 12.0 2019   grade_11 5 0 0   0 0     0   0   4 1             *         5 5 0 0   0 0     0   0   4 1                 5
1305693 ID     school 1602060 11   MEADOWS VALLEY DISTRICT 160206000826 342 MEADOWS VALLEY SCHOOL   Regular School No Other PK 12.0 2019   grade_12 9 0 1   0 1     0   0   8 3             5         11 9 0 1   0 1     0   0   8 3         5       11
1305694 ID     school 1602060 11   MEADOWS VALLEY DISTRICT 160206000826 342 MEADOWS VALLEY SCHOOL   Regular School No Other PK 12.0 2019   grade_2 7 0 0   0 0     0   0   5 2             *         7 7 0 0   0 0     0   0   5 2                 7
1305695 ID     school 1602060 11   MEADOWS VALLEY DISTRICT 160206000826 342 MEADOWS VALLEY SCHOOL   Regular School No Other PK 12.0 2019   grade_3 6 0 1   0 0     0   0   2 5             *         7 6 0 1   0 0     0   0   2 5                 7
1305696 ID     school 1602060 11   MEADOWS VALLEY DISTRICT 160206000826 342 MEADOWS VALLEY SCHOOL   Regular School No Other PK 12.0 2019   grade_4 14 0 2   0 0     0   0   7 9             9         16 14 0 2   0 0     0   0   7 9         9       16
1305697 ID     school 1602060 11   MEADOWS VALLEY DISTRICT 160206000826 342 MEADOWS VALLEY SCHOOL   Regular School No Other PK 12.0 2019   grade_5 13 0 0   1 0     0   0   7 7             5         14 13 0 0   1 0     0   0   7 7         5       14
1305698 ID     school 1602060 11   MEADOWS VALLEY DISTRICT 160206000826 342 MEADOWS VALLEY SCHOOL   Regular School No Other PK 12.0 2019   grade_6 15 0 3   0 0     0   1   9 10             11         19 15 0 3   0 0     0   1   9 10         11       19
1305699 ID     school 1602060 11   MEADOWS VALLEY DISTRICT 160206000826 342 MEADOWS VALLEY SCHOOL   Regular School No Other PK 12.0 2019   grade_7 13 0 1   1 0     0   0   7 8             7         15 13 0 1   1 0     0   0   7 8         7       15
1305700 ID     school 1602060 11   MEADOWS VALLEY DISTRICT 160206000826 342 MEADOWS VALLEY SCHOOL   Regular School No Other PK 12.0 2019   grade_8 14 0 1   0 0     0   0   11 4             9         15 14 0 1   0 0     0   0   11 4         9       15
1305701 ID     school 1602060 11   MEADOWS VALLEY DISTRICT 160206000826 342 MEADOWS VALLEY SCHOOL   Regular School No Other PK 12.0 2019   grade_9 11 0 1   1 0     0   0   8 5             7         13 11 0 1   1 0     0   0   8 5         7       13
1305702 ID     school 1602060 11   MEADOWS VALLEY DISTRICT 160206000826 342 MEADOWS VALLEY SCHOOL   Regular School No Other PK 12.0 2019   k_12_total 131 0 15   3 1     0   2   87 65             79         152 131 0 15   3 1     0   2   87 65         79       152
1305703 ID     school 1602060 11   MEADOWS VALLEY DISTRICT 160206000826 342 MEADOWS VALLEY SCHOOL   Regular School No Other PK 12.0 2019   kindergarten 10 0 2   0 0     0   0   6 6             7         12 10 0 2   0 0     0   0   6 6         7       12
1305890 ID     school 1602640 25   POCATELLO DISTRICT 160264000186 9034 POCATELLO JUVENILE DETENTION   Alternative School No Other 01 12.0 2019   grade_10 1 0 0   0 0     0   0   0 1             *         1 1 0 0   0 0     0   0   0 1                 1
1305891 ID     school 1602640 25   POCATELLO DISTRICT 160264000186 9034 POCATELLO JUVENILE DETENTION   Alternative School No Other 01 12.0 2019   grade_12 1 0 0   0 0     0   0   1 0             *         1 1 0 0   0 0     0   0   1 0                 1
1305892 ID     school 1602640 25   POCATELLO DISTRICT 160264000186 9034 POCATELLO JUVENILE DETENTION   Alternative School No Other 01 12.0 2019   grade_9 2 0 0   0 0     0   0   2 0             *         2 2 0 0   0 0     0   0   2 0                 2
1305893 ID     school 1602640 25   POCATELLO DISTRICT 160264000186 9034 POCATELLO JUVENILE DETENTION   Alternative School No Other 01 12.0 2019   k_12_total 4 0 0   0 0     0   0   3 1             *         4 4 0 0   0 0     0   0   3 1                 4
1306105 ID     school 1600300 61   BLAINE COUNTY DISTRICT 160030000034 197 CAREY PUBLIC SCHOOL   Regular School No Other PK 12.0 2019   grade_1 9 0 6   0 0     0   0   8 7             *         15 9 0 6   0 0     0   0   8 7                 15
1306106 ID     school 1600300 61   BLAINE COUNTY DISTRICT 160030000034 197 CAREY PUBLIC SCHOOL   Regular School No Other PK 12.0 2019   grade_10 16 0 7   0 0     0   0   14 9             6         23 16 0 7   0 0     0   0   14 9         6       23
1306107 ID     school 1600300 61   BLAINE COUNTY DISTRICT 160030000034 197 CAREY PUBLIC SCHOOL   Regular School No Other PK 12.0 2019   grade_11 14 0 5   0 0     0   0   12 7             *         19 14 0 5   0 0     0   0   12 7                 19
1306108 ID     school 1600300 61   BLAINE COUNTY DISTRICT 160030000034 197 CAREY PUBLIC SCHOOL   Regular School No Other PK 12.0 2019   grade_12 13 0 6   0 0     0   0   8 11             7         19 13 0 6   0 0     0   0   8 11         7       19
1306109 ID     school 1600300 61   BLAINE COUNTY DISTRICT 160030000034 197 CAREY PUBLIC SCHOOL   Regular School No Other PK 12.0 2019   grade_2 10 0 3   0 0     0   0   5 8             6         13 10 0 3   0 0     0   0   5 8         6       13
1306110 ID     school 1600300 61   BLAINE COUNTY DISTRICT 160030000034 197 CAREY PUBLIC SCHOOL   Regular School No Other PK 12.0 2019   grade_3 9 0 5   0 0     0   1   8 7             6         15 9 0 5   0 0     0   1   8 7         6       15
1306111 ID     school 1600300 61   BLAINE COUNTY DISTRICT 160030000034 197 CAREY PUBLIC SCHOOL   Regular School No Other PK 12.0 2019   grade_4 9 0 3   0 0     0   0   7 5             7         12 9 0 3   0 0     0   0   7 5         7       12
1306112 ID     school 1600300 61   BLAINE COUNTY DISTRICT 160030000034 197 CAREY PUBLIC SCHOOL   Regular School No Other PK 12.0 2019   grade_5 14 0 6   0 0     0   1   13 8             7         21 14 0 6   0 0     0   1   13 8         7       21
1306113 ID     school 1600300 61   BLAINE COUNTY DISTRICT 160030000034 197 CAREY PUBLIC SCHOOL   Regular School No Other PK 12.0 2019   grade_6 15 0 7   0 0     0   1   13 10             12         23 15 0 7   0 0     0   1   13 10         12       23
1306114 ID     school 1600300 61   BLAINE COUNTY DISTRICT 160030000034 197 CAREY PUBLIC SCHOOL   Regular School No Other PK 12.0 2019   grade_7 12 0 4   0 0     0   0   8 8             5         16 12 0 4   0 0     0   0   8 8         5       16
1306115 ID     school 1600300 61   BLAINE COUNTY DISTRICT 160030000034 197 CAREY PUBLIC SCHOOL   Regular School No Other PK 12.0 2019   grade_8 16 0 8   0 0     0   0   15 9             10         24 16 0 8   0 0     0   0   15 9         10       24
1306116 ID     school 1600300 61   BLAINE COUNTY DISTRICT 160030000034 197 CAREY PUBLIC SCHOOL   Regular School No Other PK 12.0 2019   grade_9 14 0 5   0 0     0   0   12 7             *         19 14 0 5   0 0     0   0   12 7                 19
1306117 ID     school 1600300 61   BLAINE COUNTY DISTRICT 160030000034 197 CAREY PUBLIC SCHOOL   Regular School No Other PK 12.0 2019   k_12_total 164 0 67   0 0     0   3   130 104             89         234 164 0 67   0 0     0   3   130 104         89       234
1306118 ID     school 1600300 61   BLAINE COUNTY DISTRICT 160030000034 197 CAREY PUBLIC SCHOOL   Regular School No Other PK 12.0 2019   kindergarten 13 0 2   0 0     0   0   7 8             *         15 13 0 2   0 0     0   0   7 8                 15
1306158 ID     school 1601170 71   GARDEN VALLEY DISTRICT 160117000830 274 GARDEN VALLEY SCHOOL   Regular School No Other PK 12.0 2019   grade_1 15 0 1   0 0     0   0   9 7             *         16 15 0 1   0 0     0   0   9 7                 16
1306159 ID     school 1601170 71   GARDEN VALLEY DISTRICT 160117000830 274 GARDEN VALLEY SCHOOL   Regular School No Other PK 12.0 2019   grade_10 17 0 1   0 0     0   1   11 8             7         19 17 0 1   0 0     0   1   11 8         7       19
1306160 ID     school 1601170 71   GARDEN VALLEY DISTRICT 160117000830 274 GARDEN VALLEY SCHOOL   Regular School No Other PK 12.0 2019   grade_11 15 0 5   1 0     0   0   14 7             8         21 15 0 5   1 0     0   0   14 7         8       21
1306161 ID     school 1601170 71   GARDEN VALLEY DISTRICT 160117000830 274 GARDEN VALLEY SCHOOL   Regular School No Other PK 12.0 2019   grade_12 9 0 1   0 0     0   0   6 4             *         10 9 0 1   0 0     0   0   6 4                 10
1306162 ID     school 1601170 71   GARDEN VALLEY DISTRICT 160117000830 274 GARDEN VALLEY SCHOOL   Regular School No Other PK 12.0 2019   grade_2 16 0 1   0 0     0   0   6 11             *         17 16 0 1   0 0     0   0   6 11                 17
1306163 ID     school 1601170 71   GARDEN VALLEY DISTRICT 160117000830 274 GARDEN VALLEY SCHOOL   Regular School No Other PK 12.0 2019   grade_3 18 0 2   0 0     0   2   14 8             *         22 18 0 2   0 0     0   2   14 8                 22
1306164 ID     school 1601170 71   GARDEN VALLEY DISTRICT 160117000830 274 GARDEN VALLEY SCHOOL   Regular School No Other PK 12.0 2019   grade_4 19 0 0   0 0     0   0   10 9             6         19 19 0 0   0 0     0   0   10 9         6       19
1306165 ID     school 1601170 71   GARDEN VALLEY DISTRICT 160117000830 274 GARDEN VALLEY SCHOOL   Regular School No Other PK 12.0 2019   grade_5 13 1 4   0 0     0   1   11 8             *         19 13 1 4   0 0     0   1   11 8                 19
1306166 ID     school 1601170 71   GARDEN VALLEY DISTRICT 160117000830 274 GARDEN VALLEY SCHOOL   Regular School No Other PK 12.0 2019   grade_6 23 0 1   0 0     0   0   12 12             6         24 23 0 1   0 0     0   0   12 12         6       24
1306167 ID     school 1601170 71   GARDEN VALLEY DISTRICT 160117000830 274 GARDEN VALLEY SCHOOL   Regular School No Other PK 12.0 2019   grade_7 20 1 2   0 0     0   0   9 14             10         23 20 1 2   0 0     0   0   9 14         10       23
1306168 ID     school 1601170 71   GARDEN VALLEY DISTRICT 160117000830 274 GARDEN VALLEY SCHOOL   Regular School No Other PK 12.0 2019   grade_8 15 0 1   0 0     0   0   10 6             *         16 15 0 1   0 0     0   0   10 6                 16
1306169 ID     school 1601170 71   GARDEN VALLEY DISTRICT 160117000830 274 GARDEN VALLEY SCHOOL   Regular School No Other PK 12.0 2019   grade_9 17 1 0   0 0     0   0   9 9             8         18 17 1 0   0 0     0   0   9 9         8       18
1306170 ID     school 1601170 71   GARDEN VALLEY DISTRICT 160117000830 274 GARDEN VALLEY SCHOOL   Regular School No Other PK 12.0 2019   k_12_total 209 3 21   1 0     0   5   131 108             *         239 209 3 21   1 0     0   5   131 108                 239
1306171 ID     school 1601170 71   GARDEN VALLEY DISTRICT 160117000830 274 GARDEN VALLEY SCHOOL   Regular School No Other PK 12.0 2019   kindergarten 12 0 2   0 0     0   1   10 5             *         15 12 0 2   0 0     0   1   10 5                 15
1306435 ID     school 1601530 91   IDAHO FALLS DISTRICT 160153000605 1152 3B JUVENILE DETENTION CENTER   Alternative School No Other 04 12.0 2019   grade_10 5 0 1   0 0     0   0   6 0             *         6 5 0 1   0 0     0   0   6 0                 6
1306436 ID     school 1601530 91   IDAHO FALLS DISTRICT 160153000605 1152 3B JUVENILE DETENTION CENTER   Alternative School No Other 04 12.0 2019   grade_11 6 0 0   0 0     0   0   5 1             *         6 6 0 0   0 0     0   0   5 1                 6
1306437 ID     school 1601530 91   IDAHO FALLS DISTRICT 160153000605 1152 3B JUVENILE DETENTION CENTER   Alternative School No Other 04 12.0 2019   grade_12 0 0 2   0 0     0   1   1 2             *         3 0 0 2   0 0     0   1   1 2                 3
1306438 ID     school 1601530 91   IDAHO FALLS DISTRICT 160153000605 1152 3B JUVENILE DETENTION CENTER   Alternative School No Other 04 12.0 2019   grade_9 0 0 3   0 0     0   0   3 0             *         3 0 0 3   0 0     0   0   3 0                 3
1306439 ID     school 1601530 91   IDAHO FALLS DISTRICT 160153000605 1152 3B JUVENILE DETENTION CENTER   Alternative School No Other 04 12.0 2019   k_12_total 11 0 6   0 0     0   1   15 3             7         18 11 0 6   0 0     0   1   15 3         7       18
1306879 ID     school 1600510 132   CALDWELL DISTRICT 160051000043 1087 SOUTHWEST IDAHO JUVENILE DETENTION   Alternative School No Other 01 12.0 2019   grade_10 1 0 3   0 1     0   1   5 1             *         6 1 0 3   0 1     0   1   5 1                 6
1306880 ID     school 1600510 132   CALDWELL DISTRICT 160051000043 1087 SOUTHWEST IDAHO JUVENILE DETENTION   Alternative School No Other 01 12.0 2019   grade_11 3 0 8   0 0     0   0   10 1             *         11 3 0 8   0 0     0   0   10 1                 11
1306881 ID     school 1600510 132   CALDWELL DISTRICT 160051000043 1087 SOUTHWEST IDAHO JUVENILE DETENTION   Alternative School No Other 01 12.0 2019   grade_12 2 0 5   0 0     0   0   5 2             *         7 2 0 5   0 0     0   0   5 2                 7
1306882 ID     school 1600510 132   CALDWELL DISTRICT 160051000043 1087 SOUTHWEST IDAHO JUVENILE DETENTION   Alternative School No Other 01 12.0 2019   grade_7 1 0 0   0 0     0   0   1 0             *         1 1 0 0   0 0     0   0   1 0                 1
1306883 ID     school 1600510 132   CALDWELL DISTRICT 160051000043 1087 SOUTHWEST IDAHO JUVENILE DETENTION   Alternative School No Other 01 12.0 2019   grade_9 3 0 0   0 0     0   2   5 0             *         5 3 0 0   0 0     0   2   5 0                 5
1306884 ID     school 1600510 132   CALDWELL DISTRICT 160051000043 1087 SOUTHWEST IDAHO JUVENILE DETENTION   Alternative School No Other 01 12.0 2019   k_12_total 10 0 16   0 1     0   3   26 4             17         30 10 0 16   0 1     0   3   26 4         17       30
1307574 ID     school 1601380 233   HAGERMAN JOINT DISTRICT 160138000840 280 HAGERMAN SCHOOL   Regular School No Other PK 12.0 2019   grade_1 16 0 8   0 0     0   2   11 15             18         26 16 0 8   0 0     0   2   11 15         18       26
1307575 ID     school 1601380 233   HAGERMAN JOINT DISTRICT 160138000840 280 HAGERMAN SCHOOL   Regular School No Other PK 12.0 2019   grade_10 17 0 4   0 0     0   0   8 13             15         21 17 0 4   0 0     0   0   8 13         15       21
1307576 ID     school 1601380 233   HAGERMAN JOINT DISTRICT 160138000840 280 HAGERMAN SCHOOL   Regular School No Other PK 12.0 2019   grade_11 14 0 3   1 0     0   0   12 6             6         18 14 0 3   1 0     0   0   12 6         6       18
1307577 ID     school 1601380 233   HAGERMAN JOINT DISTRICT 160138000840 280 HAGERMAN SCHOOL   Regular School No Other PK 12.0 2019   grade_12 12 0 6   0 0     0   0   6 12             13         18 12 0 6   0 0     0   0   6 12         13       18
1307578 ID     school 1601380 233   HAGERMAN JOINT DISTRICT 160138000840 280 HAGERMAN SCHOOL   Regular School No Other PK 12.0 2019   grade_2 18 0 5   0 0     0   1   8 16             15         24 18 0 5   0 0     0   1   8 16         15       24
1307579 ID     school 1601380 233   HAGERMAN JOINT DISTRICT 160138000840 280 HAGERMAN SCHOOL   Regular School No Other PK 12.0 2019   grade_3 22 0 5   1 0     0   0   12 16             14         28 22 0 5   1 0     0   0   12 16         14       28
1307580 ID     school 1601380 233   HAGERMAN JOINT DISTRICT 160138000840 280 HAGERMAN SCHOOL   Regular School No Other PK 12.0 2019   grade_4 14 0 7   0 0     0   3   11 13             17         24 14 0 7   0 0     0   3   11 13         17       24
1307581 ID     school 1601380 233   HAGERMAN JOINT DISTRICT 160138000840 280 HAGERMAN SCHOOL   Regular School No Other PK 12.0 2019   grade_5 22 1 5   0 0     0   0   13 15             16         28 22 1 5   0 0     0   0   13 15         16       28
1307582 ID     school 1601380 233   HAGERMAN JOINT DISTRICT 160138000840 280 HAGERMAN SCHOOL   Regular School No Other PK 12.0 2019   grade_6 22 1 8   1 0     0   0   16 16             20         32 22 1 8   1 0     0   0   16 16         20       32
1307583 ID     school 1601380 233   HAGERMAN JOINT DISTRICT 160138000840 280 HAGERMAN SCHOOL   Regular School No Other PK 12.0 2019   grade_7 18 0 3   0 0     0   0   12 9             15         21 18 0 3   0 0     0   0   12 9         15       21
1307584 ID     school 1601380 233   HAGERMAN JOINT DISTRICT 160138000840 280 HAGERMAN SCHOOL   Regular School No Other PK 12.0 2019   grade_8 22 0 1   0 0     0   0   14 9             15         23 22 0 1   0 0     0   0   14 9         15       23
1307585 ID     school 1601380 233   HAGERMAN JOINT DISTRICT 160138000840 280 HAGERMAN SCHOOL   Regular School No Other PK 12.0 2019   grade_9 19 1 3   0 0     0   1   14 10             10         24 19 1 3   0 0     0   1   14 10         10       24
1307586 ID     school 1601380 233   HAGERMAN JOINT DISTRICT 160138000840 280 HAGERMAN SCHOOL   Regular School No Other PK 12.0 2019   k_12_total 232 3 61   3 0     0   7   149 157             184         306 232 3 61   3 0     0   7   149 157         184       306
1307587 ID     school 1601380 233   HAGERMAN JOINT DISTRICT 160138000840 280 HAGERMAN SCHOOL   Regular School No Other PK 12.0 2019   kindergarten 16 0 3   0 0     0   0   12 7             10         19 16 0 3   0 0     0   0   12 7         10       19
1307588 ID     school 1600330 234   BLISS JOINT DISTRICT 160033000040 714 BLISS SCHOOL   Regular School No Other PK 12.0 2019   grade_1 7 0 3   0 0     0   0   3 7             *         10 7 0 3   0 0     0   0   3 7                 10
1307589 ID     school 1600330 234   BLISS JOINT DISTRICT 160033000040 714 BLISS SCHOOL   Regular School No Other PK 12.0 2019   grade_10 10 0 2   0 0     0   0   5 7             7         12 10 0 2   0 0     0   0   5 7         7       12
1307590 ID     school 1600330 234   BLISS JOINT DISTRICT 160033000040 714 BLISS SCHOOL   Regular School No Other PK 12.0 2019   grade_11 6 0 2   0 0     0   0   3 5             *         8 6 0 2   0 0     0   0   3 5                 8
1307591 ID     school 1600330 234   BLISS JOINT DISTRICT 160033000040 714 BLISS SCHOOL   Regular School No Other PK 12.0 2019   grade_12 3 0 3   0 0     0   0   3 3             *         6 3 0 3   0 0     0   0   3 3                 6
1307592 ID     school 1600330 234   BLISS JOINT DISTRICT 160033000040 714 BLISS SCHOOL   Regular School No Other PK 12.0 2019   grade_2 5 0 3   0 0     0   0   4 4             *         8 5 0 3   0 0     0   0   4 4                 8
1307593 ID     school 1600330 234   BLISS JOINT DISTRICT 160033000040 714 BLISS SCHOOL   Regular School No Other PK 12.0 2019   grade_3 8 0 5   0 0     0   0   7 6             *         13 8 0 5   0 0     0   0   7 6                 13
1307594 ID     school 1600330 234   BLISS JOINT DISTRICT 160033000040 714 BLISS SCHOOL   Regular School No Other PK 12.0 2019   grade_4 6 0 3   0 0     0   0   4 5             *         9 6 0 3   0 0     0   0   4 5                 9
1307595 ID     school 1600330 234   BLISS JOINT DISTRICT 160033000040 714 BLISS SCHOOL   Regular School No Other PK 12.0 2019   grade_5 11 0 4   0 0     0   0   7 8             10         15 11 0 4   0 0     0   0   7 8         10       15
1307596 ID     school 1600330 234   BLISS JOINT DISTRICT 160033000040 714 BLISS SCHOOL   Regular School No Other PK 12.0 2019   grade_6 4 0 9   0 0     0   0   7 6             *         13 4 0 9   0 0     0   0   7 6                 13
1307597 ID     school 1600330 234   BLISS JOINT DISTRICT 160033000040 714 BLISS SCHOOL   Regular School No Other PK 12.0 2019   grade_7 3 0 4   0 0     0   0   3 4             *         7 3 0 4   0 0     0   0   3 4                 7
1307598 ID     school 1600330 234   BLISS JOINT DISTRICT 160033000040 714 BLISS SCHOOL   Regular School No Other PK 12.0 2019   grade_8 11 0 5   0 0     0   0   8 8             11         16 11 0 5   0 0     0   0   8 8         11       16
1307599 ID     school 1600330 234   BLISS JOINT DISTRICT 160033000040 714 BLISS SCHOOL   Regular School No Other PK 12.0 2019   grade_9 2 0 7   0 0     0   0   4 5             *         9 2 0 7   0 0     0   0   4 5                 9
1307600 ID     school 1600330 234   BLISS JOINT DISTRICT 160033000040 714 BLISS SCHOOL   Regular School No Other PK 12.0 2019   k_12_total 83 0 57   0 0     0   0   69 71             106         140 83 0 57   0 0     0   0   69 71         106       140
1307601 ID     school 1600330 234   BLISS JOINT DISTRICT 160033000040 714 BLISS SCHOOL   Regular School No Other PK 12.0 2019   kindergarten 7 0 7   0 0     0   0   11 3             *         14 7 0 7   0 0     0   0   11 3                 14
1307762 ID     school 1601590 261   JEROME JOINT DISTRICT 160159000289 297 JEROME ACADEMY   Special Education School No Other KG 12.0 2019   grade_1 1 0 1   0 0     0   0   2 0             *         2 1 0 1   0 0     0   0   2 0                 2
1307763 ID     school 1601590 261   JEROME JOINT DISTRICT 160159000289 297 JEROME ACADEMY   Special Education School No Other KG 12.0 2019   grade_2 1 0 0   0 0     0   0   1 0             *         1 1 0 0   0 0     0   0   1 0                 1
1307764 ID     school 1601590 261   JEROME JOINT DISTRICT 160159000289 297 JEROME ACADEMY   Special Education School No Other KG 12.0 2019   grade_3 1 0 0   0 0     0   0   1 0             *         1 1 0 0   0 0     0   0   1 0                 1
1307765 ID     school 1601590 261   JEROME JOINT DISTRICT 160159000289 297 JEROME ACADEMY   Special Education School No Other KG 12.0 2019   grade_4 3 0 1   0 0     0   0   4 0             *         4 3 0 1   0 0     0   0   4 0                 4
1307766 ID     school 1601590 261   JEROME JOINT DISTRICT 160159000289 297 JEROME ACADEMY   Special Education School No Other KG 12.0 2019   grade_5 0 0 1   0 0     0   0   0 1             *         1 0 0 1   0 0     0   0   0 1                 1
1307767 ID     school 1601590 261   JEROME JOINT DISTRICT 160159000289 297 JEROME ACADEMY   Special Education School No Other KG 12.0 2019   k_12_total 6 0 3   0 0     0   0   8 1             *         9 6 0 3   0 0     0   0   8 1                 9
1307788 ID     school 1603270 262   VALLEY DISTRICT 160327000558 119 VALLEY SCHOOL   Regular School No Other PK 12.0 2019   grade_1 30 0 19   0 0     0   1   27 23             31         50 30 0 19   0 0     0   1   27 23         31       50

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