Data source: Big Local News · About: Big Local

33,441 rows where state = "ID"

View and edit SQL

grade

year

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
702768 ID     school 1600360 1   BOISE INDEPENDENT DISTRICT 160036000051 2 FAIRMONT JUNIOR HIGH SCHOOL   Regular School No Middle 07 09 2021   grade_8 117 16 61   0 7     1   13   106 109             91         215 117 16 61   0 7     1   13   106 109         91       215
702769 ID     school 1600360 1   BOISE INDEPENDENT DISTRICT 160036000051 2 FAIRMONT JUNIOR HIGH SCHOOL   Regular School No Middle 07 09 2021   grade_9 125 15 47   1 6     2   10   114 92             95         206 125 15 47   1 6     2   10   114 92         95       206
702770 ID     school 1600360 1   BOISE INDEPENDENT DISTRICT 160036000051 2 FAIRMONT JUNIOR HIGH SCHOOL   Regular School No Middle 07 09 2021   k_12_total 371 52 179   1 22     4   37   338 328             317         666 371 52 179   1 22     4   37   338 328         317       666
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
702772 ID     school 1600360 1   BOISE INDEPENDENT DISTRICT 160036000057 3 HILLSIDE JUNIOR HIGH SCHOOL   Regular School No Middle 07 09 2021   grade_8 393 30 75   3 27     4   24   262 294             165         556 393 30 75   3 27     4   24   262 294         165       556
702773 ID     school 1600360 1   BOISE INDEPENDENT DISTRICT 160036000057 3 HILLSIDE JUNIOR HIGH SCHOOL   Regular School No Middle 07 09 2021   grade_9 350 25 55   5 27     5   24   245 246             127         491 350 25 55   5 27     5   24   245 246         127       491
702774 ID     school 1600360 1   BOISE INDEPENDENT DISTRICT 160036000057 3 HILLSIDE JUNIOR HIGH SCHOOL   Regular School No Middle 07 09 2021   k_12_total 1063 90 190   8 79     14   74   745 773             422         1518 1063 90 190   8 79     14   74   745 773         422       1518
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
702776 ID     school 1600360 1   BOISE INDEPENDENT DISTRICT 160036000069 4 NORTH JUNIOR HIGH SCHOOL   Regular School No Middle 07 09 2021   grade_8 241 6 22   3 5     0   9   131 155             39         286 241 6 22   3 5     0   9   131 155         39       286
702777 ID     school 1600360 1   BOISE INDEPENDENT DISTRICT 160036000069 4 NORTH JUNIOR HIGH SCHOOL   Regular School No Middle 07 09 2021   grade_9 194 5 17   2 6     1   6   109 122             33         231 194 5 17   2 6     1   6   109 122         33       231
702778 ID     school 1600360 1   BOISE INDEPENDENT DISTRICT 160036000069 4 NORTH JUNIOR HIGH SCHOOL   Regular School No Middle 07 09 2021   k_12_total 633 21 59   7 14     2   24   367 393             104         760 633 21 59   7 14     2   24   367 393         104       760
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
702780 ID     school 1600360 1   BOISE INDEPENDENT DISTRICT 160036000073 5 SOUTH JUNIOR HIGH SCHOOL   Regular School No Middle 07 09 2021   grade_8 116 8 42   0 1     2   8   98 79             91         177 116 8 42   0 1     2   8   98 79         91       177
702781 ID     school 1600360 1   BOISE INDEPENDENT DISTRICT 160036000073 5 SOUTH JUNIOR HIGH SCHOOL   Regular School No Middle 07 09 2021   grade_9 107 9 28   1 3     0   5   80 73             76         153 107 9 28   1 3     0   5   80 73         76       153
702782 ID     school 1600360 1   BOISE INDEPENDENT DISTRICT 160036000073 5 SOUTH JUNIOR HIGH SCHOOL   Regular School No Middle 07 09 2021   k_12_total 349 31 111   3 7     4   16   270 251             272         521 349 31 111   3 7     4   16   270 251         272       521
702783 ID     school 1600360 1   BOISE INDEPENDENT DISTRICT 160036000044 7 BOISE SENIOR HIGH SCHOOL   Regular School No High 09 12 2021   grade_10 403 19 46   0 13     2   12   275 220             83         495 403 19 46   0 13     2   12   275 220         83       495
702784 ID     school 1600360 1   BOISE INDEPENDENT DISTRICT 160036000044 7 BOISE SENIOR HIGH SCHOOL   Regular School No High 09 12 2021   grade_11 388 23 28   3 20     2   13   222 255             72         477 388 23 28   3 20     2   13   222 255         72       477
702785 ID     school 1600360 1   BOISE INDEPENDENT DISTRICT 160036000044 7 BOISE SENIOR HIGH SCHOOL   Regular School No High 09 12 2021   grade_12 389 13 23   1 13     2   8   229 220             47         449 389 13 23   1 13     2   8   229 220         47       449
702786 ID     school 1600360 1   BOISE INDEPENDENT DISTRICT 160036000044 7 BOISE SENIOR HIGH SCHOOL   Regular School No High 09 12 2021   k_12_total 1180 55 97   4 46     6   33   726 695             202         1421 1180 55 97   4 46     6   33   726 695         202       1421
702787 ID     school 1600360 1   BOISE INDEPENDENT DISTRICT 160036000045 8 BORAH SENIOR HIGH SCHOOL   Regular School No High 09 12 2021   grade_10 320 28 49   0 11     2   11   217 204             129         421 320 28 49   0 11     2   11   217 204         129       421
702788 ID     school 1600360 1   BOISE INDEPENDENT DISTRICT 160036000045 8 BORAH SENIOR HIGH SCHOOL   Regular School No High 09 12 2021   grade_11 280 23 52   2 7     3   9   219 157             106         376 280 23 52   2 7     3   9   219 157         106       376
702789 ID     school 1600360 1   BOISE INDEPENDENT DISTRICT 160036000045 8 BORAH SENIOR HIGH SCHOOL   Regular School No High 09 12 2021   grade_12 258 16 43   2 13     5   9   200 146             *         346 258 16 43   2 13     5   9   200 146                 346
702790 ID     school 1600360 1   BOISE INDEPENDENT DISTRICT 160036000045 8 BORAH SENIOR HIGH SCHOOL   Regular School No High 09 12 2021   grade_9 1 0 0   0 0     0   0   1 0             *         1 1 0 0   0 0     0   0   1 0                 1
702791 ID     school 1600360 1   BOISE INDEPENDENT DISTRICT 160036000045 8 BORAH SENIOR HIGH SCHOOL   Regular School No High 09 12 2021   k_12_total 859 67 144   4 31     10   29   637 507             320         1144 859 67 144   4 31     10   29   637 507         320       1144
702792 ID     school 1600360 1   BOISE INDEPENDENT DISTRICT 160036000047 9 CAPITAL SENIOR HIGH SCHOOL   Regular School No High 09 12 2021   grade_10 255 21 90   2 20     1   12   212 189             142         401 255 21 90   2 20     1   12   212 189         142       401
702793 ID     school 1600360 1   BOISE INDEPENDENT DISTRICT 160036000047 9 CAPITAL SENIOR HIGH SCHOOL   Regular School No High 09 12 2021   grade_11 234 27 66   1 13     1   13   200 155             112         355 234 27 66   1 13     1   13   200 155         112       355
702794 ID     school 1600360 1   BOISE INDEPENDENT DISTRICT 160036000047 9 CAPITAL SENIOR HIGH SCHOOL   Regular School No High 09 12 2021   grade_12 252 17 47   3 9     3   11   177 165             87         342 252 17 47   3 9     3   11   177 165         87       342
702795 ID     school 1600360 1   BOISE INDEPENDENT DISTRICT 160036000047 9 CAPITAL SENIOR HIGH SCHOOL   Regular School No High 09 12 2021   k_12_total 741 65 203   6 42     5   36   589 509             341         1098 741 65 203   6 42     5   36   589 509         341       1098
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
702797 ID     school 1600360 1   BOISE INDEPENDENT DISTRICT 160036000183 206 LES BOIS JUNIOR HIGH SCHOOL   Regular School No Middle 06 09 2021   grade_8 144 3 17   1 8     0   6   82 97             37         179 144 3 17   1 8     0   6   82 97         37       179
702798 ID     school 1600360 1   BOISE INDEPENDENT DISTRICT 160036000183 206 LES BOIS JUNIOR HIGH SCHOOL   Regular School No Middle 06 09 2021   grade_9 180 3 17   2 8     1   3   111 103             *         214 180 3 17   2 8     1   3   111 103                 214
702799 ID     school 1600360 1   BOISE INDEPENDENT DISTRICT 160036000183 206 LES BOIS JUNIOR HIGH SCHOOL   Regular School No Middle 06 09 2021   k_12_total 482 10 53   4 23     1   18   287 304             96         591 482 10 53   4 23     1   18   287 304         96       591
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
702801 ID     school 1600360 1   BOISE INDEPENDENT DISTRICT 160036000632 242 RIVERGLEN JR HIGH SCHOOL   Regular School No Middle 07 09 2021   grade_8 112 3 20   0 5     0   9   76 73             44         149 112 3 20   0 5     0   9   76 73         44       149
702802 ID     school 1600360 1   BOISE INDEPENDENT DISTRICT 160036000632 242 RIVERGLEN JR HIGH SCHOOL   Regular School No Middle 07 09 2021   grade_9 116 4 22   1 2     0   7   90 62             41         152 116 4 22   1 2     0   7   90 62         41       152
702803 ID     school 1600360 1   BOISE INDEPENDENT DISTRICT 160036000632 242 RIVERGLEN JR HIGH SCHOOL   Regular School No Middle 07 09 2021   k_12_total 336 11 65   1 8     1   18   234 206             123         440 336 11 65   1 8     1   18   234 206         123       440
702804 ID     school 1600360 1   BOISE INDEPENDENT DISTRICT 160036000643 243 TIMBERLINE HIGH SCHOOL   Regular School No High 10 12 2021   grade_10 553 23 80   1 38     4   34   384 349             141         733 553 23 80   1 38     4   34   384 349         141       733
702805 ID     school 1600360 1   BOISE INDEPENDENT DISTRICT 160036000643 243 TIMBERLINE HIGH SCHOOL   Regular School No High 10 12 2021   grade_11 551 22 58   8 41     3   20   356 347             124         703 551 22 58   8 41     3   20   356 347         124       703
702806 ID     school 1600360 1   BOISE INDEPENDENT DISTRICT 160036000643 243 TIMBERLINE HIGH SCHOOL   Regular School No High 10 12 2021   grade_12 508 18 76   3 34     4   23   334 332             101         666 508 18 76   3 34     4   23   334 332         101       666
702807 ID     school 1600360 1   BOISE INDEPENDENT DISTRICT 160036000643 243 TIMBERLINE HIGH SCHOOL   Regular School No High 10 12 2021   k_12_total 1612 63 214   12 113     11   77   1074 1028             366         2102 1612 63 214   12 113     11   77   1074 1028         366       2102
702808 ID     school 1600360 1   BOISE INDEPENDENT DISTRICT 160036000590 287 TRAIL WIND ELEMENTARY   Regular School No Elementary PK 06 2021   grade_1 36 0 1   0 3     1   7   23 25             8         48 36 0 1   0 3     1   7   23 25         8       48
702809 ID     school 1600360 1   BOISE INDEPENDENT DISTRICT 160036000590 287 TRAIL WIND ELEMENTARY   Regular School No Elementary PK 06 2021   grade_2 47 0 5   0 2     0   1   28 27             5         55 47 0 5   0 2     0   1   28 27         5       55
702810 ID     school 1600360 1   BOISE INDEPENDENT DISTRICT 160036000590 287 TRAIL WIND ELEMENTARY   Regular School No Elementary PK 06 2021   grade_3 38 0 4   0 1     0   0   22 21             5         43 38 0 4   0 1     0   0   22 21         5       43
702811 ID     school 1600360 1   BOISE INDEPENDENT DISTRICT 160036000590 287 TRAIL WIND ELEMENTARY   Regular School No Elementary PK 06 2021   grade_4 67 0 2   0 1     1   4   44 31             8         75 67 0 2   0 1     1   4   44 31         8       75
702812 ID     school 1600360 1   BOISE INDEPENDENT DISTRICT 160036000590 287 TRAIL WIND ELEMENTARY   Regular School No Elementary PK 06 2021   grade_5 70 0 5   0 4     1   3   38 45             6         83 70 0 5   0 4     1   3   38 45         6       83
702813 ID     school 1600360 1   BOISE INDEPENDENT DISTRICT 160036000590 287 TRAIL WIND ELEMENTARY   Regular School No Elementary PK 06 2021   grade_6 78 0 5   0 2     0   4   42 47             12         89 78 0 5   0 2     0   4   42 47         12       89
702814 ID     school 1600360 1   BOISE INDEPENDENT DISTRICT 160036000590 287 TRAIL WIND ELEMENTARY   Regular School No Elementary PK 06 2021   k_12_total 380 1 24   0 16     3   21   221 224             49         445 380 1 24   0 16     3   21   221 224         49       445
702815 ID     school 1600360 1   BOISE INDEPENDENT DISTRICT 160036000590 287 TRAIL WIND ELEMENTARY   Regular School No Elementary PK 06 2021   kindergarten 44 1 2   0 3     0   2   24 28             5         52 44 1 2   0 3     0   2   24 28         5       52
702816 ID     school 1600360 1   BOISE INDEPENDENT DISTRICT 160036000591 288 SHADOW HILLS ELEMENTARY   Regular School No Elementary PK 06 2021   grade_1 45 1 2   0 0     0   3   32 19             14         51 45 1 2   0 0     0   3   32 19         14       51
702817 ID     school 1600360 1   BOISE INDEPENDENT DISTRICT 160036000591 288 SHADOW HILLS ELEMENTARY   Regular School No Elementary PK 06 2021   grade_2 39 1 12   0 0     0   0   27 25             11         52 39 1 12   0 0     0   0   27 25         11       52
702818 ID     school 1600360 1   BOISE INDEPENDENT DISTRICT 160036000591 288 SHADOW HILLS ELEMENTARY   Regular School No Elementary PK 06 2021   grade_3 49 0 2   0 0     0   1   32 20             14         52 49 0 2   0 0     0   1   32 20         14       52
702819 ID     school 1600360 1   BOISE INDEPENDENT DISTRICT 160036000591 288 SHADOW HILLS ELEMENTARY   Regular School No Elementary PK 06 2021   grade_4 37 1 8   1 1     0   3   29 22             9         51 37 1 8   1 1     0   3   29 22         9       51
702820 ID     school 1600360 1   BOISE INDEPENDENT DISTRICT 160036000591 288 SHADOW HILLS ELEMENTARY   Regular School No Elementary PK 06 2021   grade_5 58 1 6   0 0     0   1   30 36             14         66 58 1 6   0 0     0   1   30 36         14       66
702821 ID     school 1600360 1   BOISE INDEPENDENT DISTRICT 160036000591 288 SHADOW HILLS ELEMENTARY   Regular School No Elementary PK 06 2021   grade_6 66 3 11   0 0     0   5   40 45             21         85 66 3 11   0 0     0   5   40 45         21       85
702822 ID     school 1600360 1   BOISE INDEPENDENT DISTRICT 160036000591 288 SHADOW HILLS ELEMENTARY   Regular School No Elementary PK 06 2021   k_12_total 338 8 45   1 1     0   13   216 190             96         406 338 8 45   1 1     0   13   216 190         96       406
702823 ID     school 1600360 1   BOISE INDEPENDENT DISTRICT 160036000591 288 SHADOW HILLS ELEMENTARY   Regular School No Elementary PK 06 2021   kindergarten 44 1 4   0 0     0   0   26 23             13         49 44 1 4   0 0     0   0   26 23         13       49
702824 ID     school 1600360 1   BOISE INDEPENDENT DISTRICT 160036000592 300 AMITY ELEMENTARY SCHOOL   Regular School No Elementary PK 06 2021   grade_1 55 1 3   0 2     0   3   33 31             11         64 55 1 3   0 2     0   3   33 31         11       64
702825 ID     school 1600360 1   BOISE INDEPENDENT DISTRICT 160036000592 300 AMITY ELEMENTARY SCHOOL   Regular School No Elementary PK 06 2021   grade_2 24 1 3   0 1     0   3   17 15             11         32 24 1 3   0 1     0   3   17 15         11       32
702826 ID     school 1600360 1   BOISE INDEPENDENT DISTRICT 160036000592 300 AMITY ELEMENTARY SCHOOL   Regular School No Elementary PK 06 2021   grade_3 63 0 0   0 1     0   2   36 30             12         66 63 0 0   0 1     0   2   36 30         12       66
702827 ID     school 1600360 1   BOISE INDEPENDENT DISTRICT 160036000592 300 AMITY ELEMENTARY SCHOOL   Regular School No Elementary PK 06 2021   grade_4 47 1 4   0 0     0   2   23 31             12         54 47 1 4   0 0     0   2   23 31         12       54
702828 ID     school 1600360 1   BOISE INDEPENDENT DISTRICT 160036000592 300 AMITY ELEMENTARY SCHOOL   Regular School No Elementary PK 06 2021   grade_5 49 0 7   0 2     0   4   38 24             14         62 49 0 7   0 2     0   4   38 24         14       62
702829 ID     school 1600360 1   BOISE INDEPENDENT DISTRICT 160036000592 300 AMITY ELEMENTARY SCHOOL   Regular School No Elementary PK 06 2021   grade_6 59 0 4   1 0     0   2   28 38             17         66 59 0 4   1 0     0   2   28 38         17       66
702830 ID     school 1600360 1   BOISE INDEPENDENT DISTRICT 160036000592 300 AMITY ELEMENTARY SCHOOL   Regular School No Elementary PK 06 2021   k_12_total 334 4 27   1 6     0   16   193 195             89         388 334 4 27   1 6     0   16   193 195         89       388
702831 ID     school 1600360 1   BOISE INDEPENDENT DISTRICT 160036000592 300 AMITY ELEMENTARY SCHOOL   Regular School No Elementary PK 06 2021   kindergarten 37 1 6   0 0     0   0   18 26             12         44 37 1 6   0 0     0   0   18 26         12       44
702832 ID     school 1600360 1   BOISE INDEPENDENT DISTRICT 160036000065 301 MAPLE GROVE ELEMENTARY SCHOOL   Regular School No Elementary PK 06 2021   grade_1 44 1 4   1 3     1   3   29 28             16         57 44 1 4   1 3     1   3   29 28         16       57
702833 ID     school 1600360 1   BOISE INDEPENDENT DISTRICT 160036000065 301 MAPLE GROVE ELEMENTARY SCHOOL   Regular School No Elementary PK 06 2021   grade_2 42 0 5   0 1     0   3   29 22             17         51 42 0 5   0 1     0   3   29 22         17       51
702834 ID     school 1600360 1   BOISE INDEPENDENT DISTRICT 160036000065 301 MAPLE GROVE ELEMENTARY SCHOOL   Regular School No Elementary PK 06 2021   grade_3 34 0 4   1 2     2   4   28 19             16         47 34 0 4   1 2     2   4   28 19         16       47
702835 ID     school 1600360 1   BOISE INDEPENDENT DISTRICT 160036000065 301 MAPLE GROVE ELEMENTARY SCHOOL   Regular School No Elementary PK 06 2021   grade_4 41 0 1   0 1     0   2   18 27             7         45 41 0 1   0 1     0   2   18 27         7       45
702836 ID     school 1600360 1   BOISE INDEPENDENT DISTRICT 160036000065 301 MAPLE GROVE ELEMENTARY SCHOOL   Regular School No Elementary PK 06 2021   grade_5 43 0 5   1 1     0   1   23 28             15         51 43 0 5   1 1     0   1   23 28         15       51
702837 ID     school 1600360 1   BOISE INDEPENDENT DISTRICT 160036000065 301 MAPLE GROVE ELEMENTARY SCHOOL   Regular School No Elementary PK 06 2021   grade_6 42 0 5   0 2     2   1   27 25             9         52 42 0 5   0 2     2   1   27 25         9       52
702838 ID     school 1600360 1   BOISE INDEPENDENT DISTRICT 160036000065 301 MAPLE GROVE ELEMENTARY SCHOOL   Regular School No Elementary PK 06 2021   k_12_total 280 1 26   3 12     5   17   174 170             90         344 280 1 26   3 12     5   17   174 170         90       344
702839 ID     school 1600360 1   BOISE INDEPENDENT DISTRICT 160036000065 301 MAPLE GROVE ELEMENTARY SCHOOL   Regular School No Elementary PK 06 2021   kindergarten 34 0 2   0 2     0   3   20 21             10         41 34 0 2   0 2     0   3   20 21         10       41
702840 ID     school 1600360 1   BOISE INDEPENDENT DISTRICT 160036000055 302 HIGHLANDS ELEMENTARY SCHOOL   Regular School No Elementary PK 06 2021   grade_1 28 0 2   0 0     0   0   14 16             *         30 28 0 2   0 0     0   0   14 16                 30
702841 ID     school 1600360 1   BOISE INDEPENDENT DISTRICT 160036000055 302 HIGHLANDS ELEMENTARY SCHOOL   Regular School No Elementary PK 06 2021   grade_2 28 0 1   0 0     0   1   16 14             *         30 28 0 1   0 0     0   1   16 14                 30
702842 ID     school 1600360 1   BOISE INDEPENDENT DISTRICT 160036000055 302 HIGHLANDS ELEMENTARY SCHOOL   Regular School No Elementary PK 06 2021   grade_3 36 0 1   0 0     0   2   18 21             *         39 36 0 1   0 0     0   2   18 21                 39
702843 ID     school 1600360 1   BOISE INDEPENDENT DISTRICT 160036000055 302 HIGHLANDS ELEMENTARY SCHOOL   Regular School No Elementary PK 06 2021   grade_4 47 0 2   0 0     0   1   33 17             *         50 47 0 2   0 0     0   1   33 17                 50
702844 ID     school 1600360 1   BOISE INDEPENDENT DISTRICT 160036000055 302 HIGHLANDS ELEMENTARY SCHOOL   Regular School No Elementary PK 06 2021   grade_5 39 0 0   0 0     0   0   23 16             *         39 39 0 0   0 0     0   0   23 16                 39
702845 ID     school 1600360 1   BOISE INDEPENDENT DISTRICT 160036000055 302 HIGHLANDS ELEMENTARY SCHOOL   Regular School No Elementary PK 06 2021   grade_6 51 0 2   0 1     0   2   30 26             *         56 51 0 2   0 1     0   2   30 26                 56
702846 ID     school 1600360 1   BOISE INDEPENDENT DISTRICT 160036000055 302 HIGHLANDS ELEMENTARY SCHOOL   Regular School No Elementary PK 06 2021   k_12_total 255 0 12   0 1     0   7   153 122             9         275 255 0 12   0 1     0   7   153 122         9       275
702847 ID     school 1600360 1   BOISE INDEPENDENT DISTRICT 160036000055 302 HIGHLANDS ELEMENTARY SCHOOL   Regular School No Elementary PK 06 2021   kindergarten 26 0 4   0 0     0   1   19 12             *         31 26 0 4   0 0     0   1   19 12                 31
702848 ID     school 1600360 1   BOISE INDEPENDENT DISTRICT 160036000053 303 GARFIELD ELEMENTARY SCHOOL   Regular School No Elementary PK 06 2021   grade_1 12 6 7   0 1     1   0   16 11             20         27 12 6 7   0 1     1   0   16 11         20       27
702849 ID     school 1600360 1   BOISE INDEPENDENT DISTRICT 160036000053 303 GARFIELD ELEMENTARY SCHOOL   Regular School No Elementary PK 06 2021   grade_2 17 5 6   1 1     0   0   21 9             18         30 17 5 6   1 1     0   0   21 9         18       30
702850 ID     school 1600360 1   BOISE INDEPENDENT DISTRICT 160036000053 303 GARFIELD ELEMENTARY SCHOOL   Regular School No Elementary PK 06 2021   grade_3 22 5 5   0 0     1   2   24 11             13         35 22 5 5   0 0     1   2   24 11         13       35
702851 ID     school 1600360 1   BOISE INDEPENDENT DISTRICT 160036000053 303 GARFIELD ELEMENTARY SCHOOL   Regular School No Elementary PK 06 2021   grade_4 23 3 8   0 3     0   1   19 19             22         38 23 3 8   0 3     0   1   19 19         22       38
702852 ID     school 1600360 1   BOISE INDEPENDENT DISTRICT 160036000053 303 GARFIELD ELEMENTARY SCHOOL   Regular School No Elementary PK 06 2021   grade_5 22 4 9   0 2     1   0   17 21             21         38 22 4 9   0 2     1   0   17 21         21       38
702853 ID     school 1600360 1   BOISE INDEPENDENT DISTRICT 160036000053 303 GARFIELD ELEMENTARY SCHOOL   Regular School No Elementary PK 06 2021   grade_6 20 3 14   1 4     0   0   18 24             24         42 20 3 14   1 4     0   0   18 24         24       42
702854 ID     school 1600360 1   BOISE INDEPENDENT DISTRICT 160036000053 303 GARFIELD ELEMENTARY SCHOOL   Regular School No Elementary PK 06 2021   k_12_total 133 29 61   2 11     3   3   129 113             137         242 133 29 61   2 11     3   3   129 113         137       242
702855 ID     school 1600360 1   BOISE INDEPENDENT DISTRICT 160036000053 303 GARFIELD ELEMENTARY SCHOOL   Regular School No Elementary PK 06 2021   kindergarten 17 3 12   0 0     0   0   14 18             19         32 17 3 12   0 0     0   0   14 18         19       32
702856 ID     school 1600360 1   BOISE INDEPENDENT DISTRICT 160036000076 305 WASHINGTON ELEMENTARY SCHOOL   Regular School No Elementary PK 06 2021   grade_1 17 0 1   0 0     0   0   12 6             *         18 17 0 1   0 0     0   0   12 6                 18
702857 ID     school 1600360 1   BOISE INDEPENDENT DISTRICT 160036000076 305 WASHINGTON ELEMENTARY SCHOOL   Regular School No Elementary PK 06 2021   grade_2 23 0 3   0 2     0   0   15 13             *         28 23 0 3   0 2     0   0   15 13                 28
702858 ID     school 1600360 1   BOISE INDEPENDENT DISTRICT 160036000076 305 WASHINGTON ELEMENTARY SCHOOL   Regular School No Elementary PK 06 2021   grade_3 28 0 0   0 0     0   1   13 16             *         29 28 0 0   0 0     0   1   13 16                 29
702859 ID     school 1600360 1   BOISE INDEPENDENT DISTRICT 160036000076 305 WASHINGTON ELEMENTARY SCHOOL   Regular School No Elementary PK 06 2021   grade_4 23 0 0   0 0     0   1   10 14             *         24 23 0 0   0 0     0   1   10 14                 24
702860 ID     school 1600360 1   BOISE INDEPENDENT DISTRICT 160036000076 305 WASHINGTON ELEMENTARY SCHOOL   Regular School No Elementary PK 06 2021   grade_5 22 1 0   0 0     0   1   9 15             *         24 22 1 0   0 0     0   1   9 15                 24
702861 ID     school 1600360 1   BOISE INDEPENDENT DISTRICT 160036000076 305 WASHINGTON ELEMENTARY SCHOOL   Regular School No Elementary PK 06 2021   grade_6 38 0 1   0 0     0   2   16 25             *         41 38 0 1   0 0     0   2   16 25                 41
702862 ID     school 1600360 1   BOISE INDEPENDENT DISTRICT 160036000076 305 WASHINGTON ELEMENTARY SCHOOL   Regular School No Elementary PK 06 2021   k_12_total 168 1 6   0 2     0   6   84 99             15         183 168 1 6   0 2     0   6   84 99         15       183
702863 ID     school 1600360 1   BOISE INDEPENDENT DISTRICT 160036000076 305 WASHINGTON ELEMENTARY SCHOOL   Regular School No Elementary PK 06 2021   kindergarten 17 0 1   0 0     0   1   9 10             *         19 17 0 1   0 0     0   1   9 10                 19
702864 ID     school 1600360 1   BOISE INDEPENDENT DISTRICT 160036000078 306 WHITNEY ELEMENTARY SCHOOL   Regular School No Elementary PK 06 2021   grade_1 29 6 22   0 0     0   2   28 31             28         59 29 6 22   0 0     0   2   28 31         28       59
702865 ID     school 1600360 1   BOISE INDEPENDENT DISTRICT 160036000078 306 WHITNEY ELEMENTARY SCHOOL   Regular School No Elementary PK 06 2021   grade_2 23 7 11   0 1     0   4   30 16             26         46 23 7 11   0 1     0   4   30 16         26       46
702866 ID     school 1600360 1   BOISE INDEPENDENT DISTRICT 160036000078 306 WHITNEY ELEMENTARY SCHOOL   Regular School No Elementary PK 06 2021   grade_3 31 8 18   0 2     1   4   30 34             34         64 31 8 18   0 2     1   4   30 34         34       64

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