Data source: Big Local News · About: Big Local

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

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
704729 ID     school 1600510 132   CALDWELL DISTRICT 160051000835 76 LEWIS AND CLARK ELEMENTARY   Regular School No Elementary PK 05 2021   grade_5 30 1 28   0 1     0   3   29 34             31         63 30 1 28   0 1     0   3   29 34         31       63
850440 ID     school 1600510 132   CALDWELL DISTRICT 160051000835 76 LEWIS AND CLARK ELEMENTARY   Regular School No Elementary PK 05 2020   grade_5 32 0 36   0 0     0   0   36 32             30         68 32 0 36   0 0     0   0   36 32         30       68
1277979 ID     school 1600510 132   CALDWELL DISTRICT 160051000835 76 LEWIS AND CLARK ELEMENTARY   Regular School No Elementary PK 5.0 2018   grade_5 32 0 58   2 0     0   1   49 44             *         93 32 0 58   2 0     0   1   49 44                 93
1306837 ID     school 1600510 132   CALDWELL DISTRICT 160051000835 76 LEWIS AND CLARK ELEMENTARY   Regular School No Elementary PK 5.0 2019   grade_5 46 0 41   0 0     1   1   45 44             37         89 46 0 41   0 0     1   1   45 44         37       89
1683405 ID     school 1600510 132   CALDWELL DISTRICT 160051000835 76 LEWIS AND CLARK ELEMENTARY   Regular School No 1.0 PK 05 2015   grade_5 22 0 40   0 0     0   1   34 29             *         63 22 0 40   0 0     0   1   34 29                 63
1727442 ID     school 1600510 132   CALDWELL DISTRICT 160051000835 76 LEWIS AND CLARK ELEMENTARY   Regular School No Elementary PK 5.0 2017   grade_5 31 0 43   0 0     0   2   38 38             *         76 31 0 43   0 0     0   2   38 38                 76
1822448 ID     school 1600510 132   CALDWELL DISTRICT 160051000835 76 LEWIS AND CLARK ELEMENTARY   Regular School No 1.0 PK 05 2016   grade_5 24 2 56   2 0     0   1   54 31             *         85 24 2 56   2 0     0   1   54 31                 85
704991 ID     school 1603000 150   SODA SPRINGS JOINT DISTRICT 160300000527 78 TIGERT MIDDLE SCHOOL   Regular School No Middle 05 08 2021   grade_5 55 0 4   0 1     0   2   41 21             *         62 55 0 4   0 1     0   2   41 21                 62
850704 ID     school 1603000 150   SODA SPRINGS JOINT DISTRICT 160300000527 78 TIGERT MIDDLE SCHOOL   Regular School No Middle 05 08 2020   grade_5 62 0 2   0 0     0   2   31 35             *         66 62 0 2   0 0     0   2   31 35                 66
1278248 ID     school 1603000 150   SODA SPRINGS JOINT DISTRICT 160300000527 78 TIGERT MIDDLE SCHOOL   Regular School No Middle 05 8.0 2018   grade_5 50 0 3   0 0     0   1   23 31             *         54 50 0 3   0 0     0   1   23 31                 54
1307102 ID     school 1603000 150   SODA SPRINGS JOINT DISTRICT 160300000527 78 TIGERT MIDDLE SCHOOL   Regular School No Middle 05 8.0 2019   grade_5 75 0 2   0 1     0   1   38 41             *         79 75 0 2   0 1     0   1   38 41                 79
1683658 ID     school 1603000 150   SODA SPRINGS JOINT DISTRICT 160300000527 78 TIGERT MIDDLE SCHOOL   Regular School No 2.0 05 08 2015   grade_5 56 0 4   0 0     0   0   33 27             21         60 56 0 4   0 0     0   0   33 27         21       60
1727702 ID     school 1603000 150   SODA SPRINGS JOINT DISTRICT 160300000527 78 TIGERT MIDDLE SCHOOL   Regular School No Middle 05 8.0 2017   grade_5 49 0 3   1 0     0   2   20 35             *         55 49 0 3   1 0     0   2   20 35                 55
1822704 ID     school 1603000 150   SODA SPRINGS JOINT DISTRICT 160300000527 78 TIGERT MIDDLE SCHOOL   Regular School No 2.0 05 08 2016   grade_5 73 0 5   1 0     0   3   34 48             30         82 73 0 5   1 0     0   3   34 48         30       82
1684073 ID     school 1601260 231   GOODING JOINT DISTRICT 160126000222 102 GOODING MIDDLE SCHOOL   Regular School No 2.0 05 08 2015   grade_5 69 0 33   2 0     0   0   48 56             *         104 69 0 33   2 0     0   0   48 56                 104
1728133 ID     school 1601260 231   GOODING JOINT DISTRICT 160126000222 102 GOODING MIDDLE SCHOOL   Regular School No Middle 05 8.0 2017   grade_5 63 0 43   1 0     0   2   56 53             68         109 63 0 43   1 0     0   2   56 53         68       109
1823123 ID     school 1601260 231   GOODING JOINT DISTRICT 160126000222 102 GOODING MIDDLE SCHOOL   Regular School No 2.0 05 08 2016   grade_5 66 1 23   0 0     0   3   56 37             *         93 66 1 23   0 0     0   3   56 37                 93
705468 ID     school 1603360 232   WENDELL DISTRICT 160336000571 104 WENDELL MIDDLE SCHOOL   Regular School No Middle 05 08 2021   grade_5 24 0 57   0 0     0   1   49 33             61         82 24 0 57   0 0     0   1   49 33         61       82
851160 ID     school 1603360 232   WENDELL DISTRICT 160336000571 104 WENDELL MIDDLE SCHOOL   Regular School No Middle 05 08 2020   grade_5 39 0 64   1 0     0   0   59 45             77         104 39 0 64   1 0     0   0   59 45         77       104
1278686 ID     school 1603360 232   WENDELL DISTRICT 160336000571 104 WENDELL MIDDLE SCHOOL   Regular School No Middle 05 8.0 2018   grade_5 23 0 43   0 0     1   0   37 30             *         67 23 0 43   0 0     1   0   37 30                 67
1307558 ID     school 1603360 232   WENDELL DISTRICT 160336000571 104 WENDELL MIDDLE SCHOOL   Regular School No Middle 05 8.0 2019   grade_5 34 0 57   0 0     0   0   52 39             67         91 34 0 57   0 0     0   0   52 39         67       91
1684089 ID     school 1603360 232   WENDELL DISTRICT 160336000571 104 WENDELL MIDDLE SCHOOL   Regular School No 2.0 05 08 2015   grade_5 37 0 48   0 0     0   0   51 34             64         85 37 0 48   0 0     0   0   51 34         64       85
1728149 ID     school 1603360 232   WENDELL DISTRICT 160336000571 104 WENDELL MIDDLE SCHOOL   Regular School No Middle 05 8.0 2017   grade_5 38 0 60   2 0     0   1   62 39             *         101 38 0 60   2 0     0   1   62 39                 101
1823139 ID     school 1603360 232   WENDELL DISTRICT 160336000571 104 WENDELL MIDDLE SCHOOL   Regular School No 2.0 05 08 2016   grade_5 30 0 58   0 1     0   0   41 48             20         89 30 0 58   0 1     0   0   41 48         20       89
705739 ID     school 1603270 262   VALLEY DISTRICT 160327000558 119 VALLEY SCHOOL   Regular School No Other PK 12 2021   grade_5 20 0 20   0 0     0   0   15 25             23         40 20 0 20   0 0     0   0   15 25         23       40
851399 ID     school 1603270 262   VALLEY DISTRICT 160327000558 119 VALLEY SCHOOL   Regular School No Other PK 12 2020   grade_5 18 1 27   0 1     0   0   23 24             30         47 18 1 27   0 1     0   0   23 24         30       47
1278925 ID     school 1603270 262   VALLEY DISTRICT 160327000558 119 VALLEY SCHOOL   Regular School No Other PK 12.0 2018   grade_5 27 0 28   0 0     0   1   25 31             38         56 27 0 28   0 0     0   1   25 31         38       56
1307795 ID     school 1603270 262   VALLEY DISTRICT 160327000558 119 VALLEY SCHOOL   Regular School No Other PK 12.0 2019   grade_5 25 0 25   0 0     0   0   35 15             33         50 25 0 25   0 0     0   0   35 15         33       50
1684330 ID     school 1603270 262   VALLEY DISTRICT 160327000558 119 VALLEY SCHOOL   Regular School No 4.0 PK 12 2015   grade_5 31 0 16   0 0     0   1   21 27             32         48 31 0 16   0 0     0   1   21 27         32       48
1728391 ID     school 1603270 262   VALLEY DISTRICT 160327000558 119 VALLEY SCHOOL   Regular School No Other PK 12.0 2017   grade_5 28 0 17   0 0     0   0   24 21             30         45 28 0 17   0 0     0   0   24 21         30       45
1823382 ID     school 1603270 262   VALLEY DISTRICT 160327000558 119 VALLEY SCHOOL   Regular School No 4.0 PK 12 2016   grade_5 24 0 29   0 0     0   1   29 25             37         54 24 0 29   0 0     0   1   29 25         37       54
706141 ID     school 1603030 292   SOUTH LEMHI DISTRICT 160303000528 137 LEADORE SCHOOL   Regular School No Other PK 12 2021   grade_5 5 0 0   0 0     0   1   2 4             *         6 5 0 0   0 0     0   1   2 4                 6
851793 ID     school 1603030 292   SOUTH LEMHI DISTRICT 160303000528 137 LEADORE SCHOOL   Regular School No Other PK 12 2020   grade_5 6 0 0   0 0     0   0   3 3             *         6 6 0 0   0 0     0   0   3 3                 6
1279319 ID     school 1603030 292   SOUTH LEMHI DISTRICT 160303000528 137 LEADORE SCHOOL   Regular School No Other PK 12.0 2018   grade_5 4 0 1   0 0     0   0   2 3             *         5 4 0 1   0 0     0   0   2 3                 5
1308187 ID     school 1603030 292   SOUTH LEMHI DISTRICT 160303000528 137 LEADORE SCHOOL   Regular School No Other PK 12.0 2019   grade_5 6 0 0   0 0     0   0   2 4             *         6 6 0 0   0 0     0   0   2 4                 6
1684716 ID     school 1603030 292   SOUTH LEMHI DISTRICT 160303000528 137 LEADORE SCHOOL   Regular School No 4.0 PK 12 2015   grade_5 3 0 0   0 0     0   0   1 2             *         3 3 0 0   0 0     0   0   1 2                 3
1728777 ID     school 1603030 292   SOUTH LEMHI DISTRICT 160303000528 137 LEADORE SCHOOL   Regular School No Other PK 12.0 2017   grade_5 3 1 1   0 1     0   0   3 3             *         6 3 1 1   0 1     0   0   3 3                 6
1823762 ID     school 1603030 292   SOUTH LEMHI DISTRICT 160303000528 137 LEADORE SCHOOL   Regular School No 4.0 PK 12 2016   grade_5 4 0 0   0 1     0   0   0 5             *         5 4 0 0   0 1     0   0   0 5                 5
706225 ID     school 1600900 314   DIETRICH DISTRICT 160090000165 143 DIETRICH SCHOOL   Regular School No Other PK 12 2021   grade_5 13 0 1   0 0     0   0   8 6             8         14 13 0 1   0 0     0   0   8 6         8       14
851876 ID     school 1600900 314   DIETRICH DISTRICT 160090000165 143 DIETRICH SCHOOL   Regular School No Other PK 12 2020   grade_5 11 0 6   0 0     0   0   7 10             12         17 11 0 6   0 0     0   0   7 10         12       17
1279404 ID     school 1600900 314   DIETRICH DISTRICT 160090000165 143 DIETRICH SCHOOL   Regular School No Other PK 12.0 2018   grade_5 15 0 8   0 0     0   0   14 9             15         23 15 0 8   0 0     0   0   14 9         15       23
1308273 ID     school 1600900 314   DIETRICH DISTRICT 160090000165 143 DIETRICH SCHOOL   Regular School No Other PK 12.0 2019   grade_5 13 0 3   0 0     0   0   8 8             10         16 13 0 3   0 0     0   0   8 8         10       16
1684803 ID     school 1600900 314   DIETRICH DISTRICT 160090000165 143 DIETRICH SCHOOL   Regular School No 4.0 PK 12 2015   grade_5 12 0 6   0 0     0   0   8 10             13         18 12 0 6   0 0     0   0   8 10         13       18
1728864 ID     school 1600900 314   DIETRICH DISTRICT 160090000165 143 DIETRICH SCHOOL   Regular School No Other PK 12.0 2017   grade_5 12 0 4   0 0     0   0   7 9             *         16 12 0 4   0 0     0   0   7 9                 16
1823849 ID     school 1600900 314   DIETRICH DISTRICT 160090000165 143 DIETRICH SCHOOL   Regular School No 4.0 PK 12 2016   grade_5 20 0 2   0 0     0   0   13 9             15         22 20 0 2   0 0     0   0   13 9         15       22
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
851890 ID     school 1602760 316   RICHFIELD DISTRICT 160276000497 144 RICHFIELD SCHOOL   Regular School No Other PK 12 2020   grade_5 16 0 6   0 0     0   0   14 8             15         22 16 0 6   0 0     0   0   14 8         15       22
1279418 ID     school 1602760 316   RICHFIELD DISTRICT 160276000497 144 RICHFIELD SCHOOL   Regular School No Other PK 12.0 2018   grade_5 12 0 4   0 0     0   0   11 5             11         16 12 0 4   0 0     0   0   11 5         11       16
1308287 ID     school 1602760 316   RICHFIELD DISTRICT 160276000497 144 RICHFIELD SCHOOL   Regular School No Other PK 12.0 2019   grade_5 12 0 6   0 0     0   0   6 12             11         18 12 0 6   0 0     0   0   6 12         11       18
1684817 ID     school 1602760 316   RICHFIELD DISTRICT 160276000497 144 RICHFIELD SCHOOL   Regular School No 4.0 PK 12 2015   grade_5 8 0 2   0 0     0   1   5 6             *         11 8 0 2   0 0     0   1   5 6                 11
1728878 ID     school 1602760 316   RICHFIELD DISTRICT 160276000497 144 RICHFIELD SCHOOL   Regular School No Other PK 12.0 2017   grade_5 12 0 2   0 0     0   0   7 7             *         14 12 0 2   0 0     0   0   7 7                 14
1823863 ID     school 1602760 316   RICHFIELD DISTRICT 160276000497 144 RICHFIELD SCHOOL   Regular School No 4.0 PK 12 2016   grade_5 12 0 2   0 0     0   0   8 6             6         14 12 0 2   0 0     0   0   8 6         6       14
703926 ID     school 1601080 59   FIRTH DISTRICT 160108000326 155 FIRTH MIDDLE SCHOOL   Regular School No Middle 05 08 2021   grade_5 75 1 8   0 1     0   0   43 42             33         85 75 1 8   0 1     0   0   43 42         33       85
849663 ID     school 1601080 59   FIRTH DISTRICT 160108000326 155 FIRTH MIDDLE SCHOOL   Regular School No Middle 05 08 2020   grade_5 53 1 9   1 1     0   0   27 38             27         65 53 1 9   1 1     0   0   27 38         27       65
1277211 ID     school 1601080 59   FIRTH DISTRICT 160108000326 155 FIRTH MIDDLE SCHOOL   Regular School No Middle 05 8.0 2018   grade_5 53 0 10   2 0     0   0   37 28             34         65 53 0 10   2 0     0   0   37 28         34       65
1306071 ID     school 1601080 59   FIRTH DISTRICT 160108000326 155 FIRTH MIDDLE SCHOOL   Regular School No Middle 05 8.0 2019   grade_5 46 1 11   0 0     0   0   36 22             26         58 46 1 11   0 0     0   0   36 22         26       58
1682638 ID     school 1601080 59   FIRTH DISTRICT 160108000326 155 FIRTH MIDDLE SCHOOL   Regular School No 2.0 05 08 2015   grade_5 40 0 8   2 0     0   0   25 25             33         50 40 0 8   2 0     0   0   25 25         33       50
1726676 ID     school 1601080 59   FIRTH DISTRICT 160108000326 155 FIRTH MIDDLE SCHOOL   Regular School No Middle 05 8.0 2017   grade_5 51 0 15   0 0     0   0   35 31             35         66 51 0 15   0 0     0   0   35 31         35       66
1821674 ID     school 1601080 59   FIRTH DISTRICT 160108000326 155 FIRTH MIDDLE SCHOOL   Regular School No 2.0 05 08 2016   grade_5 54 1 13   1 0     0   0   40 29             31         69 54 1 13   1 0     0   0   40 29         31       69
704039 ID     school 1600180 72   BASIN SCHOOL DISTRICT 160018000334 159 BASIN ELEMENTARY SCHOOL   Regular School No Elementary PK 06 2021   grade_5 23 0 1   0 0     0   1   17 8             11         25 23 0 1   0 0     0   1   17 8         11       25
849775 ID     school 1600180 72   BASIN SCHOOL DISTRICT 160018000334 159 BASIN ELEMENTARY SCHOOL   Regular School No Elementary PK 06 2020   grade_5 22 0 3   0 0     0   2   11 16             11         27 22 0 3   0 0     0   2   11 16         11       27
1277320 ID     school 1600180 72   BASIN SCHOOL DISTRICT 160018000334 159 BASIN ELEMENTARY SCHOOL   Regular School No Elementary PK 6.0 2018   grade_5 27 0 1   0 0     0   0   14 14             11         28 27 0 1   0 0     0   0   14 14         11       28
1306182 ID     school 1600180 72   BASIN SCHOOL DISTRICT 160018000334 159 BASIN ELEMENTARY SCHOOL   Regular School No Elementary PK 6.0 2019   grade_5 20 0 0   0 0     0   1   11 10             8         21 20 0 0   0 0     0   1   11 10         8       21
1682745 ID     school 1600180 72   BASIN SCHOOL DISTRICT 160018000334 159 BASIN ELEMENTARY SCHOOL   Regular School No 1.0 PK 06 2015   grade_5 32 0 1   2 0     0   0   16 19             25         35 32 0 1   2 0     0   0   16 19         25       35
1726783 ID     school 1600180 72   BASIN SCHOOL DISTRICT 160018000334 159 BASIN ELEMENTARY SCHOOL   Regular School No Elementary PK 6.0 2017   grade_5 20 0 2   0 0     0   0   11 11             9         22 20 0 2   0 0     0   0   11 11         9       22
1821781 ID     school 1600180 72   BASIN SCHOOL DISTRICT 160018000334 159 BASIN ELEMENTARY SCHOOL   Regular School No 1.0 PK 06 2016   grade_5 27 0 1   0 0     0   1   16 13             11         29 27 0 1   0 0     0   1   16 13         11       29
706627 ID     school 1601140 373   FRUITLAND DISTRICT 160114000213 165 FRUITLAND MIDDLE SCHOOL   Regular School No Middle 05 08 2021   grade_5 73 0 38   1 1     0   2   62 53             41         115 73 0 38   1 1     0   2   62 53         41       115
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
1279805 ID     school 1601140 373   FRUITLAND DISTRICT 160114000213 165 FRUITLAND MIDDLE SCHOOL   Regular School No Middle 05 8.0 2018   grade_5 104 2 33   0 2     0   0   83 58             66         141 104 2 33   0 2     0   0   83 58         66       141
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
1685212 ID     school 1601140 373   FRUITLAND DISTRICT 160114000213 165 FRUITLAND MIDDLE SCHOOL   Regular School No 2.0 05 08 2015   grade_5 111 0 35   0 1     0   3   77 73             66         150 111 0 35   0 1     0   3   77 73         66       150
1729286 ID     school 1601140 373   FRUITLAND DISTRICT 160114000213 165 FRUITLAND MIDDLE SCHOOL   Regular School No Middle 05 8.0 2017   grade_5 85 0 47   2 0     0   3   77 60             74         137 85 0 47   2 0     0   3   77 60         74       137
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
706678 ID     school 1602820 382   ROCKLAND DISTRICT 160282000501 169 ROCKLAND PUBLIC SCHOOL   Regular School No Other PK 12 2021   grade_5 14 0 0   0 0     0   0   2 12             7         14 14 0 0   0 0     0   0   2 12         7       14
852332 ID     school 1602820 382   ROCKLAND DISTRICT 160282000501 169 ROCKLAND PUBLIC SCHOOL   Regular School No Other PK 12 2020   grade_5 11 0 0   0 0     0   0   6 5             *         11 11 0 0   0 0     0   0   6 5                 11
1279857 ID     school 1602820 382   ROCKLAND DISTRICT 160282000501 169 ROCKLAND PUBLIC SCHOOL   Regular School No Other PK 12.0 2018   grade_5 16 0 0   0 0     0   0   10 6             9         16 16 0 0   0 0     0   0   10 6         9       16
1308727 ID     school 1602820 382   ROCKLAND DISTRICT 160282000501 169 ROCKLAND PUBLIC SCHOOL   Regular School No Other PK 12.0 2019   grade_5 13 0 0   0 0     0   0   7 6             *         13 13 0 0   0 0     0   0   7 6                 13
1685263 ID     school 1602820 382   ROCKLAND DISTRICT 160282000501 169 ROCKLAND PUBLIC SCHOOL   Regular School No 4.0 PK 12 2015   grade_5 11 0 0   0 0     0   0   5 6             5         11 11 0 0   0 0     0   0   5 6         5       11
1729338 ID     school 1602820 382   ROCKLAND DISTRICT 160282000501 169 ROCKLAND PUBLIC SCHOOL   Regular School No Other PK 12.0 2017   grade_5 8 0 1   1 0     0   0   8 2             *         10 8 0 1   1 0     0   0   8 2                 10
1824307 ID     school 1602820 382   ROCKLAND DISTRICT 160282000501 169 ROCKLAND PUBLIC SCHOOL   Regular School No 4.0 PK 12 2016   grade_5 17 0 0   0 0     0   0   10 7             5         17 17 0 0   0 0     0   0   10 7         5       17
706721 ID     school 1602280 392   MULLAN DISTRICT 160228000405 172 MULLAN SCHOOLS   Regular School No Other KG 12 2021   grade_5 7 0 0   1 0     0   1   5 4             *         9 7 0 0   1 0     0   1   5 4                 9
852375 ID     school 1602280 392   MULLAN DISTRICT 160228000405 172 MULLAN SCHOOLS   Regular School No Other PK 12 2020   grade_5 4 0 0   1 0     0   0   2 3             *         5 4 0 0   1 0     0   0   2 3                 5
1308770 ID     school 1602280 392   MULLAN DISTRICT 160228000405 172 MULLAN SCHOOLS   Regular School No Other KG 12.0 2019   grade_5 8 0 0   0 0     0   2   4 6             *         10 8 0 0   0 0     0   2   4 6                 10
706732 ID     school 1603300 393   WALLACE DISTRICT 160330000562 173 SILVER HILLS ELEMENTARY SCHOOL   Regular School No Elementary PK 06 2021   grade_5 34 1 2   0 1     0   2   22 18             21         40 34 1 2   0 1     0   2   22 18         21       40
852386 ID     school 1603300 393   WALLACE DISTRICT 160330000562 173 SILVER HILLS ELEMENTARY SCHOOL   Regular School No Elementary PK 06 2020   grade_5 46 0 0   1 0     0   0   21 26             29         47 46 0 0   1 0     0   0   21 26         29       47
1279912 ID     school 1603300 393   WALLACE DISTRICT 160330000562 173 SILVER HILLS ELEMENTARY SCHOOL   Regular School No Elementary PK 6.0 2018   grade_5 32 0 1   0 0     1   2   14 22             27         36 32 0 1   0 0     1   2   14 22         27       36
1308781 ID     school 1603300 393   WALLACE DISTRICT 160330000562 173 SILVER HILLS ELEMENTARY SCHOOL   Regular School No Elementary PK 6.0 2019   grade_5 37 1 0   1 0     0   1   23 17             29         40 37 1 0   1 0     0   1   23 17         29       40
1685327 ID     school 1603300 393   WALLACE DISTRICT 160330000562 173 SILVER HILLS ELEMENTARY SCHOOL   Regular School No 1.0 PK 06 2015   grade_5 34 0 1   0 0     0   1   18 18             21         36 34 0 1   0 0     0   1   18 18         21       36
1729395 ID     school 1603300 393   WALLACE DISTRICT 160330000562 173 SILVER HILLS ELEMENTARY SCHOOL   Regular School No Elementary PK 6.0 2017   grade_5 33 0 0   0 0     0   1   17 17             24         34 33 0 0   0 0     0   1   17 17         24       34
1824363 ID     school 1603300 393   WALLACE DISTRICT 160330000562 173 SILVER HILLS ELEMENTARY SCHOOL   Regular School No 1.0 PK 06 2016   grade_5 37 2 3   1 0     0   2   22 23             31         45 37 2 3   1 0     0   2   22 23         31       45
706987 ID     school 1600690 417   CASTLEFORD DISTRICT 160069000137 185 CASTLEFORD SCHOOL   Regular School No Other PK 12 2021   grade_5 20 0 14   0 0     0   0   16 18             23         34 20 0 14   0 0     0   0   16 18         23       34
852636 ID     school 1600690 417   CASTLEFORD DISTRICT 160069000137 185 CASTLEFORD SCHOOL   Regular School No Other PK 12 2020   grade_5 19 0 9   2 0     0   0   16 14             20         30 19 0 9   2 0     0   0   16 14         20       30
1280160 ID     school 1600690 417   CASTLEFORD DISTRICT 160069000137 185 CASTLEFORD SCHOOL   Regular School No Other PK 12.0 2018   grade_5 15 0 7   1 0     0   0   9 14             14         23 15 0 7   1 0     0   0   9 14         14       23
1309034 ID     school 1600690 417   CASTLEFORD DISTRICT 160069000137 185 CASTLEFORD SCHOOL   Regular School No Other PK 12.0 2019   grade_5 15 0 6   1 0     0   0   11 11             12         22 15 0 6   1 0     0   0   11 11         12       22
1685548 ID     school 1600690 417   CASTLEFORD DISTRICT 160069000137 185 CASTLEFORD SCHOOL   Regular School No 4.0 PK 12 2015   grade_5 17 0 6   0 0     0   0   14 9             18         23 17 0 6   0 0     0   0   14 9         18       23
1729626 ID     school 1600690 417   CASTLEFORD DISTRICT 160069000137 185 CASTLEFORD SCHOOL   Regular School No Other PK 12.0 2017   grade_5 20 0 4   0 0     0   0   9 15             12         24 20 0 4   0 0     0   0   9 15         12       24
1824577 ID     school 1600690 417   CASTLEFORD DISTRICT 160069000137 185 CASTLEFORD SCHOOL   Regular School No 4.0 PK 12 2016   grade_5 15 0 7   0 0     0   1   15 8             15         23 15 0 7   0 0     0   1   15 8         15       23
703967 ID     school 1600300 61   BLAINE COUNTY DISTRICT 160030000034 197 CAREY PUBLIC SCHOOL   Regular School No Other PK 12 2021   grade_5 5 0 5   0 0     0   3   8 5             8         13 5 0 5   0 0     0   3   8 5         8       13
849704 ID     school 1600300 61   BLAINE COUNTY DISTRICT 160030000034 197 CAREY PUBLIC SCHOOL   Regular School No Other PK 12 2020   grade_5 8 0 5   0 0     0   1   9 5             *         14 8 0 5   0 0     0   1   9 5                 14
1277252 ID     school 1600300 61   BLAINE COUNTY DISTRICT 160030000034 197 CAREY PUBLIC SCHOOL   Regular School No Other PK 12.0 2018   grade_5 14 0 6   0 0     0   1   11 10             10         21 14 0 6   0 0     0   1   11 10         10       21

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