Data source: Big Local News · About: Big Local

2,670 rows where grade = "grade_5" and state = "ID" sorted by white descending

View and edit SQL

year

grade

  • grade_5 · 2,670
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
1279167 ID     school 1602670 273   POST FALLS DISTRICT 160267000970 2517 WEST RIDGE ELEMENTARY SCHOOL   Regular School No Elementary 01 5.0 2018   grade_5 99 1 5   0 1     0   2   55 53             49         108 99 1 5   0 1     0   2   55 53         49       108
1280047 ID     school 1603240 411   TWIN FALLS DISTRICT 160324001075 1381 PILLAR FALLS ELEMENTARY   Regular School No Elementary PK 5.0 2018   grade_5 99 1 13   0 1     0   1   56 59             37         115 99 1 13   0 1     0   1   56 59         37       115
1307498 ID     school 1601020 221   EMMETT INDEPENDENT DISTRICT 160102000191 224 EMMETT MIDDLE SCHOOL   Regular School No Middle 05 8.0 2019   grade_5 99 0 19   1 0     0   1   64 56             *         120 99 0 19   1 0     0   1   64 56                 120
1309175 ID     school 1600004 452   IDAHO VIRTUAL ACADEMY, INC. 160000400859 869 IDAHO VIRTUAL ACADEMY   Regular School Yes Other KG 12.0 2019   grade_5 99 0 6   1 0     1   9   55 61             75         116 99 0 6   1 0     1   9   55 61         75       116
1683486 ID     school 1602130 134   MIDDLETON DISTRICT 160213000376 453 MIDDLETON MILL CREEK ELEMENTARY   Regular School No 1.0 PK 05 2015   grade_5 99 2 9   0 0     1   0   57 54             54         111 99 2 9   0 0     1   0   57 54         54       111
1726052 ID     school 1602100 2   JOINT SCHOOL DISTRICT NO. 2 160210000624 340 EAGLE HILLS ELEMENTARY SCHOOL   Regular School No Elementary PK 5.0 2017   grade_5 99 1 9   3 1     1   1   57 58             15         115 99 1 9   3 1     1   1   57 58         15       115
1822531 ID     school 1602130 134   MIDDLETON DISTRICT 160213000376 453 MIDDLETON MILL CREEK ELEMENTARY   Regular School No 1.0 PK 05 2016   grade_5 99 0 7   0 0     0   4   64 46             42         110 99 0 7   0 0     0   4   64 46         42       110
703356 ID     school 1602100 2   JOINT SCHOOL DISTRICT NO. 2 160210000989 899 SIENA ELEMENTARY   Regular School No Elementary PK 05 2021   grade_5 98 0 11   1 3     0   7   67 53             12         120 98 0 11   1 3     0   7   67 53         12       120
703483 ID     school 1601770 3   KUNA JOINT DISTRICT 160177000915 635 ROSS ELEMENTARY SCHOOL   Regular School No Elementary 04 05 2021   grade_5 98 1 14   1 1     0   3   74 44             45         118 98 1 14   1 1     0   3   74 44         45       118
706307 ID     school 1603090 322   SUGAR-SALEM JOINT DISTRICT 160309000645 225 KERSHAW INTERMEDIATE SCHOOL   Regular School No Middle 04 06 2021   grade_5 98 2 4   1 0     0   4   54 55             45         109 98 2 4   1 0     0   4   54 55         45       109
707183 ID     school 1600007 455   COMPASS PUBLIC CHARTER SCHOOL, INC. 160000700864 575 COMPASS PUBLIC CHARTER SCHOOL   Regular School Yes Other KG 12 2021   grade_5 98 0 10   0 6     0   3   58 59             17         117 98 0 10   0 6     0   3   58 59         17       117
1820958 ID     school 1602100 2   JOINT SCHOOL DISTRICT NO. 2 160210000818 283 PEPPER RIDGE ELEMENTARY   Regular School No 1.0 PK 05 2016   grade_5 98 2 10   0 6     0   7   69 54             12         123 98 2 10   0 6     0   7   69 54         12       123
1821089 ID     school 1602100 2   JOINT SCHOOL DISTRICT NO. 2 160210000010 507 PIONEER SCHOOL OF THE ARTS   Regular School No 1.0 PK 05 2016   grade_5 98 2 9   0 6     1   1   40 77             18         117 98 2 9   0 6     1   1   40 77         18       117
851474 ID     school 1600780 271   COEUR D'ALENE DISTRICT 160078000152 740 ATLAS ELEMENTARY SCHOOL   Regular School No Elementary KG 05 2020   grade_5 97 0 8   1 1     0   6   65 48             42         113 97 0 8   1 1     0   6   65 48         42       113
852831 ID     school 1600007 455   COMPASS PUBLIC CHARTER SCHOOL, INC. 160000700864 575 COMPASS PUBLIC CHARTER SCHOOL   Regular School Yes Other KG 12 2020   grade_5 97 2 12   0 3     1   3   58 60             19         118 97 2 12   0 3     1   3   58 60         19       118
1276807 ID     school 1601770 3   KUNA JOINT DISTRICT 160177000805 850 FREMONT H TEED MIDDLE SCHOOL   Regular School No Middle 04 8.0 2018   grade_5 97 0 9   1 0     2   4   63 50             48         113 97 0 9   1 0     2   4   63 50         48       113
1277572 ID     school 1601530 91   IDAHO FALLS DISTRICT 160153000725 668 SUNNYSIDE ELEMENTARY SCHOOL   Regular School No Elementary PK 6.0 2018   grade_5 97 1 5   0 1     0   1   54 51             9         105 97 1 5   0 1     0   1   54 51         9       105
1305484 ID     school 1602100 2   JOINT SCHOOL DISTRICT NO. 2 160210000010 507 PIONEER SCHOOL OF THE ARTS   Regular School No Elementary PK 5.0 2019   grade_5 97 0 7   0 1     1   4   48 62             17         110 97 0 7   0 1     1   4   48 62         17       110
1308675 ID     school 1601140 373   FRUITLAND DISTRICT 160114000213 165 FRUITLAND MIDDLE SCHOOL   Regular School No Middle 05 8.0 2019   grade_5 97 1 31   3 0     0   2   65 69             53         134 97 1 31   3 0     0   2   65 69         53       134
1823591 ID     school 1602670 273   POST FALLS DISTRICT 160267000487 748 PONDEROSA ELEMENTARY SCHOOL   Regular School No 1.0 01 05 2016   grade_5 97 3 6   3 0     0   1   57 53             51         110 97 3 6   3 0     0   1   57 53         51       110
705643 ID     school 1601570 251   JEFFERSON COUNTY JOINT DISTRICT 160157001128 1437 COTTONWOOD ELEMENTARY   Regular School No Elementary KG 05 2021   grade_5 96 0 8   0 0     0   3   52 55             26         107 96 0 8   0 0     0   3   52 55         26       107
850025 ID     school 1601530 91   IDAHO FALLS DISTRICT 160153000725 668 SUNNYSIDE ELEMENTARY SCHOOL   Regular School No Elementary PK 06 2020   grade_5 96 0 5   0 0     0   1   52 50             6         102 96 0 5   0 0     0   1   52 50         6       102
1276362 ID     school 1600360 1   BOISE INDEPENDENT DISTRICT 160036000004 509 RIVERSIDE ELEMENTARY SCHOOL   Regular School No Elementary PK 6.0 2018   grade_5 96 1 3   1 8     1   2   58 54             8         112 96 1 3   1 8     1   2   58 54         8       112
1278965 ID     school 1600780 271   COEUR D'ALENE DISTRICT 160078000114 506 HAYDEN MEADOWS ELEMENTARY SCHOOL   Regular School No Elementary PK 5.0 2018   grade_5 96 0 7   1 1     0   2   53 54             22         107 96 0 7   1 1     0   2   53 54         22       107
1308356 ID     school 1603090 322   SUGAR-SALEM JOINT DISTRICT 160309000645 225 KERSHAW INTERMEDIATE SCHOOL   Regular School No Middle 04 6.0 2019   grade_5 96 0 12   0 2     1   0   47 64             53         111 96 0 12   0 2     1   0   47 64         53       111
1682073 ID     school 1602100 2   JOINT SCHOOL DISTRICT NO. 2 160210000593 523 CECIL D ANDRUS ELEMENTARY   Regular School No 1.0 PK 05 2015   grade_5 96 0 6   0 2     0   5   59 50             16         109 96 0 6   0 2     0   5   59 50         16       109
1726087 ID     school 1602100 2   JOINT SCHOOL DISTRICT NO. 2 160210000801 521 DISCOVERY ELEMENTARY SCHOOL   Regular School No Elementary PK 5.0 2017   grade_5 96 0 14   0 4     0   5   59 60             22         119 96 0 14   0 4     0   5   59 60         22       119
1821117 ID     school 1602100 2   JOINT SCHOOL DISTRICT NO. 2 160210000595 525 ELIZA HART SPALDING STEM ACADEMY   Regular School No 1.0 PK 05 2016   grade_5 96 6 9   0 3     0   2   61 55             20         116 96 6 9   0 3     0   2   61 55         20       116
850375 ID     school 1602340 131   NAMPA SCHOOL DISTRICT 160234000986 647 LAKE RIDGE ELEMENTARY   Regular School No Elementary PK 05 2020   grade_5 95 3 24   0 0     0   2   65 59             43         124 95 3 24   0 0     0   2   65 59         43       124
1276702 ID     school 1602100 2   JOINT SCHOOL DISTRICT NO. 2 160210000989 899 SIENA ELEMENTARY   Regular School No Elementary PK 5.0 2018   grade_5 95 2 5   2 6     0   5   70 45             15         115 95 2 5   2 6     0   5   70 45         15       115
1280301 ID     school 1600004 452   IDAHO VIRTUAL ACADEMY, INC. 160000400859 869 IDAHO VIRTUAL ACADEMY   Regular School Yes Other KG 12.0 2018   grade_5 95 3 12   0 1     1   4   63 53             64         116 95 3 12   0 1     1   4   63 53         64       116
1305353 ID     school 1602100 2   JOINT SCHOOL DISTRICT NO. 2 160210000818 283 PEPPER RIDGE ELEMENTARY   Regular School No Elementary PK 5.0 2019   grade_5 95 0 10   0 1     0   6   52 60             16         112 95 0 10   0 1     0   6   52 60         16       112
1685409 ID     school 1603240 411   TWIN FALLS DISTRICT 160324000551 825 MORNINGSIDE ELEMENTARY SCHOOL   Regular School No 1.0 PK 05 2015   grade_5 95 0 18   0 4     1   1   62 57             61         119 95 0 18   0 4     1   1   62 57         61       119
1685499 ID     school 1601050 413   FILER DISTRICT 160105001006 1244 FILER INTERMEDIATE SCHOOL   Regular School No 2.0 04 06 2015   grade_5 95 1 15   1 0     0   0   59 53             *         112 95 1 15   1 0     0   0   59 53                 112
1727524 ID     school 1602130 134   MIDDLETON DISTRICT 160213000376 453 MIDDLETON MILL CREEK ELEMENTARY   Regular School No Elementary PK 5.0 2017   grade_5 95 0 5   1 0     0   2   49 54             38         103 95 0 5   1 0     0   2   49 54         38       103
1728946 ID     school 1603090 322   SUGAR-SALEM JOINT DISTRICT 160309000645 225 KERSHAW INTERMEDIATE SCHOOL   Regular School No Elementary 04 6.0 2017   grade_5 95 1 9   1 0     0   0   61 45             51         106 95 1 9   1 0     0   0   61 45         51       106
1823077 ID     school 1601020 221   EMMETT INDEPENDENT DISTRICT 160102000191 224 EMMETT MIDDLE SCHOOL   Regular School No 2.0 05 08 2016   grade_5 95 1 17   0 1     0   1   58 57             63         115 95 1 17   0 1     0   1   58 57         63       115
1824256 ID     school 1601140 373   FRUITLAND DISTRICT 160114000213 165 FRUITLAND MIDDLE SCHOOL   Regular School No 2.0 05 08 2016   grade_5 95 1 28   2 1     0   1   65 63             64         128 95 1 28   2 1     0   1   65 63         64       128
1306921 ID     school 1602130 134   MIDDLETON DISTRICT 160213000376 453 MIDDLETON MILL CREEK ELEMENTARY   Regular School No Elementary PK 5.0 2019   grade_5 94 1 16   0 0     0   5   62 54             29         116 94 1 16   0 0     0   5   62 54         29       116
1308914 ID     school 1603240 411   TWIN FALLS DISTRICT 160324001075 1381 PILLAR FALLS ELEMENTARY   Regular School No Elementary PK 5.0 2019   grade_5 94 5 9   1 1     0   2   53 59             34         112 94 5 9   1 1     0   2   53 59         34       112
1682113 ID     school 1602100 2   JOINT SCHOOL DISTRICT NO. 2 160210000902 593 PROSPECT ELEMENTARY SCHOOL   Regular School No 1.0 PK 05 2015   grade_5 94 2 21   0 3     1   6   62 65             22         127 94 2 21   0 3     1   6   62 65         22       127
1726080 ID     school 1602100 2   JOINT SCHOOL DISTRICT NO. 2 160210000010 507 PIONEER SCHOOL OF THE ARTS   Regular School No Elementary PK 5.0 2017   grade_5 94 3 6   0 1     0   4   41 67             21         108 94 3 6   0 1     0   4   41 67         21       108
849088 ID     school 1602100 2   JOINT SCHOOL DISTRICT NO. 2 160210000593 523 CECIL D ANDRUS ELEMENTARY   Regular School No Elementary PK 05 2020   grade_5 93 0 6   1 1     1   4   57 49             19         106 93 0 6   1 1     1   4   57 49         19       106
852523 ID     school 1603240 411   TWIN FALLS DISTRICT 160324001075 1381 PILLAR FALLS ELEMENTARY   Regular School No Elementary PK 05 2020   grade_5 93 4 11   3 1     0   2   62 52             30         114 93 4 11   3 1     0   2   62 52         30       114
1820625 ID     school 1600360 1   BOISE INDEPENDENT DISTRICT 160036000590 287 TRAIL WIND ELEMENTARY   Regular School No 1.0 PK 06 2016   grade_5 93 2 12   0 5     2   4   68 50             26         118 93 2 12   0 5     2   4   68 50         26       118
1821588 ID     school 1602970 52   SNAKE RIVER DISTRICT 160297000644 380 SNAKE RIVER MIDDLE SCHOOL   Regular School No 2.0 05 06 2016   grade_5 93 0 24   1 0     0   2   51 69             64         120 93 0 24   1 0     0   2   51 69         64       120
706869 ID     school 1603240 411   TWIN FALLS DISTRICT 160324001075 1381 PILLAR FALLS ELEMENTARY   Regular School No Elementary PK 05 2021   grade_5 92 2 12   0 2     0   2   47 63             25         110 92 2 12   0 2     0   2   47 63         25       110
1276755 ID     school 1602100 2   JOINT SCHOOL DISTRICT NO. 2 160210001081 1383 HILLSDALE ELEMENTARY   Regular School No Elementary PK 5.0 2018   grade_5 92 1 18   0 3     0   4   66 52             13         118 92 1 18   0 3     0   4   66 52         13       118
1278070 ID     school 1602130 134   MIDDLETON DISTRICT 160213000675 500 MIDDLETON HEIGHTS ELEMENTARY   Regular School No Elementary PK 5.0 2018   grade_5 92 1 14   0 1     0   3   54 57             63         111 92 1 14   0 1     0   3   54 57         63       111
1280054 ID     school 1603240 411   TWIN FALLS DISTRICT 160324001076 1382 ROCK CREEK ELEMENTARY   Regular School No Elementary KG 5.0 2018   grade_5 92 1 9   2 1     1   0   57 49             33         106 92 1 9   2 1     1   0   57 49         33       106
1305559 ID     school 1602100 2   JOINT SCHOOL DISTRICT NO. 2 160210000989 899 SIENA ELEMENTARY   Regular School No Elementary PK 5.0 2019   grade_5 92 2 10   0 1     0   6   59 52             10         111 92 2 10   0 1     0   6   59 52         10       111
1306545 ID     school 1600930 93   BONNEVILLE JOINT DISTRICT 160093000910 637 WOODLAND HILLS ELEMENTARY   Regular School No Elementary PK 6.0 2019   grade_5 92 1 2   0 2     0   0   44 53             10         97 92 1 2   0 2     0   0   44 53         10       97
1309224 ID     school 1600007 455   COMPASS PUBLIC CHARTER SCHOOL, INC. 160000700864 575 COMPASS PUBLIC CHARTER SCHOOL   Regular School Yes Other KG 12.0 2019   grade_5 92 2 9   0 3     0   4   52 58             16         110 92 2 9   0 3     0   4   52 58         16       110
1681605 ID     school 1600360 1   BOISE INDEPENDENT DISTRICT 160036000592 300 AMITY ELEMENTARY SCHOOL   Regular School No 1.0 PK 06 2015   grade_5 92 0 7   1 1     0   4   51 54             26         105 92 0 7   1 1     0   4   51 54         26       105
1682059 ID     school 1602100 2   JOINT SCHOOL DISTRICT NO. 2 160210000010 507 PIONEER SCHOOL OF THE ARTS   Regular School No 1.0 PK 05 2015   grade_5 92 1 6   0 2     1   5   50 57             26         107 92 1 6   0 2     1   5   50 57         26       107
1727382 ID     school 1602340 131   NAMPA SCHOOL DISTRICT 160234000986 647 LAKE RIDGE ELEMENTARY   Regular School No Elementary PK 5.0 2017   grade_5 92 1 17   0 2     1   1   49 65             *         114 92 1 17   0 2     1   1   49 65                 114
1729705 ID     school 1603330 431   WEISER DISTRICT 160333000566 840 PARK INTERMEDIATE SCHOOL   Regular School No Elementary 04 5.0 2017   grade_5 92 0 35   2 0     0   0   57 72             73         129 92 0 35   2 0     0   0   57 72         73       129
1823450 ID     school 1600780 271   COEUR D'ALENE DISTRICT 160078000150 739 DALTON ELEMENTARY SCHOOL   Regular School No 1.0 PK 05 2016   grade_5 92 0 3   0 1     0   2   48 50             25         98 92 0 3   0 1     0   2   48 50         25       98
1277691 ID     school 1600930 93   BONNEVILLE JOINT DISTRICT 160093000910 637 WOODLAND HILLS ELEMENTARY   Regular School No Elementary PK 6.0 2018   grade_5 91 1 3   1 2     0   1   43 56             16         99 91 1 3   1 2     0   1   43 56         16       99
1308869 ID     school 1603240 411   TWIN FALLS DISTRICT 160324000554 826 SAWTOOTH ELEMENTARY SCHOOL   Regular School No Elementary PK 5.0 2019   grade_5 91 0 11   1 1     0   0   55 49             36         104 91 0 11   1 1     0   0   55 49         36       104
1726270 ID     school 1601770 3   KUNA JOINT DISTRICT 160177000805 850 FREMONT H TEED MIDDLE SCHOOL   Regular School No Elementary 02 6.0 2017   grade_5 91 1 8   0 0     0   3   57 46             48         103 91 1 8   0 0     0   3   57 46         48       103
1821143 ID     school 1602100 2   JOINT SCHOOL DISTRICT NO. 2 160210000902 593 PROSPECT ELEMENTARY SCHOOL   Regular School No 1.0 PK 05 2016   grade_5 91 1 12   0 3     0   3   64 46             21         110 91 1 12   0 3     0   3   64 46         21       110
1825122 ID     school 1600174 493   NORTH STAR CHARTER SCHOOL, INC. 160017400803 1371 NORTH STAR CHARTER SCHOOL   Regular School Yes 4.0 PK 12 2016   grade_5 91 2 6   0 5     0   1   54 51             *         105 91 2 6   0 5     0   1   54 51                 105
704812 ID     school 1602130 134   MIDDLETON DISTRICT 160213000376 453 MIDDLETON MILL CREEK ELEMENTARY   Regular School No Elementary PK 05 2021   grade_5 90 1 12   2 1     0   1   57 50             18         107 90 1 12   2 1     0   1   57 50         18       107
849277 ID     school 1601770 3   KUNA JOINT DISTRICT 160177001029 1308 SILVER TRAIL ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2020   grade_5 90 1 8   0 0     0   2   48 53             21         101 90 1 8   0 0     0   2   48 53         21       101
1276557 ID     school 1602100 2   JOINT SCHOOL DISTRICT NO. 2 160210000373 334 STAR ELEMENTARY SCHOOL   Regular School No Elementary PK 5.0 2018   grade_5 90 0 17   0 2     1   3   54 59             35         113 90 0 17   0 2     1   3   54 59         35       113
1682080 ID     school 1602100 2   JOINT SCHOOL DISTRICT NO. 2 160210000597 524 CHAPARRAL ELEMENTARY   Regular School No 1.0 PK 05 2015   grade_5 90 0 9   1 1     1   4   41 65             32         106 90 0 9   1 1     1   4   41 65         32       106
1823422 ID     school 1600780 271   COEUR D'ALENE DISTRICT 160078000114 506 HAYDEN MEADOWS ELEMENTARY SCHOOL   Regular School No 1.0 PK 05 2016   grade_5 90 0 6   0 2     0   1   46 53             28         99 90 0 6   0 2     0   1   46 53         28       99
703782 ID     school 1603060 41   ST MARIES JOINT DISTRICT 160306000536 374 UPRIVER ELEMENTARY SCHOOL   Regular School No Elementary KG 06 2021   grade_5 9 0 0   1 0     0   0   5 5             *         10 9 0 0   1 0     0   0   5 5                 10
704554 ID     school 1600540 121   CAMAS COUNTY DISTRICT 160054000110 440 CAMAS COUNTY ELEM/JR HIGH SCHOOL   Regular School No Elementary PK 08 2021   grade_5 9 0 0   0 0     0   0   4 5             *         9 9 0 0   0 0     0   0   4 5                 9
705103 ID     school 1600660 151   CASSIA COUNTY JOINT DISTRICT 160066000122 475 ALBION ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2021   grade_5 9 0 0   0 0     0   0   5 4             *         9 9 0 0   0 0     0   0   5 4                 9
705128 ID     school 1600660 151   CASSIA COUNTY JOINT DISTRICT 160066001141 1441 MINI-CASSIA ONLINE LEARNING ACADEMY   Regular School No Other KG 12 2021   grade_5 9 0 6   0 0     0   0   8 7             *         15 9 0 6   0 0     0   0   8 7                 15
706239 ID     school 1602760 316   RICHFIELD DISTRICT 160276000497 144 RICHFIELD SCHOOL   Regular School No Other PK 12 2021   grade_5 9 1 5   0 0     0   0   10 5             10         15 9 1 5   0 0     0   0   10 5         10       15
707048 ID     school 1600630 422   CASCADE DISTRICT 160063000120 838 CASCADE ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2021   grade_5 9 0 1   0 0     0   1   5 6             *         11 9 0 1   0 0     0   1   5 6                 11
849540 ID     school 1603060 41   ST MARIES JOINT DISTRICT 160306000536 374 UPRIVER ELEMENTARY SCHOOL   Regular School No Elementary KG 06 2020   grade_5 9 0 0   0 0     0   2   7 4             *         11 9 0 0   0 0     0   2   7 4                 11
851223 ID     school 1600138 243   SALMON RIVER JOINT SCHOOL DISTRICT 160013800959 1280 RIGGINS ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2020   grade_5 9 0 1   0 0     0   1   6 5             5         11 9 0 1   0 0     0   1   6 5         5       11
851299 ID     school 1601570 251   JEFFERSON COUNTY JOINT DISTRICT 160157000278 726 ROBERTS ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2020   grade_5 9 0 9   0 0     0   0   8 10             *         18 9 0 9   0 0     0   0   8 10                 18
851842 ID     school 1601440 305   HIGHLAND JOINT DISTRICT 160144000849 285 HIGHLAND SCHOOL   Regular School No Other PK 12 2020   grade_5 9 1 2   0 0     0   0   3 9             6         12 9 1 2   0 0     0   0   3 9         6       12
852229 ID     school 1600450 365   BRUNEAU-GRAND VIEW JOINT SCHOOL DISTRICT 160045000099 802 GRAND VIEW ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2020   grade_5 9 0 6   1 0     0   1   7 10             11         17 9 0 6   1 0     0   1   7 10         11       17
853308 ID     school 1600172 534   GEM PREP: ONLINE LLC 160017200846 1426 GEM PREP: ONLINE SCHOOL   Regular School Yes Other PK 12 2020   grade_5 9 0 1   0 0     0   0   8 2             5         10 9 0 1   0 0     0   0   8 2         5       10
1277704 ID     school 1600930 93   BONNEVILLE JOINT DISTRICT 160093000999 1238 BONNEVILLE ONLINE ELEMENTARY   Regular School No Elementary PK 8.0 2018   grade_5 9 0 1   0 0     0   0   9 1             *         10 9 0 1   0 0     0   0   9 1                 10
1305948 ID     school 1603060 41   ST MARIES JOINT DISTRICT 160306000536 374 UPRIVER ELEMENTARY SCHOOL   Regular School No Elementary KG 6.0 2019   grade_5 9 0 1   0 0     0   1   7 4             *         11 9 0 1   0 0     0   1   7 4                 11
1308050 ID     school 1601740 274   KOOTENAI DISTRICT 160174000302 751 HARRISON ELEMENTARY SCHOOL   Regular School No Elementary KG 5.0 2019   grade_5 9 1 0   0 0     0   0   2 8             *         10 9 1 0   0 0     0   0   2 8                 10
1309142 ID     school 1602160 433   MIDVALE DISTRICT 160216000857 286 MIDVALE SCHOOL   Regular School No Other PK 12.0 2019   grade_5 9 0 1   0 0     0   0   5 5             *         10 9 0 1   0 0     0   0   5 5                 10
1683245 ID     school 1600540 121   CAMAS COUNTY DISTRICT 160054000110 440 CAMAS COUNTY ELEM/JR HIGH SCHOOL   Regular School No 1.0 PK 08 2015   grade_5 9 0 1   0 0     0   1   3 8             *         11 9 0 1   0 0     0   1   3 8                 11
1821341 ID     school 1601950 21   MARSH VALLEY JOINT DISTRICT 160195000344 350 DOWNEY ELEMENTARY SCHOOL   Regular School No 1.0 PK 06 2016   grade_5 9 1 0   1 0     0   0   4 7             *         11 9 1 0   1 0     0   0   4 7                 11
1822700 ID     school 1602430 149   NORTH GEM DISTRICT 160243000427 464 NORTH GEM ELEMENTARY   Regular School No 1.0 PK 06 2016   grade_5 9 0 1   0 0     1   0   6 5             *         11 9 0 1   0 0     1   0   6 5                 11
1824355 ID     school 1602280 392   MULLAN DISTRICT 160228000404 815 JOHN MULLAN ELEMENTARY SCHOOL   Regular School No 1.0 PK 06 2016   grade_5 9 0 2   0 0     0   0   4 7             5         11 9 0 2   0 0     0   0   4 7         5       11
1824524 ID     school 1601050 413   FILER DISTRICT 160105000195 832 HOLLISTER ELEMENTARY SCHOOL   Regular School No 1.0 PK 05 2016   grade_5 9 0 2   0 0     0   1   8 4             *         12 9 0 2   0 0     0   1   8 4                 12
703424 ID     school 1602100 2   JOINT SCHOOL DISTRICT NO. 2 160210001081 1383 HILLSDALE ELEMENTARY   Regular School No Elementary PK 05 2021   grade_5 89 0 9   1 0     0   2   58 43             6         101 89 0 9   1 0     0   2   58 43         6       101
848804 ID     school 1600360 1   BOISE INDEPENDENT DISTRICT 160036000004 509 RIVERSIDE ELEMENTARY SCHOOL   Regular School No Elementary PK 06 2020   grade_5 89 0 6   0 4     0   8   64 43             7         107 89 0 6   0 4     0   8   64 43         7       107
849218 ID     school 1602100 2   JOINT SCHOOL DISTRICT NO. 2 160210000945 2511 GALILEO MAGNET SCHOOL   Regular School No Elementary PK 08 2020   grade_5 89 1 9   0 0     0   0   58 41             6         99 89 1 9   0 0     0   0   58 41         6       99
852281 ID     school 1601140 373   FRUITLAND DISTRICT 160114000213 165 FRUITLAND MIDDLE SCHOOL   Regular School No Middle 05 08 2020   grade_5 89 1 41   0 4     0   4   66 73             51         139 89 1 41   0 4     0   4   66 73         51       139
1305413 ID     school 1602100 2   JOINT SCHOOL DISTRICT NO. 2 160210000373 334 STAR ELEMENTARY SCHOOL   Regular School No Elementary PK 5.0 2019   grade_5 89 0 9   1 1     0   5   54 51             23         105 89 0 9   1 1     0   5   54 51         23       105
1726108 ID     school 1602100 2   JOINT SCHOOL DISTRICT NO. 2 160210000595 525 ELIZA HART SPALDING STEM ACADEMY   Regular School No Elementary PK 5.0 2017   grade_5 89 1 9   0 6     0   7   50 62             23         112 89 1 9   0 6     0   7   50 62         23       112
1729482 ID     school 1603240 411   TWIN FALLS DISTRICT 160324000554 826 SAWTOOTH ELEMENTARY SCHOOL   Regular School No Elementary PK 5.0 2017   grade_5 89 1 8   2 1     0   2   49 54             44         103 89 1 8   2 1     0   2   49 54         44       103
1821061 ID     school 1602100 2   JOINT SCHOOL DISTRICT NO. 2 160210000624 340 EAGLE HILLS ELEMENTARY SCHOOL   Regular School No 1.0 PK 05 2016   grade_5 89 0 7   1 3     0   2   48 54             11         102 89 0 7   1 3     0   2   48 54         11       102
1821405 ID     school 1602640 25   POCATELLO DISTRICT 160264000473 355 INDIAN HILLS ELEMENTARY SCHOOL   Regular School No 1.0 KG 05 2016   grade_5 89 1 12   2 1     0   2   65 42             54         107 89 1 12   2 1     0   2   65 42         54       107
1824657 ID     school 1603330 431   WEISER DISTRICT 160333000566 840 PARK INTERMEDIATE SCHOOL   Regular School No 2.0 04 05 2016   grade_5 89 0 34   4 1     0   2   63 67             74         130 89 0 34   4 1     0   2   63 67         74       130
848604 ID     school 1600360 1   BOISE INDEPENDENT DISTRICT 160036000590 287 TRAIL WIND ELEMENTARY   Regular School No Elementary PK 06 2020   grade_5 88 0 5   0 4     0   6   53 50             15         103 88 0 5   0 4     0   6   53 50         15       103

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