Data source: Big Local News · About: Big Local

2,743 rows where grade = "grade_4" and state = "ID" sorted by ccd_school_low_grade

View and edit SQL

year

grade

  • grade_4 · 2,743
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
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
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
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
850723 ID     school   150   SODA SPRINGS JOINT DISTRICT   1025 BORDER DISTRICT - FREEDOM ELEMENTARY             2020   grade_4 1 0 0   0 0     0   0   1 0             *         1 1 0 0   0 0     0   0   1 0                 1
852044 ID     school   340   LEWISTON INDEPENDENT DISTRICT   611 NORTHWEST CHILDRENS HOME             2020   grade_4 5 0 0   0 0     0   0   5 0             *         5 5 0 0   0 0     0   0   5 0                 5
1278266 ID     school   150   SODA SPRINGS JOINT DISTRICT   1025 BORDER DISTRICT - FREEDOM ELEMENTARY             2018   grade_4 1 0 1   0 0     0   0   0 2             *         2 1 0 1   0 0     0   0   0 2                 2
1308443 ID     school   340   LEWISTON INDEPENDENT DISTRICT   611 NORTHWEST CHILDRENS HOME             2019   grade_4 1 0 0   0 0     0   0   1 0             *         1 1 0 0   0 0     0   0   1 0                 1
1308544 ID     school   342   CULDESAC JOINT DISTRICT   1373 NORTHWEST CHILDREN'S HOME             2019   grade_4 0 0 0   1 0     0   0   1 0             *         1 0 0 0   1 0     0   0   1 0                 1
1684976 ID     school   340   LEWISTON INDEPENDENT DISTRICT   611 NORTHWEST CHILDRENS HOME             2015   grade_4 1 0 0   0 0     0   0   1 0             *         1 1 0 0   0 0     0   0   1 0                 1
1685063 ID     school   341   LAPWAI DISTRICT   1050 NORTHWEST CHILDREN'S HOME             2015   grade_4 0 0 0   1 0     0   0   1 0             *         1 0 0 0   1 0     0   0   1 0                 1
1726928 ID     school   84   LAKE PEND OREILLE SCHOOL DISTRICT   1391 LPOSD HOME SCHOOL ACADEMY             2017   grade_4 2 0 0   0 0     0   0   2 0             *         2 2 0 0   0 0     0   0   2 0                 2
1824022 ID     school   340   LEWISTON INDEPENDENT DISTRICT   611 NORTHWEST CHILDRENS HOME             2016   grade_4 0 0 0   0 0     0   1   0 1             *         1 0 0 0   0 0     0   1   0 1                 1
704965 ID     school 1601290 148   GRACE JOINT DISTRICT 160129000228 462 THATCHER ELEMENTARY SCHOOL   Regular School No Elementary 01 05 2021   grade_4 14 0 0   0 0     0   0   7 7             *         14 14 0 0   0 0     0   0   7 7                 14
850677 ID     school 1601290 148   GRACE JOINT DISTRICT 160129000228 462 THATCHER ELEMENTARY SCHOOL   Regular School No Elementary 01 05 2020   grade_4 25 0 0   0 0     0   0   10 15             14         25 25 0 0   0 0     0   0   10 15         14       25
851607 ID     school 1602670 273   POST FALLS DISTRICT 160267000209 736 PRAIRIE VIEW ELEMENTARY   Regular School No Elementary 01 05 2020   grade_4 89 1 8   1 1     0   6   50 56             46         106 89 1 8   1 1     0   6   50 56         46       106
851634 ID     school 1602670 273   POST FALLS DISTRICT 160267001085 1388 GREENSFERRY ELEMENTARY SCHOOL   Regular School No Elementary 01 05 2020   grade_4 79 0 6   3 0     1   2   44 47             38         91 79 0 6   3 0     1   2   44 47         38       91
851640 ID     school 1602670 273   POST FALLS DISTRICT 160267000970 2517 WEST RIDGE ELEMENTARY SCHOOL   Regular School No Elementary 01 05 2020   grade_4 71 0 5   0 0     1   5   37 45             35         82 71 0 5   0 0     1   5   37 45         35       82
1278221 ID     school 1601290 148   GRACE JOINT DISTRICT 160129000228 462 THATCHER ELEMENTARY SCHOOL   Regular School No Elementary 01 5.0 2018   grade_4 25 0 0   0 0     0   0   12 13             10         25 25 0 0   0 0     0   0   12 13         10       25
1279135 ID     school 1602670 273   POST FALLS DISTRICT 160267000209 736 PRAIRIE VIEW ELEMENTARY   Regular School No Elementary 01 5.0 2018   grade_4 72 1 5   1 0     0   3   37 45             30         82 72 1 5   1 0     0   3   37 45         30       82
1279141 ID     school 1602670 273   POST FALLS DISTRICT 160267000487 748 PONDEROSA ELEMENTARY SCHOOL   Regular School No Elementary 01 5.0 2018   grade_4 83 2 4   0 0     0   2   52 39             49         91 83 2 4   0 0     0   2   52 39         49       91
1279147 ID     school 1602670 273   POST FALLS DISTRICT 160267000490 749 SELTICE ELEMENTARY SCHOOL   Regular School No Elementary 01 5.0 2018   grade_4 45 1 4   0 0     0   0   23 27             22         50 45 1 4   0 0     0   0   23 27         22       50
1279160 ID     school 1602670 273   POST FALLS DISTRICT 160267001085 1388 GREENSFERRY ELEMENTARY SCHOOL   Regular School No Elementary 01 5.0 2018   grade_4 60 0 2   0 0     0   1   27 36             17         63 60 0 2   0 0     0   1   27 36         17       63
1279166 ID     school 1602670 273   POST FALLS DISTRICT 160267000970 2517 WEST RIDGE ELEMENTARY SCHOOL   Regular School No Elementary 01 5.0 2018   grade_4 81 0 3   0 2     0   4   46 44             38         90 81 0 3   0 2     0   4   46 44         38       90
1307075 ID     school 1601290 148   GRACE JOINT DISTRICT 160129000228 462 THATCHER ELEMENTARY SCHOOL   Regular School No Elementary 01 5.0 2019   grade_4 13 0 0   0 0     0   0   11 2             *         13 13 0 0   0 0     0   0   11 2                 13
1308004 ID     school 1602670 273   POST FALLS DISTRICT 160267000209 736 PRAIRIE VIEW ELEMENTARY   Regular School No Elementary 01 5.0 2019   grade_4 71 0 7   0 1     0   2   37 44             44         81 71 0 7   0 1     0   2   37 44         44       81
1308010 ID     school 1602670 273   POST FALLS DISTRICT 160267000487 748 PONDEROSA ELEMENTARY SCHOOL   Regular School No Elementary 01 5.0 2019   grade_4 78 0 8   0 1     0   5   34 58             52         92 78 0 8   0 1     0   5   34 58         52       92
1308016 ID     school 1602670 273   POST FALLS DISTRICT 160267000490 749 SELTICE ELEMENTARY SCHOOL   Regular School No Elementary 01 5.0 2019   grade_4 66 0 4   0 1     0   4   39 36             39         75 66 0 4   0 1     0   4   39 36         39       75
1308029 ID     school 1602670 273   POST FALLS DISTRICT 160267001085 1388 GREENSFERRY ELEMENTARY SCHOOL   Regular School No Elementary 01 5.0 2019   grade_4 64 0 9   2 0     0   7   38 44             30         82 64 0 9   2 0     0   7   38 44         30       82
1308035 ID     school 1602670 273   POST FALLS DISTRICT 160267000970 2517 WEST RIDGE ELEMENTARY SCHOOL   Regular School No Elementary 01 5.0 2019   grade_4 85 3 9   1 1     0   5   53 51             49         104 85 3 9   1 1     0   5   53 51         49       104
1682569 ID     school 1600270 55   BLACKFOOT DISTRICT 160027000031 382 DONALD D STALKER ELEMENTARY   Regular School No 1.0 01 05 2015   grade_4 30 0 23   10 1     0   2   33 33             51         66 30 0 23   10 1     0   2   33 33         51       66
1682605 ID     school 1600270 55   BLACKFOOT DISTRICT 160027000028 388 I T STODDARD ELEMENTARY SCHOOL   Regular School No 1.0 01 05 2015   grade_4 50 1 6   7 1     0   2   37 30             38         67 50 1 6   7 1     0   2   37 30         38       67
1683632 ID     school 1601290 148   GRACE JOINT DISTRICT 160129000228 462 THATCHER ELEMENTARY SCHOOL   Regular School No 1.0 01 05 2015   grade_4 14 0 2   0 0     0   0   7 9             11         16 14 0 2   0 0     0   0   7 9         11       16
1684300 ID     school 1601590 261   JEROME JOINT DISTRICT 160159000289 297 JEROME ACADEMY   Special Education School No 4.0 01 12 2015   grade_4 1 0 0   0 0     0   0   1 0             *         1 1 0 0   0 0     0   0   1 0                 1
1684535 ID     school 1602670 273   POST FALLS DISTRICT 160267000209 736 PRAIRIE VIEW ELEMENTARY   Regular School No 1.0 01 05 2015   grade_4 99 0 12   1 1     0   1   64 50             59         114 99 0 12   1 1     0   1   64 50         59       114
1684541 ID     school 1602670 273   POST FALLS DISTRICT 160267000487 748 PONDEROSA ELEMENTARY SCHOOL   Regular School No 1.0 01 05 2015   grade_4 91 3 6   2 0     0   1   54 49             57         103 91 3 6   2 0     0   1   54 49         57       103
1684547 ID     school 1602670 273   POST FALLS DISTRICT 160267000490 749 SELTICE ELEMENTARY SCHOOL   Regular School No 1.0 01 05 2015   grade_4 68 1 2   2 1     0   2   44 32             50         76 68 1 2   2 1     0   2   44 32         50       76
1684560 ID     school 1602670 273   POST FALLS DISTRICT 160267000970 2517 WEST RIDGE ELEMENTARY SCHOOL   Regular School No 1.0 01 05 2015   grade_4 76 0 6   2 0     0   2   45 41             *         86 76 0 6   2 0     0   2   45 41                 86
1727676 ID     school 1601290 148   GRACE JOINT DISTRICT 160129000228 462 THATCHER ELEMENTARY SCHOOL   Regular School No Elementary 01 5.0 2017   grade_4 19 0 3   0 0     0   0   14 8             15         22 19 0 3   0 0     0   0   14 8         15       22
1728360 ID     school 1601590 261   JEROME JOINT DISTRICT 160159000289 297 JEROME ACADEMY   Special Education School No Other 01 12.0 2017   grade_4 0 0 1   0 0     0   1   2 0             *         2 0 0 1   0 0     0   1   2 0                 2
1728594 ID     school 1602670 273   POST FALLS DISTRICT 160267000209 736 PRAIRIE VIEW ELEMENTARY   Regular School No Elementary 01 5.0 2017   grade_4 80 0 12   0 1     0   5   44 54             47         98 80 0 12   0 1     0   5   44 54         47       98
1728600 ID     school 1602670 273   POST FALLS DISTRICT 160267000487 748 PONDEROSA ELEMENTARY SCHOOL   Regular School No Elementary 01 5.0 2017   grade_4 75 1 6   1 0     0   4   53 34             44         87 75 1 6   1 0     0   4   53 34         44       87
1728606 ID     school 1602670 273   POST FALLS DISTRICT 160267000490 749 SELTICE ELEMENTARY SCHOOL   Regular School No Elementary 01 5.0 2017   grade_4 64 0 3   0 1     1   2   33 38             39         71 64 0 3   0 1     1   2   33 38         39       71
1728619 ID     school 1602670 273   POST FALLS DISTRICT 160267001085 1388 GREENSFERRY ELEMENTARY SCHOOL   Regular School No Elementary 01 5.0 2017   grade_4 76 0 4   1 0     0   3   51 33             28         84 76 0 4   1 0     0   3   51 33         28       84
1728625 ID     school 1602670 273   POST FALLS DISTRICT 160267000970 2517 WEST RIDGE ELEMENTARY SCHOOL   Regular School No Elementary 01 5.0 2017   grade_4 87 2 6   0 1     0   2   47 51             52         98 87 2 6   0 1     0   2   47 51         52       98
1821641 ID     school 1600270 55   BLACKFOOT DISTRICT 160027000028 388 I T STODDARD ELEMENTARY SCHOOL   Regular School No 1.0 01 05 2016   grade_4 48 0 17   6 0     0   3   37 37             38         74 48 0 17   6 0     0   3   37 37         38       74
1822678 ID     school 1601290 148   GRACE JOINT DISTRICT 160129000228 462 THATCHER ELEMENTARY SCHOOL   Regular School No 1.0 01 05 2016   grade_4 15 0 0   1 0     0   1   8 9             5         17 15 0 0   1 0     0   1   8 9         5       17
1823352 ID     school 1601590 261   JEROME JOINT DISTRICT 160159000289 297 JEROME ACADEMY   Special Education School No 4.0 01 12 2016   grade_4 2 0 0   0 0     0   0   2 0             *         2 2 0 0   0 0     0   0   2 0                 2
1823584 ID     school 1602670 273   POST FALLS DISTRICT 160267000209 736 PRAIRIE VIEW ELEMENTARY   Regular School No 1.0 01 05 2016   grade_4 104 0 10   1 0     0   5   68 52             57         120 104 0 10   1 0     0   5   68 52         57       120
1823590 ID     school 1602670 273   POST FALLS DISTRICT 160267000487 748 PONDEROSA ELEMENTARY SCHOOL   Regular School No 1.0 01 05 2016   grade_4 89 2 4   1 0     0   4   52 48             59         100 89 2 4   1 0     0   4   52 48         59       100
1823596 ID     school 1602670 273   POST FALLS DISTRICT 160267000490 749 SELTICE ELEMENTARY SCHOOL   Regular School No 1.0 01 05 2016   grade_4 69 0 3   1 1     0   0   44 30             43         74 69 0 3   1 1     0   0   44 30         43       74
1823609 ID     school 1602670 273   POST FALLS DISTRICT 160267000970 2517 WEST RIDGE ELEMENTARY SCHOOL   Regular School No 1.0 01 05 2016   grade_4 61 0 6   1 0     0   3   35 36             *         71 61 0 6   1 0     0   3   35 36                 71
705729 ID     school 1601590 261   JEROME JOINT DISTRICT 160159000972 2516 SUMMIT ELEMENTARY   Regular School No Elementary 02 05 2021   grade_4 122 0 173   0 2     0   3   156 144             *         300 122 0 173   0 2     0   3   156 144                 300
1684261 ID     school 1602790 252   RIRIE JOINT DISTRICT 160279000435 229 RIRIE ELEMENTARY SCHOOL   Regular School No 1.0 02 08 2015   grade_4 45 0 3   0 0     0   0   22 26             21         48 45 0 3   0 0     0   0   22 26         21       48
1726269 ID     school 1601770 3   KUNA JOINT DISTRICT 160177000805 850 FREMONT H TEED MIDDLE SCHOOL   Regular School No Elementary 02 6.0 2017   grade_4 100 0 11   1 0     2   5   66 53             58         119 100 0 11   1 0     2   5   66 53         58       119
1821267 ID     school 1601770 3   KUNA JOINT DISTRICT 160177000805 850 FREMONT H TEED MIDDLE SCHOOL   Regular School No 1.0 02 06 2016   grade_4 94 1 6   0 0     0   2   60 43             52         103 94 1 6   0 0     0   2   60 43         52       103
703953 ID     school 1602910 60   SHELLEY JOINT DISTRICT 160291001012 1251 RIVERVIEW ELEMENTARY SCHOOL   Regular School No Elementary 03 04 2021   grade_4 150 1 21   1 2     0   0   98 77             58         175 150 1 21   1 2     0   0   98 77         58       175
705318 ID     school 1600960 201   PRESTON JOINT DISTRICT 160096000181 497 OAKWOOD ELEMENTARY SCHOOL   Regular School No Elementary 03 05 2021   grade_4 146 1 24   2 0     0   2   87 88             61         175 146 1 24   2 0     0   2   87 88         61       175
706020 ID     school 1602220 281   MOSCOW DISTRICT 160222000391 753 J RUSSELL ELEMENTARY SCHOOL   Regular School No Elementary 03 05 2021   grade_4 40 2 4   0 4     0   1   21 30             27         51 40 2 4   0 4     0   1   21 30         27       51
706668 ID     school 1600060 381   AMERICAN FALLS JOINT DISTRICT 160006000816 849 J.R. SIMPLOT ELEMENTARY SCHOOL   Regular School No Elementary 03 05 2021   grade_4 48 0 55   5 0     0   0   51 57             *         108 48 0 55   5 0     0   0   51 57                 108
849690 ID     school 1602910 60   SHELLEY JOINT DISTRICT 160291001012 1251 RIVERVIEW ELEMENTARY SCHOOL   Regular School No Elementary 03 04 2020   grade_4 159 2 21   0 3     0   1   86 100             91         186 159 2 21   0 3     0   1   86 100         91       186
851017 ID     school 1600960 201   PRESTON JOINT DISTRICT 160096000181 497 OAKWOOD ELEMENTARY SCHOOL   Regular School No Elementary 03 05 2020   grade_4 141 0 21   2 0     0   2   83 83             71         166 141 0 21   2 0     0   2   83 83         71       166
851319 ID     school 1601570 251   JEFFERSON COUNTY JOINT DISTRICT 160157001064 1359 PHILO T FARNSWORTH ELEMENTARY SCHOOL   Regular School No Elementary 03 05 2020   grade_4 219 0 16   2 0     0   5   124 118             78         242 219 0 16   2 0     0   5   124 118         78       242
851672 ID     school 1602220 281   MOSCOW DISTRICT 160222000391 753 J RUSSELL ELEMENTARY SCHOOL   Regular School No Elementary 03 05 2020   grade_4 48 2 4   2 1     0   6   30 33             20         63 48 2 4   2 1     0   6   30 33         20       63
852322 ID     school 1600060 381   AMERICAN FALLS JOINT DISTRICT 160006000816 849 J.R. SIMPLOT ELEMENTARY SCHOOL   Regular School No Elementary 03 05 2020   grade_4 70 1 55   1 0     0   0   64 63             83         127 70 1 55   1 0     0   0   64 63         83       127
1277238 ID     school 1602910 60   SHELLEY JOINT DISTRICT 160291001012 1251 RIVERVIEW ELEMENTARY SCHOOL   Regular School No Elementary 03 4.0 2018   grade_4 164 0 26   0 1     0   1   111 81             80         192 164 0 26   0 1     0   1   111 81         80       192
1278542 ID     school 1600960 201   PRESTON JOINT DISTRICT 160096000181 497 OAKWOOD ELEMENTARY SCHOOL   Regular School No Elementary 03 5.0 2018   grade_4 173 0 17   3 1     0   2   105 91             93         196 173 0 17   3 1     0   2   105 91         93       196
1278843 ID     school 1601570 251   JEFFERSON COUNTY JOINT DISTRICT 160157001064 1359 PHILO T FARNSWORTH ELEMENTARY SCHOOL   Regular School No Elementary 03 5.0 2018   grade_4 220 0 22   0 0     0   4   113 133             81         246 220 0 22   0 0     0   4   113 133         81       246
1279198 ID     school 1602220 281   MOSCOW DISTRICT 160222000391 753 J RUSSELL ELEMENTARY SCHOOL   Regular School No Elementary 03 5.0 2018   grade_4 47 2 4   1 4     0   4   27 35             29         62 47 2 4   1 4     0   4   27 35         29       62
1306098 ID     school 1602910 60   SHELLEY JOINT DISTRICT 160291001012 1251 RIVERVIEW ELEMENTARY SCHOOL   Regular School No Elementary 03 4.0 2019   grade_4 163 1 25   0 0     0   0   91 98             99         189 163 1 25   0 0     0   0   91 98         99       189
1307415 ID     school 1600960 201   PRESTON JOINT DISTRICT 160096000181 497 OAKWOOD ELEMENTARY SCHOOL   Regular School No Elementary 03 5.0 2019   grade_4 155 2 23   2 0     0   0   92 90             106         182 155 2 23   2 0     0   0   92 90         106       182
1307714 ID     school 1601570 251   JEFFERSON COUNTY JOINT DISTRICT 160157001064 1359 PHILO T FARNSWORTH ELEMENTARY SCHOOL   Regular School No Elementary 03 5.0 2019   grade_4 237 0 20   0 0     0   0   131 126             83         257 237 0 20   0 0     0   0   131 126         83       257
1308066 ID     school 1602220 281   MOSCOW DISTRICT 160222000391 753 J RUSSELL ELEMENTARY SCHOOL   Regular School No Elementary 03 5.0 2019   grade_4 53 0 4   0 1     0   7   24 41             25         65 53 0 4   0 1     0   7   24 41         25       65
1682226 ID     school 1601770 3   KUNA JOINT DISTRICT 160177000915 635 ROSS ELEMENTARY SCHOOL   Regular School No 1.0 03 06 2015   grade_4 56 0 8   0 0     0   1   33 32             38         65 56 0 8   0 0     0   1   33 32         38       65
1682665 ID     school 1602910 60   SHELLEY JOINT DISTRICT 160291001012 1251 RIVERVIEW ELEMENTARY SCHOOL   Regular School No 1.0 03 04 2015   grade_4 140 1 30   2 1     1   1   85 91             92         176 140 1 30   2 1     1   1   85 91         92       176
1683944 ID     school 1600960 201   PRESTON JOINT DISTRICT 160096000181 497 OAKWOOD ELEMENTARY SCHOOL   Regular School No 1.0 03 05 2015   grade_4 170 0 16   3 1     0   2   97 95             92         192 170 0 16   3 1     0   2   97 95         92       192
1684249 ID     school 1601570 251   JEFFERSON COUNTY JOINT DISTRICT 160157001064 1359 PHILO T FARNSWORTH ELEMENTARY SCHOOL   Regular School No 1.0 03 05 2015   grade_4 168 0 23   0 0     0   5   87 109             82         196 168 0 23   0 0     0   5   87 109         82       196
1684592 ID     school 1602220 281   MOSCOW DISTRICT 160222000391 753 J RUSSELL ELEMENTARY SCHOOL   Regular School No 1.0 03 05 2015   grade_4 39 3 5   0 4     0   2   24 29             32         53 39 3 5   0 4     0   2   24 29         32       53
1726264 ID     school 1601770 3   KUNA JOINT DISTRICT 160177000915 635 ROSS ELEMENTARY SCHOOL   Regular School No Elementary 03 6.0 2017   grade_4 70 0 5   0 0     0   4   40 39             45         79 70 0 5   0 0     0   4   40 39         45       79
1726703 ID     school 1602910 60   SHELLEY JOINT DISTRICT 160291001012 1251 RIVERVIEW ELEMENTARY SCHOOL   Regular School No Elementary 03 4.0 2017   grade_4 146 0 31   2 2     0   0   92 89             96         181 146 0 31   2 2     0   0   92 89         96       181
1728005 ID     school 1600960 201   PRESTON JOINT DISTRICT 160096000181 497 OAKWOOD ELEMENTARY SCHOOL   Regular School No Elementary 03 5.0 2017   grade_4 137 1 22   4 1     0   1   91 75             90         166 137 1 22   4 1     0   1   91 75         90       166
1728309 ID     school 1601570 251   JEFFERSON COUNTY JOINT DISTRICT 160157001064 1359 PHILO T FARNSWORTH ELEMENTARY SCHOOL   Regular School No Elementary 03 5.0 2017   grade_4 197 0 15   1 0     0   3   123 93             76         216 197 0 15   1 0     0   3   123 93         76       216
1728657 ID     school 1602220 281   MOSCOW DISTRICT 160222000391 753 J RUSSELL ELEMENTARY SCHOOL   Regular School No Elementary 03 5.0 2017   grade_4 42 6 3   0 6     0   5   29 33             35         62 42 6 3   0 6     0   5   29 33         35       62
1821262 ID     school 1601770 3   KUNA JOINT DISTRICT 160177000915 635 ROSS ELEMENTARY SCHOOL   Regular School No 1.0 03 06 2016   grade_4 53 0 6   1 2     0   1   37 26             32         63 53 0 6   1 2     0   1   37 26         32       63
1821702 ID     school 1602910 60   SHELLEY JOINT DISTRICT 160291001012 1251 RIVERVIEW ELEMENTARY SCHOOL   Regular School No 1.0 03 04 2016   grade_4 138 1 19   0 1     0   1   85 75             *         160 138 1 19   0 1     0   1   85 75                 160
1822994 ID     school 1600960 201   PRESTON JOINT DISTRICT 160096000181 497 OAKWOOD ELEMENTARY SCHOOL   Regular School No 1.0 03 05 2016   grade_4 179 1 17   2 1     0   1   99 102             97         201 179 1 17   2 1     0   1   99 102         97       201
1823302 ID     school 1601570 251   JEFFERSON COUNTY JOINT DISTRICT 160157001064 1359 PHILO T FARNSWORTH ELEMENTARY SCHOOL   Regular School No 1.0 03 05 2016   grade_4 175 2 17   1 0     0   3   107 91             89         198 175 2 17   1 0     0   3   107 91         89       198
1823641 ID     school 1602220 281   MOSCOW DISTRICT 160222000391 753 J RUSSELL ELEMENTARY SCHOOL   Regular School No 1.0 03 05 2016   grade_4 52 1 2   1 9     2   2   35 34             27         69 52 1 2   1 9     2   2   35 34         27       69
703482 ID     school 1601770 3   KUNA JOINT DISTRICT 160177000915 635 ROSS ELEMENTARY SCHOOL   Regular School No Elementary 04 05 2021   grade_4 109 0 12   0 1     0   2   60 64             36         124 109 0 12   0 1     0   2   60 64         36       124
703820 ID     school 1602970 52   SNAKE RIVER DISTRICT 160297000519 378 ROCKFORD ELEMENTARY SCHOOL   Regular School No Elementary 04 04 2021   grade_4 99 0 22   1 0     0   0   69 53             *         122 99 0 22   1 0     0   0   69 53                 122
706108 ID     school 1600010 288   WHITEPINE JOINT SCHOOL DISTRICT 160001000579 794 DEARY SCHOOL   Regular School No Other 04 12 2021   grade_4 12 0 0   0 0     0   0   9 3             *         12 12 0 0   0 0     0   0   9 3                 12
706172 ID     school 1601620 304   KAMIAH JOINT DISTRICT 160162000458 232 KAMIAH MIDDLE SCHOOL   Regular School No Middle 04 08 2021   grade_4 20 0 2   8 0     0   1   16 15             10         31 20 0 2   8 0     0   1   16 15         10       31
706254 ID     school 1601920 321   MADISON DISTRICT 160192000210 250 MADISON MIDDLE SCHOOL   Regular School No Middle 04 06 2021   grade_4 21 0 0   0 0     0   0   12 9             9         21 21 0 0   0 0     0   0   12 9         9       21
706306 ID     school 1603090 322   SUGAR-SALEM JOINT DISTRICT 160309000645 225 KERSHAW INTERMEDIATE SCHOOL   Regular School No Middle 04 06 2021   grade_4 80 0 4   0 0     0   3   42 45             32         87 80 0 4   0 0     0   3   42 45         32       87
706599 ID     school 1602580 371   PAYETTE JOINT DISTRICT 160258000456 805 WESTSIDE ELEMENTARY SCHOOL   Regular School No Elementary 04 05 2021   grade_4 58 0 38   0 1     1   2   50 50             45         100 58 0 38   0 1     1   2   50 50         45       100
706781 ID     school 1603180 401   TETON COUNTY DISTRICT 160318001022 1236 RENDEZVOUS UPPER ELEMENTARY SCHOOL   Regular School No Elementary 04 05 2021   grade_4 73 0 36   0 0     1   2   52 60             36         112 73 0 36   0 0     1   2   52 60         36       112
706934 ID     school 1601050 413   FILER DISTRICT 160105001006 1244 FILER INTERMEDIATE SCHOOL   Regular School No Middle 04 06 2021   grade_4 87 0 15   0 0     0   0   48 54             *         102 87 0 15   0 0     0   0   48 54                 102
707065 ID     school 1603330 431   WEISER DISTRICT 160333000566 840 PARK INTERMEDIATE SCHOOL   Regular School No Elementary 04 05 2021   grade_4 73 0 30   1 0     0   2   58 48             *         106 73 0 30   1 0     0   2   58 48                 106
707661 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_4 12 0 0   0 0     0   0   6 6             *         12 12 0 0   0 0     0   0   6 6                 12
849254 ID     school 1601770 3   KUNA JOINT DISTRICT 160177000915 635 ROSS ELEMENTARY SCHOOL   Regular School No Elementary 04 05 2020   grade_4 96 1 10   0 1     0   3   71 40             53         111 96 1 10   0 1     0   3   71 40         53       111
849578 ID     school 1602970 52   SNAKE RIVER DISTRICT 160297000519 378 ROCKFORD ELEMENTARY SCHOOL   Regular School No Elementary 04 04 2020   grade_4 118 1 16   2 0     0   2   69 70             49         139 118 1 16   2 0     0   2   69 70         49       139

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