Data source: Big Local News · About: Big Local

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

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
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
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
850724 ID     school   150   SODA SPRINGS JOINT DISTRICT   1025 BORDER DISTRICT - FREEDOM ELEMENTARY             2020   grade_5 2 0 0   0 0     0   0   0 2             *         2 2 0 0   0 0     0   0   0 2                 2
852045 ID     school   340   LEWISTON INDEPENDENT DISTRICT   611 NORTHWEST CHILDRENS HOME             2020   grade_5 2 0 0   0 0     0   0   2 0             *         2 2 0 0   0 0     0   0   2 0                 2
852149 ID     school   342   CULDESAC JOINT DISTRICT   1373 NORTHWEST CHILDREN'S HOME             2020   grade_5 0 0 0   1 0     0   0   1 0             *         1 0 0 0   1 0     0   0   1 0                 1
1278267 ID     school   150   SODA SPRINGS JOINT DISTRICT   1025 BORDER DISTRICT - FREEDOM ELEMENTARY             2018   grade_5 2 0 0   0 0     0   0   2 0             *         2 2 0 0   0 0     0   0   2 0                 2
1307121 ID     school   150   SODA SPRINGS JOINT DISTRICT   1025 BORDER DISTRICT - FREEDOM ELEMENTARY             2019   grade_5 3 0 1   0 0     0   0   2 2             *         4 3 0 1   0 0     0   0   2 2                 4
1308444 ID     school   340   LEWISTON INDEPENDENT DISTRICT   611 NORTHWEST CHILDRENS HOME             2019   grade_5 1 0 0   0 0     0   0   1 0             *         1 1 0 0   0 0     0   0   1 0                 1
1684977 ID     school   340   LEWISTON INDEPENDENT DISTRICT   611 NORTHWEST CHILDRENS HOME             2015   grade_5 1 0 0   0 0     0   0   1 0             *         1 1 0 0   0 0     0   0   1 0                 1
1685064 ID     school   341   LAPWAI DISTRICT   1050 NORTHWEST CHILDREN'S HOME             2015   grade_5 0 0 0   1 0     0   0   1 0             *         1 0 0 0   1 0     0   0   1 0                 1
1685068 ID     school   341   LAPWAI DISTRICT   9503 NEZ PERCE TRIBE HEAD START             2015   grade_5 0 0 0   1 0     0   0   1 0             *         1 0 0 0   1 0     0   0   1 0                 1
1727721 ID     school   150   SODA SPRINGS JOINT DISTRICT   1025 BORDER DISTRICT - FREEDOM ELEMENTARY             2017   grade_5 1 0 0   0 0     0   0   1 0             *         1 1 0 0   0 0     0   0   1 0                 1
1729040 ID     school   340   LEWISTON INDEPENDENT DISTRICT   611 NORTHWEST CHILDRENS HOME             2017   grade_5 1 0 0   0 0     0   1   1 1             *         2 1 0 0   0 0     0   1   1 1                 2
1824023 ID     school   340   LEWISTON INDEPENDENT DISTRICT   611 NORTHWEST CHILDRENS HOME             2016   grade_5 1 0 0   0 0     0   0   1 0             *         1 1 0 0   0 0     0   0   1 0                 1
850678 ID     school 1601290 148   GRACE JOINT DISTRICT 160129000228 462 THATCHER ELEMENTARY SCHOOL   Regular School No Elementary 01 05 2020   grade_5 12 0 1   0 0     0   0   9 4             *         13 12 0 1   0 0     0   0   9 4                 13
851608 ID     school 1602670 273   POST FALLS DISTRICT 160267000209 736 PRAIRIE VIEW ELEMENTARY   Regular School No Elementary 01 05 2020   grade_5 75 0 8   0 1     0   4   38 50             46         88 75 0 8   0 1     0   4   38 50         46       88
851635 ID     school 1602670 273   POST FALLS DISTRICT 160267001085 1388 GREENSFERRY ELEMENTARY SCHOOL   Regular School No Elementary 01 05 2020   grade_5 68 0 5   2 0     1   9   43 42             28         85 68 0 5   2 0     1   9   43 42         28       85
851641 ID     school 1602670 273   POST FALLS DISTRICT 160267000970 2517 WEST RIDGE ELEMENTARY SCHOOL   Regular School No Elementary 01 05 2020   grade_5 81 1 10   2 1     0   4   54 45             45         99 81 1 10   2 1     0   4   54 45         45       99
1278222 ID     school 1601290 148   GRACE JOINT DISTRICT 160129000228 462 THATCHER ELEMENTARY SCHOOL   Regular School No Elementary 01 5.0 2018   grade_5 21 0 3   0 0     0   0   16 8             15         24 21 0 3   0 0     0   0   16 8         15       24
1279136 ID     school 1602670 273   POST FALLS DISTRICT 160267000209 736 PRAIRIE VIEW ELEMENTARY   Regular School No Elementary 01 5.0 2018   grade_5 81 0 10   0 1     0   4   49 47             41         96 81 0 10   0 1     0   4   49 47         41       96
1279142 ID     school 1602670 273   POST FALLS DISTRICT 160267000487 748 PONDEROSA ELEMENTARY SCHOOL   Regular School No Elementary 01 5.0 2018   grade_5 70 1 10   3 0     0   4   51 37             48         88 70 1 10   3 0     0   4   51 37         48       88
1279148 ID     school 1602670 273   POST FALLS DISTRICT 160267000490 749 SELTICE ELEMENTARY SCHOOL   Regular School No Elementary 01 5.0 2018   grade_5 63 0 4   0 1     1   2   33 38             40         71 63 0 4   0 1     1   2   33 38         40       71
1279161 ID     school 1602670 273   POST FALLS DISTRICT 160267001085 1388 GREENSFERRY ELEMENTARY SCHOOL   Regular School No Elementary 01 5.0 2018   grade_5 73 0 4   2 0     0   2   47 34             27         81 73 0 4   2 0     0   2   47 34         27       81
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
1307076 ID     school 1601290 148   GRACE JOINT DISTRICT 160129000228 462 THATCHER ELEMENTARY SCHOOL   Regular School No Elementary 01 5.0 2019   grade_5 27 0 0   0 0     0   0   14 13             *         27 27 0 0   0 0     0   0   14 13                 27
1308005 ID     school 1602670 273   POST FALLS DISTRICT 160267000209 736 PRAIRIE VIEW ELEMENTARY   Regular School No Elementary 01 5.0 2019   grade_5 78 1 4   2 0     0   3   43 45             41         88 78 1 4   2 0     0   3   43 45         41       88
1308011 ID     school 1602670 273   POST FALLS DISTRICT 160267000487 748 PONDEROSA ELEMENTARY SCHOOL   Regular School No Elementary 01 5.0 2019   grade_5 88 1 3   0 0     0   1   48 45             46         93 88 1 3   0 0     0   1   48 45         46       93
1308017 ID     school 1602670 273   POST FALLS DISTRICT 160267000490 749 SELTICE ELEMENTARY SCHOOL   Regular School No Elementary 01 5.0 2019   grade_5 52 1 4   1 0     0   0   25 33             28         58 52 1 4   1 0     0   0   25 33         28       58
1308030 ID     school 1602670 273   POST FALLS DISTRICT 160267001085 1388 GREENSFERRY ELEMENTARY SCHOOL   Regular School No Elementary 01 5.0 2019   grade_5 65 1 2   0 0     0   4   30 42             25         72 65 1 2   0 0     0   4   30 42         25       72
1308036 ID     school 1602670 273   POST FALLS DISTRICT 160267000970 2517 WEST RIDGE ELEMENTARY SCHOOL   Regular School No Elementary 01 5.0 2019   grade_5 75 1 5   0 2     0   4   46 41             39         87 75 1 5   0 2     0   4   46 41         39       87
1682570 ID     school 1600270 55   BLACKFOOT DISTRICT 160027000031 382 DONALD D STALKER ELEMENTARY   Regular School No 1.0 01 05 2015   grade_5 16 0 19   17 0     0   2   23 31             45         54 16 0 19   17 0     0   2   23 31         45       54
1682606 ID     school 1600270 55   BLACKFOOT DISTRICT 160027000028 388 I T STODDARD ELEMENTARY SCHOOL   Regular School No 1.0 01 05 2015   grade_5 29 0 18   4 1     0   2   21 33             35         54 29 0 18   4 1     0   2   21 33         35       54
1683633 ID     school 1601290 148   GRACE JOINT DISTRICT 160129000228 462 THATCHER ELEMENTARY SCHOOL   Regular School No 1.0 01 05 2015   grade_5 15 0 1   0 0     0   0   7 9             *         16 15 0 1   0 0     0   0   7 9                 16
1684301 ID     school 1601590 261   JEROME JOINT DISTRICT 160159000289 297 JEROME ACADEMY   Special Education School No 4.0 01 12 2015   grade_5 1 0 0   0 0     0   0   1 0             *         1 1 0 0   0 0     0   0   1 0                 1
1684536 ID     school 1602670 273   POST FALLS DISTRICT 160267000209 736 PRAIRIE VIEW ELEMENTARY   Regular School No 1.0 01 05 2015   grade_5 111 2 7   1 1     0   2   67 57             66         124 111 2 7   1 1     0   2   67 57         66       124
1684542 ID     school 1602670 273   POST FALLS DISTRICT 160267000487 748 PONDEROSA ELEMENTARY SCHOOL   Regular School No 1.0 01 05 2015   grade_5 104 0 10   0 1     0   2   55 62             55         117 104 0 10   0 1     0   2   55 62         55       117
1684548 ID     school 1602670 273   POST FALLS DISTRICT 160267000490 749 SELTICE ELEMENTARY SCHOOL   Regular School No 1.0 01 05 2015   grade_5 66 0 5   1 1     0   1   42 32             40         74 66 0 5   1 1     0   1   42 32         40       74
1684561 ID     school 1602670 273   POST FALLS DISTRICT 160267000970 2517 WEST RIDGE ELEMENTARY SCHOOL   Regular School No 1.0 01 05 2015   grade_5 74 0 5   0 2     1   3   34 51             33         85 74 0 5   0 2     1   3   34 51         33       85
1727677 ID     school 1601290 148   GRACE JOINT DISTRICT 160129000228 462 THATCHER ELEMENTARY SCHOOL   Regular School No Elementary 01 5.0 2017   grade_5 17 0 0   1 0     0   1   9 10             6         19 17 0 0   1 0     0   1   9 10         6       19
1728361 ID     school 1601590 261   JEROME JOINT DISTRICT 160159000289 297 JEROME ACADEMY   Special Education School No Other 01 12.0 2017   grade_5 1 0 0   0 0     0   0   1 0             *         1 1 0 0   0 0     0   0   1 0                 1
1728595 ID     school 1602670 273   POST FALLS DISTRICT 160267000209 736 PRAIRIE VIEW ELEMENTARY   Regular School No Elementary 01 5.0 2017   grade_5 73 0 7   0 0     0   2   43 39             40         82 73 0 7   0 0     0   2   43 39         40       82
1728601 ID     school 1602670 273   POST FALLS DISTRICT 160267000487 748 PONDEROSA ELEMENTARY SCHOOL   Regular School No Elementary 01 5.0 2017   grade_5 82 2 3   0 0     0   3   53 37             45         90 82 2 3   0 0     0   3   53 37         45       90
1728607 ID     school 1602670 273   POST FALLS DISTRICT 160267000490 749 SELTICE ELEMENTARY SCHOOL   Regular School No Elementary 01 5.0 2017   grade_5 60 0 2   2 1     0   0   41 24             36         65 60 0 2   2 1     0   0   41 24         36       65
1728620 ID     school 1602670 273   POST FALLS DISTRICT 160267001085 1388 GREENSFERRY ELEMENTARY SCHOOL   Regular School No Elementary 01 5.0 2017   grade_5 54 0 6   1 0     0   3   36 28             *         64 54 0 6   1 0     0   3   36 28                 64
1728626 ID     school 1602670 273   POST FALLS DISTRICT 160267000970 2517 WEST RIDGE ELEMENTARY SCHOOL   Regular School No Elementary 01 5.0 2017   grade_5 62 0 8   0 0     0   3   33 40             31         73 62 0 8   0 0     0   3   33 40         31       73
1821642 ID     school 1600270 55   BLACKFOOT DISTRICT 160027000028 388 I T STODDARD ELEMENTARY SCHOOL   Regular School No 1.0 01 05 2016   grade_5 47 1 9   11 2     0   4   39 35             34         74 47 1 9   11 2     0   4   39 35         34       74
1822679 ID     school 1601290 148   GRACE JOINT DISTRICT 160129000228 462 THATCHER ELEMENTARY SCHOOL   Regular School No 1.0 01 05 2016   grade_5 21 0 1   0 0     0   0   9 13             11         22 21 0 1   0 0     0   0   9 13         11       22
1823353 ID     school 1601590 261   JEROME JOINT DISTRICT 160159000289 297 JEROME ACADEMY   Special Education School No 4.0 01 12 2016   grade_5 2 0 0   0 0     0   0   2 0             *         2 2 0 0   0 0     0   0   2 0                 2
1823585 ID     school 1602670 273   POST FALLS DISTRICT 160267000209 736 PRAIRIE VIEW ELEMENTARY   Regular School No 1.0 01 05 2016   grade_5 88 0 11   1 0     0   2   57 45             50         102 88 0 11   1 0     0   2   57 45         50       102
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
1823597 ID     school 1602670 273   POST FALLS DISTRICT 160267000490 749 SELTICE ELEMENTARY SCHOOL   Regular School No 1.0 01 05 2016   grade_5 74 1 3   2 1     0   2   50 33             49         83 74 1 3   2 1     0   2   50 33         49       83
1823610 ID     school 1602670 273   POST FALLS DISTRICT 160267000970 2517 WEST RIDGE ELEMENTARY SCHOOL   Regular School No 1.0 01 05 2016   grade_5 82 0 5   2 0     0   4   46 47             47         93 82 0 5   2 0     0   4   46 47         47       93
705730 ID     school 1601590 261   JEROME JOINT DISTRICT 160159000972 2516 SUMMIT ELEMENTARY   Regular School No Elementary 02 05 2021   grade_5 130 0 165   1 1     1   2   152 148             *         300 130 0 165   1 1     1   2   152 148                 300
1684262 ID     school 1602790 252   RIRIE JOINT DISTRICT 160279000435 229 RIRIE ELEMENTARY SCHOOL   Regular School No 1.0 02 08 2015   grade_5 47 1 3   2 0     0   4   27 30             30         57 47 1 3   2 0     0   4   27 30         30       57
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
1821268 ID     school 1601770 3   KUNA JOINT DISTRICT 160177000805 850 FREMONT H TEED MIDDLE SCHOOL   Regular School No 1.0 02 06 2016   grade_5 82 2 8   0 0     1   5   52 46             40         98 82 2 8   0 0     1   5   52 46         40       98
705319 ID     school 1600960 201   PRESTON JOINT DISTRICT 160096000181 497 OAKWOOD ELEMENTARY SCHOOL   Regular School No Elementary 03 05 2021   grade_5 147 0 21   2 0     0   1   90 81             53         171 147 0 21   2 0     0   1   90 81         53       171
706021 ID     school 1602220 281   MOSCOW DISTRICT 160222000391 753 J RUSSELL ELEMENTARY SCHOOL   Regular School No Elementary 03 05 2021   grade_5 40 2 3   2 1     0   6   25 29             *         54 40 2 3   2 1     0   6   25 29                 54
706669 ID     school 1600060 381   AMERICAN FALLS JOINT DISTRICT 160006000816 849 J.R. SIMPLOT ELEMENTARY SCHOOL   Regular School No Elementary 03 05 2021   grade_5 67 0 52   1 0     0   1   60 61             74         121 67 0 52   1 0     0   1   60 61         74       121
851018 ID     school 1600960 201   PRESTON JOINT DISTRICT 160096000181 497 OAKWOOD ELEMENTARY SCHOOL   Regular School No Elementary 03 05 2020   grade_5 156 2 22   2 0     1   0   90 93             100         183 156 2 22   2 0     1   0   90 93         100       183
851320 ID     school 1601570 251   JEFFERSON COUNTY JOINT DISTRICT 160157001064 1359 PHILO T FARNSWORTH ELEMENTARY SCHOOL   Regular School No Elementary 03 05 2020   grade_5 236 0 18   0 0     0   0   128 126             73         254 236 0 18   0 0     0   0   128 126         73       254
851673 ID     school 1602220 281   MOSCOW DISTRICT 160222000391 753 J RUSSELL ELEMENTARY SCHOOL   Regular School No Elementary 03 05 2020   grade_5 50 0 2   0 1     0   5   23 35             22         58 50 0 2   0 1     0   5   23 35         22       58
852323 ID     school 1600060 381   AMERICAN FALLS JOINT DISTRICT 160006000816 849 J.R. SIMPLOT ELEMENTARY SCHOOL   Regular School No Elementary 03 05 2020   grade_5 49 3 70   2 0     0   0   61 63             93         124 49 3 70   2 0     0   0   61 63         93       124
1278543 ID     school 1600960 201   PRESTON JOINT DISTRICT 160096000181 497 OAKWOOD ELEMENTARY SCHOOL   Regular School No Elementary 03 5.0 2018   grade_5 145 1 22   3 1     0   0   90 82             87         172 145 1 22   3 1     0   0   90 82         87       172
1278844 ID     school 1601570 251   JEFFERSON COUNTY JOINT DISTRICT 160157001064 1359 PHILO T FARNSWORTH ELEMENTARY SCHOOL   Regular School No Elementary 03 5.0 2018   grade_5 219 0 17   1 0     0   3   128 112             82         240 219 0 17   1 0     0   3   128 112         82       240
1279199 ID     school 1602220 281   MOSCOW DISTRICT 160222000391 753 J RUSSELL ELEMENTARY SCHOOL   Regular School No Elementary 03 5.0 2018   grade_5 45 5 4   0 6     0   3   31 32             30         63 45 5 4   0 6     0   3   31 32         30       63
1307416 ID     school 1600960 201   PRESTON JOINT DISTRICT 160096000181 497 OAKWOOD ELEMENTARY SCHOOL   Regular School No Elementary 03 5.0 2019   grade_5 162 0 20   3 1     1   2   101 88             80         189 162 0 20   3 1     1   2   101 88         80       189
1307715 ID     school 1601570 251   JEFFERSON COUNTY JOINT DISTRICT 160157001064 1359 PHILO T FARNSWORTH ELEMENTARY SCHOOL   Regular School No Elementary 03 5.0 2019   grade_5 213 0 27   0 0     0   4   111 133             76         244 213 0 27   0 0     0   4   111 133         76       244
1308067 ID     school 1602220 281   MOSCOW DISTRICT 160222000391 753 J RUSSELL ELEMENTARY SCHOOL   Regular School No Elementary 03 5.0 2019   grade_5 43 2 4   1 3     0   4   24 33             *         57 43 2 4   1 3     0   4   24 33                 57
1682227 ID     school 1601770 3   KUNA JOINT DISTRICT 160177000915 635 ROSS ELEMENTARY SCHOOL   Regular School No 1.0 03 06 2015   grade_5 54 0 1   0 1     0   1   28 29             23         57 54 0 1   0 1     0   1   28 29         23       57
1683945 ID     school 1600960 201   PRESTON JOINT DISTRICT 160096000181 497 OAKWOOD ELEMENTARY SCHOOL   Regular School No 1.0 03 05 2015   grade_5 162 0 20   2 1     0   3   112 76             93         188 162 0 20   2 1     0   3   112 76         93       188
1684250 ID     school 1601570 251   JEFFERSON COUNTY JOINT DISTRICT 160157001064 1359 PHILO T FARNSWORTH ELEMENTARY SCHOOL   Regular School No 1.0 03 05 2015   grade_5 144 0 14   0 0     0   4   81 81             65         162 144 0 14   0 0     0   4   81 81         65       162
1684593 ID     school 1602220 281   MOSCOW DISTRICT 160222000391 753 J RUSSELL ELEMENTARY SCHOOL   Regular School No 1.0 03 05 2015   grade_5 55 0 4   2 4     0   3   37 31             37         68 55 0 4   2 4     0   3   37 31         37       68
1726265 ID     school 1601770 3   KUNA JOINT DISTRICT 160177000915 635 ROSS ELEMENTARY SCHOOL   Regular School No Elementary 03 6.0 2017   grade_5 53 0 4   0 2     1   1   34 27             28         61 53 0 4   0 2     1   1   34 27         28       61
1728006 ID     school 1600960 201   PRESTON JOINT DISTRICT 160096000181 497 OAKWOOD ELEMENTARY SCHOOL   Regular School No Elementary 03 5.0 2017   grade_5 181 1 17   3 1     0   1   101 103             92         204 181 1 17   3 1     0   1   101 103         92       204
1728310 ID     school 1601570 251   JEFFERSON COUNTY JOINT DISTRICT 160157001064 1359 PHILO T FARNSWORTH ELEMENTARY SCHOOL   Regular School No Elementary 03 5.0 2017   grade_5 188 2 17   1 0     0   3   112 99             86         211 188 2 17   1 0     0   3   112 99         86       211
1728658 ID     school 1602220 281   MOSCOW DISTRICT 160222000391 753 J RUSSELL ELEMENTARY SCHOOL   Regular School No Elementary 03 5.0 2017   grade_5 50 2 2   1 5     2   2   26 38             25         64 50 2 2   1 5     2   2   26 38         25       64
1821263 ID     school 1601770 3   KUNA JOINT DISTRICT 160177000915 635 ROSS ELEMENTARY SCHOOL   Regular School No 1.0 03 06 2016   grade_5 49 0 11   0 0     0   1   35 26             30         61 49 0 11   0 0     0   1   35 26         30       61
1822995 ID     school 1600960 201   PRESTON JOINT DISTRICT 160096000181 497 OAKWOOD ELEMENTARY SCHOOL   Regular School No 1.0 03 05 2016   grade_5 170 0 17   2 0     0   2   95 96             87         191 170 0 17   2 0     0   2   95 96         87       191
1823303 ID     school 1601570 251   JEFFERSON COUNTY JOINT DISTRICT 160157001064 1359 PHILO T FARNSWORTH ELEMENTARY SCHOOL   Regular School No 1.0 03 05 2016   grade_5 163 0 23   0 0     0   7   89 104             76         193 163 0 23   0 0     0   7   89 104         76       193
1823642 ID     school 1602220 281   MOSCOW DISTRICT 160222000391 753 J RUSSELL ELEMENTARY SCHOOL   Regular School No 1.0 03 05 2016   grade_5 39 2 3   0 2     0   2   22 26             24         48 39 2 3   0 2     0   2   22 26         24       48
703031 ID     school 1600360 1   BOISE INDEPENDENT DISTRICT 160036000823 573 TREASURE VALLEY MATH/SCIENCE   Regular School No Other 04 12 2021   grade_5 2 0 0   0 0     0   0   2 0             *         2 2 0 0   0 0     0   0   2 0                 2
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
706109 ID     school 1600010 288   WHITEPINE JOINT SCHOOL DISTRICT 160001000579 794 DEARY SCHOOL   Regular School No Other 04 12 2021   grade_5 11 0 0   0 0     0   0   7 4             5         11 11 0 0   0 0     0   0   7 4         5       11
706173 ID     school 1601620 304   KAMIAH JOINT DISTRICT 160162000458 232 KAMIAH MIDDLE SCHOOL   Regular School No Middle 04 08 2021   grade_5 13 0 2   4 0     0   3   10 12             7         22 13 0 2   4 0     0   3   10 12         7       22
706255 ID     school 1601920 321   MADISON DISTRICT 160192000210 250 MADISON MIDDLE SCHOOL   Regular School No Middle 04 06 2021   grade_5 335 4 38   0 1     2   1   194 187             133         381 335 4 38   0 1     2   1   194 187         133       381
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
706600 ID     school 1602580 371   PAYETTE JOINT DISTRICT 160258000456 805 WESTSIDE ELEMENTARY SCHOOL   Regular School No Elementary 04 05 2021   grade_5 60 0 35   1 0     0   2   42 56             36         98 60 0 35   1 0     0   2   42 56         36       98
706782 ID     school 1603180 401   TETON COUNTY DISTRICT 160318001022 1236 RENDEZVOUS UPPER ELEMENTARY SCHOOL   Regular School No Elementary 04 05 2021   grade_5 84 0 49   0 0     0   1   74 60             50         134 84 0 49   0 0     0   1   74 60         50       134
706935 ID     school 1601050 413   FILER DISTRICT 160105001006 1244 FILER INTERMEDIATE SCHOOL   Regular School No Middle 04 06 2021   grade_5 109 1 13   1 0     0   1   69 56             40         125 109 1 13   1 0     0   1   69 56         40       125
707066 ID     school 1603330 431   WEISER DISTRICT 160333000566 840 PARK INTERMEDIATE SCHOOL   Regular School No Elementary 04 05 2021   grade_5 68 0 25   2 0     0   2   50 47             50         97 68 0 25   2 0     0   2   50 47         50       97
707662 ID     school 1600186 531   FERN-WATERS PUBLIC CHARTER SCHOOL, INC. 160018601114 1423 FERN-WATERS PUBLIC CHARTER SCHOOL   Regular School Yes Middle 04 08 2021   grade_5 13 0 0   0 0     0   0   6 7             8         13 13 0 0   0 0     0   0   6 7         8       13
849255 ID     school 1601770 3   KUNA JOINT DISTRICT 160177000915 635 ROSS ELEMENTARY SCHOOL   Regular School No Elementary 04 05 2020   grade_5 114 0 18   0 0     2   3   65 72             54         137 114 0 18   0 0     2   3   65 72         54       137
851390 ID     school 1601590 261   JEROME JOINT DISTRICT 160159000972 2516 SUMMIT ELEMENTARY   Regular School No Elementary 04 05 2020   grade_5 126 0 187   3 1     2   1   157 163             *         320 126 0 187   3 1     2   1   157 163                 320
851761 ID     school 1600010 288   WHITEPINE JOINT SCHOOL DISTRICT 160001000579 794 DEARY SCHOOL   Regular School No Other 04 12 2020   grade_5 18 0 0   0 0     0   0   11 7             12         18 18 0 0   0 0     0   0   11 7         12       18
851906 ID     school 1601920 321   MADISON DISTRICT 160192000210 250 MADISON MIDDLE SCHOOL   Regular School No Middle 04 06 2020   grade_5 362 2 44   1 1     3   2   223 192             158         415 362 2 44   1 1     3   2   223 192         158       415
851959 ID     school 1603090 322   SUGAR-SALEM JOINT DISTRICT 160309000645 225 KERSHAW INTERMEDIATE SCHOOL   Regular School No Middle 04 06 2020   grade_5 121 3 6   2 0     0   0   70 62             56         132 121 3 6   2 0     0   0   70 62         56       132
852263 ID     school 1602580 371   PAYETTE JOINT DISTRICT 160258000456 805 WESTSIDE ELEMENTARY SCHOOL   Regular School No Elementary 04 05 2020   grade_5 66 0 29   2 0     1   1   52 47             47         99 66 0 29   2 0     1   1   52 47         47       99
852436 ID     school 1603180 401   TETON COUNTY DISTRICT 160318001022 1236 RENDEZVOUS UPPER ELEMENTARY SCHOOL   Regular School No Elementary 04 05 2020   grade_5 111 0 47   0 0     0   2   76 84             52         160 111 0 47   0 0     0   2   76 84         52       160
852582 ID     school 1601050 413   FILER DISTRICT 160105001006 1244 FILER INTERMEDIATE SCHOOL   Regular School No Middle 04 06 2020   grade_5 83 1 17   0 0     0   1   59 43             *         102 83 1 17   0 0     0   1   59 43                 102

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