enrollments

Data source: Big Local News · About: Big Local

1,582 rows where grade = "grade_7" and state = "ID" sorted by school

✎ View and edit SQL

This data as json, CSV (advanced)

year ✖

grade ✖

  • grade_7 · 1,482 ✖
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
1278272 1278272 ID     school   150   SODA SPRINGS JOINT DISTRICT   1026 BORDER DISTRICT FREEDOM - SECONDARY             2018   grade_7 1 0 1   0 0     0   0   1 1             *         2 1 0 1   0 0     0   0   1 1                 2
1307128 1307128 ID     school   150   SODA SPRINGS JOINT DISTRICT   1026 BORDER DISTRICT FREEDOM - SECONDARY             2019   grade_7 1 0 1   0 0     0   0   1 1             *         2 1 0 1   0 0     0   0   1 1                 2
1727726 1727726 ID     school   150   SODA SPRINGS JOINT DISTRICT   1026 BORDER DISTRICT FREEDOM - SECONDARY             2017   grade_7 0 0 2   0 0     0   0   2 0             *         2 0 0 2   0 0     0   0   2 0                 2
704504 704504 ID     school 1600420 101   BOUNDARY COUNTY DISTRICT 160042000029 201 BOUNDARY COUNTY MIDDLE SCHOOL   Regular School No Middle 06 08 2021   grade_7 84 0 4   3 0     0   4   52 43             42         95 84 0 4   3 0     0   4   52 43         42       95
850229 850229 ID     school 1600420 101   BOUNDARY COUNTY DISTRICT 160042000029 201 BOUNDARY COUNTY MIDDLE SCHOOL   Regular School No Middle 06 08 2020   grade_7 82 1 4   3 0     0   3   49 44             45         93 82 1 4   3 0     0   3   49 44         45       93
1277769 1277769 ID     school 1600420 101   BOUNDARY COUNTY DISTRICT 160042000029 201 BOUNDARY COUNTY MIDDLE SCHOOL   Regular School No Middle 06 8.0 2018   grade_7 109 0 6   3 1     0   4   66 57             65         123 109 0 6   3 1     0   4   66 57         65       123
1306627 1306627 ID     school 1600420 101   BOUNDARY COUNTY DISTRICT 160042000029 201 BOUNDARY COUNTY MIDDLE SCHOOL   Regular School No Middle 06 8.0 2019   grade_7 92 1 7   2 0     0   5   50 57             63         107 92 1 7   2 0     0   5   50 57         63       107
1683189 1683189 ID     school 1600420 101   BOUNDARY COUNTY DISTRICT 160042000029 201 BOUNDARY COUNTY MIDDLE SCHOOL   Regular School No 2.0 06 08 2015   grade_7 88 2 4   5 2     0   0   52 49             61         101 88 2 4   5 2     0   0   52 49         61       101
1727233 1727233 ID     school 1600420 101   BOUNDARY COUNTY DISTRICT 160042000029 201 BOUNDARY COUNTY MIDDLE SCHOOL   Regular School No Middle 06 8.0 2017   grade_7 83 2 4   1 3     1   4   44 54             45         98 83 2 4   1 3     1   4   44 54         45       98
1822239 1822239 ID     school 1600420 101   BOUNDARY COUNTY DISTRICT 160042000029 201 BOUNDARY COUNTY MIDDLE SCHOOL   Regular School No 2.0 06 08 2016   grade_7 107 0 7   2 1     0   4   50 71             74         121 107 0 7   2 1     0   4   50 71         74       121
706851 706851 ID     school 1603240 411   TWIN FALLS DISTRICT 160324000755 1147 BRIDGE ACADEMY   Alternative School No Middle 07 08 2021   grade_7 16 0 11   0 0     0   0   20 7             14         27 16 0 11   0 0     0   0   20 7         14       27
852505 852505 ID     school 1603240 411   TWIN FALLS DISTRICT 160324000755 1147 BRIDGE ACADEMY   Alternative School No Middle 07 08 2020   grade_7 17 0 8   0 0     1   1   20 7             *         27 17 0 8   0 0     1   1   20 7                 27
1280029 1280029 ID     school 1603240 411   TWIN FALLS DISTRICT 160324000755 1147 BRIDGE ACADEMY   Alternative School No Middle 06 8.0 2018   grade_7 12 0 5   1 0     0   1   17 2             *         19 12 0 5   1 0     0   1   17 2                 19
1308898 1308898 ID     school 1603240 411   TWIN FALLS DISTRICT 160324000755 1147 BRIDGE ACADEMY   Alternative School No Middle 06 8.0 2019   grade_7 12 0 13   0 0     0   0   13 12             *         25 12 0 13   0 0     0   0   13 12                 25
1685447 1685447 ID     school 1603240 411   TWIN FALLS DISTRICT 160324000755 1147 BRIDGE ACADEMY   Alternative Education School No 3.0 07 12 2015   grade_7 28 0 5   0 5     0   0   26 12             *         38 28 0 5   0 5     0   0   26 12                 38
1729512 1729512 ID     school 1603240 411   TWIN FALLS DISTRICT 160324000755 1147 BRIDGE ACADEMY   Alternative School No Middle 06 8.0 2017   grade_7 18 3 10   1 0     0   0   24 8             *         32 18 3 10   1 0     0   0   24 8                 32
1824478 1824478 ID     school 1603240 411   TWIN FALLS DISTRICT 160324000755 1147 BRIDGE ACADEMY   Alternative Education School No 3.0 07 12 2016   grade_7 19 5 8   1 1     0   0   22 12             *         34 19 5 8   1 1     0   0   22 12                 34
706894 706894 ID     school 1600480 412   BUHL JOINT DISTRICT 160048000103 179 BUHL MIDDLE SCHOOL   Regular School No Middle 06 08 2021   grade_7 52 0 31   0 0     0   0   47 36             44         83 52 0 31   0 0     0   0   47 36         44       83
852541 852541 ID     school 1600480 412   BUHL JOINT DISTRICT 160048000103 179 BUHL MIDDLE SCHOOL   Regular School No Middle 06 08 2020   grade_7 64 0 41   0 0     0   4   54 55             50         109 64 0 41   0 0     0   4   54 55         50       109
1280071 1280071 ID     school 1600480 412   BUHL JOINT DISTRICT 160048000103 179 BUHL MIDDLE SCHOOL   Regular School No Middle 06 8.0 2018   grade_7 69 0 37   0 1     0   4   59 52             43         111 69 0 37   0 1     0   4   59 52         43       111
1308939 1308939 ID     school 1600480 412   BUHL JOINT DISTRICT 160048000103 179 BUHL MIDDLE SCHOOL   Regular School No Middle 06 8.0 2019   grade_7 60 0 48   0 1     0   3   58 54             27         112 60 0 48   0 1     0   3   58 54         27       112
1685463 1685463 ID     school 1600480 412   BUHL JOINT DISTRICT 160048000103 179 BUHL MIDDLE SCHOOL   Regular School No 2.0 06 08 2015   grade_7 58 3 38   1 0     0   0   48 52             68         100 58 3 38   1 0     0   0   48 52         68       100
1729540 1729540 ID     school 1600480 412   BUHL JOINT DISTRICT 160048000103 179 BUHL MIDDLE SCHOOL   Regular School No Middle 06 8.0 2017   grade_7 58 0 39   0 0     0   2   47 52             38         99 58 0 39   0 0     0   2   47 52         38       99
1824492 1824492 ID     school 1600480 412   BUHL JOINT DISTRICT 160048000103 179 BUHL MIDDLE SCHOOL   Regular School No 2.0 06 08 2016   grade_7 50 0 34   0 0     1   3   46 42             65         88 50 0 34   0 0     1   3   46 42         65       88
705021 705021 ID     school 1600660 151   CASSIA COUNTY JOINT DISTRICT 160066000125 80 BURLEY JUNIOR HIGH SCHOOL   Regular School No Middle 07 08 2021   grade_7 166 0 100   1 3     0   1   131 140             121         271 166 0 100   1 3     0   1   131 140         121       271
850735 850735 ID     school 1600660 151   CASSIA COUNTY JOINT DISTRICT 160066000125 80 BURLEY JUNIOR HIGH SCHOOL   Regular School No Middle 07 08 2020   grade_7 171 2 151   2 1     1   4   160 172             205         332 171 2 151   2 1     1   4   160 172         205       332
1278276 1278276 ID     school 1600660 151   CASSIA COUNTY JOINT DISTRICT 160066000125 80 BURLEY JUNIOR HIGH SCHOOL   Regular School No Middle 07 8.0 2018   grade_7 160 3 131   0 0     0   4   155 143             179         298 160 3 131   0 0     0   4   155 143         179       298
1307132 1307132 ID     school 1600660 151   CASSIA COUNTY JOINT DISTRICT 160066000125 80 BURLEY JUNIOR HIGH SCHOOL   Regular School No Middle 07 8.0 2019   grade_7 161 1 134   1 0     0   3   162 138             176         300 161 1 134   1 0     0   3   162 138         176       300
1683674 1683674 ID     school 1600660 151   CASSIA COUNTY JOINT DISTRICT 160066000125 80 BURLEY JUNIOR HIGH SCHOOL   Regular School No 2.0 07 08 2015   grade_7 156 1 115   2 0     2   0   147 129             166         276 156 1 115   2 0     2   0   147 129         166       276
1727730 1727730 ID     school 1600660 151   CASSIA COUNTY JOINT DISTRICT 160066000125 80 BURLEY JUNIOR HIGH SCHOOL   Regular School No Middle 07 8.0 2017   grade_7 149 1 111   5 0     3   4   150 123             169         273 149 1 111   5 0     3   4   150 123         169       273
1822720 1822720 ID     school 1600660 151   CASSIA COUNTY JOINT DISTRICT 160066000125 80 BURLEY JUNIOR HIGH SCHOOL   Regular School No 2.0 07 08 2016   grade_7 132 3 112   0 3     0   1   123 128             146         251 132 3 112   0 3     0   1   123 128         146       251
1277794 1277794 ID     school 1600490 111   BUTTE COUNTY JOINT DISTRICT 160049000662 58 BUTTE COUNTY MIDDLE SCHOOL   Regular School No Middle 06 8.0 2018   grade_7 28 0 1   2 0     0   0   20 11             15         31 28 0 1   2 0     0   0   20 11         15       31
1683214 1683214 ID     school 1600490 111   BUTTE COUNTY JOINT DISTRICT 160049000662 58 BUTTE COUNTY MIDDLE SCHOOL   Regular School No 2.0 06 08 2015   grade_7 24 0 0   0 0     0   1   18 7             10         25 24 0 0   0 0     0   1   18 7         10       25
1727258 1727258 ID     school 1600490 111   BUTTE COUNTY JOINT DISTRICT 160049000662 58 BUTTE COUNTY MIDDLE SCHOOL   Regular School No Middle 06 8.0 2017   grade_7 32 1 3   3 0     0   0   20 19             22         39 32 1 3   3 0     0   0   20 19         22       39
1822264 1822264 ID     school 1600490 111   BUTTE COUNTY JOINT DISTRICT 160049000662 58 BUTTE COUNTY MIDDLE SCHOOL   Regular School No 2.0 06 08 2016   grade_7 38 1 2   0 0     0   0   20 21             25         41 38 1 2   0 0     0   0   20 21         25       41
704531 704531 ID     school 1600490 111   BUTTE COUNTY JOINT DISTRICT 160049000008 59 BUTTE COUNTY MIDDLE/HIGH SCHOOL   Regular School No High 07 12 2021   grade_7 37 0 1   1 0     0   0   16 23             16         39 37 0 1   1 0     0   0   16 23         16       39
850256 850256 ID     school 1600490 111   BUTTE COUNTY JOINT DISTRICT 160049000008 59 BUTTE COUNTY MIDDLE/HIGH SCHOOL   Regular School No High 07 12 2020   grade_7 32 0 1   0 1     0   0   17 17             17         34 32 0 1   0 1     0   0   17 17         17       34
1306655 1306655 ID     school 1600490 111   BUTTE COUNTY JOINT DISTRICT 160049000008 59 BUTTE COUNTY MIDDLE/HIGH SCHOOL   Regular School No High 06 12.0 2019   grade_7 36 0 1   0 0     0   0   18 19             14         37 36 0 1   0 0     0   0   18 19         14       37
706749 706749 ID     school 1600150 394   AVERY SCHOOL DISTRICT 160015001010 820 CALDER SCHOOL   Regular School No Elementary KG 08 2021   grade_7 5 0 0   0 0     0   0   2 3             *         5 5 0 0   0 0     0   0   2 3                 5
852403 852403 ID     school 1600150 394   AVERY SCHOOL DISTRICT 160015001010 820 CALDER SCHOOL   Regular School No Elementary KG 08 2020   grade_7 3 0 0   0 0     0   0   3 0             *         3 3 0 0   0 0     0   0   3 0                 3
1308798 1308798 ID     school 1600150 394   AVERY SCHOOL DISTRICT 160015001010 820 CALDER SCHOOL   Regular School No Elementary KG 8.0 2019   grade_7 1 0 0   0 0     0   1   2 0             *         2 1 0 0   0 0     0   1   2 0                 2
1685342 1685342 ID     school 1600150 394   AVERY SCHOOL DISTRICT 160015001010 820 CALDER SCHOOL   Regular School No 1.0 KG 08 2015   grade_7 2 0 0   0 0     0   0   2 0             *         2 2 0 0   0 0     0   0   2 0                 2
1729410 1729410 ID     school 1600150 394   AVERY SCHOOL DISTRICT 160015001010 820 CALDER SCHOOL   Regular School No Other KG 12.0 2017   grade_7 0 0 0   0 0     0   1   0 1             *         1 0 0 0   0 0     0   1   0 1                 1
704556 704556 ID     school 1600540 121   CAMAS COUNTY DISTRICT 160054000110 440 CAMAS COUNTY ELEM/JR HIGH SCHOOL   Regular School No Elementary PK 08 2021   grade_7 14 0 2   0 0     0   0   5 11             *         16 14 0 2   0 0     0   0   5 11                 16
850284 850284 ID     school 1600540 121   CAMAS COUNTY DISTRICT 160054000110 440 CAMAS COUNTY ELEM/JR HIGH SCHOOL   Regular School No Elementary PK 08 2020   grade_7 19 0 0   0 0     0   0   7 12             8         19 19 0 0   0 0     0   0   7 12         8       19
1277826 1277826 ID     school 1600540 121   CAMAS COUNTY DISTRICT 160054000110 440 CAMAS COUNTY ELEM/JR HIGH SCHOOL   Regular School No Elementary PK 8.0 2018   grade_7 8 0 0   0 0     0   0   3 5             *         8 8 0 0   0 0     0   0   3 5                 8
1306683 1306683 ID     school 1600540 121   CAMAS COUNTY DISTRICT 160054000110 440 CAMAS COUNTY ELEM/JR HIGH SCHOOL   Regular School No Elementary PK 8.0 2019   grade_7 19 0 1   0 0     0   1   13 8             6         21 19 0 1   0 0     0   1   13 8         6       21
1683247 1683247 ID     school 1600540 121   CAMAS COUNTY DISTRICT 160054000110 440 CAMAS COUNTY ELEM/JR HIGH SCHOOL   Regular School No 1.0 PK 08 2015   grade_7 11 0 0   0 0     0   0   7 4             *         11 11 0 0   0 0     0   0   7 4                 11
1727291 1727291 ID     school 1600540 121   CAMAS COUNTY DISTRICT 160054000110 440 CAMAS COUNTY ELEM/JR HIGH SCHOOL   Regular School No Elementary PK 8.0 2017   grade_7 9 0 1   0 0     0   1   4 7             5         11 9 0 1   0 0     0   1   4 7         5       11
1822297 1822297 ID     school 1600540 121   CAMAS COUNTY DISTRICT 160054000110 440 CAMAS COUNTY ELEM/JR HIGH SCHOOL   Regular School No 1.0 PK 08 2016   grade_7 6 0 3   0 0     0   0   3 6             *         9 6 0 3   0 0     0   0   3 6                 9
707076 707076 ID     school 1600570 432   CAMBRIDGE JOINT DISTRICT 160057000113 193 CAMBRIDGE MIDDLE/HIGH SCHOOL   Regular School No High 06 12 2021   grade_7 16 0 3   0 0     0   0   10 9             9         19 16 0 3   0 0     0   0   10 9         9       19
852725 852725 ID     school 1600570 432   CAMBRIDGE JOINT DISTRICT 160057000113 193 CAMBRIDGE MIDDLE/HIGH SCHOOL   Regular School No High 06 12 2020   grade_7 10 0 0   0 0     0   0   4 6             *         10 10 0 0   0 0     0   0   4 6                 10
1280249 1280249 ID     school 1600570 432   CAMBRIDGE JOINT DISTRICT 160057000113 193 CAMBRIDGE MIDDLE/HIGH SCHOOL   Regular School No High 06 12.0 2018   grade_7 9 0 0   0 0     0   0   9 0             *         9 9 0 0   0 0     0   0   9 0                 9
1309124 1309124 ID     school 1600570 432   CAMBRIDGE JOINT DISTRICT 160057000113 193 CAMBRIDGE MIDDLE/HIGH SCHOOL   Regular School No High 06 12.0 2019   grade_7 9 0 0   0 0     0   0   7 2             *         9 9 0 0   0 0     0   0   7 2                 9
1685638 1685638 ID     school 1600570 432   CAMBRIDGE JOINT DISTRICT 160057000113 193 CAMBRIDGE MIDDLE/HIGH SCHOOL   Regular School No 3.0 07 12 2015   grade_7 8 0 0   0 0     0   3   6 5             *         11 8 0 0   0 0     0   3   6 5                 11
1824666 1824666 ID     school 1600570 432   CAMBRIDGE JOINT DISTRICT 160057000113 193 CAMBRIDGE MIDDLE/HIGH SCHOOL   Regular School No 3.0 07 12 2016   grade_7 13 0 0   0 0     0   0   9 4             7         13 13 0 0   0 0     0   0   9 4         7       13
705747 705747 ID     school 1600780 271   COEUR D'ALENE DISTRICT 160078000148 120 CANFIELD MIDDLE SCHOOL   Regular School No Middle 06 08 2021   grade_7 212 1 14   2 1     0   6   128 108             *         236 212 1 14   2 1     0   6   128 108                 236
851407 851407 ID     school 1600780 271   COEUR D'ALENE DISTRICT 160078000148 120 CANFIELD MIDDLE SCHOOL   Regular School No Middle 06 08 2020   grade_7 266 3 16   1 2     0   12   168 132             *         300 266 3 16   1 2     0   12   168 132                 300
1278933 1278933 ID     school 1600780 271   COEUR D'ALENE DISTRICT 160078000148 120 CANFIELD MIDDLE SCHOOL   Regular School No Middle 06 8.0 2018   grade_7 251 1 19   0 1     0   5   149 128             *         277 251 1 19   0 1     0   5   149 128                 277
1307803 1307803 ID     school 1600780 271   COEUR D'ALENE DISTRICT 160078000148 120 CANFIELD MIDDLE SCHOOL   Regular School No Middle 06 8.0 2019   grade_7 244 1 15   2 1     0   14   136 141             *         277 244 1 15   2 1     0   14   136 141                 277
1684338 1684338 ID     school 1600780 271   COEUR D'ALENE DISTRICT 160078000148 120 CANFIELD MIDDLE SCHOOL   Regular School No 2.0 06 08 2015   grade_7 220 2 23   0 4     0   13   137 125             *         262 220 2 23   0 4     0   13   137 125                 262
1728399 1728399 ID     school 1600780 271   COEUR D'ALENE DISTRICT 160078000148 120 CANFIELD MIDDLE SCHOOL   Regular School No Middle 06 8.0 2017   grade_7 218 1 15   1 3     1   12   134 117             49         251 218 1 15   1 3     1   12   134 117         49       251
1823390 1823390 ID     school 1600780 271   COEUR D'ALENE DISTRICT 160078000148 120 CANFIELD MIDDLE SCHOOL   Regular School No 2.0 06 08 2016   grade_7 238 1 7   0 8     0   7   126 135             96         261 238 1 7   0 8     0   7   126 135         96       261
850490 850490 ID     school 1600510 132   CALDWELL DISTRICT 160051000041 1090 CANYON SPRINGS HIGH SCHOOL   Alternative School No High 06 12 2020   grade_7 0 0 2   0 0     0   0   1 1             *         2 0 0 2   0 0     0   0   1 1                 2
1278030 1278030 ID     school 1600510 132   CALDWELL DISTRICT 160051000041 1090 CANYON SPRINGS HIGH SCHOOL   Alternative School No High 06 12.0 2018   grade_7 0 0 0   0 0     0   1   0 1             *         1 0 0 0   0 0     0   1   0 1                 1
1306888 1306888 ID     school 1600510 132   CALDWELL DISTRICT 160051000041 1090 CANYON SPRINGS HIGH SCHOOL   Alternative School No High 06 12.0 2019   grade_7 2 0 4   0 0     0   0   4 2             *         6 2 0 4   0 0     0   0   4 2                 6
703969 703969 ID     school 1600300 61   BLAINE COUNTY DISTRICT 160030000034 197 CAREY PUBLIC SCHOOL   Regular School No Other PK 12 2021   grade_7 16 0 6   0 0     0   1   12 11             7         23 16 0 6   0 0     0   1   12 11         7       23
849706 849706 ID     school 1600300 61   BLAINE COUNTY DISTRICT 160030000034 197 CAREY PUBLIC SCHOOL   Regular School No Other PK 12 2020   grade_7 15 0 7   0 0     0   1   13 10             12         23 15 0 7   0 0     0   1   13 10         12       23
1277254 1277254 ID     school 1600300 61   BLAINE COUNTY DISTRICT 160030000034 197 CAREY PUBLIC SCHOOL   Regular School No Other PK 12.0 2018   grade_7 15 0 9   0 0     0   0   13 11             11         24 15 0 9   0 0     0   0   13 11         11       24
1306114 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
1682681 1682681 ID     school 1600300 61   BLAINE COUNTY DISTRICT 160030000034 197 CAREY PUBLIC SCHOOL   Regular School No 4.0 PK 12 2015   grade_7 15 0 3   0 0     0   1   12 7             9         19 15 0 3   0 0     0   1   12 7         9       19
1726719 1726719 ID     school 1600300 61   BLAINE COUNTY DISTRICT 160030000034 197 CAREY PUBLIC SCHOOL   Regular School No Other PK 12.0 2017   grade_7 16 0 4   0 0     0   0   12 8             10         20 16 0 4   0 0     0   0   12 8         10       20
1821718 1821718 ID     school 1600300 61   BLAINE COUNTY DISTRICT 160030000034 197 CAREY PUBLIC SCHOOL   Regular School No 4.0 PK 12 2016   grade_7 12 0 8   0 0     0   0   7 13             10         20 12 0 8   0 0     0   0   7 13         10       20
707040 707040 ID     school 1600630 422   CASCADE DISTRICT 160063000121 190 CASCADE JR/SR HIGH SCHOOL   Regular School No High 06 12 2021   grade_7 11 0 0   1 0     0   0   6 6             *         12 11 0 0   1 0     0   0   6 6                 12
852689 852689 ID     school 1600630 422   CASCADE DISTRICT 160063000121 190 CASCADE JR/SR HIGH SCHOOL   Regular School No High 06 12 2020   grade_7 15 1 0   0 0     0   0   10 6             7         16 15 1 0   0 0     0   0   10 6         7       16
1280212 1280212 ID     school 1600630 422   CASCADE DISTRICT 160063000121 190 CASCADE JR/SR HIGH SCHOOL   Regular School No High 07 12.0 2018   grade_7 7 1 2   1 0     0   0   4 7             *         11 7 1 2   1 0     0   0   4 7                 11
1309086 1309086 ID     school 1600630 422   CASCADE DISTRICT 160063000121 190 CASCADE JR/SR HIGH SCHOOL   Regular School No High 07 12.0 2019   grade_7 17 0 0   1 0     0   1   13 6             9         19 17 0 0   1 0     0   1   13 6         9       19
1685602 1685602 ID     school 1600630 422   CASCADE DISTRICT 160063000121 190 CASCADE JR/SR HIGH SCHOOL   Regular School No 3.0 07 12 2015   grade_7 20 0 1   0 0     0   0   13 8             13         21 20 0 1   0 0     0   0   13 8         13       21
1729678 1729678 ID     school 1600630 422   CASCADE DISTRICT 160063000121 190 CASCADE JR/SR HIGH SCHOOL   Regular School No High 07 12.0 2017   grade_7 18 0 1   1 0     0   0   10 10             10         20 18 0 1   1 0     0   0   10 10         10       20
1824630 1824630 ID     school 1600630 422   CASCADE DISTRICT 160063000121 190 CASCADE JR/SR HIGH SCHOOL   Regular School No 3.0 07 12 2016   grade_7 20 0 1   0 1     0   0   8 14             16         22 20 0 1   0 1     0   0   8 14         16       22
1727820 1727820 ID     school 1600660 151   CASSIA COUNTY JOINT DISTRICT 160066001072 1377 CASSIA COUNTY DAY TREATMENT CENTER   Special Education School No Elementary KG 8.0 2017   grade_7 0 0 1   0 0     0   0   0 1             *         1 0 0 1   0 0     0   0   0 1                 1
705109 705109 ID     school 1600660 151   CASSIA COUNTY JOINT DISTRICT 160066000540 990 CASSIA JR/SR HIGH SCHOOL   Alternative School No High 07 12 2021   grade_7 1 0 0   0 0     0   0   1 0             *         1 1 0 0   0 0     0   0   1 0                 1
850828 850828 ID     school 1600660 151   CASSIA COUNTY JOINT DISTRICT 160066000540 990 CASSIA JR/SR HIGH SCHOOL   Alternative School No High 07 12 2020   grade_7 1 0 1   0 0     0   0   0 2             *         2 1 0 1   0 0     0   0   0 2                 2
1278359 1278359 ID     school 1600660 151   CASSIA COUNTY JOINT DISTRICT 160066000540 990 CASSIA JR/SR HIGH SCHOOL   Alternative School No High 07 12.0 2018   grade_7 2 0 1   0 0     0   0   1 2             *         3 2 0 1   0 0     0   0   1 2                 3
1307225 1307225 ID     school 1600660 151   CASSIA COUNTY JOINT DISTRICT 160066000540 990 CASSIA JR/SR HIGH SCHOOL   Alternative School No High 07 12.0 2019   grade_7 3 0 0   0 0     0   0   0 3             *         3 3 0 0   0 0     0   0   0 3                 3
1683757 1683757 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_7 0 0 1   0 0     0   0   1 0             *         1 0 0 1   0 0     0   0   1 0                 1
1727813 1727813 ID     school 1600660 151   CASSIA COUNTY JOINT DISTRICT 160066000540 990 CASSIA JR/SR HIGH SCHOOL   Alternative School No High 07 12.0 2017   grade_7 0 0 1   0 0     0   0   1 0             *         1 0 0 1   0 0     0   0   1 0                 1
1822803 1822803 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_7 0 0 1   0 0     0   0   0 1             *         1 0 0 1   0 0     0   0   0 1                 1
706989 706989 ID     school 1600690 417   CASTLEFORD DISTRICT 160069000137 185 CASTLEFORD SCHOOL   Regular School No Other PK 12 2021   grade_7 13 0 8   1 0     0   0   12 10             12         22 13 0 8   1 0     0   0   12 10         12       22
852638 852638 ID     school 1600690 417   CASTLEFORD DISTRICT 160069000137 185 CASTLEFORD SCHOOL   Regular School No Other PK 12 2020   grade_7 14 0 9   1 0     0   0   11 13             14         24 14 0 9   1 0     0   0   11 13         14       24
1280162 1280162 ID     school 1600690 417   CASTLEFORD DISTRICT 160069000137 185 CASTLEFORD SCHOOL   Regular School No Other PK 12.0 2018   grade_7 17 0 8   0 0     0   1   15 11             18         26 17 0 8   0 0     0   1   15 11         18       26
1309036 1309036 ID     school 1600690 417   CASTLEFORD DISTRICT 160069000137 185 CASTLEFORD SCHOOL   Regular School No Other PK 12.0 2019   grade_7 24 0 6   0 0     0   0   11 19             19         30 24 0 6   0 0     0   0   11 19         19       30
1685550 1685550 ID     school 1600690 417   CASTLEFORD DISTRICT 160069000137 185 CASTLEFORD SCHOOL   Regular School No 4.0 PK 12 2015   grade_7 14 0 7   1 0     0   0   10 12             14         22 14 0 7   1 0     0   0   10 12         14       22
1729628 1729628 ID     school 1600690 417   CASTLEFORD DISTRICT 160069000137 185 CASTLEFORD SCHOOL   Regular School No Other PK 12.0 2017   grade_7 18 0 6   0 0     0   0   13 11             12         24 18 0 6   0 0     0   0   13 11         12       24
1824579 1824579 ID     school 1600690 417   CASTLEFORD DISTRICT 160069000137 185 CASTLEFORD SCHOOL   Regular School No 4.0 PK 12 2016   grade_7 28 0 5   0 0     0   0   11 22             18         33 28 0 5   0 0     0   0   11 22         18       33
705846 705846 ID     school 1600780 271   COEUR D'ALENE DISTRICT 160078000704 1038 CDA JUVENILE DETENTION CENTER   Alternative School No Other 04 12 2021   grade_7 1 0 0   0 0     0   0   1 0             *         1 1 0 0   0 0     0   0   1 0                 1
851506 851506 ID     school 1600780 271   COEUR D'ALENE DISTRICT 160078000704 1038 CDA JUVENILE DETENTION CENTER   Alternative School No Other 04 12 2020   grade_7 1 0 0   0 0     0   0   1 0             *         1 1 0 0   0 0     0   0   1 0                 1
1279033 1279033 ID     school 1600780 271   COEUR D'ALENE DISTRICT 160078000704 1038 CDA JUVENILE DETENTION CENTER   Alternative School No Other 04 12.0 2018   grade_7 2 0 0   0 0     0   0   2 0             *         2 2 0 0   0 0     0   0   2 0                 2
1307902 1307902 ID     school 1600780 271   COEUR D'ALENE DISTRICT 160078000704 1038 CDA JUVENILE DETENTION CENTER   Alternative School No Other 04 12.0 2019   grade_7 1 1 0   0 0     0   0   2 0             *         2 1 1 0   0 0     0   0   2 0                 2
1684440 1684440 ID     school 1600780 271   COEUR D'ALENE DISTRICT 160078000704 1038 CDA JUVENILE DETENTION CENTER   Alternative Education School No 4.0 04 12 2015   grade_7 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]);