Data source: Big Local News · About: Big Local

391 rows where grade = "grade_2", state = "ID" and year = 2017 sorted by total

View and edit SQL

year

  • 2017 · 391

grade

  • grade_2 · 391
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
1727719 ID     school   150   SODA SPRINGS JOINT DISTRICT   1025 BORDER DISTRICT - FREEDOM ELEMENTARY             2017   grade_2 1 0 0   0 0     0   0   0 1             *         1 1 0 0   0 0     0   0   0 1                 1
1727900 ID     school 1600720 181   CHALLIS JOINT DISTRICT 160072000142 487 PATTERSON ELEMENTARY SCHOOL   Regular School No Elementary KG 6.0 2017   grade_2 1 0 0   0 0     0   0   1 0             *         1 1 0 0   0 0     0   0   1 0                 1
1728358 ID     school 1601590 261   JEROME JOINT DISTRICT 160159000289 297 JEROME ACADEMY   Special Education School No Other 01 12.0 2017   grade_2 0 0 1   0 0     0   0   1 0             *         1 0 0 1   0 0     0   0   1 0                 1
1729155 ID     school 1602490 351   ONEIDA COUNTY DISTRICT 160249000434 797 STONE ELEMENTARY SCHOOL   Regular School No Elementary PK 3.0 2017   grade_2 1 0 0   0 0     0   0   0 1             *         1 1 0 0   0 0     0   0   0 1                 1
1729406 ID     school 1600150 394   AVERY SCHOOL DISTRICT 160015001010 820 CALDER SCHOOL   Regular School No Other KG 12.0 2017   grade_2 1 0 0   0 0     0   0   0 1             *         1 1 0 0   0 0     0   0   0 1                 1
1729611 ID     school 1603210 416   THREE CREEK JOINT ELEMENTARY DISTRICT 160321000546 835 THREE CREEK ELEM/JR HIGH SCHOOL   Regular School No Elementary PK 8.0 2017   grade_2 1 0 0   0 0     0   0   1 0             *         1 1 0 0   0 0     0   0   1 0                 1
1726550 ID     school 1603060 41   ST MARIES JOINT DISTRICT 160306000536 374 UPRIVER ELEMENTARY SCHOOL   Regular School No Elementary KG 6.0 2017   grade_2 7 0 0   0 0     0   3   5 5             *         10 7 0 0   0 0     0   3   5 5                 10
1727169 ID     school 1600930 93   BONNEVILLE JOINT DISTRICT 160093000999 1238 BONNEVILLE ONLINE ELEMENTARY   Regular School No Elementary PK 8.0 2017   grade_2 10 0 0   0 0     0   0   6 4             *         10 10 0 0   0 0     0   0   6 4                 10
1728211 ID     school 1600138 243   SALMON RIVER JOINT SCHOOL DISTRICT 160013800959 1280 RIGGINS ELEMENTARY SCHOOL   Regular School No Elementary PK 5.0 2017   grade_2 8 0 1   0 0     0   1   6 4             5         10 8 0 1   0 0     0   1   6 4         5       10
1729130 ID     school 1600870 342   CULDESAC JOINT DISTRICT 160087000164 795 CULDESAC SCHOOL   Regular School No Other PK 12.0 2017   grade_2 9 0 1   0 0     0   0   8 2             *         10 9 0 1   0 0     0   0   8 2                 10
1729370 ID     school 1601650 391   KELLOGG JOINT DISTRICT 160165000290 812 CANYON ELEMENTARY SCHOOL   Regular School No Elementary KG 5.0 2017   grade_2 9 0 0   1 0     0   0   8 2             *         10 9 0 0   1 0     0   0   8 2                 10
1730099 ID     school 1600170 486   UPPER CARMEN PUBLIC CHARTER SCHOOL, INC. 160017000847 1366 UPPER CARMEN PUBLIC CHARTER SCHOOL   Regular School Yes Elementary PK 8.0 2017   grade_2 10 0 0   0 0     0   0   5 5             *         10 10 0 0   0 0     0   0   5 5                 10
1729533 ID     school 1603240 411   TWIN FALLS DISTRICT 160324001076 1382 ROCK CREEK ELEMENTARY   Regular School No Elementary KG 5.0 2017   grade_2 89 0 9   0 2     0   1   54 47             32         101 89 0 9   0 2     0   1   54 47         32       101
1726091 ID     school 1602100 2   JOINT SCHOOL DISTRICT NO. 2 160210000593 523 CECIL D ANDRUS ELEMENTARY   Regular School No Elementary PK 5.0 2017   grade_2 90 0 6   2 2     1   1   52 50             21         102 90 0 6   2 2     1   1   52 50         21       102
1727521 ID     school 1602130 134   MIDDLETON DISTRICT 160213000376 453 MIDDLETON MILL CREEK ELEMENTARY   Regular School No Elementary PK 5.0 2017   grade_2 90 0 7   1 1     0   3   49 53             37         102 90 0 7   1 1     0   3   49 53         37       102
1727600 ID     school 1600600 139   VALLIVUE SCHOOL DISTRICT 160060000115 460 EAST CANYON ELEMENTARY SCHOOL   Regular School No Elementary PK 5.0 2017   grade_2 60 0 40   1 0     0   1   53 49             65         102 60 0 40   1 0     0   1   53 49         65       102
1727971 ID     school 1602250 193   MOUNTAIN HOME DISTRICT 160225000402 495 NORTH ELEMENTARY SCHOOL   Regular School No Elementary PK 4.0 2017   grade_2 73 0 27   0 1     0   1   56 46             61         102 73 0 27   0 1     0   1   56 46         61       102
1727528 ID     school 1602130 134   MIDDLETON DISTRICT 160213000675 500 MIDDLETON HEIGHTS ELEMENTARY   Regular School No Elementary PK 5.0 2017   grade_2 86 1 13   1 0     0   2   49 54             50         103 86 1 13   1 0     0   2   49 54         50       103
1728144 ID     school 1601260 231   GOODING JOINT DISTRICT 160126000223 711 GOODING ELEMENTARY SCHOOL   Regular School No Elementary PK 5.0 2017   grade_2 55 0 46   1 0     0   2   43 61             *         104 55 0 46   1 0     0   2   43 61                 104
1728428 ID     school 1600780 271   COEUR D'ALENE DISTRICT 160078000114 506 HAYDEN MEADOWS ELEMENTARY SCHOOL   Regular School No Elementary PK 5.0 2017   grade_2 95 0 4   0 0     1   4   61 43             37         104 95 0 4   0 0     1   4   61 43         37       104
1729564 ID     school 1601050 413   FILER DISTRICT 160105000193 831 FILER ELEMENTARY SCHOOL   Regular School No Elementary PK 3.0 2017   grade_2 88 0 16   0 0     0   0   62 42             *         104 88 0 16   0 0     0   0   62 42                 104
1727367 ID     school 1602340 131   NAMPA SCHOOL DISTRICT 160234000833 581 WILLOW CREEK ELEMENTARY   Regular School No Elementary PK 5.0 2017   grade_2 64 0 38   0 0     0   3   52 53             *         105 64 0 38   0 0     0   3   52 53                 105
1727621 ID     school 1600600 139   VALLIVUE SCHOOL DISTRICT 160060000778 519 BIRCH ELEMENTARY SCHOOL   Regular School No Elementary PK 5.0 2017   grade_2 74 0 27   0 0     0   4   57 48             56         105 74 0 27   0 0     0   4   57 48         56       105
1729250 ID     school 1602580 371   PAYETTE JOINT DISTRICT 160258000171 508 PAYETTE PRIMARY SCHOOL   Regular School No Elementary PK 3.0 2017   grade_2 72 0 33   0 0     0   0   59 46             *         105 72 0 33   0 0     0   0   59 46                 105
1727607 ID     school 1600600 139   VALLIVUE SCHOOL DISTRICT 160060000119 461 WEST CANYON ELEMENTARY SCHOOL   Regular School No Elementary PK 5.0 2017   grade_2 62 0 42   0 0     0   2   59 47             73         106 62 0 42   0 0     0   2   59 47         73       106
1726124 ID     school 1602100 2   JOINT SCHOOL DISTRICT NO. 2 160210000901 592 DESERT SAGE ELEMENTARY SCHOOL   Regular School No Elementary PK 5.0 2017   grade_2 73 5 16   0 5     5   3   59 48             *         107 73 5 16   0 5     5   3   59 48                 107
1727471 ID     school 1600510 132   CALDWELL DISTRICT 160051000107 451 VAN BUREN ELEMENTARY SCHOOL   Regular School No Elementary KG 5.0 2017   grade_2 39 0 66   0 0     0   3   55 53             *         108 39 0 66   0 0     0   3   55 53                 108
1728161 ID     school 1603360 232   WENDELL DISTRICT 160336000570 712 WENDELL ELEMENTARY SCHOOL   Regular School No Elementary PK 4.0 2017   grade_2 43 0 64   1 0     0   0   53 55             *         108 43 0 64   1 0     0   0   53 55                 108
1728412 ID     school 1600780 271   COEUR D'ALENE DISTRICT 160078000799 217 SKYWAY ELEMENTARY SCHOOL   Regular School No Elementary PK 5.0 2017   grade_2 99 1 4   3 0     0   1   69 39             40         108 99 1 4   3 0     0   1   69 39         40       108
1728997 ID     school 1602190 331   MINIDOKA COUNTY JOINT DISTRICT 160219000666 845 RUPERT ELEMENTARY SCHOOL   Regular School No Elementary PK 5.0 2017   grade_2 41 0 66   0 0     0   1   56 52             *         108 41 0 66   0 0     0   1   56 52                 108
1725609 ID     school 1600360 1   BOISE INDEPENDENT DISTRICT 160036000590 287 TRAIL WIND ELEMENTARY   Regular School No Elementary PK 6.0 2017   grade_2 91 0 5   0 6     2   5   57 52             17         109 91 0 5   0 6     2   5   57 52         17       109
1726070 ID     school 1602100 2   JOINT SCHOOL DISTRICT NO. 2 160210000770 504 PONDEROSA ELEMENTARY SCHOOL   Regular School No Elementary PK 5.0 2017   grade_2 89 1 18   0 0     0   1   63 46             44         109 89 1 18   0 0     0   1   63 46         44       109
1726714 ID     school 1600300 61   BLAINE COUNTY DISTRICT 160030000034 197 CAREY PUBLIC SCHOOL   Regular School No Other PK 12.0 2017   grade_2 7 0 3   0 0     0   1   5 6             *         11 7 0 3   0 0     0   1   5 6                 11
1726765 ID     school 1601170 71   GARDEN VALLEY DISTRICT 160117000830 274 GARDEN VALLEY SCHOOL   Regular School No Other PK 13.0 2017   grade_2 11 0 0   0 0     0   0   5 6             5         11 11 0 0   0 0     0   0   5 6         5       11
1728826 ID     school 1601440 305   HIGHLAND JOINT DISTRICT 160144000849 285 HIGHLAND SCHOOL   Regular School No Other PK 12.0 2017   grade_2 9 0 2   0 0     0   0   5 6             *         11 9 0 2   0 0     0   0   5 6                 11
1729211 ID     school 1600450 365   BRUNEAU-GRAND VIEW JOINT SCHOOL DISTRICT 160045000098 801 BRUNEAU ELEMENTARY SCHOOL   Regular School No Elementary PK 5.0 2017   grade_2 6 0 5   0 0     0   0   7 4             *         11 6 0 5   0 0     0   0   7 4                 11
1729335 ID     school 1602820 382   ROCKLAND DISTRICT 160282000501 169 ROCKLAND PUBLIC SCHOOL   Regular School No Other PK 12.0 2017   grade_2 11 0 0   0 0     0   0   6 5             5         11 11 0 0   0 0     0   0   6 5         5       11
1730009 ID     school 1600155 476   ANOTHER CHOICE VIRTUAL CHARTER SCHOOL, INC. 160015501008 1247 ANOTHER CHOICE VIRTUAL CHARTER   Regular School Yes Other PK 12.0 2017   grade_2 9 0 1   0 0     0   1   7 4             6         11 9 0 1   0 0     0   1   7 4         6       11
1729526 ID     school 1603240 411   TWIN FALLS DISTRICT 160324001075 1381 PILLAR FALLS ELEMENTARY   Regular School No Elementary PK 5.0 2017   grade_2 91 4 10   2 1     0   2   64 46             36         110 91 4 10   2 1     0   2   64 46         36       110
1727379 ID     school 1602340 131   NAMPA SCHOOL DISTRICT 160234000986 647 LAKE RIDGE ELEMENTARY   Regular School No Elementary PK 5.0 2017   grade_2 88 4 19   0 0     0   0   70 41             *         111 88 4 19   0 0     0   0   70 41                 111
1726151 ID     school 1602100 2   JOINT SCHOOL DISTRICT NO. 2 160210000989 899 SIENA ELEMENTARY   Regular School No Elementary PK 5.0 2017   grade_2 96 0 10   0 4     0   4   67 47             15         114 96 0 10   0 4     0   4   67 47         15       114
1726077 ID     school 1602100 2   JOINT SCHOOL DISTRICT NO. 2 160210000010 507 PIONEER SCHOOL OF THE ARTS   Regular School No Elementary PK 5.0 2017   grade_2 106 1 6   0 0     1   4   54 64             20         118 106 1 6   0 0     1   4   54 64         20       118
1725957 ID     school 1602100 2   JOINT SCHOOL DISTRICT NO. 2 160210000824 296 HUNTER ELEMENTARY SCHOOL   Regular School No Elementary PK 5.0 2017   grade_2 106 0 5   0 2     0   6   61 58             17         119 106 0 5   0 2     0   6   61 58         17       119
1730266 ID     school 1602340 795   IDAHO ARTS CHARTER SCHOOL, INC. 160234000834 577 IDAHO ARTS CHARTER SCHOOL   Regular School Yes Other PK 12.0 2017   grade_2 82 0 29   1 0     0   7   50 69             52         119 82 0 29   1 0     0   7   50 69         52       119
1726795 ID     school 1601500 73   HORSESHOE BEND SCHOOL DISTRICT 160150000506 256 HORSESHOE BEND ELEMENTARY   Regular School No Elementary PK 5.0 2017   grade_2 10 0 2   0 0     0   0   6 6             *         12 10 0 2   0 0     0   0   6 6                 12
1727286 ID     school 1600540 121   CAMAS COUNTY DISTRICT 160054000110 440 CAMAS COUNTY ELEM/JR HIGH SCHOOL   Regular School No Elementary PK 8.0 2017   grade_2 10 0 2   0 0     0   0   6 6             7         12 10 0 2   0 0     0   0   6 6         7       12
1727831 ID     school 1600750 161   CLARK COUNTY DISTRICT 160075000145 478 LINDY ROSS ELEMENTARY SCHOOL   Regular School No Elementary PK 8.0 2017   grade_2 6 0 6   0 0     0   0   6 6             *         12 6 0 6   0 0     0   0   6 6                 12
1727922 ID     school 1601900 182   MACKAY JOINT DISTRICT 160190000331 490 MACKAY ELEMENTARY SCHOOL   Regular School No Elementary PK 6.0 2017   grade_2 11 0 0   1 0     0   0   5 7             5         12 11 0 0   1 0     0   0   5 7         5       12
1729719 ID     school 1600570 432   CAMBRIDGE JOINT DISTRICT 160057000112 841 CAMBRIDGE ELEMENTARY SCHOOL   Regular School No Elementary PK 5.0 2017   grade_2 12 0 0   0 0     0   0   9 3             *         12 12 0 0   0 0     0   0   9 3                 12
1728293 ID     school 1601570 251   JEFFERSON COUNTY JOINT DISTRICT 160157001001 1110 SOUTH FORK ELEMENTARY SCHOOL   Regular School No Elementary PK 5.0 2017   grade_2 109 1 8   0 2     0   0   66 54             51         120 109 1 8   0 2     0   0   66 54         51       120
1729549 ID     school 1600480 412   BUHL JOINT DISTRICT 160048000101 830 POPPLEWELL ELEMENTARY SCHOOL   Regular School No Elementary PK 5.0 2017   grade_2 67 0 52   0 0     0   2   61 60             57         121 67 0 52   0 0     0   2   61 60         57       121
1726585 ID     school 1602970 52   SNAKE RIVER DISTRICT 160297000518 376 RIVERSIDE ELEMENTARY SCHOOL   Regular School No Elementary 02 3.0 2017   grade_2 98 1 21   0 0     0   2   66 56             57         122 98 1 21   0 0     0   2   66 56         57       122
1727220 ID     school 1600930 93   BONNEVILLE JOINT DISTRICT 160093000971 2519 DISCOVERY ELEMENTARY SCHOOL   Regular School No Elementary PK 6.0 2017   grade_2 104 0 16   1 0     0   1   70 52             53         122 104 0 16   1 0     0   1   70 52         53       122
1726131 ID     school 1602100 2   JOINT SCHOOL DISTRICT NO. 2 160210000902 593 PROSPECT ELEMENTARY SCHOOL   Regular School No Elementary PK 5.0 2017   grade_2 97 2 19   1 1     1   2   73 50             30         123 97 2 19   1 1     1   2   73 50         30       123
1727639 ID     school 1600600 139   VALLIVUE SCHOOL DISTRICT 160060000935 892 DESERT SPRINGS ELEMENTARY SCHOOL   Regular School No Elementary PK 5.0 2017   grade_2 63 0 53   2 0     0   5   74 49             79         123 63 0 53   2 0     0   5   74 49         79       123
1727614 ID     school 1600600 139   VALLIVUE SCHOOL DISTRICT 160060000083 505 CENTRAL CANYON ELEMENTARY SCHOOL   Regular School No Elementary PK 5.0 2017   grade_2 64 0 58   0 0     0   2   56 68             89         124 64 0 58   0 0     0   2   56 68         89       124
1726105 ID     school 1602100 2   JOINT SCHOOL DISTRICT NO. 2 160210000595 525 ELIZA HART SPALDING STEM ACADEMY   Regular School No Elementary PK 5.0 2017   grade_2 102 0 12   2 2     0   7   68 57             29         125 102 0 12   2 2     0   7   68 57         29       125
1729324 ID     school 1600060 381   AMERICAN FALLS JOINT DISTRICT 160006000005 808 HILLCREST ELEMENTARY SCHOOL   Regular School No Elementary PK 3.0 2017   grade_2 57 2 68   2 0     0   0   64 65             99         129 57 2 68   2 0     0   0   64 65         99       129
1728738 ID     school 1600010 288   WHITEPINE JOINT SCHOOL DISTRICT 160001000578 771 BOVILL ELEMENTARY SCHOOL   Regular School No Elementary PK 3.0 2017   grade_2 13 0 0   0 0     0   0   8 5             7         13 13 0 0   0 0     0   0   8 5         7       13
1728463 ID     school 1600780 271   COEUR D'ALENE DISTRICT 160078000152 740 ATLAS ELEMENTARY SCHOOL   Regular School No Elementary PK 5.0 2017   grade_2 119 0 8   0 1     0   3   60 71             55         131 119 0 8   0 1     0   3   60 71         55       131
1728953 ID     school 1603090 322   SUGAR-SALEM JOINT DISTRICT 160309000537 781 CENTRAL ELEMENTARY SCHOOL   Regular School No Elementary PK 3.0 2017   grade_2 122 1 6   2 0     0   0   63 68             62         131 122 1 6   2 0     0   0   63 68         62       131
1728449 ID     school 1600780 271   COEUR D'ALENE DISTRICT 160078000155 738 RAMSEY MAGNET SCHOOL OF SCIENCE   Regular School No Elementary PK 5.0 2017   grade_2 109 1 10   1 0     1   10   64 68             60         132 109 1 10   1 0     1   10   64 68         60       132
1727799 ID     school 1600660 151   CASSIA COUNTY JOINT DISTRICT 160066000128 474 DWORSHAK ELEMENTARY SCHOOL   Regular School No Elementary PK 3.0 2017   grade_2 61 1 70   2 0     1   1   73 63             104         136 61 1 70   2 0     1   1   73 63         104       136
1727778 ID     school 1600660 151   CASSIA COUNTY JOINT DISTRICT 160066000130 470 MOUNTAIN VIEW ELEMENTARY   Regular School No Elementary PK 3.0 2017   grade_2 86 0 46   0 1     0   4   68 69             89         137 86 0 46   0 1     0   4   68 69         89       137
1727680 ID     school 1601290 148   GRACE JOINT DISTRICT 160129000225 463 GRACE ELEMENTARY SCHOOL   Regular School No Elementary PK 6.0 2017   grade_2 12 0 2   0 0     0   0   6 8             5         14 12 0 2   0 0     0   0   6 8         5       14
1729218 ID     school 1600450 365   BRUNEAU-GRAND VIEW JOINT SCHOOL DISTRICT 160045000099 802 GRAND VIEW ELEMENTARY SCHOOL   Regular School No Elementary PK 5.0 2017   grade_2 8 1 5   0 0     0   0   7 7             *         14 8 1 5   0 0     0   0   7 7                 14
1730086 ID     school 1600163 483   CHIEF TAHGEE ELEMENTARY ACADEMY, INC. 160016301040 1347 CHIEF TAHGEE ELEMENTARY ACADEMY   Regular School Yes Elementary KG 6.0 2017   grade_2 0 0 0   14 0     0   0   8 6             *         14 0 0 0   14 0     0   0   8 6                 14
1729297 ID     school 1601140 373   FRUITLAND DISTRICT 160114000211 807 FRUITLAND ELEMENTARY SCHOOL   Regular School No Elementary PK 4.0 2017   grade_2 91 0 43   0 2     0   4   64 76             62         140 91 0 43   0 2     0   4   64 76         62       140
1729589 ID     school 1601710 414   KIMBERLY DISTRICT 160171000300 833 KIMBERLY ELEMENTARY SCHOOL   Regular School No Elementary PK 5.0 2017   grade_2 129 1 8   1 0     0   1   71 69             51         140 129 1 8   1 0     0   1   71 69         51       140
1726298 ID     school 1602060 11   MEADOWS VALLEY DISTRICT 160206000826 342 MEADOWS VALLEY SCHOOL   Regular School No Other PK 12.0 2017   grade_2 13 0 2   0 0     0   0   6 9             *         15 13 0 2   0 0     0   0   6 9                 15
1726870 ID     school 1600002 84   LAKE PEND OREILLE SCHOOL DISTRICT 160000200614 401 HOPE ELEMENTARY SCHOOL   Regular School No Elementary PK 6.0 2017   grade_2 13 0 2   0 0     0   0   12 3             10         15 13 0 2   0 0     0   0   12 3         10       15
1727674 ID     school 1601290 148   GRACE JOINT DISTRICT 160129000228 462 THATCHER ELEMENTARY SCHOOL   Regular School No Elementary 01 5.0 2017   grade_2 15 0 0   0 0     0   0   10 5             7         15 15 0 0   0 0     0   0   10 5         7       15
1728700 ID     school 1601680 283   KENDRICK JOINT DISTRICT 160168000298 758 JULIAETTA ELEMENTARY SCHOOL   Regular School No Elementary PK 6.0 2017   grade_2 15 0 0   0 0     0   0   12 3             8         15 15 0 0   0 0     0   0   12 3         8       15
1728875 ID     school 1602760 316   RICHFIELD DISTRICT 160276000497 144 RICHFIELD SCHOOL   Regular School No Other PK 12.0 2017   grade_2 11 0 4   0 0     0   0   11 4             *         15 11 0 4   0 0     0   0   11 4                 15
1728369 ID     school 1601590 261   JEROME JOINT DISTRICT 160159000283 731 JEFFERSON ELEMENTARY SCHOOL   Regular School No Elementary KG 3.0 2017   grade_2 53 0 100   2 1     1   0   77 80             119         157 53 0 100   2 1     1   0   77 80         119       157
1726515 ID     school 1600240 33   BEAR LAKE COUNTY DISTRICT 160024000021 371 GEORGETOWN ELEMENTARY SCHOOL   Regular School No Elementary PK 5.0 2017   grade_2 16 0 0   0 0     0   0   8 8             5         16 16 0 0   0 0     0   0   8 8         5       16
1726522 ID     school 1600240 33   BEAR LAKE COUNTY DISTRICT 160024000019 372 PARIS ELEMENTARY SCHOOL   Regular School No Elementary PK 5.0 2017   grade_2 16 0 0   0 0     0   0   8 8             11         16 16 0 0   0 0     0   0   8 8         11       16
1727880 ID     school 1602520 171   OROFINO JOINT DISTRICT 160252000983 2520 TIMBERLINE ELEMENTARY   Regular School No Elementary PK 5.0 2017   grade_2 15 0 0   1 0     0   0   9 7             *         16 15 0 0   1 0     0   0   9 7                 16
1728364 ID     school 1601590 261   JEROME JOINT DISTRICT 160159000272 516 HORIZON ELEMENTARY SCHOOL   Regular School No Elementary PK 3.0 2017   grade_2 76 0 86   1 0     1   0   88 76             *         164 76 0 86   1 0     1   0   88 76                 164
1728171 ID     school 1601380 233   HAGERMAN JOINT DISTRICT 160138000840 280 HAGERMAN SCHOOL   Regular School No Other PK 12.0 2017   grade_2 11 0 5   0 0     0   1   6 11             12         17 11 0 5   0 0     0   1   6 11         12       17
1729683 ID     school 1600630 422   CASCADE DISTRICT 160063000120 838 CASCADE ELEMENTARY SCHOOL   Regular School No Elementary PK 6.0 2017   grade_2 15 0 1   0 0     0   1   6 11             11         17 15 0 1   0 0     0   1   6 11         11       17
1730040 ID     school 1600159 479   HERITAGE ACADEMY, INC. 160015901017 1341 HERITAGE ACADEMY   Regular School Yes Elementary PK 8.0 2017   grade_2 13 0 3   0 0     0   1   7 10             *         17 13 0 3   0 0     0   1   7 10                 17
1726696 ID     school 1602910 60   SHELLEY JOINT DISTRICT 160291000508 391 SUNRISE ELEMENTARY SCHOOL   Regular School No Elementary KG 2.0 2017   grade_2 156 1 25   0 0     0   0   91 91             93         182 156 1 25   0 0     0   0   91 91         93       182
1728009 ID     school 1600960 201   PRESTON JOINT DISTRICT 160096000709 499 PIONEER ELEMENTARY SCHOOL   Regular School No Elementary PK 2.0 2017   grade_2 156 2 21   3 0     0   0   95 87             100         182 156 2 21   3 0     0   0   95 87         100       182
1726340 ID     school 1601950 21   MARSH VALLEY JOINT DISTRICT 160195000344 350 DOWNEY ELEMENTARY SCHOOL   Regular School No Elementary PK 6.0 2017   grade_2 17 0 1   0 0     0   1   12 7             *         19 17 0 1   0 0     0   1   12 7                 19
1726780 ID     school 1600180 72   BASIN SCHOOL DISTRICT 160018000334 159 BASIN ELEMENTARY SCHOOL   Regular School No Elementary PK 6.0 2017   grade_2 19 0 0   0 0     0   0   11 8             *         19 19 0 0   0 0     0   0   11 8                 19
1726894 ID     school 1600002 84   LAKE PEND OREILLE SCHOOL DISTRICT 160000200616 405 SOUTHSIDE ELEMENTARY SCHOOL   Regular School No Elementary PK 6.0 2017   grade_2 18 0 0   0 0     0   1   13 6             10         19 18 0 0   0 0     0   1   13 6         10       19
1728861 ID     school 1600900 314   DIETRICH DISTRICT 160090000165 143 DIETRICH SCHOOL   Regular School No Other PK 12.0 2017   grade_2 12 0 7   0 0     0   0   10 9             *         19 12 0 7   0 0     0   0   10 9                 19
1727861 ID     school 1602520 171   OROFINO JOINT DISTRICT 160252000436 481 CAVENDISH-TEAKEAN ELEMENTARY SCHOOL   Regular School No Elementary PK 6.0 2017   grade_2 2 0 0   0 0     0   0   0 2             *         2 2 0 0   0 0     0   0   0 2                 2
1727869 ID     school 1602520 171   OROFINO JOINT DISTRICT 160252000442 482 PECK ELEMENTARY SCHOOL   Regular School No Elementary PK 6.0 2017   grade_2 2 0 0   0 0     0   0   2 0             *         2 2 0 0   0 0     0   0   2 0                 2
1728113 ID     school 1601020 221   EMMETT INDEPENDENT DISTRICT 160102000190 710 OLA ELEMENTARY SCHOOL   Regular School No Elementary PK 6.0 2017   grade_2 2 0 0   0 0     0   0   0 2             *         2 2 0 0   0 0     0   0   0 2                 2
1729017 ID     school 1602190 331   MINIDOKA COUNTY JOINT DISTRICT 160219001028 1263 DAY TREATMENT ELEMENTARY   Special Education School No Elementary KG 6.0 2017   grade_2 2 0 0   0 0     0   0   2 0             *         2 2 0 0   0 0     0   0   2 0                 2
1729038 ID     school   340   LEWISTON INDEPENDENT DISTRICT   611 NORTHWEST CHILDRENS HOME             2017   grade_2 1 0 0   1 0     0   0   2 0             *         2 1 0 0   1 0     0   0   2 0                 2
1729192 ID     school 1602610 364   PLEASANT VALLEY ELEMENTARY DISTRICT 160261000459 800 PLEASANT VALLEY ELEM/JR HIGH   Regular School No Elementary PK 8.0 2017   grade_2 2 0 0   0 0     0   0   0 2             *         2 2 0 0   0 0     0   0   0 2                 2
1727244 ID     school 1600420 101   BOUNDARY COUNTY DISTRICT 160042000091 434 MOUNT HALL ELEMENTARY SCHOOL   Regular School No Elementary KG 5.0 2017   grade_2 18 1 1   0 0     0   0   13 7             9         20 18 1 1   0 0     0   0   13 7         9       20
1729921 ID     school 1600143 465   NORTH VALLEY ACADEMY, INC. 160014300968 653 NORTH VALLEY ACADEMY   Regular School Yes Other PK 12.0 2017   grade_2 15 0 3   0 1     0   1   13 7             10         20 15 0 3   0 1     0   1   13 7         10       20
1726316 ID     school 1600840 13   COUNCIL DISTRICT 160084000162 348 COUNCIL ELEMENTARY SCHOOL   Regular School No Elementary PK 6.0 2017   grade_2 20 1 0   0 0     0   0   12 9             10         21 20 1 0   0 0     0   0   12 9         10       21
1726834 ID     school 1600001 83   WEST BONNER COUNTY DISTRICT 160000100613 411 IDAHO HILL ELEMENTARY SCHOOL   Regular School No Elementary PK 6.0 2017   grade_2 18 0 1   0 0     0   2   6 15             *         21 18 0 1   0 0     0   2   6 15                 21
1729428 ID     school 1603180 401   TETON COUNTY DISTRICT 160318000545 822 TETONIA ELEMENTARY SCHOOL   Regular School No Elementary KG 3.0 2017   grade_2 17 0 3   0 0     0   1   9 12             *         21 17 0 3   0 0     0   1   9 12                 21
1730283 ID     school 1602220 813   MOSCOW CHARTER SCHOOL, INC. 160222000749 813 MOSCOW CHARTER SCHOOL   Regular School Yes Elementary PK 8.0 2017   grade_2 19 0 0   0 0     0   2   12 9             *         21 19 0 0   0 0     0   2   12 9                 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]);