Data source: Big Local News · About: Big Local

403 rows where grade = "grade_2", state = "ID" and year = 2020 sorted by district

View and edit SQL

year

  • 2020 · 403

grade

  • grade_2 · 403
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
849648 ID     school 1600030 58   ABERDEEN DISTRICT 160003000828 298 ABERDEEN ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2020   grade_2 16 0 36   0 0     0   0   24 28             42         52 16 0 36   0 0     0   0   24 28         42       52
853208 ID     school 1600175 495   ALTURAS INTERNATIONAL ACADEMY, INC. 160017501082 1385 ALTURAS INTERNATIONAL ACADEMY   Regular School Yes Elementary KG 08 2020   grade_2 52 0 7   0 2     0   3   29 35             *         64 52 0 7   0 2     0   3   29 35                 64
852318 ID     school 1600060 381   AMERICAN FALLS JOINT DISTRICT 160006000005 808 HILLCREST ELEMENTARY SCHOOL   Regular School No Elementary PK 02 2020   grade_2 51 0 57   1 0     0   1   54 56             83         110 51 0 57   1 0     0   1   54 56         83       110
853113 ID     school 1600162 482   AMERICAN HERITAGE CHARTER SCHOOL, INC. 160016201044 1346 AMERICAN HERITAGE CHARTER SCHOOL   Regular School Yes Other KG 12 2020   grade_2 45 0 1   0 0     0   0   24 22             15         46 45 0 1   0 0     0   0   24 22         15       46
853045 ID     school 1600155 476   ANOTHER CHOICE VIRTUAL CHARTER SCHOOL, INC. 160015501008 1247 ANOTHER CHOICE VIRTUAL CHARTER   Regular School Yes Other PK 12 2020   grade_2 11 0 3   0 1     0   0   7 8             *         15 11 0 3   0 1     0   0   7 8                 15
853174 ID     school 1600360 492   ANSER OF IDAHO, INC. 160036000758 819 ANSER CHARTER SCHOOL   Regular School Yes Elementary PK 08 2020   grade_2 31 0 2   0 0     0   2   17 18             5         35 31 0 2   0 0     0   2   17 18         5       35
852339 ID     school 1600090 383   ARBON ELEMENTARY DISTRICT 160009000006 810 ARBON ELEMENTARY SCHOOL   Regular School No Elementary KG 06 2020   grade_2 4 0 0   0 0     0   0   1 3             *         4 4 0 0   0 0     0   0   1 3                 4
852398 ID     school 1600150 394   AVERY SCHOOL DISTRICT 160015001010 820 CALDER SCHOOL   Regular School No Elementary KG 08 2020   grade_2 2 0 0   0 0     0   0   1 1             *         2 2 0 0   0 0     0   0   1 1                 2
849772 ID     school 1600180 72   BASIN SCHOOL DISTRICT 160018000334 159 BASIN ELEMENTARY SCHOOL   Regular School No Elementary PK 06 2020   grade_2 17 0 2   0 0     0   0   11 8             8         19 17 0 2   0 0     0   0   11 8         8       19
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
849503 ID     school 1600240 33   BEAR LAKE COUNTY DISTRICT 160024000021 371 GEORGETOWN ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2020   grade_2 21 0 0   0 0     0   1   13 9             11         22 21 0 0   0 0     0   1   13 9         11       22
849510 ID     school 1600240 33   BEAR LAKE COUNTY DISTRICT 160024000019 372 PARIS ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2020   grade_2 19 1 1   0 0     0   0   10 11             9         21 19 1 1   0 0     0   0   10 11         9       21
853056 ID     school 1600153 477   BLACKFOOT CHARTER COMMUNITY LEARNING CENTER, INC. 160015300796 1294 BLACKFOOT CHARTER COMMUNITY   Regular School Yes Elementary PK 08 2020   grade_2 67 0 8   1 0     0   0   32 44             53         76 67 0 8   1 0     0   0   32 44         53       76
849595 ID     school 1600270 55   BLACKFOOT DISTRICT 160027000031 382 DONALD D STALKER ELEMENTARY   Regular School No Elementary PK 05 2020   grade_2 18 0 20   9 0     1   1   31 18             33         49 18 0 20   9 0     1   1   31 18         33       49
849602 ID     school 1600270 55   BLACKFOOT DISTRICT 160027000025 384 RIDGE CREST ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2020   grade_2 31 0 17   0 0     0   0   28 20             35         48 31 0 17   0 0     0   0   28 20         35       48
849609 ID     school 1600270 55   BLACKFOOT DISTRICT 160027000032 385 WAPELLO ELEMENTARY SCHOOL   Regular School No Elementary KG 05 2020   grade_2 32 0 5   0 0     0   0   15 22             16         37 32 0 5   0 0     0   0   15 22         16       37
849616 ID     school 1600270 55   BLACKFOOT DISTRICT 160027000027 386 GROVELAND ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2020   grade_2 26 0 4   0 0     0   4   16 18             15         34 26 0 4   0 0     0   4   16 18         15       34
849623 ID     school 1600270 55   BLACKFOOT DISTRICT 160027000026 387 FORT HALL ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2020   grade_2 1 0 0   18 0     0   5   15 9             15         24 1 0 0   18 0     0   5   15 9         15       24
849630 ID     school 1600270 55   BLACKFOOT DISTRICT 160027000028 388 I T STODDARD ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2020   grade_2 26 0 15   8 0     0   6   18 37             43         55 26 0 15   8 0     0   6   18 37         43       55
849701 ID     school 1600300 61   BLAINE COUNTY DISTRICT 160030000034 197 CAREY PUBLIC SCHOOL   Regular School No Other PK 12 2020   grade_2 9 0 5   0 0     0   1   8 7             *         15 9 0 5   0 0     0   1   8 7                 15
849712 ID     school 1600300 61   BLAINE COUNTY DISTRICT 160030000033 394 BELLEVUE ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2020   grade_2 15 0 8   0 1     1   0   14 11             *         25 15 0 8   0 1     1   0   14 11                 25
849719 ID     school 1600300 61   BLAINE COUNTY DISTRICT 160030000035 395 ERNEST HEMINGWAY STEAM SCHOOL   Regular School No Elementary PK 08 2020   grade_2 33 0 26   0 1     0   0   31 29             16         60 33 0 26   0 1     0   0   31 29         16       60
849729 ID     school 1600300 61   BLAINE COUNTY DISTRICT 160030000036 396 HAILEY ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2020   grade_2 25 0 20   0 0     1   3   27 22             14         49 25 0 20   0 0     1   3   27 22         14       49
849736 ID     school 1600300 61   BLAINE COUNTY DISTRICT 160030000908 636 ALTURAS ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2020   grade_2 26 0 51   0 0     0   1   41 37             28         78 26 0 51   0 0     0   1   41 37         28       78
851194 ID     school 1600330 234   BLISS JOINT DISTRICT 160033000040 714 BLISS SCHOOL   Regular School No Other PK 12 2020   grade_2 4 0 2   0 0     0   0   3 3             *         6 4 0 2   0 0     0   0   3 3                 6
848601 ID     school 1600360 1   BOISE INDEPENDENT DISTRICT 160036000590 287 TRAIL WIND ELEMENTARY   Regular School No Elementary PK 06 2020   grade_2 55 1 5   0 7     0   4   42 30             8         72 55 1 5   0 7     0   4   42 30         8       72
848609 ID     school 1600360 1   BOISE INDEPENDENT DISTRICT 160036000591 288 SHADOW HILLS ELEMENTARY   Regular School No Elementary PK 06 2020   grade_2 61 0 4   0 0     0   3   40 28             20         68 61 0 4   0 0     0   3   40 28         20       68
848617 ID     school 1600360 1   BOISE INDEPENDENT DISTRICT 160036000592 300 AMITY ELEMENTARY SCHOOL   Regular School No Elementary PK 06 2020   grade_2 71 1 2   0 3     0   2   46 33             18         79 71 1 2   0 3     0   2   46 33         18       79
848625 ID     school 1600360 1   BOISE INDEPENDENT DISTRICT 160036000065 301 MAPLE GROVE ELEMENTARY SCHOOL   Regular School No Elementary PK 06 2020   grade_2 44 1 6   1 2     2   5   33 28             22         61 44 1 6   1 2     2   5   33 28         22       61
848633 ID     school 1600360 1   BOISE INDEPENDENT DISTRICT 160036000055 302 HIGHLANDS ELEMENTARY SCHOOL   Regular School No Elementary PK 06 2020   grade_2 31 0 0   0 0     0   2   11 22             *         33 31 0 0   0 0     0   2   11 22                 33
848641 ID     school 1600360 1   BOISE INDEPENDENT DISTRICT 160036000053 303 GARFIELD ELEMENTARY SCHOOL   Regular School No Elementary PK 06 2020   grade_2 34 2 9   0 3     0   4   30 22             18         52 34 2 9   0 3     0   4   30 22         18       52
848649 ID     school 1600360 1   BOISE INDEPENDENT DISTRICT 160036000076 305 WASHINGTON ELEMENTARY SCHOOL   Regular School No Elementary PK 06 2020   grade_2 41 0 3   0 1     0   1   17 29             *         46 41 0 3   0 1     0   1   17 29                 46
848657 ID     school 1600360 1   BOISE INDEPENDENT DISTRICT 160036000078 306 WHITNEY ELEMENTARY SCHOOL   Regular School No Elementary PK 06 2020   grade_2 40 10 23   0 2     1   4   37 43             42         80 40 10 23   0 2     1   4   37 43         42       80
848665 ID     school 1600360 1   BOISE INDEPENDENT DISTRICT 160036000056 307 HILLCREST ELEMENTARY SCHOOL   Regular School No Elementary PK 06 2020   grade_2 21 3 8   0 1     0   1   20 14             15         34 21 3 8   0 1     0   1   20 14         15       34
848673 ID     school 1600360 1   BOISE INDEPENDENT DISTRICT 160036000054 308 HAWTHORNE ELEMENTARY SCHOOL   Regular School No Elementary PK 06 2020   grade_2 25 1 7   0 3     0   2   21 17             15         38 25 1 7   0 3     0   2   21 17         15       38
848681 ID     school 1600360 1   BOISE INDEPENDENT DISTRICT 160036000072 309 ROOSEVELT ELEMENTARY SCHOOL   Regular School No Elementary PK 06 2020   grade_2 35 2 1   0 0     0   3   24 17             5         41 35 2 1   0 0     0   3   24 17         5       41
848689 ID     school 1600360 1   BOISE INDEPENDENT DISTRICT 160036000071 310 PIERCE PARK ELEMENTARY SCHOOL   Regular School No Elementary PK 06 2020   grade_2 26 1 7   0 1     0   0   16 19             16         35 26 1 7   0 1     0   0   16 19         16       35
848697 ID     school 1600360 1   BOISE INDEPENDENT DISTRICT 160036000070 313 OWYHEE ELEMENTARY SCHOOL   Regular School No Elementary PK 06 2020   grade_2 16 1 7   0 2     0   3   13 16             9         29 16 1 7   0 2     0   3   13 16         9       29
848705 ID     school 1600360 1   BOISE INDEPENDENT DISTRICT 160036000042 315 ADAMS ELEMENTARY SCHOOL   Regular School No Elementary PK 06 2020   grade_2 37 1 3   0 1     0   3   19 26             6         45 37 1 3   0 1     0   3   19 26         6       45
848713 ID     school 1600360 1   BOISE INDEPENDENT DISTRICT 160036000650 316 LIBERTY ELEMENTARY SCHOOL   Regular School No Elementary PK 06 2020   grade_2 71 0 6   0 3     2   4   52 34             19         86 71 0 6   0 3     2   4   52 34         19       86
848721 ID     school 1600360 1   BOISE INDEPENDENT DISTRICT 160036000059 317 JEFFERSON ELEMENTARY SCHOOL   Regular School No Elementary PK 06 2020   grade_2 21 11 5   1 2     0   0   20 20             24         40 21 11 5   1 2     0   0   20 20         24       40
848729 ID     school 1600360 1   BOISE INDEPENDENT DISTRICT 160036000063 319 LOWELL ELEMENTARY SCHOOL   Regular School No Elementary PK 06 2020   grade_2 29 0 3   1 0     0   1   17 17             7         34 29 0 3   1 0     0   1   17 17         7       34
848737 ID     school 1600360 1   BOISE INDEPENDENT DISTRICT 160036000075 320 VALLEY VIEW ELEMENTARY SCHOOL   Regular School No Elementary PK 06 2020   grade_2 43 0 8   0 0     0   2   33 20             26         53 43 0 8   0 0     0   2   33 20         26       53
848745 ID     school 1600360 1   BOISE INDEPENDENT DISTRICT 160036000074 321 TAFT ELEMENTARY SCHOOL   Regular School No Elementary PK 06 2020   grade_2 24 10 5   0 1     1   1   19 23             25         42 24 10 5   0 1     1   1   19 23         25       42
848753 ID     school 1600360 1   BOISE INDEPENDENT DISTRICT 160036000068 322 MOUNTAIN VIEW ELEMENTARY SCHOOL   Regular School No Elementary PK 06 2020   grade_2 29 2 4   0 0     0   2   17 20             19         37 29 2 4   0 0     0   2   17 20         19       37
848761 ID     school 1600360 1   BOISE INDEPENDENT DISTRICT 160036000062 323 LONGFELLOW ELEMENTARY SCHOOL   Regular School No Elementary PK 06 2020   grade_2 27 1 4   0 1     0   0   16 17             6         33 27 1 4   0 1     0   0   16 17         6       33
848769 ID     school 1600360 1   BOISE INDEPENDENT DISTRICT 160036000067 324 MONROE ELEMENTARY SCHOOL   Regular School No Elementary PK 06 2020   grade_2 32 0 2   0 0     1   1   15 21             7         36 32 0 2   0 0     1   1   15 21         7       36
848777 ID     school 1600360 1   BOISE INDEPENDENT DISTRICT 160036000060 325 KOELSCH ELEMENTARY SCHOOL   Regular School No Elementary PK 06 2020   grade_2 30 4 15   0 1     1   1   28 24             33         52 30 4 15   0 1     1   1   28 24         33       52
848785 ID     school 1600360 1   BOISE INDEPENDENT DISTRICT 160036000049 326 COLLISTER ELEMENTARY SCHOOL   Regular School No Elementary PK 06 2020   grade_2 23 0 3   0 11     0   1   23 15             *         38 23 0 3   0 11     0   1   23 15                 38
848793 ID     school 1600360 1   BOISE INDEPENDENT DISTRICT 160036000079 327 WHITTIER ELEMENTARY SCHOOL   Regular School No Elementary PK 06 2020   grade_2 43 4 31   1 0     0   3   43 39             33         82 43 4 31   1 0     0   3   43 39         33       82
848801 ID     school 1600360 1   BOISE INDEPENDENT DISTRICT 160036000004 509 RIVERSIDE ELEMENTARY SCHOOL   Regular School No Elementary PK 06 2020   grade_2 91 0 6   0 7     0   0   44 60             9         104 91 0 6   0 7     0   0   44 60         9       104
848809 ID     school 1600360 1   BOISE INDEPENDENT DISTRICT 160036000009 510 HORIZON ELEMENTARY SCHOOL   Regular School No Elementary PK 06 2020   grade_2 46 4 17   0 4     0   4   38 37             41         75 46 4 17   0 4     0   4   38 37         41       75
848829 ID     school 1600360 1   BOISE INDEPENDENT DISTRICT 160036000707 665 CYNTHIA MANN ELEMENTARY SCHOOL   Regular School No Elementary PK 06 2020   grade_2 47 1 4   0 0     0   4   30 26             16         56 47 1 4   0 0     0   4   30 26         16       56
848837 ID     school 1600360 1   BOISE INDEPENDENT DISTRICT 160036000706 666 WHITE PINE ELEMENTARY SCHOOL   Regular School No Elementary PK 06 2020   grade_2 43 6 3   1 19     2   1   40 35             22         75 43 6 3   1 19     2   1   40 35         22       75
848845 ID     school 1600360 1   BOISE INDEPENDENT DISTRICT 160036000980 673 MORLEY NELSON ELEMENTARY   Regular School No Elementary PK 06 2020   grade_2 39 10 25   1 4     0   3   39 43             36         82 39 10 25   1 4     0   3   39 43         36       82
848853 ID     school 1600360 1   BOISE INDEPENDENT DISTRICT 160036000982 674 GRACE JORDAN ELEMENTARY   Regular School No Elementary PK 06 2020   grade_2 30 5 18   1 0     0   3   28 29             34         57 30 5 18   1 0     0   3   28 29         34       57
848876 ID     school 1600360 1   BOISE INDEPENDENT DISTRICT 160036001004 679 HIDDEN SPRINGS ELEMENTARY SCHOOL   Regular School No Elementary PK 06 2020   grade_2 39 1 3   0 0     0   2   22 23             *         45 39 1 3   0 0     0   2   22 23                 45
850079 ID     school 1600930 93   BONNEVILLE JOINT DISTRICT 160093000173 425 FALLS VALLEY ELEMENTARY SCHOOL   Regular School No Elementary PK 06 2020   grade_2 32 1 10   0 2     0   2   24 23             35         47 32 1 10   0 2     0   2   24 23         35       47
850087 ID     school 1600930 93   BONNEVILLE JOINT DISTRICT 160093000167 426 AMMON ELEMENTARY SCHOOL   Regular School No Elementary PK 06 2020   grade_2 35 2 3   2 0     0   0   17 25             13         42 35 2 3   2 0     0   0   17 25         13       42
850095 ID     school 1600930 93   BONNEVILLE JOINT DISTRICT 160093000176 427 IONA ELEMENTARY SCHOOL   Regular School No Elementary PK 06 2020   grade_2 74 1 7   1 0     1   2   39 47             21         86 74 1 7   1 0     1   2   39 47         21       86
850103 ID     school 1600930 93   BONNEVILLE JOINT DISTRICT 160093000175 428 HILLVIEW ELEMENTARY SCHOOL   Regular School No Elementary PK 06 2020   grade_2 56 1 7   0 0     0   2   28 38             41         66 56 1 7   0 0     0   2   28 38         41       66
850111 ID     school 1600930 93   BONNEVILLE JOINT DISTRICT 160093000178 429 UCON ELEMENTARY SCHOOL   Regular School No Elementary PK 06 2020   grade_2 63 0 5   1 0     0   0   32 37             26         69 63 0 5   1 0     0   0   32 37         26       69
850119 ID     school 1600930 93   BONNEVILLE JOINT DISTRICT 160093000630 431 CLOVERDALE ELEMENTARY SCHOOL   Regular School No Elementary PK 06 2020   grade_2 55 0 11   1 1     0   1   39 30             29         69 55 0 11   1 1     0   1   39 30         29       69
850127 ID     school 1600930 93   BONNEVILLE JOINT DISTRICT 160093000172 432 FAIRVIEW ELEMENTARY SCHOOL   Regular School No Elementary PK 06 2020   grade_2 40 0 3   0 0     0   1   26 18             22         44 40 0 3   0 0     0   1   26 18         22       44
850135 ID     school 1600930 93   BONNEVILLE JOINT DISTRICT 160093000670 501 TIEBREAKER ELEMENTARY SCHOOL   Regular School No Elementary PK 06 2020   grade_2 47 0 15   0 3     0   2   34 33             37         67 47 0 15   0 3     0   2   34 33         37       67
850143 ID     school 1600930 93   BONNEVILLE JOINT DISTRICT 160093000910 637 WOODLAND HILLS ELEMENTARY   Regular School No Elementary PK 06 2020   grade_2 81 1 2   0 0     0   1   38 47             *         85 81 1 2   0 0     0   1   38 47                 85
850157 ID     school 1600930 93   BONNEVILLE JOINT DISTRICT 160093000999 1238 BONNEVILLE ONLINE ELEMENTARY   Regular School No Elementary PK 08 2020   grade_2 40 0 4   0 0     1   1   22 24             *         46 40 0 4   0 0     1   1   22 24                 46
850167 ID     school 1600930 93   BONNEVILLE JOINT DISTRICT 160093001015 1250 MOUNTAIN VALLEY ELEMENTARY SCHOOL   Regular School No Elementary PK 06 2020   grade_2 65 1 10   1 0     1   1   39 40             23         79 65 1 10   1 0     1   1   39 40         23       79
850175 ID     school 1600930 93   BONNEVILLE JOINT DISTRICT 160093000909 1255 RIMROCK ELEMENTARY   Regular School No Elementary PK 06 2020   grade_2 68 0 1   0 1     0   0   40 30             12         70 68 0 1   0 1     0   0   40 30         12       70
850195 ID     school 1600930 93   BONNEVILLE JOINT DISTRICT 160093001062 1360 SUMMIT HILLS ELEMENTARY SCHOOL   Regular School No Elementary KG 06 2020   grade_2 53 0 22   0 1     0   0   34 42             34         76 53 0 22   0 1     0   0   34 42         34       76
850208 ID     school 1600930 93   BONNEVILLE JOINT DISTRICT 160093000975 2518 BRIDGEWATER ELEMENTARY SCHOOL   Regular School No Elementary PK 06 2020   grade_2 38 0 12   0 0     0   2   27 25             25         52 38 0 12   0 0     0   2   27 25         25       52
850216 ID     school 1600930 93   BONNEVILLE JOINT DISTRICT 160093000971 2519 DISCOVERY ELEMENTARY SCHOOL   Regular School No Elementary PK 06 2020   grade_2 97 0 10   0 0     0   0   59 48             44         107 97 0 10   0 0     0   0   59 48         44       107
850233 ID     school 1600420 101   BOUNDARY COUNTY DISTRICT 160042000092 433 NAPLES ELEMENTARY SCHOOL   Regular School No Elementary KG 05 2020   grade_2 14 0 1   0 0     0   0   4 11             *         15 14 0 1   0 0     0   0   4 11                 15
850240 ID     school 1600420 101   BOUNDARY COUNTY DISTRICT 160042000091 434 MOUNT HALL ELEMENTARY SCHOOL   Regular School No Elementary KG 05 2020   grade_2 19 0 1   1 0     0   1   14 8             *         22 19 0 1   1 0     0   1   14 8                 22
850247 ID     school 1600420 101   BOUNDARY COUNTY DISTRICT 160042000094 437 VALLEY VIEW ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2020   grade_2 46 0 10   2 0     0   4   30 32             36         62 46 0 10   2 0     0   4   30 32         36       62
852219 ID     school 1600450 365   BRUNEAU-GRAND VIEW JOINT SCHOOL DISTRICT 160045000098 801 BRUNEAU ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2020   grade_2 2 0 2   0 0     0   0   2 2             *         4 2 0 2   0 0     0   0   2 2                 4
852226 ID     school 1600450 365   BRUNEAU-GRAND VIEW JOINT SCHOOL DISTRICT 160045000099 802 GRAND VIEW ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2020   grade_2 4 0 5   1 0     0   0   4 6             *         10 4 0 5   1 0     0   0   4 6                 10
852550 ID     school 1600480 412   BUHL JOINT DISTRICT 160048000101 830 POPPLEWELL ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2020   grade_2 68 1 30   2 0     0   0   52 49             64         101 68 1 30   2 0     0   0   52 49         64       101
850261 ID     school 1600490 111   BUTTE COUNTY JOINT DISTRICT 160049000011 438 HOWE ELEMENTARY SCHOOL   Regular School No Elementary KG 03 2020   grade_2 2 0 0   0 0     0   0   2 0             *         2 2 0 0   0 0     0   0   2 0                 2
850266 ID     school 1600490 111   BUTTE COUNTY JOINT DISTRICT 160049000007 439 ARCO ELEMENTARY SCHOOL   Regular School No Elementary PK 06 2020   grade_2 24 0 1   0 0     0   0   11 14             *         25 24 0 1   0 0     0   0   11 14                 25
850437 ID     school 1600510 132   CALDWELL DISTRICT 160051000835 76 LEWIS AND CLARK ELEMENTARY   Regular School No Elementary PK 05 2020   grade_2 23 0 46   0 0     1   2   28 44             41         72 23 0 46   0 0     1   2   28 44         41       72
850448 ID     school 1600510 132   CALDWELL DISTRICT 160051000609 289 WILSON ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2020   grade_2 46 0 47   0 0     0   4   54 43             55         97 46 0 47   0 0     0   4   54 43         55       97
850455 ID     school 1600510 132   CALDWELL DISTRICT 160051000108 448 WASHINGTON ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2020   grade_2 30 0 58   0 1     0   1   44 46             53         90 30 0 58   0 1     0   1   44 46         53       90
850462 ID     school 1600510 132   CALDWELL DISTRICT 160051000106 449 LINCOLN ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2020   grade_2 30 0 19   0 0     0   2   31 20             34         51 30 0 19   0 0     0   2   31 20         34       51
850469 ID     school 1600510 132   CALDWELL DISTRICT 160051000107 451 VAN BUREN ELEMENTARY SCHOOL   Regular School No Elementary KG 05 2020   grade_2 35 0 69   2 0     0   1   52 55             63         107 35 0 69   2 0     0   1   52 55         63       107
850476 ID     school 1600510 132   CALDWELL DISTRICT 160051000731 457 SACAJAWEA ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2020   grade_2 22 1 63   0 0     0   1   43 44             51         87 22 1 63   0 0     0   1   43 44         51       87
850279 ID     school 1600540 121   CAMAS COUNTY DISTRICT 160054000110 440 CAMAS COUNTY ELEM/JR HIGH SCHOOL   Regular School No Elementary PK 08 2020   grade_2 16 0 0   0 0     0   0   6 10             8         16 16 0 0   0 0     0   0   6 10         8       16
852730 ID     school 1600570 432   CAMBRIDGE JOINT DISTRICT 160057000112 841 CAMBRIDGE ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2020   grade_2 9 0 0   0 0     0   1   8 2             *         10 9 0 0   0 0     0   1   8 2                 10
852694 ID     school 1600630 422   CASCADE DISTRICT 160063000120 838 CASCADE ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2020   grade_2 11 0 1   0 0     0   0   8 4             6         12 11 0 1   0 0     0   0   8 4         6       12
850763 ID     school 1600660 151   CASSIA COUNTY JOINT DISTRICT 160066000387 216 WHITE PINE ELEMENTARY   Regular School No Elementary KG 06 2020   grade_2 60 0 28   0 1     0   0   43 46             41         89 60 0 28   0 1     0   0   43 46         41       89
850775 ID     school 1600660 151   CASSIA COUNTY JOINT DISTRICT 160066000123 468 ALMO ELEMENTARY SCHOOL   Regular School No Elementary PK 06 2020   grade_2 2 0 0   0 0     0   0   1 1             *         2 2 0 0   0 0     0   0   1 1                 2
850780 ID     school 1600660 151   CASSIA COUNTY JOINT DISTRICT 160066000126 469 DECLO ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2020   grade_2 56 0 13   0 0     0   1   40 30             29         70 56 0 13   0 0     0   1   40 30         29       70
850787 ID     school 1600660 151   CASSIA COUNTY JOINT DISTRICT 160066000130 470 MOUNTAIN VIEW ELEMENTARY   Regular School No Elementary KG 06 2020   grade_2 36 1 29   0 0     0   0   34 32             43         66 36 1 29   0 0     0   0   34 32         43       66
850795 ID     school 1600660 151   CASSIA COUNTY JOINT DISTRICT 160066000129 471 RAFT RIVER ELEMENTARY SCHOOL   Regular School No Elementary PK 06 2020   grade_2 12 0 3   0 0     0   0   7 8             *         15 12 0 3   0 0     0   0   7 8                 15
850803 ID     school 1600660 151   CASSIA COUNTY JOINT DISTRICT 160066000131 473 OAKLEY ELEMENTARY SCHOOL   Regular School No Elementary PK 06 2020   grade_2 24 0 6   0 0     0   0   20 10             16         30 24 0 6   0 0     0   0   20 10         16       30
850811 ID     school 1600660 151   CASSIA COUNTY JOINT DISTRICT 160066000128 474 DWORSHAK ELEMENTARY SCHOOL   Regular School No Elementary KG 06 2020   grade_2 27 0 26   0 1     0   3   32 25             41         57 27 0 26   0 1     0   3   32 25         41       57
850819 ID     school 1600660 151   CASSIA COUNTY JOINT DISTRICT 160066000122 475 ALBION ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2020   grade_2 8 0 0   0 0     0   0   5 3             *         8 8 0 0   0 0     0   0   5 3                 8
850833 ID     school 1600660 151   CASSIA COUNTY JOINT DISTRICT 160066001088 1395 JOHN V EVANS ELEMENTARY   Regular School No Elementary KG 06 2020   grade_2 42 0 30   0 0     0   0   30 42             45         72 42 0 30   0 0     0   0   30 42         45       72
852633 ID     school 1600690 417   CASTLEFORD DISTRICT 160069000137 185 CASTLEFORD SCHOOL   Regular School No Other PK 12 2020   grade_2 10 0 7   0 0     0   0   9 8             *         17 10 0 7   0 0     0   0   9 8                 17
850913 ID     school 1600720 181   CHALLIS JOINT DISTRICT 160072000143 486 STANLEY ELEM/JR HIGH SCHOOL   Regular School No Elementary KG 08 2020   grade_2 2 0 0   0 0     0   0   1 1             *         2 2 0 0   0 0     0   0   1 1                 2

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