Data source: Big Local News · About: Big Local

33,441 rows where state = "ID" sorted by school

View and edit SQL

grade

year

Link rowid state county county_state_id admin_level district_nces_id district_state_id district_state_type district school_nces_id school_state_id school ▼ school_state_type ccd_school_type ccd_charter_school ccd_school_lvl ccd_school_low_grade ccd_school_high_grade year term grade white black hispanic native_american native_american_alaskan_native asian native_hawaiian asian_pacific_islander native_hawaiian_pacific_islander pacific_islander multiracial unknown_race male female non_binary unknown_gender ell ell_percent homeless homeless_percent low_income free_and_reduced free_and_reduced_percent disability section_504 total white_int black_int hispanic_int native_american_int native_american_alaskan_native_int asian_int native_hawaiian_int asian_pacific_islander_int native_hawaiian_pacific_islander_int pacific_islander_int multiracial_int unknown_race_int male_int female_int non_binary_int unknown_gender_int ell_int homeless_int low_income_int free_and_reduced_int disability_int section_504_int total_int
1821969 ID     school 1601530 91   IDAHO FALLS DISTRICT 160153000252 415 A H BUSH ELEMENTARY SCHOOL   Regular School No 1.0 PK 06 2016   grade_4 40 1 23   0 2     0   1   35 32             52         67 40 1 23   0 2     0   1   35 32         52       67
1821970 ID     school 1601530 91   IDAHO FALLS DISTRICT 160153000252 415 A H BUSH ELEMENTARY SCHOOL   Regular School No 1.0 PK 06 2016   grade_5 47 1 23   0 0     0   1   28 44             58         72 47 1 23   0 0     0   1   28 44         58       72
1821971 ID     school 1601530 91   IDAHO FALLS DISTRICT 160153000252 415 A H BUSH ELEMENTARY SCHOOL   Regular School No 1.0 PK 06 2016   grade_6 46 1 12   1 0     0   2   30 32             41         62 46 1 12   1 0     0   2   30 32         41       62
1821972 ID     school 1601530 91   IDAHO FALLS DISTRICT 160153000252 415 A H BUSH ELEMENTARY SCHOOL   Regular School No 1.0 PK 06 2016   k_12_total 300 7 151   2 4     0   13   244 233             375         477 300 7 151   2 4     0   13   244 233         375       477
1821973 ID     school 1601530 91   IDAHO FALLS DISTRICT 160153000252 415 A H BUSH ELEMENTARY SCHOOL   Regular School No 1.0 PK 06 2016   kindergarten 40 2 24   0 1     0   1   42 26             52         68 40 2 24   0 1     0   1   42 26         52       68
703726 ID     school 1600240 33   BEAR LAKE COUNTY DISTRICT 160024000016 370 A J WINTERS ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2021   grade_1 35 0 0   0 0     0   0   14 21             14         35 35 0 0   0 0     0   0   14 21         14       35
703727 ID     school 1600240 33   BEAR LAKE COUNTY DISTRICT 160024000016 370 A J WINTERS ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2021   grade_2 43 0 0   1 0     1   0   23 22             10         45 43 0 0   1 0     1   0   23 22         10       45
703728 ID     school 1600240 33   BEAR LAKE COUNTY DISTRICT 160024000016 370 A J WINTERS ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2021   grade_3 45 0 1   0 0     0   0   27 19             19         46 45 0 1   0 0     0   0   27 19         19       46
703729 ID     school 1600240 33   BEAR LAKE COUNTY DISTRICT 160024000016 370 A J WINTERS ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2021   grade_4 46 0 1   0 0     1   0   24 24             11         48 46 0 1   0 0     1   0   24 24         11       48
703730 ID     school 1600240 33   BEAR LAKE COUNTY DISTRICT 160024000016 370 A J WINTERS ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2021   grade_5 51 0 0   1 0     0   0   21 31             20         52 51 0 0   1 0     0   0   21 31         20       52
703731 ID     school 1600240 33   BEAR LAKE COUNTY DISTRICT 160024000016 370 A J WINTERS ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2021   k_12_total 269 0 3   2 0     2   0   132 144             90         276 269 0 3   2 0     2   0   132 144         90       276
703732 ID     school 1600240 33   BEAR LAKE COUNTY DISTRICT 160024000016 370 A J WINTERS ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2021   kindergarten 49 0 1   0 0     0   0   23 27             16         50 49 0 1   0 0     0   0   23 27         16       50
849495 ID     school 1600240 33   BEAR LAKE COUNTY DISTRICT 160024000016 370 A J WINTERS ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2020   grade_1 48 0 2   1 0     1   0   25 27             20         52 48 0 2   1 0     1   0   25 27         20       52
849496 ID     school 1600240 33   BEAR LAKE COUNTY DISTRICT 160024000016 370 A J WINTERS ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2020   grade_2 46 0 2   2 0     0   0   30 20             30         50 46 0 2   2 0     0   0   30 20         30       50
849497 ID     school 1600240 33   BEAR LAKE COUNTY DISTRICT 160024000016 370 A J WINTERS ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2020   grade_3 50 0 2   0 0     1   0   28 25             21         53 50 0 2   0 0     1   0   28 25         21       53
849498 ID     school 1600240 33   BEAR LAKE COUNTY DISTRICT 160024000016 370 A J WINTERS ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2020   grade_4 54 0 2   2 0     0   0   25 33             31         58 54 0 2   2 0     0   0   25 33         31       58
849499 ID     school 1600240 33   BEAR LAKE COUNTY DISTRICT 160024000016 370 A J WINTERS ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2020   grade_5 43 0 2   1 0     0   0   25 21             23         46 43 0 2   1 0     0   0   25 21         23       46
849500 ID     school 1600240 33   BEAR LAKE COUNTY DISTRICT 160024000016 370 A J WINTERS ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2020   k_12_total 278 1 11   6 0     2   0   151 147             138         298 278 1 11   6 0     2   0   151 147         138       298
849501 ID     school 1600240 33   BEAR LAKE COUNTY DISTRICT 160024000016 370 A J WINTERS ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2020   kindergarten 37 1 1   0 0     0   0   18 21             13         39 37 1 1   0 0     0   0   18 21         13       39
1277042 ID     school 1600240 33   BEAR LAKE COUNTY DISTRICT 160024000016 370 A J WINTERS ELEMENTARY SCHOOL   Regular School No Elementary PK 5.0 2018   grade_1 51 0 2   0 0     1   0   27 27             22         54 51 0 2   0 0     1   0   27 27         22       54
1277043 ID     school 1600240 33   BEAR LAKE COUNTY DISTRICT 160024000016 370 A J WINTERS ELEMENTARY SCHOOL   Regular School No Elementary PK 5.0 2018   grade_2 54 0 1   2 0     0   0   23 34             33         57 54 0 1   2 0     0   0   23 34         33       57
1277044 ID     school 1600240 33   BEAR LAKE COUNTY DISTRICT 160024000016 370 A J WINTERS ELEMENTARY SCHOOL   Regular School No Elementary PK 5.0 2018   grade_3 48 0 0   1 0     0   0   27 22             30         49 48 0 0   1 0     0   0   27 22         30       49
1277045 ID     school 1600240 33   BEAR LAKE COUNTY DISTRICT 160024000016 370 A J WINTERS ELEMENTARY SCHOOL   Regular School No Elementary PK 5.0 2018   grade_4 54 0 3   0 0     0   0   22 35             24         57 54 0 3   0 0     0   0   22 35         24       57
1277046 ID     school 1600240 33   BEAR LAKE COUNTY DISTRICT 160024000016 370 A J WINTERS ELEMENTARY SCHOOL   Regular School No Elementary PK 5.0 2018   grade_5 55 0 3   0 0     0   0   26 32             28         58 55 0 3   0 0     0   0   26 32         28       58
1277047 ID     school 1600240 33   BEAR LAKE COUNTY DISTRICT 160024000016 370 A J WINTERS ELEMENTARY SCHOOL   Regular School No Elementary PK 5.0 2018   k_12_total 308 0 9   5 0     1   0   151 172             162         323 308 0 9   5 0     1   0   151 172         162       323
1277048 ID     school 1600240 33   BEAR LAKE COUNTY DISTRICT 160024000016 370 A J WINTERS ELEMENTARY SCHOOL   Regular School No Elementary PK 5.0 2018   kindergarten 46 0 0   2 0     0   0   26 22             25         48 46 0 0   2 0     0   0   26 22         25       48
1305903 ID     school 1600240 33   BEAR LAKE COUNTY DISTRICT 160024000016 370 A J WINTERS ELEMENTARY SCHOOL   Regular School No Elementary PK 5.0 2019   grade_1 44 0 1   2 0     0   0   28 19             33         47 44 0 1   2 0     0   0   28 19         33       47
1305904 ID     school 1600240 33   BEAR LAKE COUNTY DISTRICT 160024000016 370 A J WINTERS ELEMENTARY SCHOOL   Regular School No Elementary PK 5.0 2019   grade_2 50 0 2   0 0     1   0   26 27             22         53 50 0 2   0 0     1   0   26 27         22       53
1305905 ID     school 1600240 33   BEAR LAKE COUNTY DISTRICT 160024000016 370 A J WINTERS ELEMENTARY SCHOOL   Regular School No Elementary PK 5.0 2019   grade_3 52 0 2   2 0     0   0   20 36             34         56 52 0 2   2 0     0   0   20 36         34       56
1305906 ID     school 1600240 33   BEAR LAKE COUNTY DISTRICT 160024000016 370 A J WINTERS ELEMENTARY SCHOOL   Regular School No Elementary PK 5.0 2019   grade_4 45 0 0   1 0     0   0   25 21             24         46 45 0 0   1 0     0   0   25 21         24       46
1305907 ID     school 1600240 33   BEAR LAKE COUNTY DISTRICT 160024000016 370 A J WINTERS ELEMENTARY SCHOOL   Regular School No Elementary PK 5.0 2019   grade_5 54 0 4   0 0     0   0   21 37             24         58 54 0 4   0 0     0   0   21 37         24       58
1305908 ID     school 1600240 33   BEAR LAKE COUNTY DISTRICT 160024000016 370 A J WINTERS ELEMENTARY SCHOOL   Regular School No Elementary PK 5.0 2019   k_12_total 288 0 10   6 0     2   0   144 162             153         306 288 0 10   6 0     2   0   144 162         153       306
1305909 ID     school 1600240 33   BEAR LAKE COUNTY DISTRICT 160024000016 370 A J WINTERS ELEMENTARY SCHOOL   Regular School No Elementary PK 5.0 2019   kindergarten 43 0 1   1 0     1   0   24 22             16         46 43 0 1   1 0     1   0   24 22         16       46
1682468 ID     school 1600240 33   BEAR LAKE COUNTY DISTRICT 160024000016 370 A J WINTERS ELEMENTARY SCHOOL   Regular School No 1.0 PK 05 2015   grade_1 52 0 4   0 0     0   0   22 34             30         56 52 0 4   0 0     0   0   22 34         30       56
1682469 ID     school 1600240 33   BEAR LAKE COUNTY DISTRICT 160024000016 370 A J WINTERS ELEMENTARY SCHOOL   Regular School No 1.0 PK 05 2015   grade_2 53 0 3   0 0     0   0   25 31             26         56 53 0 3   0 0     0   0   25 31         26       56
1682470 ID     school 1600240 33   BEAR LAKE COUNTY DISTRICT 160024000016 370 A J WINTERS ELEMENTARY SCHOOL   Regular School No 1.0 PK 05 2015   grade_3 52 0 3   0 0     0   0   26 29             32         55 52 0 3   0 0     0   0   26 29         32       55
1682471 ID     school 1600240 33   BEAR LAKE COUNTY DISTRICT 160024000016 370 A J WINTERS ELEMENTARY SCHOOL   Regular School No 1.0 PK 05 2015   grade_4 52 0 5   0 0     0   0   26 31             29         57 52 0 5   0 0     0   0   26 31         29       57
1682472 ID     school 1600240 33   BEAR LAKE COUNTY DISTRICT 160024000016 370 A J WINTERS ELEMENTARY SCHOOL   Regular School No 1.0 PK 05 2015   grade_5 51 0 2   0 0     0   0   24 29             35         53 51 0 2   0 0     0   0   24 29         35       53
1682473 ID     school 1600240 33   BEAR LAKE COUNTY DISTRICT 160024000016 370 A J WINTERS ELEMENTARY SCHOOL   Regular School No 1.0 PK 05 2015   k_12_total 307 0 19   0 0     0   1   151 176             177         327 307 0 19   0 0     0   1   151 176         177       327
1682474 ID     school 1600240 33   BEAR LAKE COUNTY DISTRICT 160024000016 370 A J WINTERS ELEMENTARY SCHOOL   Regular School No 1.0 PK 05 2015   kindergarten 47 0 2   0 0     0   1   28 22             25         50 47 0 2   0 0     0   1   28 22         25       50
1726507 ID     school 1600240 33   BEAR LAKE COUNTY DISTRICT 160024000016 370 A J WINTERS ELEMENTARY SCHOOL   Regular School No Elementary PK 5.0 2017   grade_1 57 0 1   2 0     0   0   26 34             35         60 57 0 1   2 0     0   0   26 34         35       60
1726508 ID     school 1600240 33   BEAR LAKE COUNTY DISTRICT 160024000016 370 A J WINTERS ELEMENTARY SCHOOL   Regular School No Elementary PK 5.0 2017   grade_2 45 0 1   1 0     0   0   25 22             30         47 45 0 1   1 0     0   0   25 22         30       47
1726509 ID     school 1600240 33   BEAR LAKE COUNTY DISTRICT 160024000016 370 A J WINTERS ELEMENTARY SCHOOL   Regular School No Elementary PK 5.0 2017   grade_3 58 0 4   0 0     0   0   25 37             32         62 58 0 4   0 0     0   0   25 37         32       62
1726510 ID     school 1600240 33   BEAR LAKE COUNTY DISTRICT 160024000016 370 A J WINTERS ELEMENTARY SCHOOL   Regular School No Elementary PK 5.0 2017   grade_4 55 0 3   0 0     0   0   25 33             31         58 55 0 3   0 0     0   0   25 33         31       58
1726511 ID     school 1600240 33   BEAR LAKE COUNTY DISTRICT 160024000016 370 A J WINTERS ELEMENTARY SCHOOL   Regular School No Elementary PK 5.0 2017   grade_5 62 0 2   0 0     1   0   32 33             37         65 62 0 2   0 0     1   0   32 33         37       65
1726512 ID     school 1600240 33   BEAR LAKE COUNTY DISTRICT 160024000016 370 A J WINTERS ELEMENTARY SCHOOL   Regular School No Elementary PK 5.0 2017   k_12_total 328 0 14   3 0     2   0   164 183             187         347 328 0 14   3 0     2   0   164 183         187       347
1726513 ID     school 1600240 33   BEAR LAKE COUNTY DISTRICT 160024000016 370 A J WINTERS ELEMENTARY SCHOOL   Regular School No Elementary PK 5.0 2017   kindergarten 51 0 3   0 0     1   0   31 24             22         55 51 0 3   0 0     1   0   31 24         22       55
1821503 ID     school 1600240 33   BEAR LAKE COUNTY DISTRICT 160024000016 370 A J WINTERS ELEMENTARY SCHOOL   Regular School No 1.0 PK 05 2016   grade_1 46 0 1   1 0     0   0   27 21             35         48 46 0 1   1 0     0   0   27 21         35       48
1821504 ID     school 1600240 33   BEAR LAKE COUNTY DISTRICT 160024000016 370 A J WINTERS ELEMENTARY SCHOOL   Regular School No 1.0 PK 05 2016   grade_2 57 0 4   0 0     0   0   25 36             32         61 57 0 4   0 0     0   0   25 36         32       61
1821505 ID     school 1600240 33   BEAR LAKE COUNTY DISTRICT 160024000016 370 A J WINTERS ELEMENTARY SCHOOL   Regular School No 1.0 PK 05 2016   grade_3 52 0 4   0 0     0   0   25 31             30         56 52 0 4   0 0     0   0   25 31         30       56
1821506 ID     school 1600240 33   BEAR LAKE COUNTY DISTRICT 160024000016 370 A J WINTERS ELEMENTARY SCHOOL   Regular School No 1.0 PK 05 2016   grade_4 53 0 2   0 0     0   0   29 26             29         55 53 0 2   0 0     0   0   29 26         29       55
1821507 ID     school 1600240 33   BEAR LAKE COUNTY DISTRICT 160024000016 370 A J WINTERS ELEMENTARY SCHOOL   Regular School No 1.0 PK 05 2016   grade_5 53 0 3   0 0     0   0   26 30             31         56 53 0 3   0 0     0   0   26 30         31       56
1821508 ID     school 1600240 33   BEAR LAKE COUNTY DISTRICT 160024000016 370 A J WINTERS ELEMENTARY SCHOOL   Regular School No 1.0 PK 05 2016   k_12_total 314 0 15   3 0     0   0   157 175             192         332 314 0 15   3 0     0   0   157 175         192       332
1821509 ID     school 1600240 33   BEAR LAKE COUNTY DISTRICT 160024000016 370 A J WINTERS ELEMENTARY SCHOOL   Regular School No 1.0 PK 05 2016   kindergarten 53 0 1   2 0     0   0   25 31             35         56 53 0 1   2 0     0   0   25 31         35       56
703931 ID     school 1601080 59   FIRTH DISTRICT 160108000196 390 A W JOHNSON ELEMENTARY SCHOOL   Regular School No Elementary PK 04 2021   grade_1 41 1 5   1 0     0   0   25 23             24         48 41 1 5   1 0     0   0   25 23         24       48
703932 ID     school 1601080 59   FIRTH DISTRICT 160108000196 390 A W JOHNSON ELEMENTARY SCHOOL   Regular School No Elementary PK 04 2021   grade_2 60 0 6   0 0     0   0   37 29             31         66 60 0 6   0 0     0   0   37 29         31       66
703933 ID     school 1601080 59   FIRTH DISTRICT 160108000196 390 A W JOHNSON ELEMENTARY SCHOOL   Regular School No Elementary PK 04 2021   grade_3 49 1 5   1 1     0   0   26 31             25         57 49 1 5   1 1     0   0   26 31         25       57
703934 ID     school 1601080 59   FIRTH DISTRICT 160108000196 390 A W JOHNSON ELEMENTARY SCHOOL   Regular School No Elementary PK 04 2021   grade_4 46 0 4   0 0     0   1   26 25             28         51 46 0 4   0 0     0   1   26 25         28       51
703935 ID     school 1601080 59   FIRTH DISTRICT 160108000196 390 A W JOHNSON ELEMENTARY SCHOOL   Regular School No Elementary PK 04 2021   k_12_total 248 2 24   2 1     0   1   143 135             121         278 248 2 24   2 1     0   1   143 135         121       278
703936 ID     school 1601080 59   FIRTH DISTRICT 160108000196 390 A W JOHNSON ELEMENTARY SCHOOL   Regular School No Elementary PK 04 2021   kindergarten 52 0 4   0 0     0   0   29 27             13         56 52 0 4   0 0     0   0   29 27         13       56
849668 ID     school 1601080 59   FIRTH DISTRICT 160108000196 390 A W JOHNSON ELEMENTARY SCHOOL   Regular School No Elementary PK 04 2020   grade_1 65 0 4   1 0     0   0   41 29             28         70 65 0 4   1 0     0   0   41 29         28       70
849669 ID     school 1601080 59   FIRTH DISTRICT 160108000196 390 A W JOHNSON ELEMENTARY SCHOOL   Regular School No Elementary PK 04 2020   grade_2 51 0 6   1 1     0   0   28 31             27         59 51 0 6   1 1     0   0   28 31         27       59
849670 ID     school 1601080 59   FIRTH DISTRICT 160108000196 390 A W JOHNSON ELEMENTARY SCHOOL   Regular School No Elementary PK 04 2020   grade_3 50 0 5   0 0     0   1   27 29             29         56 50 0 5   0 0     0   1   27 29         29       56
849671 ID     school 1601080 59   FIRTH DISTRICT 160108000196 390 A W JOHNSON ELEMENTARY SCHOOL   Regular School No Elementary PK 04 2020   grade_4 73 0 7   0 1     0   0   43 38             29         81 73 0 7   0 1     0   0   43 38         29       81
849672 ID     school 1601080 59   FIRTH DISTRICT 160108000196 390 A W JOHNSON ELEMENTARY SCHOOL   Regular School No Elementary PK 04 2020   k_12_total 274 1 27   2 2     0   1   160 147             123         307 274 1 27   2 2     0   1   160 147         123       307
849673 ID     school 1601080 59   FIRTH DISTRICT 160108000196 390 A W JOHNSON ELEMENTARY SCHOOL   Regular School No Elementary PK 04 2020   kindergarten 35 1 5   0 0     0   0   21 20             10         41 35 1 5   0 0     0   0   21 20         10       41
1277216 ID     school 1601080 59   FIRTH DISTRICT 160108000196 390 A W JOHNSON ELEMENTARY SCHOOL   Regular School No Elementary PK 4.0 2018   grade_1 47 1 5   0 0     0   1   29 25             30         54 47 1 5   0 0     0   1   29 25         30       54
1277217 ID     school 1601080 59   FIRTH DISTRICT 160108000196 390 A W JOHNSON ELEMENTARY SCHOOL   Regular School No Elementary PK 4.0 2018   grade_2 67 1 7   0 0     0   0   39 36             32         75 67 1 7   0 0     0   0   39 36         32       75
1277218 ID     school 1601080 59   FIRTH DISTRICT 160108000196 390 A W JOHNSON ELEMENTARY SCHOOL   Regular School No Elementary PK 4.0 2018   grade_3 48 1 7   1 0     0   0   28 29             26         57 48 1 7   1 0     0   0   28 29         26       57
1277219 ID     school 1601080 59   FIRTH DISTRICT 160108000196 390 A W JOHNSON ELEMENTARY SCHOOL   Regular School No Elementary PK 4.0 2018   grade_4 46 2 10   0 0     0   0   35 23             34         58 46 2 10   0 0     0   0   35 23         34       58
1277220 ID     school 1601080 59   FIRTH DISTRICT 160108000196 390 A W JOHNSON ELEMENTARY SCHOOL   Regular School No Elementary PK 4.0 2018   k_12_total 256 5 32   2 0     0   2   156 141             139         297 256 5 32   2 0     0   2   156 141         139       297
1277221 ID     school 1601080 59   FIRTH DISTRICT 160108000196 390 A W JOHNSON ELEMENTARY SCHOOL   Regular School No Elementary PK 4.0 2018   kindergarten 48 0 3   1 0     0   1   25 28             17         53 48 0 3   1 0     0   1   25 28         17       53
1306076 ID     school 1601080 59   FIRTH DISTRICT 160108000196 390 A W JOHNSON ELEMENTARY SCHOOL   Regular School No Elementary PK 4.0 2019   grade_1 50 1 5   2 1     0   1   27 33             27         60 50 1 5   2 1     0   1   27 33         27       60
1306077 ID     school 1601080 59   FIRTH DISTRICT 160108000196 390 A W JOHNSON ELEMENTARY SCHOOL   Regular School No Elementary PK 4.0 2019   grade_2 50 0 5   0 0     0   0   27 28             27         55 50 0 5   0 0     0   0   27 28         27       55
1306078 ID     school 1601080 59   FIRTH DISTRICT 160108000196 390 A W JOHNSON ELEMENTARY SCHOOL   Regular School No Elementary PK 4.0 2019   grade_3 72 1 7   0 1     0   0   43 38             30         81 72 1 7   0 1     0   0   43 38         30       81
1306079 ID     school 1601080 59   FIRTH DISTRICT 160108000196 390 A W JOHNSON ELEMENTARY SCHOOL   Regular School No Elementary PK 4.0 2019   grade_4 52 1 8   1 1     0   0   25 38             25         63 52 1 8   1 1     0   0   25 38         25       63
1306080 ID     school 1601080 59   FIRTH DISTRICT 160108000196 390 A W JOHNSON ELEMENTARY SCHOOL   Regular School No Elementary PK 4.0 2019   k_12_total 284 3 29   3 3     0   1   159 164             123         323 284 3 29   3 3     0   1   159 164         123       323
1306081 ID     school 1601080 59   FIRTH DISTRICT 160108000196 390 A W JOHNSON ELEMENTARY SCHOOL   Regular School No Elementary PK 4.0 2019   kindergarten 60 0 4   0 0     0   0   37 27             14         64 60 0 4   0 0     0   0   37 27         14       64
1682643 ID     school 1601080 59   FIRTH DISTRICT 160108000196 390 A W JOHNSON ELEMENTARY SCHOOL   Regular School No 1.0 PK 04 2015   grade_1 45 1 8   0 0     0   1   28 27             *         55 45 1 8   0 0     0   1   28 27                 55
1682644 ID     school 1601080 59   FIRTH DISTRICT 160108000196 390 A W JOHNSON ELEMENTARY SCHOOL   Regular School No 1.0 PK 04 2015   grade_2 54 0 8   1 0     0   0   35 28             34         63 54 0 8   1 0     0   0   35 28         34       63
1682645 ID     school 1601080 59   FIRTH DISTRICT 160108000196 390 A W JOHNSON ELEMENTARY SCHOOL   Regular School No 1.0 PK 04 2015   grade_3 49 0 10   1 0     0   0   33 27             33         60 49 0 10   1 0     0   0   33 27         33       60
1682646 ID     school 1601080 59   FIRTH DISTRICT 160108000196 390 A W JOHNSON ELEMENTARY SCHOOL   Regular School No 1.0 PK 04 2015   grade_4 55 1 16   1 0     0   0   41 32             39         73 55 1 16   1 0     0   0   41 32         39       73
1682647 ID     school 1601080 59   FIRTH DISTRICT 160108000196 390 A W JOHNSON ELEMENTARY SCHOOL   Regular School No 1.0 PK 04 2015   k_12_total 253 3 47   3 0     0   2   164 144             120         308 253 3 47   3 0     0   2   164 144         120       308
1682648 ID     school 1601080 59   FIRTH DISTRICT 160108000196 390 A W JOHNSON ELEMENTARY SCHOOL   Regular School No 1.0 PK 04 2015   kindergarten 50 1 5   0 0     0   1   27 30             *         57 50 1 5   0 0     0   1   27 30                 57
1726681 ID     school 1601080 59   FIRTH DISTRICT 160108000196 390 A W JOHNSON ELEMENTARY SCHOOL   Regular School No Elementary PK 4.0 2017   grade_1 68 0 7   0 0     0   0   41 34             32         75 68 0 7   0 0     0   0   41 34         32       75
1726682 ID     school 1601080 59   FIRTH DISTRICT 160108000196 390 A W JOHNSON ELEMENTARY SCHOOL   Regular School No Elementary PK 4.0 2017   grade_2 47 1 7   1 0     0   0   26 30             29         56 47 1 7   1 0     0   0   26 30         29       56
1726683 ID     school 1601080 59   FIRTH DISTRICT 160108000196 390 A W JOHNSON ELEMENTARY SCHOOL   Regular School No Elementary PK 4.0 2017   grade_3 40 2 10   0 0     0   0   29 23             23         52 40 2 10   0 0     0   0   29 23         23       52
1726684 ID     school 1601080 59   FIRTH DISTRICT 160108000196 390 A W JOHNSON ELEMENTARY SCHOOL   Regular School No Elementary PK 4.0 2017   grade_4 52 0 10   2 0     0   0   35 29             38         64 52 0 10   2 0     0   0   35 29         38       64
1726685 ID     school 1601080 59   FIRTH DISTRICT 160108000196 390 A W JOHNSON ELEMENTARY SCHOOL   Regular School No Elementary PK 4.0 2017   k_12_total 251 3 39   3 0     0   0   158 138             140         296 251 3 39   3 0     0   0   158 138         140       296
1726686 ID     school 1601080 59   FIRTH DISTRICT 160108000196 390 A W JOHNSON ELEMENTARY SCHOOL   Regular School No Elementary PK 4.0 2017   kindergarten 44 0 5   0 0     0   0   27 22             18         49 44 0 5   0 0     0   0   27 22         18       49
1821679 ID     school 1601080 59   FIRTH DISTRICT 160108000196 390 A W JOHNSON ELEMENTARY SCHOOL   Regular School No 1.0 PK 04 2016   grade_1 48 1 6   1 0     0   0   24 32             *         56 48 1 6   1 0     0   0   24 32                 56
1821680 ID     school 1601080 59   FIRTH DISTRICT 160108000196 390 A W JOHNSON ELEMENTARY SCHOOL   Regular School No 1.0 PK 04 2016   grade_2 37 1 7   0 0     0   0   25 20             *         45 37 1 7   0 0     0   0   25 20                 45
1821681 ID     school 1601080 59   FIRTH DISTRICT 160108000196 390 A W JOHNSON ELEMENTARY SCHOOL   Regular School No 1.0 PK 04 2016   grade_3 52 0 10   2 0     0   0   38 26             27         64 52 0 10   2 0     0   0   38 26         27       64
1821682 ID     school 1601080 59   FIRTH DISTRICT 160108000196 390 A W JOHNSON ELEMENTARY SCHOOL   Regular School No 1.0 PK 04 2016   grade_4 44 0 12   0 0     0   0   29 27             29         56 44 0 12   0 0     0   0   29 27         29       56
1821683 ID     school 1601080 59   FIRTH DISTRICT 160108000196 390 A W JOHNSON ELEMENTARY SCHOOL   Regular School No 1.0 PK 04 2016   k_12_total 239 2 41   3 0     0   0   151 134             67         285 239 2 41   3 0     0   0   151 134         67       285
1821684 ID     school 1601080 59   FIRTH DISTRICT 160108000196 390 A W JOHNSON ELEMENTARY SCHOOL   Regular School No 1.0 PK 04 2016   kindergarten 58 0 6   0 0     0   0   35 29             *         64 58 0 6   0 0     0   0   35 29                 64
703910 ID     school 1600030 58   ABERDEEN DISTRICT 160003000828 298 ABERDEEN ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2021   grade_1 12 1 33   0 0     0   0   26 20             *         46 12 1 33   0 0     0   0   26 20                 46
703911 ID     school 1600030 58   ABERDEEN DISTRICT 160003000828 298 ABERDEEN ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2021   grade_2 16 1 34   0 0     0   0   23 28             *         51 16 1 34   0 0     0   0   23 28                 51
703912 ID     school 1600030 58   ABERDEEN DISTRICT 160003000828 298 ABERDEEN ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2021   grade_3 16 0 34   0 0     0   0   23 27             *         50 16 0 34   0 0     0   0   23 27                 50
703913 ID     school 1600030 58   ABERDEEN DISTRICT 160003000828 298 ABERDEEN ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2021   grade_4 13 0 32   0 0     0   0   21 24             *         45 13 0 32   0 0     0   0   21 24                 45

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