Data source: Big Local News · About: Big Local

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

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
850055 ID     school   92   SWAN VALLEY ELEMENTARY DISTRICT   1014 BORDER DISTRICT - STAR VALLEY ELEMENTARY SCHOOL             2020   grade_2 1 0 0   0 0     0   0   0 1             *         1 1 0 0   0 0     0   0   0 1                 1
851265 ID     school 1600139 244   MOUNTAIN VIEW SCHOOL DISTRICT 160013900933 1287 ELK CITY SCHOOL   Regular School No Elementary PK 08 2020   grade_2 1 0 0   0 0     0   0   1 0             *         1 1 0 0   0 0     0   0   1 0                 1
851800 ID     school 1603030 292   SOUTH LEMHI DISTRICT 160303000529 765 TENDOY ELEMENTARY SCHOOL   Regular School No Elementary KG 05 2020   grade_2 1 0 0   0 0     0   0   0 1             *         1 1 0 0   0 0     0   0   0 1                 1
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
850694 ID     school 1602430 149   NORTH GEM DISTRICT 160243000427 464 NORTH GEM ELEMENTARY   Regular School No Elementary PK 06 2020   grade_2 8 0 0   0 0     2   0   7 3             *         10 8 0 0   0 0     2   0   7 3                 10
852139 ID     school 1600870 342   CULDESAC JOINT DISTRICT 160087000164 795 CULDESAC SCHOOL   Regular School No Other PK 12 2020   grade_2 6 1 0   3 0     0   0   7 3             *         10 6 1 0   3 0     0   0   7 3                 10
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
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
848951 ID     school 1602100 2   JOINT SCHOOL DISTRICT NO. 2 160210000824 296 HUNTER ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2020   grade_2 81 2 8   0 2     1   6   55 45             16         100 81 2 8   0 2     1   6   55 45         16       100
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
850022 ID     school 1601530 91   IDAHO FALLS DISTRICT 160153000725 668 SUNNYSIDE ELEMENTARY SCHOOL   Regular School No Elementary PK 06 2020   grade_2 89 0 3   0 3     0   5   51 49             9         100 89 0 3   0 3     0   5   51 49         9       100
852010 ID     school 1602190 331   MINIDOKA COUNTY JOINT DISTRICT 160219000666 845 RUPERT ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2020   grade_2 33 0 65   0 0     1   1   57 43             77         100 33 0 65   0 0     1   1   57 43         77       100
848979 ID     school 1602100 2   JOINT SCHOOL DISTRICT NO. 2 160210000365 331 LAKE HAZEL ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2020   grade_2 81 0 10   0 3     2   5   46 55             22         101 81 0 10   0 3     2   5   46 55         22       101
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
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
851471 ID     school 1600780 271   COEUR D'ALENE DISTRICT 160078000152 740 ATLAS ELEMENTARY SCHOOL   Regular School No Elementary KG 05 2020   grade_2 85 0 8   0 1     0   7   48 53             35         101 85 0 8   0 1     0   7   48 53         35       101
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
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
850637 ID     school 1600600 139   VALLIVUE SCHOOL DISTRICT 160060000935 892 DESERT SPRINGS ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2020   grade_2 68 2 29   0 0     1   3   58 45             55         103 68 2 29   0 0     1   3   58 45         55       103
852452 ID     school 1603240 411   TWIN FALLS DISTRICT 160324000316 515 OREGON TRAIL ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2020   grade_2 53 0 48   0 2     0   0   50 53             54         103 53 0 48   0 2     0   0   50 53         54       103
852520 ID     school 1603240 411   TWIN FALLS DISTRICT 160324001075 1381 PILLAR FALLS ELEMENTARY   Regular School No Elementary PK 05 2020   grade_2 94 0 6   0 2     0   1   56 47             27         103 94 0 6   0 2     0   1   56 47         27       103
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
851492 ID     school 1600780 271   COEUR D'ALENE DISTRICT 160078000157 743 WINTON ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2020   grade_2 85 0 10   0 0     1   8   70 34             64         104 85 0 10   0 0     1   8   70 34         64       104
852570 ID     school 1601050 413   FILER DISTRICT 160105000193 831 FILER ELEMENTARY SCHOOL   Regular School No Elementary PK 03 2020   grade_2 92 0 12   0 0     0   0   45 59             *         104 92 0 12   0 0     0   0   45 59                 104
852710 ID     school 1603330 431   WEISER DISTRICT 160333000567 839 PIONEER PRIMARY SCHOOL   Regular School No Elementary PK 03 2020   grade_2 72 0 29   0 0     0   4   54 51             59         105 72 0 29   0 0     0   4   54 51         59       105
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
850520 ID     school 1602130 134   MIDDLETON DISTRICT 160213000376 453 MIDDLETON MILL CREEK ELEMENTARY   Regular School No Elementary PK 05 2020   grade_2 92 2 8   0 1     0   3   55 51             26         106 92 2 8   0 1     0   3   55 51         26       106
851154 ID     school 1601260 231   GOODING JOINT DISTRICT 160126000223 711 GOODING ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2020   grade_2 60 0 41   1 1     1   2   56 50             21         106 60 0 41   1 1     1   2   56 50         21       106
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
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
852527 ID     school 1603240 411   TWIN FALLS DISTRICT 160324001076 1382 ROCK CREEK ELEMENTARY   Regular School No Elementary KG 05 2020   grade_2 86 2 13   0 5     0   1   60 47             37         107 86 2 13   0 5     0   1   60 47         37       107
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
850360 ID     school 1602340 131   NAMPA SCHOOL DISTRICT 160234000833 581 WILLOW CREEK ELEMENTARY   Regular School No Elementary PK 05 2020   grade_2 60 0 45   0 0     0   3   57 51             72         108 60 0 45   0 0     0   3   57 51         72       108
850630 ID     school 1600600 139   VALLIVUE SCHOOL DISTRICT 160060000976 646 LAKEVUE ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2020   grade_2 57 2 45   0 0     2   2   60 48             61         108 57 2 45   0 0     2   2   60 48         61       108
851966 ID     school 1603090 322   SUGAR-SALEM JOINT DISTRICT 160309000537 781 CENTRAL ELEMENTARY SCHOOL   Regular School No Elementary PK 03 2020   grade_2 101 2 5   0 0     0   0   54 54             47         108 101 2 5   0 0     0   0   54 54         47       108
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
851220 ID     school 1600138 243   SALMON RIVER JOINT SCHOOL DISTRICT 160013800959 1280 RIGGINS ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2020   grade_2 11 0 0   0 0     0   0   4 7             5         11 11 0 0   0 0     0   0   4 7         5       11
852575 ID     school 1601050 413   FILER DISTRICT 160105000195 832 HOLLISTER ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2020   grade_2 7 0 4   0 0     0   0   4 7             *         11 7 0 4   0 0     0   0   4 7                 11
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
850656 ID     school 1600600 139   VALLIVUE SCHOOL DISTRICT 160060001092 1397 SKYWAY ELEMENTARY   Regular School No Elementary KG 05 2020   grade_2 54 0 55   0 0     0   2   45 66             73         111 54 0 55   0 0     0   2   45 66         73       111
850619 ID     school 1600600 139   VALLIVUE SCHOOL DISTRICT 160060000778 519 BIRCH ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2020   grade_2 79 0 25   0 1     3   4   67 45             47         112 79 0 25   0 1     3   4   67 45         47       112
852828 ID     school 1600007 455   COMPASS PUBLIC CHARTER SCHOOL, INC. 160000700864 575 COMPASS PUBLIC CHARTER SCHOOL   Regular School Yes Other KG 12 2020   grade_2 86 0 14   0 4     0   8   57 55             18         112 86 0 14   0 4     0   8   57 55         18       112
849064 ID     school 1602100 2   JOINT SCHOOL DISTRICT NO. 2 160210000770 504 PONDEROSA ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2020   grade_2 92 0 14   0 1     1   5   68 45             38         113 92 0 14   0 1     1   5   68 45         38       113
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
851105 ID     school 1601020 221   EMMETT INDEPENDENT DISTRICT 160102000797 230 KENNETH J CARBERRY ELEMENTARY   Regular School No Elementary PK 04 2020   grade_2 84 0 28   0 1     0   3   58 58             67         116 84 0 28   0 1     0   3   58 58         67       116
851715 ID     school 1601680 283   KENDRICK JOINT DISTRICT 160168000298 758 JULIAETTA ELEMENTARY SCHOOL   Regular School No Elementary PK 06 2020   grade_2 10 1 0   0 0     0   1   8 4             5         12 10 1 0   0 0     0   1   8 4         5       12
851839 ID     school 1601440 305   HIGHLAND JOINT DISTRICT 160144000849 285 HIGHLAND SCHOOL   Regular School No Other PK 12 2020   grade_2 10 0 1   1 0     0   0   8 4             6         12 10 0 1   1 0     0   0   8 4         6       12
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
853151 ID     school 1600166 488   SYRINGA MOUNTAIN SCHOOL, INC. 160016601066 1367 SYRINGA MOUNTAIN CHARTER SCHOOL   Regular School Yes Elementary KG 08 2020   grade_2 11 0 1   0 0     0   0   7 5             7         12 11 0 1   0 0     0   0   7 5         7       12
853385 ID     school 1602340 795   IDAHO ARTS CHARTER SCHOOL, INC. 160234000834 577 IDAHO ARTS CHARTER SCHOOL   Regular School Yes Other PK 12 2020   grade_2 81 2 32   0 0     0   5   41 79             56         120 81 2 32   0 0     0   5   41 79         56       120
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
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
851457 ID     school 1600780 271   COEUR D'ALENE DISTRICT 160078000155 738 RAMSEY MAGNET SCHOOL OF SCIENCE   Regular School No Elementary PK 05 2020   grade_2 111 0 11   1 2     1   3   70 59             43         129 111 0 11   1 2     1   3   70 59         43       129
852292 ID     school 1601140 373   FRUITLAND DISTRICT 160114000211 807 FRUITLAND ELEMENTARY SCHOOL   Regular School No Elementary PK 04 2020   grade_2 81 0 37   0 1     1   9   69 60             65         129 81 0 37   0 1     1   9   69 60         65       129
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
851303 ID     school 1601570 251   JEFFERSON COUNTY JOINT DISTRICT 160157001001 1110 SOUTH FORK ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2020   grade_2 115 0 10   1 1     0   3   62 68             48         130 115 0 10   1 1     0   3   62 68         48       130
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
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
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
853076 ID     school 1600159 479   HERITAGE ACADEMY, INC. 160015901017 1341 HERITAGE ACADEMY   Regular School Yes Elementary PK 08 2020   grade_2 9 0 5   0 0     0   0   9 5             *         14 9 0 5   0 0     0   0   9 5                 14
853138 ID     school 1600170 486   UPPER CARMEN PUBLIC CHARTER SCHOOL, INC. 160017000847 1366 UPPER CARMEN PUBLIC CHARTER SCHOOL   Regular School Yes Elementary KG 03 2020   grade_2 14 0 0   0 0     0   0   9 5             9         14 14 0 0   0 0     0   0   9 5         9       14
853259 ID     school 1600182 513   PROJECT IMPACT STEM ACADEMY, INC. 160018201102 1413 PROJECT IMPACT STEM ACADEMY   Regular School Yes Other KG 10 2020   grade_2 11 0 3   0 0     0   0   5 9             7         14 11 0 3   0 0     0   0   5 9         7       14
851378 ID     school 1601590 261   JEROME JOINT DISTRICT 160159000283 731 JEFFERSON ELEMENTARY SCHOOL   Regular School No Elementary KG 03 2020   grade_2 52 0 90   0 0     0   2   75 69             114         144 52 0 90   0 0     0   2   75 69         114       144
851373 ID     school 1601590 261   JEROME JOINT DISTRICT 160159000272 516 HORIZON ELEMENTARY SCHOOL   Regular School No Elementary PK 03 2020   grade_2 72 0 72   1 0     0   1   76 70             *         146 72 0 72   1 0     0   1   76 70                 146
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
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
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
850900 ID     school 1602520 171   OROFINO JOINT DISTRICT 160252000983 2520 TIMBERLINE ELEMENTARY   Regular School No Elementary PK 05 2020   grade_2 14 0 1   0 0     0   0   8 7             *         15 14 0 1   0 0     0   0   8 7                 15
851069 ID     school 1601110 215   FREMONT COUNTY JOINT DISTRICT 160111000204 700 PARKER-EGIN ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2020   grade_2 14 0 1   0 0     0   0   8 7             *         15 14 0 1   0 0     0   0   8 7                 15
851873 ID     school 1600900 314   DIETRICH DISTRICT 160090000165 143 DIETRICH SCHOOL   Regular School No Other PK 12 2020   grade_2 9 0 6   0 0     0   0   7 8             *         15 9 0 6   0 0     0   0   7 8                 15
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
851021 ID     school 1600960 201   PRESTON JOINT DISTRICT 160096000709 499 PIONEER ELEMENTARY SCHOOL   Regular School No Elementary PK 02 2020   grade_2 148 0 7   2 0     0   0   82 75             74         157 148 0 7   2 0     0   0   82 75         74       157
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
850935 ID     school 1601900 182   MACKAY JOINT DISTRICT 160190000331 490 MACKAY ELEMENTARY SCHOOL   Regular School No Elementary PK 06 2020   grade_2 15 0 1   0 0     0   0   7 9             7         16 15 0 1   0 0     0   0   7 9         7       16
851887 ID     school 1602760 316   RICHFIELD DISTRICT 160276000497 144 RICHFIELD SCHOOL   Regular School No Other PK 12 2020   grade_2 10 0 6   0 0     0   0   5 11             11         16 10 0 6   0 0     0   0   5 11         11       16
853124 ID     school 1600163 483   CHIEF TAHGEE ELEMENTARY ACADEMY, INC. 160016301040 1347 CHIEF TAHGEE ELEMENTARY ACADEMY   Regular School Yes Elementary KG 07 2020   grade_2 0 0 1   15 0     0   0   6 10             *         16 0 0 1   15 0     0   0   6 10                 16
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
850675 ID     school 1601290 148   GRACE JOINT DISTRICT 160129000228 462 THATCHER ELEMENTARY SCHOOL   Regular School No Elementary 01 05 2020   grade_2 17 0 0   0 0     0   0   9 8             12         17 17 0 0   0 0     0   0   9 8         12       17
850920 ID     school 1600720 181   CHALLIS JOINT DISTRICT 160072000139 489 CHALLIS ELEMENTARY SCHOOL   Regular School No Elementary PK 06 2020   grade_2 17 0 0   0 0     0   0   10 7             *         17 17 0 0   0 0     0   0   10 7                 17
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
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
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
852948 ID     school 1600143 465   NORTH VALLEY ACADEMY, INC. 160014300968 653 NORTH VALLEY ACADEMY   Regular School Yes Other KG 12 2020   grade_2 9 0 7   1 0     1   0   8 10             11         18 9 0 7   1 0     1   0   8 10         11       18
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
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
851738 ID     school 1600009 287   TROY SCHOOL DISTRICT 160000900581 766 TROY ELEMENTARY SCHOOL   Regular School No Elementary PK 06 2020   grade_2 18 0 1   0 0     0   0   13 6             5         19 18 0 1   0 0     0   0   13 6         5       19
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
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
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
850887 ID     school 1602520 171   OROFINO JOINT DISTRICT 160252000442 482 PECK ELEMENTARY SCHOOL   Regular School No Elementary PK 06 2020   grade_2 2 0 0   0 0     0   0   0 2             *         2 2 0 0   0 0     0   0   0 2                 2
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
851367 ID     school 1601590 261   JEROME JOINT DISTRICT 160159000289 297 JEROME ACADEMY   Special Education School No Other KG 12 2020   grade_2 2 0 0   0 0     0   0   2 0             *         2 2 0 0   0 0     0   0   2 0                 2
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
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
851753 ID     school 1600010 288   WHITEPINE JOINT SCHOOL DISTRICT 160001000578 771 BOVILL ELEMENTARY SCHOOL   Regular School No Elementary PK 03 2020   grade_2 20 0 0   0 0     0   0   11 9             8         20 20 0 0   0 0     0   0   11 9         8       20
852422 ID     school 1603180 401   TETON COUNTY DISTRICT 160318000545 822 TETONIA ELEMENTARY SCHOOL   Regular School No Elementary KG 03 2020   grade_2 16 0 4   0 0     0   0   10 10             10         20 16 0 4   0 0     0   0   10 10         10       20
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
850681 ID     school 1601290 148   GRACE JOINT DISTRICT 160129000225 463 GRACE ELEMENTARY SCHOOL   Regular School No Elementary PK 06 2020   grade_2 20 0 1   0 0     0   0   16 5             11         21 20 0 1   0 0     0   0   16 5         11       21
852998 ID     school 1600151 472   PALOUSE PRAIRIE EDUCATIONAL ORGANIZATION, INC. 160015100994 1234 PALOUSE PRAIRIE CHARTER SCHOOL   Regular School Yes Elementary KG 08 2020   grade_2 14 1 2   0 0     0   4   9 12             *         21 14 1 2   0 0     0   4   9 12                 21
853406 ID     school 1602220 813   MOSCOW CHARTER SCHOOL, INC. 160222000749 813 MOSCOW CHARTER SCHOOL   Regular School Yes Elementary KG 08 2020   grade_2 20 0 0   0 0     0   1   11 10             5         21 20 0 0   0 0     0   1   11 10         5       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]);