Data source: Big Local News · About: Big Local

1,598 rows where grade = "grade_8" and state = "ID" sorted by school

View and edit SQL

year

grade

  • grade_8 · 1,498
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
1277731 ID     school 1600930 93   BONNEVILLE JOINT DISTRICT 160093001050 1319 BONNEVILLE ONLINE SCHOOL   Regular School No High 06 12.0 2018   grade_8 18 0 3   0 0     0   0   11 10             *         21 18 0 3   0 0     0   0   11 10                 21
1306585 ID     school 1600930 93   BONNEVILLE JOINT DISTRICT 160093001050 1319 BONNEVILLE ONLINE SCHOOL   Regular School No High 06 12.0 2019   grade_8 28 1 2   0 0     0   1   15 17             *         32 28 1 2   0 0     0   1   15 17                 32
1277602 ID     school   92   SWAN VALLEY ELEMENTARY DISTRICT   1014 BORDER DISTRICT - STAR VALLEY ELEMENTARY SCHOOL             2018   grade_8 1 0 0   0 0     0   0   0 1             *         1 1 0 0   0 0     0   0   0 1                 1
1822071 ID     school   92   SWAN VALLEY ELEMENTARY DISTRICT   1015 BORDER DISTRICT - STAR VALLEY JR-SR HIGH SCHOOL             2016   grade_8 2 0 0   0 0     0   0   1 1             *         2 2 0 0   0 0     0   0   1 1                 2
850732 ID     school   150   SODA SPRINGS JOINT DISTRICT   1026 BORDER DISTRICT FREEDOM - SECONDARY             2020   grade_8 3 0 0   0 0     0   0   2 1             *         3 3 0 0   0 0     0   0   2 1                 3
1278273 ID     school   150   SODA SPRINGS JOINT DISTRICT   1026 BORDER DISTRICT FREEDOM - SECONDARY             2018   grade_8 0 0 2   0 0     0   0   2 0             *         2 0 0 2   0 0     0   0   2 0                 2
1307129 ID     school   150   SODA SPRINGS JOINT DISTRICT   1026 BORDER DISTRICT FREEDOM - SECONDARY             2019   grade_8 2 0 1   0 0     0   0   2 1             *         3 2 0 1   0 0     0   0   2 1                 3
1727727 ID     school   150   SODA SPRINGS JOINT DISTRICT   1026 BORDER DISTRICT FREEDOM - SECONDARY             2017   grade_8 2 0 0   0 0     0   0   2 0             *         2 2 0 0   0 0     0   0   2 0                 2
704505 ID     school 1600420 101   BOUNDARY COUNTY DISTRICT 160042000029 201 BOUNDARY COUNTY MIDDLE SCHOOL   Regular School No Middle 06 08 2021   grade_8 80 1 3   3 0     0   1   46 42             40         88 80 1 3   3 0     0   1   46 42         40       88
850230 ID     school 1600420 101   BOUNDARY COUNTY DISTRICT 160042000029 201 BOUNDARY COUNTY MIDDLE SCHOOL   Regular School No Middle 06 08 2020   grade_8 101 0 6   3 0     0   6   55 61             54         116 101 0 6   3 0     0   6   55 61         54       116
1277770 ID     school 1600420 101   BOUNDARY COUNTY DISTRICT 160042000029 201 BOUNDARY COUNTY MIDDLE SCHOOL   Regular School No Middle 06 8.0 2018   grade_8 86 2 6   1 2     1   3   49 52             45         101 86 2 6   1 2     1   3   49 52         45       101
1306628 ID     school 1600420 101   BOUNDARY COUNTY DISTRICT 160042000029 201 BOUNDARY COUNTY MIDDLE SCHOOL   Regular School No Middle 06 8.0 2019   grade_8 109 0 5   3 0     0   5   62 60             63         122 109 0 5   3 0     0   5   62 60         63       122
1683190 ID     school 1600420 101   BOUNDARY COUNTY DISTRICT 160042000029 201 BOUNDARY COUNTY MIDDLE SCHOOL   Regular School No 2.0 06 08 2015   grade_8 92 0 8   4 0     0   2   60 46             62         106 92 0 8   4 0     0   2   60 46         62       106
1727234 ID     school 1600420 101   BOUNDARY COUNTY DISTRICT 160042000029 201 BOUNDARY COUNTY MIDDLE SCHOOL   Regular School No Middle 06 8.0 2017   grade_8 109 0 8   2 1     0   4   50 74             72         124 109 0 8   2 1     0   4   50 74         72       124
1822240 ID     school 1600420 101   BOUNDARY COUNTY DISTRICT 160042000029 201 BOUNDARY COUNTY MIDDLE SCHOOL   Regular School No 2.0 06 08 2016   grade_8 89 1 3   5 3     0   0   52 49             57         101 89 1 3   5 3     0   0   52 49         57       101
706852 ID     school 1603240 411   TWIN FALLS DISTRICT 160324000755 1147 BRIDGE ACADEMY   Alternative School No Middle 07 08 2021   grade_8 17 0 11   0 0     1   1   23 7             *         30 17 0 11   0 0     1   1   23 7                 30
852506 ID     school 1603240 411   TWIN FALLS DISTRICT 160324000755 1147 BRIDGE ACADEMY   Alternative School No Middle 07 08 2020   grade_8 20 0 10   0 0     0   1   19 12             *         31 20 0 10   0 0     0   1   19 12                 31
1280030 ID     school 1603240 411   TWIN FALLS DISTRICT 160324000755 1147 BRIDGE ACADEMY   Alternative School No Middle 06 8.0 2018   grade_8 17 0 7   1 0     0   0   15 10             *         25 17 0 7   1 0     0   0   15 10                 25
1308899 ID     school 1603240 411   TWIN FALLS DISTRICT 160324000755 1147 BRIDGE ACADEMY   Alternative School No Middle 06 8.0 2019   grade_8 19 0 10   1 1     0   3   22 12             *         34 19 0 10   1 1     0   3   22 12                 34
1685448 ID     school 1603240 411   TWIN FALLS DISTRICT 160324000755 1147 BRIDGE ACADEMY   Alternative Education School No 3.0 07 12 2015   grade_8 17 0 16   0 2     1   0   22 14             *         36 17 0 16   0 2     1   0   22 14                 36
1729513 ID     school 1603240 411   TWIN FALLS DISTRICT 160324000755 1147 BRIDGE ACADEMY   Alternative School No Middle 06 8.0 2017   grade_8 33 3 14   1 0     0   0   37 14             *         51 33 3 14   1 0     0   0   37 14                 51
1824479 ID     school 1603240 411   TWIN FALLS DISTRICT 160324000755 1147 BRIDGE ACADEMY   Alternative Education School No 3.0 07 12 2016   grade_8 26 4 11   1 0     0   0   29 13             *         42 26 4 11   1 0     0   0   29 13                 42
706895 ID     school 1600480 412   BUHL JOINT DISTRICT 160048000103 179 BUHL MIDDLE SCHOOL   Regular School No Middle 06 08 2021   grade_8 60 0 40   0 0     0   2   53 49             44         102 60 0 40   0 0     0   2   53 49         44       102
852542 ID     school 1600480 412   BUHL JOINT DISTRICT 160048000103 179 BUHL MIDDLE SCHOOL   Regular School No Middle 06 08 2020   grade_8 72 0 49   0 1     0   2   66 58             70         124 72 0 49   0 1     0   2   66 58         70       124
1280072 ID     school 1600480 412   BUHL JOINT DISTRICT 160048000103 179 BUHL MIDDLE SCHOOL   Regular School No Middle 06 8.0 2018   grade_8 60 0 35   0 0     0   2   43 54             39         97 60 0 35   0 0     0   2   43 54         39       97
1308940 ID     school 1600480 412   BUHL JOINT DISTRICT 160048000103 179 BUHL MIDDLE SCHOOL   Regular School No Middle 06 8.0 2019   grade_8 64 0 37   0 0     0   2   54 49             29         103 64 0 37   0 0     0   2   54 49         29       103
1685464 ID     school 1600480 412   BUHL JOINT DISTRICT 160048000103 179 BUHL MIDDLE SCHOOL   Regular School No 2.0 06 08 2015   grade_8 64 1 35   0 0     0   0   47 53             66         100 64 1 35   0 0     0   0   47 53         66       100
1729541 ID     school 1600480 412   BUHL JOINT DISTRICT 160048000103 179 BUHL MIDDLE SCHOOL   Regular School No Middle 06 8.0 2017   grade_8 50 1 38   0 0     1   3   48 45             30         93 50 1 38   0 0     1   3   48 45         30       93
1824493 ID     school 1600480 412   BUHL JOINT DISTRICT 160048000103 179 BUHL MIDDLE SCHOOL   Regular School No 2.0 06 08 2016   grade_8 54 3 40   2 0     0   0   50 49             64         99 54 3 40   2 0     0   0   50 49         64       99
705022 ID     school 1600660 151   CASSIA COUNTY JOINT DISTRICT 160066000125 80 BURLEY JUNIOR HIGH SCHOOL   Regular School No Middle 07 08 2021   grade_8 150 1 132   1 1     0   2   141 146             136         287 150 1 132   1 1     0   2   141 146         136       287
850736 ID     school 1600660 151   CASSIA COUNTY JOINT DISTRICT 160066000125 80 BURLEY JUNIOR HIGH SCHOOL   Regular School No Middle 07 08 2020   grade_8 153 0 125   0 0     0   3   151 130             161         281 153 0 125   0 0     0   3   151 130         161       281
1278277 ID     school 1600660 151   CASSIA COUNTY JOINT DISTRICT 160066000125 80 BURLEY JUNIOR HIGH SCHOOL   Regular School No Middle 07 8.0 2018   grade_8 145 0 105   4 0     1   4   141 118             138         259 145 0 105   4 0     1   4   141 118         138       259
1307133 ID     school 1600660 151   CASSIA COUNTY JOINT DISTRICT 160066000125 80 BURLEY JUNIOR HIGH SCHOOL   Regular School No Middle 07 8.0 2019   grade_8 156 3 130   0 0     0   5   154 140             157         294 156 3 130   0 0     0   5   154 140         157       294
1683675 ID     school 1600660 151   CASSIA COUNTY JOINT DISTRICT 160066000125 80 BURLEY JUNIOR HIGH SCHOOL   Regular School No 2.0 07 08 2015   grade_8 132 1 93   0 0     1   1   110 118             114         228 132 1 93   0 0     1   1   110 118         114       228
1727731 ID     school 1600660 151   CASSIA COUNTY JOINT DISTRICT 160066000125 80 BURLEY JUNIOR HIGH SCHOOL   Regular School No Middle 07 8.0 2017   grade_8 134 3 112   1 2     0   1   124 129             144         253 134 3 112   1 2     0   1   124 129         144       253
1822721 ID     school 1600660 151   CASSIA COUNTY JOINT DISTRICT 160066000125 80 BURLEY JUNIOR HIGH SCHOOL   Regular School No 2.0 07 08 2016   grade_8 143 1 104   2 1     2   2   137 118             140         255 143 1 104   2 1     2   2   137 118         140       255
1277795 ID     school 1600490 111   BUTTE COUNTY JOINT DISTRICT 160049000662 58 BUTTE COUNTY MIDDLE SCHOOL   Regular School No Middle 06 8.0 2018   grade_8 26 2 3   2 0     0   0   13 20             15         33 26 2 3   2 0     0   0   13 20         15       33
1683215 ID     school 1600490 111   BUTTE COUNTY JOINT DISTRICT 160049000662 58 BUTTE COUNTY MIDDLE SCHOOL   Regular School No 2.0 06 08 2015   grade_8 22 0 1   0 0     0   1   16 8             12         24 22 0 1   0 0     0   1   16 8         12       24
1727259 ID     school 1600490 111   BUTTE COUNTY JOINT DISTRICT 160049000662 58 BUTTE COUNTY MIDDLE SCHOOL   Regular School No Middle 06 8.0 2017   grade_8 32 0 2   0 0     0   0   13 21             16         34 32 0 2   0 0     0   0   13 21         16       34
1822265 ID     school 1600490 111   BUTTE COUNTY JOINT DISTRICT 160049000662 58 BUTTE COUNTY MIDDLE SCHOOL   Regular School No 2.0 06 08 2016   grade_8 25 0 0   0 0     0   1   20 6             9         26 25 0 0   0 0     0   1   20 6         9       26
704532 ID     school 1600490 111   BUTTE COUNTY JOINT DISTRICT 160049000008 59 BUTTE COUNTY MIDDLE/HIGH SCHOOL   Regular School No High 07 12 2021   grade_8 24 0 1   0 1     0   0   14 12             11         26 24 0 1   0 1     0   0   14 12         11       26
850257 ID     school 1600490 111   BUTTE COUNTY JOINT DISTRICT 160049000008 59 BUTTE COUNTY MIDDLE/HIGH SCHOOL   Regular School No High 07 12 2020   grade_8 31 0 0   0 0     0   0   14 17             11         31 31 0 0   0 0     0   0   14 17         11       31
1306656 ID     school 1600490 111   BUTTE COUNTY JOINT DISTRICT 160049000008 59 BUTTE COUNTY MIDDLE/HIGH SCHOOL   Regular School No High 06 12.0 2019   grade_8 29 0 1   3 0     0   0   21 12             15         33 29 0 1   3 0     0   0   21 12         15       33
706750 ID     school 1600150 394   AVERY SCHOOL DISTRICT 160015001010 820 CALDER SCHOOL   Regular School No Elementary KG 08 2021   grade_8 3 0 0   0 0     0   0   3 0             *         3 3 0 0   0 0     0   0   3 0                 3
852404 ID     school 1600150 394   AVERY SCHOOL DISTRICT 160015001010 820 CALDER SCHOOL   Regular School No Elementary KG 08 2020   grade_8 1 0 0   0 0     0   1   2 0             *         2 1 0 0   0 0     0   1   2 0                 2
1279929 ID     school 1600150 394   AVERY SCHOOL DISTRICT 160015001010 820 CALDER SCHOOL   Regular School No Elementary KG 8.0 2018   grade_8 1 0 0   0 0     0   0   0 1             *         1 1 0 0   0 0     0   0   0 1                 1
1685343 ID     school 1600150 394   AVERY SCHOOL DISTRICT 160015001010 820 CALDER SCHOOL   Regular School No 1.0 KG 08 2015   grade_8 3 0 0   0 0     0   0   2 1             *         3 3 0 0   0 0     0   0   2 1                 3
704557 ID     school 1600540 121   CAMAS COUNTY DISTRICT 160054000110 440 CAMAS COUNTY ELEM/JR HIGH SCHOOL   Regular School No Elementary PK 08 2021   grade_8 21 0 1   0 0     0   0   11 11             7         22 21 0 1   0 0     0   0   11 11         7       22
850285 ID     school 1600540 121   CAMAS COUNTY DISTRICT 160054000110 440 CAMAS COUNTY ELEM/JR HIGH SCHOOL   Regular School No Elementary PK 08 2020   grade_8 21 0 1   0 0     0   1   14 9             5         23 21 0 1   0 0     0   1   14 9         5       23
1277827 ID     school 1600540 121   CAMAS COUNTY DISTRICT 160054000110 440 CAMAS COUNTY ELEM/JR HIGH SCHOOL   Regular School No Elementary PK 8.0 2018   grade_8 14 0 1   0 0     0   0   3 12             5         15 14 0 1   0 0     0   0   3 12         5       15
1306684 ID     school 1600540 121   CAMAS COUNTY DISTRICT 160054000110 440 CAMAS COUNTY ELEM/JR HIGH SCHOOL   Regular School No Elementary PK 8.0 2019   grade_8 9 0 0   0 0     0   0   5 4             *         9 9 0 0   0 0     0   0   5 4                 9
1683248 ID     school 1600540 121   CAMAS COUNTY DISTRICT 160054000110 440 CAMAS COUNTY ELEM/JR HIGH SCHOOL   Regular School No 1.0 PK 08 2015   grade_8 10 0 2   0 0     0   1   7 6             7         13 10 0 2   0 0     0   1   7 6         7       13
1727292 ID     school 1600540 121   CAMAS COUNTY DISTRICT 160054000110 440 CAMAS COUNTY ELEM/JR HIGH SCHOOL   Regular School No Elementary PK 8.0 2017   grade_8 6 0 2   0 0     0   0   3 5             *         8 6 0 2   0 0     0   0   3 5                 8
1822298 ID     school 1600540 121   CAMAS COUNTY DISTRICT 160054000110 440 CAMAS COUNTY ELEM/JR HIGH SCHOOL   Regular School No 1.0 PK 08 2016   grade_8 11 0 0   0 0     0   0   7 4             *         11 11 0 0   0 0     0   0   7 4                 11
707077 ID     school 1600570 432   CAMBRIDGE JOINT DISTRICT 160057000113 193 CAMBRIDGE MIDDLE/HIGH SCHOOL   Regular School No High 06 12 2021   grade_8 14 0 1   0 0     0   0   7 8             9         15 14 0 1   0 0     0   0   7 8         9       15
852726 ID     school 1600570 432   CAMBRIDGE JOINT DISTRICT 160057000113 193 CAMBRIDGE MIDDLE/HIGH SCHOOL   Regular School No High 06 12 2020   grade_8 12 0 0   0 0     0   0   9 3             *         12 12 0 0   0 0     0   0   9 3                 12
1309125 ID     school 1600570 432   CAMBRIDGE JOINT DISTRICT 160057000113 193 CAMBRIDGE MIDDLE/HIGH SCHOOL   Regular School No High 06 12.0 2019   grade_8 9 0 0   0 0     0   0   9 0             *         9 9 0 0   0 0     0   0   9 0                 9
1685639 ID     school 1600570 432   CAMBRIDGE JOINT DISTRICT 160057000113 193 CAMBRIDGE MIDDLE/HIGH SCHOOL   Regular School No 3.0 07 12 2015   grade_8 10 0 0   0 0     0   0   6 4             5         10 10 0 0   0 0     0   0   6 4         5       10
1729715 ID     school 1600570 432   CAMBRIDGE JOINT DISTRICT 160057000113 193 CAMBRIDGE MIDDLE/HIGH SCHOOL   Regular School No Other 06 12.0 2017   grade_8 12 0 0   0 0     0   0   7 5             6         12 12 0 0   0 0     0   0   7 5         6       12
1824667 ID     school 1600570 432   CAMBRIDGE JOINT DISTRICT 160057000113 193 CAMBRIDGE MIDDLE/HIGH SCHOOL   Regular School No 3.0 07 12 2016   grade_8 7 0 0   0 0     0   2   4 5             *         9 7 0 0   0 0     0   2   4 5                 9
705748 ID     school 1600780 271   COEUR D'ALENE DISTRICT 160078000148 120 CANFIELD MIDDLE SCHOOL   Regular School No Middle 06 08 2021   grade_8 261 3 17   0 2     0   12   170 125             *         295 261 3 17   0 2     0   12   170 125                 295
851408 ID     school 1600780 271   COEUR D'ALENE DISTRICT 160078000148 120 CANFIELD MIDDLE SCHOOL   Regular School No Middle 06 08 2020   grade_8 260 0 16   2 1     0   14   144 149             *         293 260 0 16   2 1     0   14   144 149                 293
1278934 ID     school 1600780 271   COEUR D'ALENE DISTRICT 160078000148 120 CANFIELD MIDDLE SCHOOL   Regular School No Middle 06 8.0 2018   grade_8 225 1 15   1 4     1   12   131 128             *         259 225 1 15   1 4     1   12   131 128                 259
1307804 ID     school 1600780 271   COEUR D'ALENE DISTRICT 160078000148 120 CANFIELD MIDDLE SCHOOL   Regular School No Middle 06 8.0 2019   grade_8 255 1 18   0 3     0   5   160 122             *         282 255 1 18   0 3     0   5   160 122                 282
1684339 ID     school 1600780 271   COEUR D'ALENE DISTRICT 160078000148 120 CANFIELD MIDDLE SCHOOL   Regular School No 2.0 06 08 2015   grade_8 277 5 13   2 1     0   7   152 153             *         305 277 5 13   2 1     0   7   152 153                 305
1728400 ID     school 1600780 271   COEUR D'ALENE DISTRICT 160078000148 120 CANFIELD MIDDLE SCHOOL   Regular School No Middle 06 8.0 2017   grade_8 246 1 11   0 8     0   6   132 140             *         272 246 1 11   0 8     0   6   132 140                 272
1823391 ID     school 1600780 271   COEUR D'ALENE DISTRICT 160078000148 120 CANFIELD MIDDLE SCHOOL   Regular School No 2.0 06 08 2016   grade_8 230 2 22   1 4     1   12   141 131             *         272 230 2 22   1 4     1   12   141 131                 272
850491 ID     school 1600510 132   CALDWELL DISTRICT 160051000041 1090 CANYON SPRINGS HIGH SCHOOL   Alternative School No High 06 12 2020   grade_8 2 0 4   0 0     0   0   5 1             *         6 2 0 4   0 0     0   0   5 1                 6
1278031 ID     school 1600510 132   CALDWELL DISTRICT 160051000041 1090 CANYON SPRINGS HIGH SCHOOL   Alternative School No High 06 12.0 2018   grade_8 0 0 1   0 0     0   0   0 1             *         1 0 0 1   0 0     0   0   0 1                 1
1306889 ID     school 1600510 132   CALDWELL DISTRICT 160051000041 1090 CANYON SPRINGS HIGH SCHOOL   Alternative School No High 06 12.0 2019   grade_8 3 0 17   0 0     0   2   18 4             *         22 3 0 17   0 0     0   2   18 4                 22
703970 ID     school 1600300 61   BLAINE COUNTY DISTRICT 160030000034 197 CAREY PUBLIC SCHOOL   Regular School No Other PK 12 2021   grade_8 14 0 7   0 0     0   1   11 11             9         22 14 0 7   0 0     0   1   11 11         9       22
849707 ID     school 1600300 61   BLAINE COUNTY DISTRICT 160030000034 197 CAREY PUBLIC SCHOOL   Regular School No Other PK 12 2020   grade_8 11 0 4   0 0     0   0   7 8             *         15 11 0 4   0 0     0   0   7 8                 15
1277255 ID     school 1600300 61   BLAINE COUNTY DISTRICT 160030000034 197 CAREY PUBLIC SCHOOL   Regular School No Other PK 12.0 2018   grade_8 16 0 5   0 0     0   0   13 8             12         21 16 0 5   0 0     0   0   13 8         12       21
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
1682682 ID     school 1600300 61   BLAINE COUNTY DISTRICT 160030000034 197 CAREY PUBLIC SCHOOL   Regular School No 4.0 PK 12 2015   grade_8 13 0 6   0 0     0   0   8 11             10         19 13 0 6   0 0     0   0   8 11         10       19
1726720 ID     school 1600300 61   BLAINE COUNTY DISTRICT 160030000034 197 CAREY PUBLIC SCHOOL   Regular School No Other PK 12.0 2017   grade_8 15 0 7   0 0     0   0   10 12             11         22 15 0 7   0 0     0   0   10 12         11       22
1821719 ID     school 1600300 61   BLAINE COUNTY DISTRICT 160030000034 197 CAREY PUBLIC SCHOOL   Regular School No 4.0 PK 12 2016   grade_8 19 0 4   0 0     0   1   16 8             12         24 19 0 4   0 0     0   1   16 8         12       24
707041 ID     school 1600630 422   CASCADE DISTRICT 160063000121 190 CASCADE JR/SR HIGH SCHOOL   Regular School No High 06 12 2021   grade_8 15 1 0   0 0     0   0   11 5             *         16 15 1 0   0 0     0   0   11 5                 16
852690 ID     school 1600630 422   CASCADE DISTRICT 160063000121 190 CASCADE JR/SR HIGH SCHOOL   Regular School No High 06 12 2020   grade_8 13 0 0   1 0     0   1   9 6             5         15 13 0 0   1 0     0   1   9 6         5       15
1280213 ID     school 1600630 422   CASCADE DISTRICT 160063000121 190 CASCADE JR/SR HIGH SCHOOL   Regular School No High 07 12.0 2018   grade_8 18 0 1   1 0     0   0   8 12             9         20 18 0 1   1 0     0   0   8 12         9       20
1309087 ID     school 1600630 422   CASCADE DISTRICT 160063000121 190 CASCADE JR/SR HIGH SCHOOL   Regular School No High 07 12.0 2019   grade_8 9 1 1   2 0     0   0   5 8             *         13 9 1 1   2 0     0   0   5 8                 13
1685603 ID     school 1600630 422   CASCADE DISTRICT 160063000121 190 CASCADE JR/SR HIGH SCHOOL   Regular School No 3.0 07 12 2015   grade_8 15 0 0   0 0     0   0   9 6             *         15 15 0 0   0 0     0   0   9 6                 15
1729679 ID     school 1600630 422   CASCADE DISTRICT 160063000121 190 CASCADE JR/SR HIGH SCHOOL   Regular School No High 07 12.0 2017   grade_8 17 0 2   0 1     0   0   9 11             11         20 17 0 2   0 1     0   0   9 11         11       20
1824631 ID     school 1600630 422   CASCADE DISTRICT 160063000121 190 CASCADE JR/SR HIGH SCHOOL   Regular School No 3.0 07 12 2016   grade_8 21 0 2   0 0     0   0   13 10             14         23 21 0 2   0 0     0   0   13 10         14       23
705110 ID     school 1600660 151   CASSIA COUNTY JOINT DISTRICT 160066000540 990 CASSIA JR/SR HIGH SCHOOL   Alternative School No High 07 12 2021   grade_8 5 0 4   0 0     0   0   4 5             *         9 5 0 4   0 0     0   0   4 5                 9
850829 ID     school 1600660 151   CASSIA COUNTY JOINT DISTRICT 160066000540 990 CASSIA JR/SR HIGH SCHOOL   Alternative School No High 07 12 2020   grade_8 6 1 5   0 0     0   0   10 2             *         12 6 1 5   0 0     0   0   10 2                 12
1278360 ID     school 1600660 151   CASSIA COUNTY JOINT DISTRICT 160066000540 990 CASSIA JR/SR HIGH SCHOOL   Alternative School No High 07 12.0 2018   grade_8 5 0 10   1 0     0   0   11 5             *         16 5 0 10   1 0     0   0   11 5                 16
1307226 ID     school 1600660 151   CASSIA COUNTY JOINT DISTRICT 160066000540 990 CASSIA JR/SR HIGH SCHOOL   Alternative School No High 07 12.0 2019   grade_8 6 0 10   0 0     0   0   11 5             *         16 6 0 10   0 0     0   0   11 5                 16
1683758 ID     school 1600660 151   CASSIA COUNTY JOINT DISTRICT 160066000540 990 CASSIA JR/SR HIGH SCHOOL   Alternative Education School No 3.0 07 12 2015   grade_8 4 1 18   0 0     0   1   18 6             *         24 4 1 18   0 0     0   1   18 6                 24
1727814 ID     school 1600660 151   CASSIA COUNTY JOINT DISTRICT 160066000540 990 CASSIA JR/SR HIGH SCHOOL   Alternative School No High 07 12.0 2017   grade_8 3 0 5   0 0     0   0   5 3             *         8 3 0 5   0 0     0   0   5 3                 8
1822804 ID     school 1600660 151   CASSIA COUNTY JOINT DISTRICT 160066000540 990 CASSIA JR/SR HIGH SCHOOL   Alternative Education School No 3.0 07 12 2016   grade_8 10 0 9   0 0     0   0   13 6             *         19 10 0 9   0 0     0   0   13 6                 19
706990 ID     school 1600690 417   CASTLEFORD DISTRICT 160069000137 185 CASTLEFORD SCHOOL   Regular School No Other PK 12 2021   grade_8 10 0 7   1 0     0   0   5 13             13         18 10 0 7   1 0     0   0   5 13         13       18
852639 ID     school 1600690 417   CASTLEFORD DISTRICT 160069000137 185 CASTLEFORD SCHOOL   Regular School No Other PK 12 2020   grade_8 19 0 6   0 0     0   0   9 16             16         25 19 0 6   0 0     0   0   9 16         16       25
1280163 ID     school 1600690 417   CASTLEFORD DISTRICT 160069000137 185 CASTLEFORD SCHOOL   Regular School No Other PK 12.0 2018   grade_8 16 0 8   0 0     0   0   13 11             12         24 16 0 8   0 0     0   0   13 11         12       24
1309037 ID     school 1600690 417   CASTLEFORD DISTRICT 160069000137 185 CASTLEFORD SCHOOL   Regular School No Other PK 12.0 2019   grade_8 20 0 10   0 0     0   1   17 14             21         31 20 0 10   0 0     0   1   17 14         21       31
1685551 ID     school 1600690 417   CASTLEFORD DISTRICT 160069000137 185 CASTLEFORD SCHOOL   Regular School No 4.0 PK 12 2015   grade_8 17 0 6   0 0     0   0   10 13             16         23 17 0 6   0 0     0   0   10 13         16       23
1729629 ID     school 1600690 417   CASTLEFORD DISTRICT 160069000137 185 CASTLEFORD SCHOOL   Regular School No Other PK 12.0 2017   grade_8 28 0 5   0 0     0   0   13 20             19         33 28 0 5   0 0     0   0   13 20         19       33
1824580 ID     school 1600690 417   CASTLEFORD DISTRICT 160069000137 185 CASTLEFORD SCHOOL   Regular School No 4.0 PK 12 2016   grade_8 19 0 4   0 0     0   0   9 14             13         23 19 0 4   0 0     0   0   9 14         13       23
705847 ID     school 1600780 271   COEUR D'ALENE DISTRICT 160078000704 1038 CDA JUVENILE DETENTION CENTER   Alternative School No Other 04 12 2021   grade_8 1 0 0   0 0     0   1   2 0             *         2 1 0 0   0 0     0   1   2 0                 2
1279034 ID     school 1600780 271   COEUR D'ALENE DISTRICT 160078000704 1038 CDA JUVENILE DETENTION CENTER   Alternative School No Other 04 12.0 2018   grade_8 1 0 0   0 0     0   0   1 0             *         1 1 0 0   0 0     0   0   1 0                 1

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