Data source: Big Local News · About: Big Local

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

View and edit SQL

year

grade

  • grade_7 · 1,582
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
702767 ID     school 1600360 1   BOISE INDEPENDENT DISTRICT 160036000051 2 FAIRMONT JUNIOR HIGH SCHOOL   Regular School No Middle 07 09 2021   grade_7 129 21 71   0 9     1   14   118 127             131         245 129 21 71   0 9     1   14   118 127         131       245
702771 ID     school 1600360 1   BOISE INDEPENDENT DISTRICT 160036000057 3 HILLSIDE JUNIOR HIGH SCHOOL   Regular School No Middle 07 09 2021   grade_7 320 35 60   0 25     5   26   238 233             130         471 320 35 60   0 25     5   26   238 233         130       471
702775 ID     school 1600360 1   BOISE INDEPENDENT DISTRICT 160036000069 4 NORTH JUNIOR HIGH SCHOOL   Regular School No Middle 07 09 2021   grade_7 198 10 20   2 3     1   9   127 116             32         243 198 10 20   2 3     1   9   127 116         32       243
702779 ID     school 1600360 1   BOISE INDEPENDENT DISTRICT 160036000073 5 SOUTH JUNIOR HIGH SCHOOL   Regular School No Middle 07 09 2021   grade_7 126 14 41   2 3     2   3   92 99             105         191 126 14 41   2 3     2   3   92 99         105       191
702796 ID     school 1600360 1   BOISE INDEPENDENT DISTRICT 160036000183 206 LES BOIS JUNIOR HIGH SCHOOL   Regular School No Middle 06 09 2021   grade_7 158 4 19   1 7     0   9   94 104             *         198 158 4 19   1 7     0   9   94 104                 198
702800 ID     school 1600360 1   BOISE INDEPENDENT DISTRICT 160036000632 242 RIVERGLEN JR HIGH SCHOOL   Regular School No Middle 07 09 2021   grade_7 108 4 23   0 1     1   2   68 71             38         139 108 4 23   0 1     1   2   68 71         38       139
703033 ID     school 1600360 1   BOISE INDEPENDENT DISTRICT 160036000823 573 TREASURE VALLEY MATH/SCIENCE   Regular School No Other 04 12 2021   grade_7 19 0 0   0 1     0   0   9 11             *         20 19 0 0   0 1     0   0   9 11                 20
703072 ID     school 1600360 1   BOISE INDEPENDENT DISTRICT 160036000984 675 FRANK CHURCH HIGH SCHOOL   Alternative School No High 06 12 2021   grade_7 2 0 1   0 0     0   0   3 0             *         3 2 0 1   0 0     0   0   3 0                 3
703076 ID     school 1600360 1   BOISE INDEPENDENT DISTRICT 160036000987 676 WEST JUNIOR HIGH   Regular School No Middle 07 09 2021   grade_7 197 11 29   1 5     2   8   134 119             82         253 197 11 29   1 5     2   8   134 119         82       253
703080 ID     school 1600360 1   BOISE INDEPENDENT DISTRICT 160036001002 677 EAST JUNIOR HIGH SCHOOL   Regular School No Middle 07 09 2021   grade_7 143 1 18   1 18     0   5   103 83             41         186 143 1 18   1 18     0   5   103 83         41       186
848559 ID     school 1600360 1   BOISE INDEPENDENT DISTRICT 160036000051 2 FAIRMONT JUNIOR HIGH SCHOOL   Regular School No Middle 07 09 2020   grade_7 163 10 73   1 6     1   13   132 135             147         267 163 10 73   1 6     1   13   132 135         147       267
848563 ID     school 1600360 1   BOISE INDEPENDENT DISTRICT 160036000057 3 HILLSIDE JUNIOR HIGH SCHOOL   Regular School No Middle 07 09 2020   grade_7 155 25 16   0 7     1   12   101 115             76         216 155 25 16   0 7     1   12   101 115         76       216
848567 ID     school 1600360 1   BOISE INDEPENDENT DISTRICT 160036000069 4 NORTH JUNIOR HIGH SCHOOL   Regular School No Middle 07 09 2020   grade_7 288 5 35   4 6     0   13   158 193             64         351 288 5 35   4 6     0   13   158 193         64       351
848571 ID     school 1600360 1   BOISE INDEPENDENT DISTRICT 160036000073 5 SOUTH JUNIOR HIGH SCHOOL   Regular School No Middle 07 09 2020   grade_7 157 16 54   0 4     2   14   125 122             167         247 157 16 54   0 4     2   14   125 122         167       247
848588 ID     school 1600360 1   BOISE INDEPENDENT DISTRICT 160036000183 206 LES BOIS JUNIOR HIGH SCHOOL   Regular School No Middle 06 09 2020   grade_7 181 5 23   1 20     2   9   118 123             61         241 181 5 23   1 20     2   9   118 123         61       241
848592 ID     school 1600360 1   BOISE INDEPENDENT DISTRICT 160036000632 242 RIVERGLEN JR HIGH SCHOOL   Regular School No Middle 07 09 2020   grade_7 152 1 31   0 4     1   8   99 98             68         197 152 1 31   0 4     1   8   99 98         68       197
848824 ID     school 1600360 1   BOISE INDEPENDENT DISTRICT 160036000823 573 TREASURE VALLEY MATH/SCIENCE   Regular School No Other 04 12 2020   grade_7 8 0 1   1 4     0   0   9 5             *         14 8 0 1   1 4     0   0   9 5                 14
848863 ID     school 1600360 1   BOISE INDEPENDENT DISTRICT 160036000984 675 FRANK CHURCH HIGH SCHOOL   Alternative School No High 06 12 2020   grade_7 2 0 0   0 0     0   0   2 0             *         2 2 0 0   0 0     0   0   2 0                 2
848867 ID     school 1600360 1   BOISE INDEPENDENT DISTRICT 160036000987 676 WEST JUNIOR HIGH   Regular School No Middle 07 09 2020   grade_7 225 11 50   3 7     0   10   155 151             126         306 225 11 50   3 7     0   10   155 151         126       306
848871 ID     school 1600360 1   BOISE INDEPENDENT DISTRICT 160036001002 677 EAST JUNIOR HIGH SCHOOL   Regular School No Middle 07 09 2020   grade_7 174 4 19   1 28     2   7   120 115             *         235 174 4 19   1 28     2   7   120 115                 235
1276115 ID     school 1600360 1   BOISE INDEPENDENT DISTRICT 160036000051 2 FAIRMONT JUNIOR HIGH SCHOOL   Regular School No Middle 07 9.0 2018   grade_7 164 15 81   2 10     3   7   143 139             *         282 164 15 81   2 10     3   7   143 139                 282
1276119 ID     school 1600360 1   BOISE INDEPENDENT DISTRICT 160036000057 3 HILLSIDE JUNIOR HIGH SCHOOL   Regular School No Middle 07 9.0 2018   grade_7 156 25 20   0 8     1   4   112 102             83         214 156 25 20   0 8     1   4   112 102         83       214
1276123 ID     school 1600360 1   BOISE INDEPENDENT DISTRICT 160036000069 4 NORTH JUNIOR HIGH SCHOOL   Regular School No Middle 07 9.0 2018   grade_7 277 4 34   0 8     1   11   195 140             67         335 277 4 34   0 8     1   11   195 140         67       335
1276127 ID     school 1600360 1   BOISE INDEPENDENT DISTRICT 160036000073 5 SOUTH JUNIOR HIGH SCHOOL   Regular School No Middle 07 9.0 2018   grade_7 163 11 39   1 8     1   9   118 114             *         232 163 11 39   1 8     1   9   118 114                 232
1276146 ID     school 1600360 1   BOISE INDEPENDENT DISTRICT 160036000183 206 LES BOIS JUNIOR HIGH SCHOOL   Regular School No Middle 06 9.0 2018   grade_7 200 8 28   0 14     2   11   139 124             66         263 200 8 28   0 14     2   11   139 124         66       263
1276150 ID     school 1600360 1   BOISE INDEPENDENT DISTRICT 160036000632 242 RIVERGLEN JR HIGH SCHOOL   Regular School No Middle 07 9.0 2018   grade_7 142 7 35   2 6     0   8   106 94             81         200 142 7 35   2 6     0   8   106 94         81       200
1276378 ID     school 1600360 1   BOISE INDEPENDENT DISTRICT 160036000823 573 TREASURE VALLEY MATH/SCIENCE   Regular School No Other 04 12.0 2018   grade_7 22 0 1   0 7     0   1   23 8             *         31 22 0 1   0 7     0   1   23 8                 31
1276417 ID     school 1600360 1   BOISE INDEPENDENT DISTRICT 160036000984 675 FRANK CHURCH HIGH SCHOOL   Alternative School No High 06 12.0 2018   grade_7 1 0 0   0 0     0   0   1 0             *         1 1 0 0   0 0     0   0   1 0                 1
1276421 ID     school 1600360 1   BOISE INDEPENDENT DISTRICT 160036000987 676 WEST JUNIOR HIGH   Regular School No Middle 07 9.0 2018   grade_7 232 11 30   0 7     1   7   139 149             99         288 232 11 30   0 7     1   7   139 149         99       288
1276425 ID     school 1600360 1   BOISE INDEPENDENT DISTRICT 160036001002 677 EAST JUNIOR HIGH SCHOOL   Regular School No Middle 07 9.0 2018   grade_7 203 5 15   0 24     1   7   138 117             48         255 203 5 15   0 24     1   7   138 117         48       255
1276440 ID     school 1600360 1   BOISE INDEPENDENT DISTRICT 160036000708 9002 ADA COUNTY JUVENILE CENTER   Alternative School No High 05 12.0 2018   grade_7 1 0 1   0 0     0   0   2 0             *         2 1 0 1   0 0     0   0   2 0                 2
1304972 ID     school 1600360 1   BOISE INDEPENDENT DISTRICT 160036000051 2 FAIRMONT JUNIOR HIGH SCHOOL   Regular School No Middle 07 9.0 2019   grade_7 151 17 58   6 9     4   15   140 120             110         260 151 17 58   6 9     4   15   140 120         110       260
1304976 ID     school 1600360 1   BOISE INDEPENDENT DISTRICT 160036000057 3 HILLSIDE JUNIOR HIGH SCHOOL   Regular School No Middle 07 9.0 2019   grade_7 167 15 18   0 2     1   8   107 104             64         211 167 15 18   0 2     1   8   107 104         64       211
1304980 ID     school 1600360 1   BOISE INDEPENDENT DISTRICT 160036000069 4 NORTH JUNIOR HIGH SCHOOL   Regular School No Middle 07 9.0 2019   grade_7 229 5 24   1 11     0   9   137 142             56         279 229 5 24   1 11     0   9   137 142         56       279
1304984 ID     school 1600360 1   BOISE INDEPENDENT DISTRICT 160036000073 5 SOUTH JUNIOR HIGH SCHOOL   Regular School No Middle 07 9.0 2019   grade_7 159 14 40   1 10     0   11   119 116             91         235 159 14 40   1 10     0   11   119 116         91       235
1305002 ID     school 1600360 1   BOISE INDEPENDENT DISTRICT 160036000183 206 LES BOIS JUNIOR HIGH SCHOOL   Regular School No Middle 06 9.0 2019   grade_7 210 4 28   2 17     1   5   147 120             55         267 210 4 28   2 17     1   5   147 120         55       267
1305006 ID     school 1600360 1   BOISE INDEPENDENT DISTRICT 160036000632 242 RIVERGLEN JR HIGH SCHOOL   Regular School No Middle 07 9.0 2019   grade_7 149 3 24   2 4     0   8   104 86             58         190 149 3 24   2 4     0   8   104 86         58       190
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
1305273 ID     school 1600360 1   BOISE INDEPENDENT DISTRICT 160036000984 675 FRANK CHURCH HIGH SCHOOL   Alternative School No High 06 12.0 2019   grade_7 7 0 0   0 0     0   0   5 2             *         7 7 0 0   0 0     0   0   5 2                 7
1305277 ID     school 1600360 1   BOISE INDEPENDENT DISTRICT 160036000987 676 WEST JUNIOR HIGH   Regular School No Middle 07 9.0 2019   grade_7 218 9 36   1 9     1   9   146 137             89         283 218 9 36   1 9     1   9   146 137         89       283
1305281 ID     school 1600360 1   BOISE INDEPENDENT DISTRICT 160036001002 677 EAST JUNIOR HIGH SCHOOL   Regular School No Middle 07 9.0 2019   grade_7 189 1 15   1 15     1   10   123 109             49         232 189 1 15   1 15     1   10   123 109         49       232
1305296 ID     school 1600360 1   BOISE INDEPENDENT DISTRICT 160036000708 9002 ADA COUNTY JUVENILE CENTER   Alternative School No High 05 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
1681544 ID     school 1600360 1   BOISE INDEPENDENT DISTRICT 160036000051 2 FAIRMONT JUNIOR HIGH SCHOOL   Regular School No 2.0 07 09 2015   grade_7 207 10 69   0 10     3   6   164 141             219         305 207 10 69   0 10     3   6   164 141         219       305
1681548 ID     school 1600360 1   BOISE INDEPENDENT DISTRICT 160036000057 3 HILLSIDE JUNIOR HIGH SCHOOL   Regular School No 2.0 07 09 2015   grade_7 146 17 10   1 8     0   3   108 77             75         185 146 17 10   1 8     0   3   108 77         75       185
1681552 ID     school 1600360 1   BOISE INDEPENDENT DISTRICT 160036000069 4 NORTH JUNIOR HIGH SCHOOL   Regular School No 2.0 07 09 2015   grade_7 221 3 25   0 7     1   7   123 141             60         264 221 3 25   0 7     1   7   123 141         60       264
1681556 ID     school 1600360 1   BOISE INDEPENDENT DISTRICT 160036000073 5 SOUTH JUNIOR HIGH SCHOOL   Regular School No 2.0 07 09 2015   grade_7 143 16 37   3 4     1   5   104 105             141         209 143 16 37   3 4     1   5   104 105         141       209
1681573 ID     school 1600360 1   BOISE INDEPENDENT DISTRICT 160036000183 206 LES BOIS JUNIOR HIGH SCHOOL   Regular School No 2.0 06 09 2015   grade_7 172 1 14   1 6     3   5   107 95             72         202 172 1 14   1 6     3   5   107 95         72       202
1681577 ID     school 1600360 1   BOISE INDEPENDENT DISTRICT 160036000632 242 RIVERGLEN JR HIGH SCHOOL   Regular School No 2.0 07 09 2015   grade_7 160 4 26   1 4     1   5   115 86             71         201 160 4 26   1 4     1   5   115 86         71       201
1681809 ID     school 1600360 1   BOISE INDEPENDENT DISTRICT 160036000823 573 TREASURE VALLEY MATH/SCIENCE   Regular School No 4.0 04 12 2015   grade_7 25 0 1   0 2     0   1   18 11             *         29 25 0 1   0 2     0   1   18 11                 29
1681848 ID     school 1600360 1   BOISE INDEPENDENT DISTRICT 160036000984 675 FRANK CHURCH HIGH SCHOOL   Alternative Education School No 3.0 07 12 2015   grade_7 2 0 0   0 0     0   1   3 0             *         3 2 0 0   0 0     0   1   3 0                 3
1681852 ID     school 1600360 1   BOISE INDEPENDENT DISTRICT 160036000987 676 WEST JUNIOR HIGH   Regular School No 2.0 07 09 2015   grade_7 264 9 34   0 12     1   11   155 176             129         331 264 9 34   0 12     1   11   155 176         129       331
1681856 ID     school 1600360 1   BOISE INDEPENDENT DISTRICT 160036001002 677 EAST JUNIOR HIGH SCHOOL   Regular School No 2.0 07 09 2015   grade_7 158 2 14   1 17     1   3   91 105             *         196 158 2 14   1 17     1   3   91 105                 196
1681871 ID     school 1600360 1   BOISE INDEPENDENT DISTRICT 160036000708 9002 ADA COUNTY JUVENILE CENTER   Alternative Education School No 4.0 05 12 2015   grade_7 1 0 0   0 0     0   0   1 0             *         1 1 0 0   0 0     0   0   1 0                 1
1725567 ID     school 1600360 1   BOISE INDEPENDENT DISTRICT 160036000051 2 FAIRMONT JUNIOR HIGH SCHOOL   Regular School No Other 07 9.0 2017   grade_7 162 15 60   3 12     1   11   150 114             *         264 162 15 60   3 12     1   11   150 114                 264
1725571 ID     school 1600360 1   BOISE INDEPENDENT DISTRICT 160036000057 3 HILLSIDE JUNIOR HIGH SCHOOL   Regular School No Other 07 9.0 2017   grade_7 169 26 18   0 12     1   5   107 124             90         231 169 26 18   0 12     1   5   107 124         90       231
1725575 ID     school 1600360 1   BOISE INDEPENDENT DISTRICT 160036000069 4 NORTH JUNIOR HIGH SCHOOL   Regular School No Other 07 9.0 2017   grade_7 286 2 24   1 11     2   9   143 192             65         335 286 2 24   1 11     2   9   143 192         65       335
1725579 ID     school 1600360 1   BOISE INDEPENDENT DISTRICT 160036000073 5 SOUTH JUNIOR HIGH SCHOOL   Regular School No Other 07 9.0 2017   grade_7 163 7 43   2 2     1   3   126 95             *         221 163 7 43   2 2     1   3   126 95                 221
1725596 ID     school 1600360 1   BOISE INDEPENDENT DISTRICT 160036000183 206 LES BOIS JUNIOR HIGH SCHOOL   Regular School No Other 06 9.0 2017   grade_7 185 3 22   4 11     1   10   126 110             58         236 185 3 22   4 11     1   10   126 110         58       236
1725600 ID     school 1600360 1   BOISE INDEPENDENT DISTRICT 160036000632 242 RIVERGLEN JR HIGH SCHOOL   Regular School No Other 07 9.0 2017   grade_7 145 1 23   5 5     1   4   101 83             75         184 145 1 23   5 5     1   4   101 83         75       184
1725830 ID     school 1600360 1   BOISE INDEPENDENT DISTRICT 160036000823 573 TREASURE VALLEY MATH/SCIENCE   Regular School No Other 04 12.0 2017   grade_7 18 2 2   0 6     0   0   15 13             *         28 18 2 2   0 6     0   0   15 13                 28
1725869 ID     school 1600360 1   BOISE INDEPENDENT DISTRICT 160036000984 675 FRANK CHURCH HIGH SCHOOL   Alternative School No Other 06 12.0 2017   grade_7 2 1 0   0 0     0   0   2 1             *         3 2 1 0   0 0     0   0   2 1                 3
1725873 ID     school 1600360 1   BOISE INDEPENDENT DISTRICT 160036000987 676 WEST JUNIOR HIGH   Regular School No Other 07 9.0 2017   grade_7 246 4 39   3 9     3   6   163 147             95         310 246 4 39   3 9     3   6   163 147         95       310
1725877 ID     school 1600360 1   BOISE INDEPENDENT DISTRICT 160036001002 677 EAST JUNIOR HIGH SCHOOL   Regular School No Other 07 9.0 2017   grade_7 185 6 17   3 17     1   4   128 105             53         233 185 6 17   3 17     1   4   128 105         53       233
1725893 ID     school 1600360 1   BOISE INDEPENDENT DISTRICT 160036000708 9002 ADA COUNTY JUVENILE CENTER   Alternative School No Other 05 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
1820579 ID     school 1600360 1   BOISE INDEPENDENT DISTRICT 160036000051 2 FAIRMONT JUNIOR HIGH SCHOOL   Regular School No 2.0 07 09 2016   grade_7 156 11 51   2 6     1   9   114 122             *         236 156 11 51   2 6     1   9   114 122                 236
1820583 ID     school 1600360 1   BOISE INDEPENDENT DISTRICT 160036000057 3 HILLSIDE JUNIOR HIGH SCHOOL   Regular School No 2.0 07 09 2016   grade_7 172 15 16   0 9     1   1   112 102             85         214 172 15 16   0 9     1   1   112 102         85       214
1820587 ID     school 1600360 1   BOISE INDEPENDENT DISTRICT 160036000069 4 NORTH JUNIOR HIGH SCHOOL   Regular School No 2.0 07 09 2016   grade_7 257 4 18   1 15     1   7   144 159             56         303 257 4 18   1 15     1   7   144 159         56       303
1820591 ID     school 1600360 1   BOISE INDEPENDENT DISTRICT 160036000073 5 SOUTH JUNIOR HIGH SCHOOL   Regular School No 2.0 07 09 2016   grade_7 152 5 38   0 11     4   7   112 105             *         217 152 5 38   0 11     4   7   112 105                 217
1820609 ID     school 1600360 1   BOISE INDEPENDENT DISTRICT 160036000183 206 LES BOIS JUNIOR HIGH SCHOOL   Regular School No 2.0 06 09 2016   grade_7 172 1 19   0 9     3   6   108 102             36         210 172 1 19   0 9     3   6   108 102         36       210
1820613 ID     school 1600360 1   BOISE INDEPENDENT DISTRICT 160036000632 242 RIVERGLEN JR HIGH SCHOOL   Regular School No 2.0 07 09 2016   grade_7 172 3 20   3 3     0   6   107 100             74         207 172 3 20   3 3     0   6   107 100         74       207
1820841 ID     school 1600360 1   BOISE INDEPENDENT DISTRICT 160036000823 573 TREASURE VALLEY MATH/SCIENCE   Regular School No 4.0 04 12 2016   grade_7 19 0 1   0 4     0   2   15 11             *         26 19 0 1   0 4     0   2   15 11                 26
1820882 ID     school 1600360 1   BOISE INDEPENDENT DISTRICT 160036000987 676 WEST JUNIOR HIGH   Regular School No 2.0 07 09 2016   grade_7 224 5 25   3 11     3   11   147 135             98         282 224 5 25   3 11     3   11   147 135         98       282
1820886 ID     school 1600360 1   BOISE INDEPENDENT DISTRICT 160036001002 677 EAST JUNIOR HIGH SCHOOL   Regular School No 2.0 07 09 2016   grade_7 169 4 23   0 14     1   7   113 105             47         218 169 4 23   0 14     1   7   113 105         47       218
1820901 ID     school 1600360 1   BOISE INDEPENDENT DISTRICT 160036000708 9002 ADA COUNTY JUVENILE CENTER   Alternative Education School No 4.0 05 12 2016   grade_7 1 1 0   0 0     0   0   2 0             *         2 1 1 0   0 0     0   0   2 0                 2
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 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 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 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 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 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 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
703522 ID     school 1602060 11   MEADOWS VALLEY DISTRICT 160206000826 342 MEADOWS VALLEY SCHOOL   Regular School No Other PK 12 2021   grade_7 11 0 0   1 0     0   0   7 5             *         12 11 0 0   1 0     0   0   7 5                 12
849289 ID     school 1602060 11   MEADOWS VALLEY DISTRICT 160206000826 342 MEADOWS VALLEY SCHOOL   Regular School No Other PK 12 2020   grade_7 16 0 1   0 0     0   1   10 8             10         18 16 0 1   0 0     0   1   10 8         10       18
1276840 ID     school 1602060 11   MEADOWS VALLEY DISTRICT 160206000826 342 MEADOWS VALLEY SCHOOL   Regular School No Other PK 12.0 2018   grade_7 13 0 1   0 0     0   0   10 4             6         14 13 0 1   0 0     0   0   10 4         6       14
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
1682264 ID     school 1602060 11   MEADOWS VALLEY DISTRICT 160206000826 342 MEADOWS VALLEY SCHOOL   Regular School No 4.0 PK 12 2015   grade_7 8 0 1   0 0     0   0   4 5             *         9 8 0 1   0 0     0   0   4 5                 9
1726303 ID     school 1602060 11   MEADOWS VALLEY DISTRICT 160206000826 342 MEADOWS VALLEY SCHOOL   Regular School No Other PK 12.0 2017   grade_7 12 0 1   0 0     1   1   8 7             10         15 12 0 1   0 0     1   1   8 7         10       15
1821301 ID     school 1602060 11   MEADOWS VALLEY DISTRICT 160206000826 342 MEADOWS VALLEY SCHOOL   Regular School No 4.0 PK 12 2016   grade_7 10 0 1   0 1     0   1   8 5             6         13 10 0 1   0 1     0   1   8 5         6       13
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 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
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
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
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 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 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
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 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 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 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 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

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