Data source: Big Local News · About: Big Local

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

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
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
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
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
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
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
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
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
848926 ID     school 1602100 2   JOINT SCHOOL DISTRICT NO. 2 160210000794 239 PEREGRINE ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2020   grade_2 67 3 9   0 2     0   10   50 41             40         91 67 3 9   0 2     0   10   50 41         40       91
848933 ID     school 1602100 2   JOINT SCHOOL DISTRICT NO. 2 160210000793 240 RIVER VALLEY ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2020   grade_2 60 0 8   1 3     0   2   35 39             22         74 60 0 8   1 3     0   2   35 39         22       74
848940 ID     school 1602100 2   JOINT SCHOOL DISTRICT NO. 2 160210000818 283 PEPPER RIDGE ELEMENTARY   Regular School No Elementary PK 05 2020   grade_2 76 0 9   0 1     0   3   47 42             24         89 76 0 9   0 1     0   3   47 42         24       89
848965 ID     school 1602100 2   JOINT SCHOOL DISTRICT NO. 2 160210000717 329 CHIEF JOSEPH SCHOOL OF THE ARTS   Regular School No Elementary PK 05 2020   grade_2 74 0 14   0 2     0   4   47 47             44         94 74 0 14   0 2     0   4   47 47         44       94
848986 ID     school 1602100 2   JOINT SCHOOL DISTRICT NO. 2 160210000362 332 EAGLE ELEMENTARY SCHOOL OF THE ARTS   Regular School No Elementary PK 05 2020   grade_2 61 0 3   2 0     0   1   31 36             13         67 61 0 3   2 0     0   1   31 36         13       67
849000 ID     school 1602100 2   JOINT SCHOOL DISTRICT NO. 2 160210000373 334 STAR ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2020   grade_2 92 0 8   1 0     0   5   54 52             19         106 92 0 8   1 0     0   5   54 52         19       106
849021 ID     school 1602100 2   JOINT SCHOOL DISTRICT NO. 2 160210000363 337 McMillan Elementary   Regular School No Elementary PK 05 2020   grade_2 28 1 8   1 3     0   3   25 19             27         44 28 1 8   1 3     0   3   25 19         27       44
849028 ID     school 1602100 2   JOINT SCHOOL DISTRICT NO. 2 160210000366 338 CHRISTINE DONNELL SCHOOL OF THE ARTS   Regular School No Elementary PK 06 2020   grade_2 72 0 3   0 1     0   8   31 53             11         84 72 0 3   0 1     0   8   31 53         11       84
849036 ID     school 1602100 2   JOINT SCHOOL DISTRICT NO. 2 160210000639 339 BARBARA MORGAN STEM ACADEMY   Regular School No Elementary KG 05 2020   grade_2 59 2 7   1 2     0   3   38 36             21         74 59 2 7   1 2     0   3   38 36         21       74
849043 ID     school 1602100 2   JOINT SCHOOL DISTRICT NO. 2 160210000624 340 EAGLE HILLS ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2020   grade_2 91 0 4   0 1     0   5   48 53             12         101 91 0 4   0 1     0   5   48 53         12       101
849050 ID     school 1602100 2   JOINT SCHOOL DISTRICT NO. 2 160210000368 341 MARY MCPHERSON ELEMENTARY   Regular School No Elementary PK 05 2020   grade_2 69 0 6   0 2     0   6   46 37             14         83 69 0 6   0 2     0   6   46 37         14       83
849057 ID     school 1602100 2   JOINT SCHOOL DISTRICT NO. 2 160210000598 343 JOPLIN ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2020   grade_2 40 1 6   0 0     0   3   30 20             15         50 40 1 6   0 0     0   3   30 20         15       50
849071 ID     school 1602100 2   JOINT SCHOOL DISTRICT NO. 2 160210000010 507 PIONEER SCHOOL OF THE ARTS   Regular School No Elementary PK 05 2020   grade_2 108 1 3   0 2     0   8   63 59             11         122 108 1 3   0 2     0   8   63 59         11       122
849078 ID     school 1602100 2   JOINT SCHOOL DISTRICT NO. 2 160210000801 521 DISCOVERY ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2020   grade_2 54 1 4   0 2     0   3   33 31             11         64 54 1 4   0 2     0   3   33 31         11       64
849092 ID     school 1602100 2   JOINT SCHOOL DISTRICT NO. 2 160210000597 524 CHAPARRAL ELEMENTARY   Regular School No Elementary PK 05 2020   grade_2 62 0 2   0 1     0   4   29 40             20         69 62 0 2   0 1     0   4   29 40         20       69
849099 ID     school 1602100 2   JOINT SCHOOL DISTRICT NO. 2 160210000595 525 ELIZA HART SPALDING STEM ACADEMY   Regular School No Elementary PK 05 2020   grade_2 109 1 7   1 2     0   4   64 60             27         124 109 1 7   1 2     0   4   64 60         27       124
849118 ID     school 1602100 2   JOINT SCHOOL DISTRICT NO. 2 160210000901 592 DESERT SAGE ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2020   grade_2 62 6 9   0 4     0   3   45 39             *         84 62 6 9   0 4     0   3   45 39                 84
849125 ID     school 1602100 2   JOINT SCHOOL DISTRICT NO. 2 160210000902 593 PROSPECT ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2020   grade_2 96 1 11   2 2     0   4   67 49             22         116 96 1 11   2 2     0   4   67 49         22       116
849146 ID     school 1602100 2   JOINT SCHOOL DISTRICT NO. 2 160210000989 899 SIENA ELEMENTARY   Regular School No Elementary PK 05 2020   grade_2 89 1 5   0 4     0   2   43 58             9         101 89 1 5   0 4     0   2   43 58         9       101
849172 ID     school 1602100 2   JOINT SCHOOL DISTRICT NO. 2 160210000955 1290 PARAMOUNT ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2020   grade_2 98 0 2   0 1     0   2   52 51             6         103 98 0 2   0 1     0   2   52 51         6       103
849185 ID     school 1602100 2   JOINT SCHOOL DISTRICT NO. 2 160210001060 1356 WILLOW CREEK ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2020   grade_2 84 1 10   0 2     0   2   61 38             9         99 84 1 10   0 2     0   2   61 38         9       99
849200 ID     school 1602100 2   JOINT SCHOOL DISTRICT NO. 2 160210001081 1383 HILLSDALE ELEMENTARY   Regular School No Elementary PK 05 2020   grade_2 121 1 2   2 0     0   6   67 65             16         132 121 1 2   2 0     0   6   67 65         16       132
849238 ID     school 1601770 3   KUNA JOINT DISTRICT 160177000596 345 HUBBARD ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2020   grade_2 38 0 6   0 0     0   1   18 27             20         45 38 0 6   0 0     0   1   18 27         20       45
849243 ID     school 1601770 3   KUNA JOINT DISTRICT 160177000904 595 REED ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2020   grade_2 71 2 24   1 0     0   2   52 48             47         100 71 2 24   1 0     0   2   52 48         47       100
849262 ID     school 1601770 3   KUNA JOINT DISTRICT 160177000951 887 CRIMSON POINT ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2020   grade_2 57 0 7   0 1     0   2   36 31             31         67 57 0 7   0 1     0   2   36 31         31       67
849274 ID     school 1601770 3   KUNA JOINT DISTRICT 160177001029 1308 SILVER TRAIL ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2020   grade_2 70 0 4   0 0     0   2   35 41             19         76 70 0 4   0 0     0   2   35 41         19       76
849284 ID     school 1602060 11   MEADOWS VALLEY DISTRICT 160206000826 342 MEADOWS VALLEY SCHOOL   Regular School No Other PK 12 2020   grade_2 7 0 3   0 0     0   0   7 3             *         10 7 0 3   0 0     0   0   7 3                 10
849302 ID     school 1600840 13   COUNCIL DISTRICT 160084000162 348 COUNCIL ELEMENTARY SCHOOL   Regular School No Elementary PK 06 2020   grade_2 17 0 0   1 0     0   0   8 10             10         18 17 0 0   1 0     0   0   8 10         10       18
849318 ID     school 1601950 21   MARSH VALLEY JOINT DISTRICT 160195000346 349 LAVA ELEMENTARY SCHOOL   Regular School No Elementary PK 06 2020   grade_2 11 0 0   0 0     0   0   8 3             *         11 11 0 0   0 0     0   0   8 3                 11
849326 ID     school 1601950 21   MARSH VALLEY JOINT DISTRICT 160195000344 350 DOWNEY ELEMENTARY SCHOOL   Regular School No Elementary PK 06 2020   grade_2 13 0 1   0 0     0   0   4 10             *         14 13 0 1   0 0     0   0   4 10                 14
849334 ID     school 1601950 21   MARSH VALLEY JOINT DISTRICT 160195000345 351 INKOM ELEMENTARY SCHOOL   Regular School No Elementary PK 06 2020   grade_2 25 0 0   0 0     0   2   17 10             10         27 25 0 0   0 0     0   2   17 10         10       27
849342 ID     school 1601950 21   MARSH VALLEY JOINT DISTRICT 160195000349 352 MOUNTAIN VIEW ELEMENTARY SCHOOL   Regular School No Elementary PK 06 2020   grade_2 27 0 0   0 0     0   0   13 14             13         27 27 0 0   0 0     0   0   13 14         13       27
849383 ID     school 1602640 25   POCATELLO DISTRICT 160264000470 354 GREENACRES ELEMENTARY SCHOOL   Regular School No Elementary KG 05 2020   grade_2 38 1 9   0 0     0   2   28 22             30         50 38 1 9   0 0     0   2   28 22         30       50
849390 ID     school 1602640 25   POCATELLO DISTRICT 160264000473 355 INDIAN HILLS ELEMENTARY SCHOOL   Regular School No Elementary KG 05 2020   grade_2 82 1 11   1 0     0   0   46 49             40         95 82 1 11   1 0     0   0   46 49         40       95
849397 ID     school 1602640 25   POCATELLO DISTRICT 160264000464 356 CHUBBUCK ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2020   grade_2 71 1 12   1 0     0   2   46 41             30         87 71 1 12   1 0     0   2   46 41         30       87
849418 ID     school 1602640 25   POCATELLO DISTRICT 160264000484 359 WASHINGTON ELEMENTARY SCHOOL   Regular School No Elementary KG 05 2020   grade_2 30 0 7   0 0     0   0   20 17             24         37 30 0 7   0 0     0   0   20 17         24       37
849425 ID     school 1602640 25   POCATELLO DISTRICT 160264000483 360 TYHEE ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2020   grade_2 66 0 12   23 0     0   7   54 54             45         108 66 0 12   23 0     0   7   54 54         45       108
849446 ID     school 1602640 25   POCATELLO DISTRICT 160264000475 365 JEFFERSON ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2020   grade_2 41 0 6   0 0     0   2   24 25             38         49 41 0 6   0 0     0   2   24 25         38       49
849453 ID     school 1602640 25   POCATELLO DISTRICT 160264000482 366 TENDOY ELEMENTARY SCHOOL   Regular School No Elementary PK 06 2020   grade_2 35 0 3   0 0     0   0   19 19             24         38 35 0 3   0 0     0   0   19 19         24       38
849460 ID     school 1602640 25   POCATELLO DISTRICT 160264000476 368 LEWIS & CLARK ELEMENTARY SCHOOL   Regular School No Elementary KG 05 2020   grade_2 53 0 28   0 0     0   3   39 45             61         84 53 0 28   0 0     0   3   39 45         61       84
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
849530 ID     school 1603060 41   ST MARIES JOINT DISTRICT 160306000485 254 HEYBURN ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2020   grade_2 52 0 1   0 0     0   1   31 23             *         54 52 0 1   0 0     0   1   31 23                 54
849537 ID     school 1603060 41   ST MARIES JOINT DISTRICT 160306000536 374 UPRIVER ELEMENTARY SCHOOL   Regular School No Elementary KG 06 2020   grade_2 7 0 1   1 0     0   0   7 2             *         9 7 0 1   1 0     0   0   7 2                 9
849557 ID     school 1600815 44   PLUMMER-WORLEY JOINT DISTRICT 160081500719 752 LAKESIDE ELEMENTARY SCHOOL   Regular School No Elementary PK 06 2020   grade_2 7 0 7   8 0     0   5   8 19             14         27 7 0 7   8 0     0   5   8 19         14       27
849572 ID     school 1602970 52   SNAKE RIVER DISTRICT 160297000518 376 RIVERSIDE ELEMENTARY SCHOOL   Regular School No Elementary 02 03 2020   grade_2 109 0 19   0 0     0   2   68 62             59         130 109 0 19   0 0     0   2   68 62         59       130
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
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
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
849683 ID     school 1602910 60   SHELLEY JOINT DISTRICT 160291000508 391 SUNRISE ELEMENTARY SCHOOL   Regular School No Elementary KG 02 2020   grade_2 160 4 18   0 1     0   2   91 94             84         185 160 4 18   0 1     0   2   91 94         84       185
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
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
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
849755 ID     school 1601170 71   GARDEN VALLEY DISTRICT 160117000830 274 GARDEN VALLEY SCHOOL   Regular School No Other PK 12 2020   grade_2 19 0 1   0 0     0   0   13 7             *         20 19 0 1   0 0     0   0   13 7                 20
849766 ID     school 1601170 71   GARDEN VALLEY DISTRICT 160117000216 398 LOWMAN ELEMENTARY SCHOOL   Regular School No Elementary PK 06 2020   grade_2 2 0 0   0 0     0   0   2 0             *         2 2 0 0   0 0     0   0   2 0                 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
849787 ID     school 1601500 73   HORSESHOE BEND SCHOOL DISTRICT 160150000506 256 HORSESHOE BEND ELEMENTARY   Regular School No Elementary PK 05 2020   grade_2 7 0 0   0 0     0   2   2 7             *         9 7 0 0   0 0     0   2   2 7                 9
849810 ID     school 1600001 83   WEST BONNER COUNTY DISTRICT 160000100620 406 PRIEST LAKE ELEMENTARY SCHOOL   Regular School No Elementary PK 06 2020   grade_2 5 0 1   0 0     0   0   5 1             *         6 5 0 1   0 0     0   0   5 1                 6
849818 ID     school 1600001 83   WEST BONNER COUNTY DISTRICT 160000100619 407 PRIEST RIVER ELEMENTARY SCHOOL   Regular School No Elementary PK 06 2020   grade_2 55 0 0   0 0     0   0   36 19             33         55 55 0 0   0 0     0   0   36 19         33       55
849826 ID     school 1600001 83   WEST BONNER COUNTY DISTRICT 160000100613 411 IDAHO HILL ELEMENTARY SCHOOL   Regular School No Elementary PK 06 2020   grade_2 15 0 2   0 0     0   1   8 10             *         18 15 0 2   0 0     0   1   8 10                 18
849849 ID     school 1600002 84   LAKE PEND OREILLE SCHOOL DISTRICT 160000200603 293 KOOTENAI ELEMENTARY SCHOOL   Regular School No Elementary KG 06 2020   grade_2 46 0 7   1 0     0   2   26 30             28         56 46 0 7   1 0     0   2   26 30         28       56
849857 ID     school 1600002 84   LAKE PEND OREILLE SCHOOL DISTRICT 160000200614 401 HOPE ELEMENTARY SCHOOL   Regular School No Elementary PK 06 2020   grade_2 14 0 0   0 0     0   0   5 9             *         14 14 0 0   0 0     0   0   5 9                 14
849865 ID     school 1600002 84   LAKE PEND OREILLE SCHOOL DISTRICT 160000200618 402 SAGLE ELEMENTARY SCHOOL   Regular School No Elementary PK 06 2020   grade_2 31 0 3   0 0     0   0   18 16             14         34 31 0 3   0 0     0   0   18 16         14       34
849873 ID     school 1600002 84   LAKE PEND OREILLE SCHOOL DISTRICT 160000200615 403 FARMIN STIDWELL ELEMENTARY SCHOOL   Regular School No Elementary PK 06 2020   grade_2 58 0 7   0 1     0   7   40 33             37         73 58 0 7   0 1     0   7   40 33         37       73
849881 ID     school 1600002 84   LAKE PEND OREILLE SCHOOL DISTRICT 160000200616 405 SOUTHSIDE ELEMENTARY SCHOOL   Regular School No Elementary PK 06 2020   grade_2 13 0 1   1 0     0   2   8 9             *         17 13 0 1   1 0     0   2   8 9                 17
849889 ID     school 1600002 84   LAKE PEND OREILLE SCHOOL DISTRICT 160000200617 408 WASHINGTON ELEMENTARY SCHOOL   Regular School No Elementary PK 06 2020   grade_2 37 0 3   0 0     0   1   14 27             16         41 37 0 3   0 0     0   1   14 27         16       41
849897 ID     school 1600002 84   LAKE PEND OREILLE SCHOOL DISTRICT 160000200621 410 NORTHSIDE ELEMENTARY SCHOOL   Regular School No Elementary PK 06 2020   grade_2 24 0 0   0 0     0   1   18 7             *         25 24 0 0   0 0     0   1   18 7                 25
849931 ID     school 1601530 91   IDAHO FALLS DISTRICT 160153000264 412 LONGFELLOW ELEMENTARY SCHOOL   Regular School No Elementary PK 06 2020   grade_2 59 0 12   1 0     0   5   34 43             24         77 59 0 12   1 0     0   5   34 43         24       77
849939 ID     school 1601530 91   IDAHO FALLS DISTRICT 160153000261 413 HAWTHORNE ELEMENTARY SCHOOL   Regular School No Elementary PK 06 2020   grade_2 28 0 14   0 1     0   1   25 19             35         44 28 0 14   0 1     0   1   25 19         35       44
849947 ID     school 1601530 91   IDAHO FALLS DISTRICT 160153000269 414 TEMPLE VIEW ELEMENTARY SCHOOL   Regular School No Elementary PK 06 2020   grade_2 36 1 10   0 0     0   0   23 24             19         47 36 1 10   0 0     0   0   23 24         19       47

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