Data source: Big Local News · About: Big Local

5,050 rows where state = "ID" and year = 2021 sorted by ccd_charter_school

View and edit SQL

grade

year

  • 2021 · 5,050
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
704332 ID     school   92   SWAN VALLEY ELEMENTARY DISTRICT   1014 BORDER DISTRICT - STAR VALLEY ELEMENTARY SCHOOL             2021   grade_3 2 0 0   0 0     0   0   0 2             *         2 2 0 0   0 0     0   0   0 2                 2
704333 ID     school   92   SWAN VALLEY ELEMENTARY DISTRICT   1014 BORDER DISTRICT - STAR VALLEY ELEMENTARY SCHOOL             2021   grade_4 1 0 0   0 0     0   0   1 0             *         1 1 0 0   0 0     0   0   1 0                 1
704334 ID     school   92   SWAN VALLEY ELEMENTARY DISTRICT   1014 BORDER DISTRICT - STAR VALLEY ELEMENTARY SCHOOL             2021   k_12_total 3 0 0   0 0     0   0   1 2             *         3 3 0 0   0 0     0   0   1 2                 3
704335 ID     school   92   SWAN VALLEY ELEMENTARY DISTRICT   1015 BORDER DISTRICT - STAR VALLEY JR-SR HIGH SCHOOL             2021   grade_11 1 0 0   0 0     0   0   0 1             *         1 1 0 0   0 0     0   0   0 1                 1
704336 ID     school   92   SWAN VALLEY ELEMENTARY DISTRICT   1015 BORDER DISTRICT - STAR VALLEY JR-SR HIGH SCHOOL             2021   k_12_total 1 0 0   0 0     0   0   0 1             *         1 1 0 0   0 0     0   0   0 1                 1
705007 ID     school   150   SODA SPRINGS JOINT DISTRICT   1025 BORDER DISTRICT - FREEDOM ELEMENTARY             2021   grade_1 5 0 0   0 0     0   0   3 2             *         5 5 0 0   0 0     0   0   3 2                 5
705008 ID     school   150   SODA SPRINGS JOINT DISTRICT   1025 BORDER DISTRICT - FREEDOM ELEMENTARY             2021   grade_2 2 0 0   0 0     0   0   1 1             *         2 2 0 0   0 0     0   0   1 1                 2
705009 ID     school   150   SODA SPRINGS JOINT DISTRICT   1025 BORDER DISTRICT - FREEDOM ELEMENTARY             2021   grade_3 5 0 0   0 0     0   0   1 4             *         5 5 0 0   0 0     0   0   1 4                 5
705010 ID     school   150   SODA SPRINGS JOINT DISTRICT   1025 BORDER DISTRICT - FREEDOM ELEMENTARY             2021   grade_4 4 0 0   0 0     0   0   0 4             *         4 4 0 0   0 0     0   0   0 4                 4
705011 ID     school   150   SODA SPRINGS JOINT DISTRICT   1025 BORDER DISTRICT - FREEDOM ELEMENTARY             2021   grade_5 1 0 0   0 0     0   0   1 0             *         1 1 0 0   0 0     0   0   1 0                 1
705012 ID     school   150   SODA SPRINGS JOINT DISTRICT   1025 BORDER DISTRICT - FREEDOM ELEMENTARY             2021   grade_6 1 0 0   0 0     0   0   0 1             *         1 1 0 0   0 0     0   0   0 1                 1
705013 ID     school   150   SODA SPRINGS JOINT DISTRICT   1025 BORDER DISTRICT - FREEDOM ELEMENTARY             2021   k_12_total 19 0 0   0 0     0   0   6 13             *         19 19 0 0   0 0     0   0   6 13                 19
705014 ID     school   150   SODA SPRINGS JOINT DISTRICT   1025 BORDER DISTRICT - FREEDOM ELEMENTARY             2021   kindergarten 1 0 0   0 0     0   0   0 1             *         1 1 0 0   0 0     0   0   0 1                 1
705015 ID     school   150   SODA SPRINGS JOINT DISTRICT   1026 BORDER DISTRICT FREEDOM - SECONDARY             2021   grade_10 3 0 1   0 0     0   0   2 2             *         4 3 0 1   0 0     0   0   2 2                 4
705016 ID     school   150   SODA SPRINGS JOINT DISTRICT   1026 BORDER DISTRICT FREEDOM - SECONDARY             2021   grade_11 0 0 2   0 0     0   0   2 0             *         2 0 0 2   0 0     0   0   2 0                 2
705017 ID     school   150   SODA SPRINGS JOINT DISTRICT   1026 BORDER DISTRICT FREEDOM - SECONDARY             2021   grade_12 3 0 1   0 0     0   0   4 0             *         4 3 0 1   0 0     0   0   4 0                 4
705018 ID     school   150   SODA SPRINGS JOINT DISTRICT   1026 BORDER DISTRICT FREEDOM - SECONDARY             2021   grade_7 1 0 1   0 0     0   0   0 2             *         2 1 0 1   0 0     0   0   0 2                 2
705019 ID     school   150   SODA SPRINGS JOINT DISTRICT   1026 BORDER DISTRICT FREEDOM - SECONDARY             2021   grade_9 3 0 0   0 0     0   0   2 1             *         3 3 0 0   0 0     0   0   2 1                 3
705020 ID     school   150   SODA SPRINGS JOINT DISTRICT   1026 BORDER DISTRICT FREEDOM - SECONDARY             2021   k_12_total 10 0 5   0 0     0   0   10 5             *         15 10 0 5   0 0     0   0   10 5                 15
706390 ID     school   340   LEWISTON INDEPENDENT DISTRICT   611 NORTHWEST CHILDRENS HOME             2021   grade_10 2 0 1   0 0     0   0   3 0             *         3 2 0 1   0 0     0   0   3 0                 3
706391 ID     school   340   LEWISTON INDEPENDENT DISTRICT   611 NORTHWEST CHILDRENS HOME             2021   grade_11 1 0 0   0 0     0   0   1 0             *         1 1 0 0   0 0     0   0   1 0                 1
706392 ID     school   340   LEWISTON INDEPENDENT DISTRICT   611 NORTHWEST CHILDRENS HOME             2021   grade_12 1 0 0   0 0     0   0   1 0             *         1 1 0 0   0 0     0   0   1 0                 1
706393 ID     school   340   LEWISTON INDEPENDENT DISTRICT   611 NORTHWEST CHILDRENS HOME             2021   grade_3 1 0 0   0 0     0   0   1 0             *         1 1 0 0   0 0     0   0   1 0                 1
706394 ID     school   340   LEWISTON INDEPENDENT DISTRICT   611 NORTHWEST CHILDRENS HOME             2021   grade_4 1 0 0   0 0     0   0   1 0             *         1 1 0 0   0 0     0   0   1 0                 1
706395 ID     school   340   LEWISTON INDEPENDENT DISTRICT   611 NORTHWEST CHILDRENS HOME             2021   grade_5 6 0 0   0 0     0   0   5 1             *         6 6 0 0   0 0     0   0   5 1                 6
706396 ID     school   340   LEWISTON INDEPENDENT DISTRICT   611 NORTHWEST CHILDRENS HOME             2021   grade_6 2 0 0   0 0     0   0   2 0             *         2 2 0 0   0 0     0   0   2 0                 2
706397 ID     school   340   LEWISTON INDEPENDENT DISTRICT   611 NORTHWEST CHILDRENS HOME             2021   grade_7 2 0 0   0 0     0   0   2 0             *         2 2 0 0   0 0     0   0   2 0                 2
706398 ID     school   340   LEWISTON INDEPENDENT DISTRICT   611 NORTHWEST CHILDRENS HOME             2021   grade_8 1 0 0   0 0     0   0   1 0             *         1 1 0 0   0 0     0   0   1 0                 1
706399 ID     school   340   LEWISTON INDEPENDENT DISTRICT   611 NORTHWEST CHILDRENS HOME             2021   grade_9 2 0 0   0 0     0   0   2 0             *         2 2 0 0   0 0     0   0   2 0                 2
706400 ID     school   340   LEWISTON INDEPENDENT DISTRICT   611 NORTHWEST CHILDRENS HOME             2021   k_12_total 20 0 1   0 0     0   0   20 1             *         21 20 0 1   0 0     0   0   20 1                 21
706401 ID     school   340   LEWISTON INDEPENDENT DISTRICT   611 NORTHWEST CHILDRENS HOME             2021   kindergarten 1 0 0   0 0     0   0   1 0             *         1 1 0 0   0 0     0   0   1 0                 1
706486 ID     school   342   CULDESAC JOINT DISTRICT   1373 NORTHWEST CHILDREN'S HOME             2021   grade_6 0 0 0   1 0     0   0   1 0             *         1 0 0 0   1 0     0   0   1 0                 1
706487 ID     school   342   CULDESAC JOINT DISTRICT   1373 NORTHWEST CHILDREN'S HOME             2021   k_12_total 0 0 0   1 0     0   0   1 0             *         1 0 0 0   1 0     0   0   1 0                 1
706544 ID     school   364   PLEASANT VALLEY ELEMENTARY DISTRICT   1056 BORDER DISTRICT - JORDAN VALLEY SECONDARY             2021   grade_11 2 0 0   0 0     0   0   0 2             *         2 2 0 0   0 0     0   0   0 2                 2
706545 ID     school   364   PLEASANT VALLEY ELEMENTARY DISTRICT   1056 BORDER DISTRICT - JORDAN VALLEY SECONDARY             2021   grade_9 1 0 0   0 0     0   0   0 1             *         1 1 0 0   0 0     0   0   0 1                 1
706546 ID     school   364   PLEASANT VALLEY ELEMENTARY DISTRICT   1056 BORDER DISTRICT - JORDAN VALLEY SECONDARY             2021   k_12_total 3 0 0   0 0     0   0   0 3             *         3 3 0 0   0 0     0   0   0 3                 3
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

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