enrollments

Data source: Big Local News · About: Big Local

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

✎ View and edit SQL

This data as json, CSV (advanced)

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 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
848559 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
1276115 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
1304972 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
1681544 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
1725567 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
1820579 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
702771 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
848563 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
1276119 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
1304976 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
1681548 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
1725571 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
1820583 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
702775 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
848567 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
1276123 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
1304980 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
1681552 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
1725575 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
1820587 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
702779 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
848571 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
1276127 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
1304984 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
1681556 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
1725579 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
1820591 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
703098 703098 ID     school 1602100 2   JOINT SCHOOL DISTRICT NO. 2 160210000367 10 LOWELL SCOTT MIDDLE SCHOOL   Regular School No Middle 06 08 2021   grade_7 218 11 28   2 7     2   14   141 141             65         282 218 11 28   2 7     2   14   141 141         65       282
848891 848891 ID     school 1602100 2   JOINT SCHOOL DISTRICT NO. 2 160210000367 10 LOWELL SCOTT MIDDLE SCHOOL   Regular School No Middle 06 08 2020   grade_7 268 17 30   0 12     0   11   179 159             109         338 268 17 30   0 12     0   11   179 159         109       338
1276445 1276445 ID     school 1602100 2   JOINT SCHOOL DISTRICT NO. 2 160210000367 10 LOWELL SCOTT MIDDLE SCHOOL   Regular School No Middle 06 8.0 2018   grade_7 257 12 27   3 21     2   16   163 175             96         338 257 12 27   3 21     2   16   163 175         96       338
1305301 1305301 ID     school 1602100 2   JOINT SCHOOL DISTRICT NO. 2 160210000367 10 LOWELL SCOTT MIDDLE SCHOOL   Regular School No Middle 06 8.0 2019   grade_7 264 9 35   0 7     0   14   173 156             102         329 264 9 35   0 7     0   14   173 156         102       329
1681876 1681876 ID     school 1602100 2   JOINT SCHOOL DISTRICT NO. 2 160210000367 10 LOWELL SCOTT MIDDLE SCHOOL   Regular School No 2.0 06 08 2015   grade_7 249 14 32   2 9     0   13   165 154             107         319 249 14 32   2 9     0   13   165 154         107       319
1725897 1725897 ID     school 1602100 2   JOINT SCHOOL DISTRICT NO. 2 160210000367 10 LOWELL SCOTT MIDDLE SCHOOL   Regular School No Middle 06 8.0 2017   grade_7 283 7 36   3 7     2   14   173 179             108         352 283 7 36   3 7     2   14   173 179         108       352
1820906 1820906 ID     school 1602100 2   JOINT SCHOOL DISTRICT NO. 2 160210000367 10 LOWELL SCOTT MIDDLE SCHOOL   Regular School No 2.0 06 08 2016   grade_7 255 7 40   4 12     1   12   164 167             91         331 255 7 40   4 12     1   12   164 167         91       331
703102 703102 ID     school 1602100 2   JOINT SCHOOL DISTRICT NO. 2 160210000370 11 MERIDIAN MIDDLE SCHOOL   Regular School No Middle 06 08 2021   grade_7 278 4 63   2 3     3   12   177 188             94         365 278 4 63   2 3     3   12   177 188         94       365
848895 848895 ID     school 1602100 2   JOINT SCHOOL DISTRICT NO. 2 160210000370 11 MERIDIAN MIDDLE SCHOOL   Regular School No Middle 06 08 2020   grade_7 282 7 87   3 8     1   10   207 191             170         398 282 7 87   3 8     1   10   207 191         170       398
1276449 1276449 ID     school 1602100 2   JOINT SCHOOL DISTRICT NO. 2 160210000370 11 MERIDIAN MIDDLE SCHOOL   Regular School No Middle 06 8.0 2018   grade_7 269 5 56   3 4     0   12   181 168             147         349 269 5 56   3 4     0   12   181 168         147       349
1305305 1305305 ID     school 1602100 2   JOINT SCHOOL DISTRICT NO. 2 160210000370 11 MERIDIAN MIDDLE SCHOOL   Regular School No Middle 06 8.0 2019   grade_7 272 8 76   3 6     1   11   198 179             158         377 272 8 76   3 6     1   11   198 179         158       377
1681880 1681880 ID     school 1602100 2   JOINT SCHOOL DISTRICT NO. 2 160210000370 11 MERIDIAN MIDDLE SCHOOL   Regular School No 2.0 06 08 2015   grade_7 246 6 58   2 6     1   12   169 162             156         331 246 6 58   2 6     1   12   169 162         156       331
1725901 1725901 ID     school 1602100 2   JOINT SCHOOL DISTRICT NO. 2 160210000370 11 MERIDIAN MIDDLE SCHOOL   Regular School No Middle 06 8.0 2017   grade_7 245 5 57   3 9     1   8   167 161             152         328 245 5 57   3 9     1   8   167 161         152       328
1820910 1820910 ID     school 1602100 2   JOINT SCHOOL DISTRICT NO. 2 160210000370 11 MERIDIAN MIDDLE SCHOOL   Regular School No 2.0 06 08 2016   grade_7 276 6 50   3 4     3   11   183 170             139         353 276 6 50   3 4     3   11   183 170         139       353
703457 703457 ID     school 1601770 3   KUNA JOINT DISTRICT 160177000306 13 KUNA MIDDLE SCHOOL   Regular School No Middle 06 08 2021   grade_7 196 3 44   1 2     1   10   137 120             70         257 196 3 44   1 2     1   10   137 120         70       257
849229 849229 ID     school 1601770 3   KUNA JOINT DISTRICT 160177000306 13 KUNA MIDDLE SCHOOL   Regular School No Middle 06 08 2020   grade_7 212 1 48   0 2     0   10   151 122             96         273 212 1 48   0 2     0   10   151 122         96       273
1276776 1276776 ID     school 1601770 3   KUNA JOINT DISTRICT 160177000306 13 KUNA MIDDLE SCHOOL   Regular School No Middle 06 8.0 2018   grade_7 349 5 55   1 0     5   13   234 194             150         428 349 5 55   1 0     5   13   234 194         150       428
1305639 1305639 ID     school 1601770 3   KUNA JOINT DISTRICT 160177000306 13 KUNA MIDDLE SCHOOL   Regular School No Middle 06 8.0 2019   grade_7 224 0 46   4 4     3   5   147 139             89         286 224 0 46   4 4     3   5   147 139         89       286
1682200 1682200 ID     school 1601770 3   KUNA JOINT DISTRICT 160177000306 13 KUNA MIDDLE SCHOOL   Regular School No 2.0 06 08 2015   grade_7 367 5 44   1 2     0   9   212 216             159         428 367 5 44   1 2     0   9   212 216         159       428
1726239 1726239 ID     school 1601770 3   KUNA JOINT DISTRICT 160177000306 13 KUNA MIDDLE SCHOOL   Regular School No Middle 06 8.0 2017   grade_7 345 2 51   5 2     1   12   221 197             180         418 345 2 51   5 2     1   12   221 197         180       418
1821237 1821237 ID     school 1601770 3   KUNA JOINT DISTRICT 160177000306 13 KUNA MIDDLE SCHOOL   Regular School No 2.0 06 08 2016   grade_7 354 2 47   5 1     0   11   225 195             163         420 354 2 47   5 1     0   11   225 195         163       420
703530 703530 ID     school 1600840 13   COUNCIL DISTRICT 160084000163 17 COUNCIL JR/SR HIGH SCHOOL   Regular School No High 07 12 2021   grade_7 27 0 1   0 0     0   0   14 14             10         28 27 0 1   0 0     0   0   14 14         10       28
849297 849297 ID     school 1600840 13   COUNCIL DISTRICT 160084000163 17 COUNCIL JR/SR HIGH SCHOOL   Regular School No High 07 12 2020   grade_7 23 0 0   0 0     0   0   13 10             10         23 23 0 0   0 0     0   0   13 10         10       23
1276848 1276848 ID     school 1600840 13   COUNCIL DISTRICT 160084000163 17 COUNCIL JR/SR HIGH SCHOOL   Regular School No High 07 12.0 2018   grade_7 26 0 1   0 0     0   3   13 17             15         30 26 0 1   0 0     0   3   13 17         15       30
1305707 1305707 ID     school 1600840 13   COUNCIL DISTRICT 160084000163 17 COUNCIL JR/SR HIGH SCHOOL   Regular School No High 07 12.0 2019   grade_7 28 0 0   0 0     0   1   14 15             20         29 28 0 0   0 0     0   1   14 15         20       29
1682272 1682272 ID     school 1600840 13   COUNCIL DISTRICT 160084000163 17 COUNCIL JR/SR HIGH SCHOOL   Regular School No 3.0 07 12 2015   grade_7 19 0 0   0 0     0   0   11 8             10         19 19 0 0   0 0     0   0   11 8         10       19
1726311 1726311 ID     school 1600840 13   COUNCIL DISTRICT 160084000163 17 COUNCIL JR/SR HIGH SCHOOL   Regular School No High 07 12.0 2017   grade_7 13 0 0   0 0     0   3   7 9             10         16 13 0 0   0 0     0   3   7 9         10       16
1821309 1821309 ID     school 1600840 13   COUNCIL DISTRICT 160084000163 17 COUNCIL JR/SR HIGH SCHOOL   Regular School No 3.0 07 12 2016   grade_7 18 0 3   0 0     1   0   8 14             12         22 18 0 3   0 0     1   0   8 14         12       22
703542 703542 ID     school 1601950 21   MARSH VALLEY JOINT DISTRICT 160195000348 18 MARSH VALLEY MIDDLE SCHOOL   Regular School No Middle 07 08 2021   grade_7 97 0 2   1 0     1   1   51 51             28         102 97 0 2   1 0     1   1   51 51         28       102
849309 849309 ID     school 1601950 21   MARSH VALLEY JOINT DISTRICT 160195000348 18 MARSH VALLEY MIDDLE SCHOOL   Regular School No Middle 07 08 2020   grade_7 94 1 2   1 0     0   0   52 46             37         98 94 1 2   1 0     0   0   52 46         37       98
1276860 1276860 ID     school 1601950 21   MARSH VALLEY JOINT DISTRICT 160195000348 18 MARSH VALLEY MIDDLE SCHOOL   Regular School No Middle 07 8.0 2018   grade_7 98 4 5   1 0     0   0   60 48             42         108 98 4 5   1 0     0   0   60 48         42       108
1305719 1305719 ID     school 1601950 21   MARSH VALLEY JOINT DISTRICT 160195000348 18 MARSH VALLEY MIDDLE SCHOOL   Regular School No Middle 07 8.0 2019   grade_7 111 0 5   2 0     1   1   59 61             42         120 111 0 5   2 0     1   1   59 61         42       120
1682284 1682284 ID     school 1601950 21   MARSH VALLEY JOINT DISTRICT 160195000348 18 MARSH VALLEY MIDDLE SCHOOL   Regular School No 2.0 07 08 2015   grade_7 101 0 3   0 0     0   0   46 58             44         104 101 0 3   0 0     0   0   46 58         44       104
1726323 1726323 ID     school 1601950 21   MARSH VALLEY JOINT DISTRICT 160195000348 18 MARSH VALLEY MIDDLE SCHOOL   Regular School No Middle 07 8.0 2017   grade_7 107 2 2   0 0     2   1   67 47             51         114 107 2 2   0 0     2   1   67 47         51       114
1821321 1821321 ID     school 1601950 21   MARSH VALLEY JOINT DISTRICT 160195000348 18 MARSH VALLEY MIDDLE SCHOOL   Regular School No 2.0 07 08 2016   grade_7 82 0 6   0 0     1   2   53 38             42         91 82 0 6   0 0     1   2   53 38         42       91
703583 703583 ID     school 1602640 25   POCATELLO DISTRICT 160264000469 20 FRANKLIN MIDDLE SCHOOL   Regular School No Middle 06 08 2021   grade_7 204 0 28   2 0     3   9   116 130             *         246 204 0 28   2 0     3   9   116 130                 246
849350 849350 ID     school 1602640 25   POCATELLO DISTRICT 160264000469 20 FRANKLIN MIDDLE SCHOOL   Regular School No Middle 06 08 2020   grade_7 207 1 26   1 5     5   10   138 117             96         255 207 1 26   1 5     5   10   138 117         96       255
1276901 1276901 ID     school 1602640 25   POCATELLO DISTRICT 160264000469 20 FRANKLIN MIDDLE SCHOOL   Regular School No Middle 06 8.0 2018   grade_7 214 0 15   2 7     2   9   110 139             *         249 214 0 15   2 7     2   9   110 139                 249
1305760 1305760 ID     school 1602640 25   POCATELLO DISTRICT 160264000469 20 FRANKLIN MIDDLE SCHOOL   Regular School No Middle 06 8.0 2019   grade_7 235 0 27   2 3     1   13   148 133             103         281 235 0 27   2 3     1   13   148 133         103       281
1682325 1682325 ID     school 1602640 25   POCATELLO DISTRICT 160264000469 20 FRANKLIN MIDDLE SCHOOL   Regular School No 2.0 06 08 2015   grade_7 205 1 22   4 5     2   5   130 114             *         244 205 1 22   4 5     2   5   130 114                 244
1726364 1726364 ID     school 1602640 25   POCATELLO DISTRICT 160264000469 20 FRANKLIN MIDDLE SCHOOL   Regular School No Middle 06 8.0 2017   grade_7 215 3 15   3 4     3   5   137 111             *         248 215 3 15   3 4     3   5   137 111                 248
1821362 1821362 ID     school 1602640 25   POCATELLO DISTRICT 160264000469 20 FRANKLIN MIDDLE SCHOOL   Regular School No 2.0 06 08 2016   grade_7 212 1 16   5 2     1   4   137 104             *         241 212 1 16   5 2     1   4   137 104                 241
703587 703587 ID     school 1602640 25   POCATELLO DISTRICT 160264000471 21 HAWTHORNE MIDDLE SCHOOL   Regular School No Middle 06 08 2021   grade_7 188 0 32   28 1     1   5   113 142             126         255 188 0 32   28 1     1   5   113 142         126       255
849354 849354 ID     school 1602640 25   POCATELLO DISTRICT 160264000471 21 HAWTHORNE MIDDLE SCHOOL   Regular School No Middle 06 08 2020   grade_7 163 1 39   19 3     1   8   121 113             119         234 163 1 39   19 3     1   8   121 113         119       234
1276905 1276905 ID     school 1602640 25   POCATELLO DISTRICT 160264000471 21 HAWTHORNE MIDDLE SCHOOL   Regular School No Middle 06 8.0 2018   grade_7 197 1 32   32 0     0   9   111 160             141         271 197 1 32   32 0     0   9   111 160         141       271
1305764 1305764 ID     school 1602640 25   POCATELLO DISTRICT 160264000471 21 HAWTHORNE MIDDLE SCHOOL   Regular School No Middle 06 8.0 2019   grade_7 198 0 27   22 1     0   10   136 122             124         258 198 0 27   22 1     0   10   136 122         124       258
1682329 1682329 ID     school 1602640 25   POCATELLO DISTRICT 160264000471 21 HAWTHORNE MIDDLE SCHOOL   Regular School No 2.0 06 08 2015   grade_7 184 1 25   32 2     0   3   132 115             114         247 184 1 25   32 2     0   3   132 115         114       247
1726368 1726368 ID     school 1602640 25   POCATELLO DISTRICT 160264000471 21 HAWTHORNE MIDDLE SCHOOL   Regular School No Middle 06 8.0 2017   grade_7 180 3 18   27 0     3   8   127 112             120         239 180 3 18   27 0     3   8   127 112         120       239
1821366 1821366 ID     school 1602640 25   POCATELLO DISTRICT 160264000471 21 HAWTHORNE MIDDLE SCHOOL   Regular School No 2.0 06 08 2016   grade_7 177 4 19   37 2     2   3   130 114             128         244 177 4 19   37 2     2   3   130 114         128       244
703591 703591 ID     school 1602640 25   POCATELLO DISTRICT 160264000474 22 IRVING MIDDLE SCHOOL   Regular School No Middle 06 08 2021   grade_7 180 0 25   6 0     1   11   114 109             121         223 180 0 25   6 0     1   11   114 109         121       223
849358 849358 ID     school 1602640 25   POCATELLO DISTRICT 160264000474 22 IRVING MIDDLE SCHOOL   Regular School No Middle 06 08 2020   grade_7 183 0 45   5 1     1   3   124 114             122         238 183 0 45   5 1     1   3   124 114         122       238
1276909 1276909 ID     school 1602640 25   POCATELLO DISTRICT 160264000474 22 IRVING MIDDLE SCHOOL   Regular School No Middle 06 8.0 2018   grade_7 145 2 31   5 2     3   6   105 89             123         194 145 2 31   5 2     3   6   105 89         123       194
1305768 1305768 ID     school 1602640 25   POCATELLO DISTRICT 160264000474 22 IRVING MIDDLE SCHOOL   Regular School No Middle 06 8.0 2019   grade_7 149 1 28   1 0     1   15   98 97             *         195 149 1 28   1 0     1   15   98 97                 195
1682333 1682333 ID     school 1602640 25   POCATELLO DISTRICT 160264000474 22 IRVING MIDDLE SCHOOL   Regular School No 2.0 06 08 2015   grade_7 149 2 24   8 0     0   3   91 95             108         186 149 2 24   8 0     0   3   91 95         108       186
1726372 1726372 ID     school 1602640 25   POCATELLO DISTRICT 160264000474 22 IRVING MIDDLE SCHOOL   Regular School No Middle 06 8.0 2017   grade_7 162 5 22   1 2     0   4   94 102             115         196 162 5 22   1 2     0   4   94 102         115       196
1821370 1821370 ID     school 1602640 25   POCATELLO DISTRICT 160264000474 22 IRVING MIDDLE SCHOOL   Regular School No 2.0 06 08 2016   grade_7 159 4 29   8 0     0   2   95 107             109         202 159 4 29   8 0     0   2   95 107         109       202
703595 703595 ID     school 1602640 25   POCATELLO DISTRICT 160264001047 23 ALAMEDA MIDDLE SCHOOL   Regular School No Middle 06 08 2021   grade_7 153 2 38   3 0     2   8   111 95             94         206 153 2 38   3 0     2   8   111 95         94       206
849362 849362 ID     school 1602640 25   POCATELLO DISTRICT 160264001047 23 ALAMEDA MIDDLE SCHOOL   Regular School No Middle 06 08 2020   grade_7 161 1 42   6 1     3   8   114 108             120         222 161 1 42   6 1     3   8   114 108         120       222
1276913 1276913 ID     school 1602640 25   POCATELLO DISTRICT 160264001047 23 ALAMEDA MIDDLE SCHOOL   Regular School No Middle 06 8.0 2018   grade_7 206 1 38   6 3     0   10   151 113             141         264 206 1 38   6 3     0   10   151 113         141       264
1305772 1305772 ID     school 1602640 25   POCATELLO DISTRICT 160264001047 23 ALAMEDA MIDDLE SCHOOL   Regular School No Middle 06 8.0 2019   grade_7 172 0 29   8 1     1   7   112 106             103         218 172 0 29   8 1     1   7   112 106         103       218
1682337 1682337 ID     school 1602640 25   POCATELLO DISTRICT 160264001047 23 ALAMEDA MIDDLE SCHOOL   Regular School No 2.0 06 08 2015   grade_7 157 3 20   6 1     0   5   94 98             114         192 157 3 20   6 1     0   5   94 98         114       192
1726376 1726376 ID     school 1602640 25   POCATELLO DISTRICT 160264001047 23 ALAMEDA MIDDLE SCHOOL   Regular School No Middle 06 8.0 2017   grade_7 177 1 33   6 0     3   6   112 114             125         226 177 1 33   6 0     3   6   112 114         125       226
1821374 1821374 ID     school 1602640 25   POCATELLO DISTRICT 160264001047 23 ALAMEDA MIDDLE SCHOOL   Regular School No 2.0 06 08 2016   grade_7 165 2 37   3 2     0   7   109 107             116         216 165 2 37   3 2     0   7   109 107         116       216
703718 703718 ID     school 1600240 33   BEAR LAKE COUNTY DISTRICT 160024000017 26 BEAR LAKE MIDDLE SCHOOL   Regular School No Middle 06 08 2021   grade_7 85 1 3   0 0     0   0   30 59             *         89 85 1 3   0 0     0   0   30 59                 89
849487 849487 ID     school 1600240 33   BEAR LAKE COUNTY DISTRICT 160024000017 26 BEAR LAKE MIDDLE SCHOOL   Regular School No Middle 06 08 2020   grade_7 89 0 3   0 0     0   0   47 45             49         92 89 0 3   0 0     0   0   47 45         49       92
1277034 1277034 ID     school 1600240 33   BEAR LAKE COUNTY DISTRICT 160024000017 26 BEAR LAKE MIDDLE SCHOOL   Regular School No Middle 06 8.0 2018   grade_7 80 0 2   0 0     0   1   36 47             37         83 80 0 2   0 0     0   1   36 47         37       83
1305895 1305895 ID     school 1600240 33   BEAR LAKE COUNTY DISTRICT 160024000017 26 BEAR LAKE MIDDLE SCHOOL   Regular School No Middle 06 8.0 2019   grade_7 91 0 2   0 0     1   0   53 41             45         94 91 0 2   0 0     1   0   53 41         45       94
1682460 1682460 ID     school 1600240 33   BEAR LAKE COUNTY DISTRICT 160024000017 26 BEAR LAKE MIDDLE SCHOOL   Regular School No 2.0 06 08 2015   grade_7 79 0 5   1 0     1   0   49 37             33         86 79 0 5   1 0     1   0   49 37         33       86
1726499 1726499 ID     school 1600240 33   BEAR LAKE COUNTY DISTRICT 160024000017 26 BEAR LAKE MIDDLE SCHOOL   Regular School No Middle 06 8.0 2017   grade_7 83 1 3   0 0     1   0   42 46             45         88 83 1 3   0 0     1   0   42 46         45       88
1821495 1821495 ID     school 1600240 33   BEAR LAKE COUNTY DISTRICT 160024000017 26 BEAR LAKE MIDDLE SCHOOL   Regular School No 2.0 06 08 2016   grade_7 73 0 5   0 0     0   2   36 44             37         80 73 0 5   0 0     0   2   36 44         37       80
703763 703763 ID     school 1603060 41   ST MARIES JOINT DISTRICT 160306000534 28 ST MARIES MIDDLE SCHOOL   Regular School No Middle 06 08 2021   grade_7 69 0 1   1 1     0   6   43 35             34         78 69 0 1   1 1     0   6   43 35         34       78
849521 849521 ID     school 1603060 41   ST MARIES JOINT DISTRICT 160306000534 28 ST MARIES MIDDLE SCHOOL   Regular School No Middle 06 08 2020   grade_7 75 0 2   0 0     0   3   44 36             51         80 75 0 2   0 0     0   3   44 36         51       80

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